Scripts for QV and QS

[katetsan]

Hi Communities,

I'm trying to copy the script of QV and paste it into QS app.

However, it keeps showing error msg as 'map_id not found'.

Could anyone have the same problem before?

Thanks in advance.

****************** Script ******************

T004T:   // Chart of Account Names

Mapping Load

   KTOPL,

   KTPLT

    ;

Select KTOPL KTPLT  SPRAS

From T004T WHERE SPRAS =1;

[SKAT]:   // G/L Account Master Record (Chart of Accounts: Description)

Load

    SAKNR as [%RACCT_SAKNR_KEY],

   KTOPL,

   ApplyMap('T004T',KTOPL) as [Chart of Accts_Name_KTOPT],

   SAKNR as [G/L Account_SAKNR],

   TXT50 as [Account Number Long Text_TXT50],

   TXT20 as [Account Number Short Text_TXT20],

   MCOD1 as [Account Number Long text_MCOD1];

Select TXT20 KTOPL MCOD1 SAKNR TXT50 SPRAS

From SKAT WHERE SPRAS = 1';

[ChennaiahNallani]

create connecting in Qlik sense and check the path

[katetsan]

I do connect to SAP system via Connector.

[ChennaiahNallani]

yeah, But you have to install sap connectors. it's not free

Try or Buy

[shilpan]

Change Qlik Sense to legacy mode

Qlik Sense Legacy mode

[agigliotti]

maybe this:

T004T:   // Chart of Account Names

Mapping Load

   KTOPL,

   KTPLT

    ;

Select KTOPL, KTPLT, SPRAS

From T004T WHERE SPRAS =1;

are you missing comma between table columns ?