Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
commonqlik
Contributor II

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   ?

1 Reply
Not applicable

Re: 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 ?

Hi qlik777view777,

You can do many things to shorten extraction times:

  • Extract from SAP, save to QVD and then operate with them.
  • Extract only one year/company at a time.
  • Usually, past years can't be modified on SAP, so extract them only once and update only 2014 to refresh data.

Please, watch your spelling and grammar, and don't use capslock.

Good luck.

Community Browser