5 Replies Latest reply: Mar 1, 2018 3:52 AM by Andrea Gigliotti RSS

    Scripts for QV and QS

    Kate Tsan

      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';