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 ?

Anonymous — Sun, 25 May 2014 02:47:18 GMT

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 ?

topic 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 ? in QlikView

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 ?

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 ?