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 ?
