Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 ?

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   ?

0 Replies