Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Maybe you can discuss your requirements with the author of this thread:
need urgently right data model for below xl sheet pls make it all fields are inline and send the ...
because of the similarities of the loaded data?
Did you deliberately post the same question three times within 14 minutes?
regards
Marco