1 Reply Latest reply: Jun 5, 2014 6:48 AM by Sistemas Inveravante RSS

    Pls create a data model for this script  because i have created data model in different ways but to populate the data it is talking much time PLS GIVE ME DATA MODEL FOR THIS  SCRIPT  PLS  HELP  ME ?

    qlik777 view777

      Pls create a data model for this script  because i have created data model in different ways but to populate the data it is talking much time PLS GIVE ME DATA MODEL FOR THIS  SCRIPT  PLS  HELP  ME ?

       

       

      MSEG:

      LOAD * INLINE

      [

      MBLNR as [Material document],

           MJAHR as [Material Document Year],

           ZEILE as [Item in Material],

            WERKS as Plant,

                  BUKRS as [Company Code],

      BWART as [Movement Type],

      BUDAT_MKPF as [Posting date]

      ];

       

      Concatenate

      LOAD *

      [

      MBLNR as  [Material document],

           MJAHR as [Material Document Year],

           ZEILE as [Item in Material],

           WERKS as Plant,

           BUKRS as [Company Code],

            BWART as  [Movement Type],

            BUDAT_MKPF as [Posting date]

      ];

      Concatenate

      LOAD *

      [

      MBLNR as [Material document],

           MJAHR as [Material Document Year],

           ZEILE as [Item in Material],

          WERKS as Plant,

          BUKRS as [Company Code],

           BWART as  [Movement Type],

            BUDAT_MKPF as  [Posting date]

      ];

      Concatenate

      LOAD   *

      [

           MBLNR as [Material document],

           MJAHR as [Material Document Year],

           ZEILE as [Item in Material],

            WERKS as plant,

            BUKRS as [Company Code],

            BWART as  [Movement Type],

            BUDAT_MKPF as [Posting date]

      ];

       

      ZZMM_MIGO103DATA:

      LOAD   * [

             VNDAT as [Vendor Excise Invoice Date],

              MATNR as [Material],

              WERKS,

             LIFNR as Vendor,

          EBELN as [Purchasing Document],

           EBELP as Item ,

            MJAHR,

           LGORT as [LBT Concessional Rs.],

      ERFME as [Units of Measurment],

         MBLNR,

             MBLPO ,

      VNINV as [Vendor Invoice No],

         CREATIONDATE as [Creation Date],

        QTY_105 as Quantity ,

          VNVAL as [Vendor Base Value]

      ];

       

      LOAD

      * INLINE [

      LIFNR AS  Vendor ,

      NAME1 as [Vendor name],

      PSTLZ AS PIN,

      if(if(Match(PSTLZ,'422001','422002','422003','422004','422005','422006','422007','422008','422009','422010','422011','422012','422013','422101'),'NSK','ÓUTNSK') as source.

      ];

       

      MAKT:

      load * inline [

      MATNR as Material ,

      SPRAS AS [Language Key],

      MAKTX AS [Material Description]

      ];

      MBEW:

      LOAD  * inline [

           MATNR  as Material,

      BWKEY AS [Valuation Area],

      BWTAR AS [Valuation Type],

      //BKLAS AS Valclass,

      if(BKLAS='3009'or BKLAS='3010','Steel',if(BKLAS='4002' or BKLAS='4003','Paint','Other'))  as  valclass

      ];

       

      LOAD  * inline

      [

      TRNTYP AS [Excise Transaction Type],

      DOCYR AS Year,

      DOCNO AS [Internal Excise Document Number],

      ZEILE as MSZEILE,

      LIFNR,

      LGORT,

      MATNR,

      MENGE AS [Quantity mentioned in the excise invoice],

      EXBAS as [Excise Duty Base Amount],

      EXBED as [Basic Excise Duty],

      RDOC1 as [Reference Document 1]

      ];

      PLS CREATE THE CORRECT DATA MODEL AND GIVE ME PRINT SHOT  BECAUSE  I  AM  USING   PERSINAL ADDITION   PLS   HELP  ME   ?