creation of idoc material

14
LSMW - Examples Project: PROJECT00 LSMW examples Subproject: LOGISTICS Logistics Data Object: IDOCMATLE Material master via IDOC Data transfer program: MATMAS03 Data transfer method: I (IDoc) Source structures MATL - material master basic data MATL2 - material master consumption data Target struct. E1MARAM - Master material general data (MARA) E1MAKTM - Master material short texts (MAKT) E1MARCM - Master material C segment (MARC) E1MVEGM - Master material total consumption E1MARMM - Master material units of measure (MARM) E1MBEWM - Master material material valuation (MBEW) Structure relations E1MARAM <=== MATL E1MAKTM <=== MATL E1MARCM <=== MATL E1MVEGM <=== MATL2 E1MARMM <=== MATL E1MBEWM <=== MATL Source fields MATL - material master basic data MATNR material number Type:C Lgth:010 Position:0001 MATTYPE material type Type:C Lgth:004 Position:0002 SECTOR industry sector Type:C Lgth:004 Position:0003 PLANT plant Type:C Lgth:004 Position:0004 30.01.22 - 1 -

Upload: yogeshchauhan2006

Post on 08-Apr-2016

14 views

Category:

Documents


0 download

DESCRIPTION

IDOC Material

TRANSCRIPT

LSMW - Examples

Project: PROJECT00 LSMW examples

Subproject: LOGISTICS Logistics Data

Object: IDOCMATLE Material master via IDOC

Data transfer program: MATMAS03

Data transfer method: I (IDoc)

Source structures

MATL - material master basic data MATL2 - material master consumption data

Target struct.

E1MARAM - Master material general data (MARA) E1MAKTM - Master material short texts (MAKT) E1MARCM - Master material C segment (MARC) E1MVEGM - Master material total consumption E1MARMM - Master material units of measure (MARM) E1MBEWM - Master material material valuation (MBEW)

Structure relations

E1MARAM <=== MATL E1MAKTM <=== MATL E1MARCM <=== MATL E1MVEGM <=== MATL2 E1MARMM <=== MATL E1MBEWM <=== MATL

Source fields

MATL - material master basic data MATNR material number Type:C Lgth:010 Position:0001 MATTYPE material type Type:C Lgth:004 Position:0002 SECTOR industry sector Type:C Lgth:004 Position:0003 PLANT plant Type:C Lgth:004 Position:0004 LOCATION storage location Type:C Lgth:004 Position:0005 COMPCODE company code Type:C Lgth:004 Position:0006 UNIT unit of measure Type:C Lgth:002 Position:0007 TEXT short text Type:C Lgth:020 Position:0008 STATUS status to be transfered Type:C Lgth:015 Position:0009 MATGROUP material group Type:C Lgth:005 Position:0010 TRANSGR transportation group Type:C Lgth:004 Position:0011

26.04.23 - 1 -

LSMW - Examples

LOADGR loading group Type:C Lgth:004 Position:0012 PURCHGR purchasing group Type:C Lgth:003 Position:0013 MRP MRP type Type:C Lgth:002 Position:0014 MRPCONTR MRP controller Type:C Lgth:003 Position:0015 LOT lot size Type:C Lgth:002 Position:0016 CHECKGR check group for availability Type:C Lgth:002 Position:0017 PERIOD period indicator Type:C Lgth:001 Position:0018 SCHED sched marg. key for floats Type:C Lgth:003 Position:0019 STORCOST storage costs indicator Type:C Lgth:001 Position:0020

MATL2 - material master consumption data MATNR material number Type:C Lgth:010 Position:0001 CONDATE consumption date Type:C Lgth:008 Position:0002 CONVALUE consumption value Type:C Lgth:010 Position:0003

Target fields

E1MARAM - Master material general data (MARA) MSGFN Function Type:CHAR Lgth:003 MATNR Material number Type:CHAR Lgth:018 ERSDA Creation date Type:DATS Lgth:008 ERNAM Name of Person who Created the Object Type:CHAR Lgth:012 LAEDA Date of last change Type:DATS Lgth:008 AENAM Name of person who changed object Type:CHAR Lgth:012 PSTAT Maintenance status Type:CHAR Lgth:015 LVORM Flag Material for Deletion at Client Level Type:CHAR Lgth:001 MTART Material type Type:CHAR Lgth:004 MBRSH Industry sector Type:CHAR Lgth:001 MATKL Material group Type:CHAR Lgth:009 BISMT Old material number Type:CHAR Lgth:018 MEINS Base unit of measure Type:UNIT Lgth:003 BSTME Order unit Type:UNIT Lgth:003 ZEINR Document number (without document management system) Type:CHAR Lgth:022 ZEIAR Document type (without Document Management system) Type:CHAR Lgth:003 ZEIVR Document version (without Document Management system) Type:CHAR Lgth:002 ZEIFO Page format of document (w/o Document Management sys.) Type:CHAR Lgth:004 AESZN Document change number (w/o document management sys.) Type:CHAR Lgth:006 BLATT Page number of document (w/o Document Management sys.) Type:CHAR Lgth:003 BLANZ Number of sheets (without Document Management system) Type:NUMC Lgth:003 FERTH Production/inspection memo Type:CHAR Lgth:018 FORMT Page Format of Production Memo Type:CHAR Lgth:004 GROES Size/dimensions Type:CHAR Lgth:032 WRKST Basic material (basic constituent of a material) Type:CHAR Lgth:014 NORMT Industry Standard Description (such as ANSI or ISO) Type:CHAR Lgth:018 LABOR Laboratory/design office Type:CHAR Lgth:003 EKWSL Purchasing value key Type:CHAR Lgth:004 BRGEW Gross weight Type:QUAN Lgth:014 NTGEW Net weight Type:QUAN Lgth:014 GEWEI Weight Unit Type:UNIT Lgth:003 VOLUM Volume Type:QUAN Lgth:014 VOLEH Volume unit Type:UNIT Lgth:003 BEHVO Container requirements Type:CHAR Lgth:002 RAUBE Storage conditions Type:CHAR Lgth:002 TEMPB Temperature conditions indicator Type:CHAR Lgth:002 TRAGR Transportation group Type:CHAR Lgth:004 STOFF Hazardous material number Type:CHAR Lgth:018 SPART Division Type:CHAR Lgth:002 KUNNR Competitor Type:CHAR Lgth:010 WESCH Quantity: Number of GR/GI slips to be printed Type:QUAN Lgth:014 BWVOR Procurement rule Type:CHAR Lgth:001 BWSCL Source of Supply Type:CHAR Lgth:001 SAISO Season category Type:CHAR Lgth:004 ETIAR Label type Type:CHAR Lgth:002

26.04.23 - 2 -

LSMW - Examples

ETIFO Label form Type:CHAR Lgth:002 EAN11 International Article Number (EAN/UPC) Type:CHAR Lgth:018 NUMTP Number category of International Article Number (EAN) Type:CHAR Lgth:002

LAENG Length Type:QUAN Lgth:014 BREIT Width Type:QUAN Lgth:014 HOEHE Height Type:QUAN Lgth:014 MEABM Unit of dimension for length/width/height Type:UNIT Lgth:003 PRDHA Product hierarchy Type:CHAR Lgth:018 CADKZ CAD indicator Type:CHAR Lgth:001 ERGEW Allowed packaging weight Type:QUAN Lgth:014 ERGEI Weight Unit Type:UNIT Lgth:003 ERVOL Allowed packaging volume Type:QUAN Lgth:014 ERVOE Volume unit Type:UNIT Lgth:003 GEWTO Excess weight tolerance for shipping unit Type:DEC Lgth:003 VOLTO Excess volume tolerance limit during packing Type:DEC Lgth:003 VABME Variable order unit active Type:CHAR Lgth:001 KZKFG Configurable Material Type:CHAR Lgth:001 XCHPF Batch management requirement indicator Type:CHAR Lgth:001 VHART Shipping material type Type:CHAR Lgth:004 FUELG Filling level (by volume) Type:DEC Lgth:003 STFAK Stacking factor Type:INT2 Lgth:005 MAGRV Material group: shipping materials Type:CHAR Lgth:004 BEGRU Authorization group Type:CHAR Lgth:004 QMPUR QM in Procurement is Active Type:CHAR Lgth:001 RBNRM Catalog Profile Type:CHAR Lgth:009 MHDRZ Minimum remaining shelf life Type:DEC Lgth:006 MHDHB Total shelf life Type:DEC Lgth:006 MHDLP Storage percentage Type:DEC Lgth:005 VPSTA Maintenance status of complete material Type:CHAR Lgth:015 EXTWG External material group Type:CHAR Lgth:018 MSTAE Cross-Plant Material Status Type:CHAR Lgth:002 MSTAV Cross-distribution-chain material status Type:CHAR Lgth:002 MSTDE Date from which cross-plant material status is valid Type:DATS Lgth:008 MSTDV Date from which X-distr.-chain mat.- status is valid Type:DATS Lgth:008 KZUMW Indicator: Environmentally relevant Type:CHAR Lgth:001 KOSCH Product allocation determination procedure Type:CHAR Lgth:018 NRFHG Material qualifies for discount in kind Type:CHAR Lgth:001 MFRPN Manufacturer part number Type:CHAR Lgth:040 MFRNR Manufacturer number Type:CHAR Lgth:010 BMATN To material number Type:CHAR Lght:018 MPROF Mfr part profile Type:CHAR Lgth:004 PROFL Dangerous goods indicator profile Type:CHAR Lgth:003 IHIVI Indicator: Highly viscous Type:CHAR Lgth:001 ILOOS Indicator: In bulk/liquid Type:CHAR Lgth:001 KZGVH Shipping material is closed packaging Type:CHAR Lgth:001 XGCHP Indicator: Approved batch record required Type:CHAR Lgth:001 COMPL Material completion level Type:NUMC Lgth:002 KZEFF Assign effectivity parameter values/ Type:CHAR Lgth:001 RDMHD Rounding rule for calculation of SLED Type:CHAR Lgth:001 IPRKZ Period indicator for shelf life expiration date Type:CHAR Lgth:001 PRZUS Indicator: Product composition printed on packaging Type:CHAR Lgth:001 MTPOS_MARA General item category group Type:CHAR Lgth:004 GEWTO_NEW Excess weight tolerance for shipping unit Type:DEC Lgth:005 VOLTO_NEW Excess volume tolerance limit during packing Type:DEC Lgth:005 WRKST_NEW Basic Material Type:CHAR Lgth:048

E1MAKTM - Master material short texts (MAKT) MSGFN Function Type:CHAR Lgth:003 SPRAS Language Key Type:LANG Lgth:001 MAKTX Material description Type:CHAR Lgth:040 SPRAS_ISO Language according to ISO 639 Type:CHAR Lgth:002

E1MARCM - Master material C segment (MARC) MSGFN Function Type:CHAR Lgth:003 WERKS Plant Type:CHAR Lgth:004 PSTAT Maintenance status Type:CHAR Lgth:015 LVORM Deletion flag Type:CHAR Lgth:001 BWTTY Valuation category Type:CHAR Lgth:001

26.04.23 - 3 -

LSMW - Examples

MAABC ABC indicator Type:CHAR Lgth:001 KZKRI Indicator: Critical part Type:CHAR Lgth:001 EKGRP Purchasing group Type:CHAR Lgth:003

AUSME Unit of issue Type:UNIT Lgth:003 DISPR Material: MRP profile Type:CHAR Lgth:004 DISMM MRP type Type:CHAR Lgth:002 DISPO MRP controller Type:CHAR Lgth:003 PLIFZ Planned delivery time in days Type:DEC Lgth:003 WEBAZ Goods receipt processing time in days Type:DEC Lgth:003 PERKZ Period indicator Type:CHAR Lgth:001 AUSSS Assembly scrap in percent Type:DEC Lgth:005 DISLS Lot size (materials planning) Type:CHAR Lgth:002 BESKZ Procurement Type Type:CHAR Lgth:001 SOBSL Special procurement type Type:CHAR Lgth:002 MINBE Reorder point Type:QUAN Lgth:014 EISBE Safety stock Type:QUAN Lgth:014 BSTMI Minimum lot size Type:QUAN Lgth:014 BSTMA Maximum lot size Type:QUAN Lgth:014 BSTFE Fixed lot size Type:QUAN Lgth:014 BSTRF Rounding value for purchase order quantity Type:QUAN Lgth:014 MABST Maximum stock level Type:QUAN Lgth:014 LOSFX Ordering costs Type:CURR Lgth:012 SBDKZ Dependent reqmts ind. for individual and coll. reqmts Type:CHAR Lgth:001 LAGPR Storage costs indicator Type:CHAR Lgth:001 ALTSL Method for Selecting Alternative Bills of Material Type:CHAR Lgth:001 KZAUS Discontinuation indicator Type:CHAR Lgth:001 AUSDT Effective-out date Type:DATS Lgth:008 NFMAT Follow-up material Type:CHAR Lgth:018 KZBED Indicator for Requirements Grouping Type:CHAR Lgth:001 MISKZ Mixed MRP indicator Type:CHAR Lgth:001 FHORI Scheduling Margin Key for Floats Type:CHAR Lgth:003 PFREI Indicator: automatic fixing of planned orders Type:CHAR Lgth:001 FFREI Release indicator for production orders Type:CHAR Lgth:001 RGEKZ Indicator: Backflush Type:CHAR Lgth:001 FEVOR Production scheduler Type:CHAR Lgth:003 BEARZ Processing time Type:DEC Lgth:006 RUEZT Setup and teardown time Type:DEC Lgth:006 TRANZ Interoperation time Type:DEC Lgth:006 BASMG Base quantity Type:QUAN Lgth:014 DZEIT In-house production time Type:DEC Lgth:003 MAXLZ Maximum storage period Type:DEC Lgth:005 LZEIH Unit for maximum storage period Type:UNIT Lgth:003 KZPRO Indicator: withdrawal of stock from production bin Type:CHAR Lgth:001 GPMKZ Indicator: material included in rough-cut planning Type:CHAR Lgth:001 UEETO Overdelivery tolerance limit Type:DEC Lgth:004 UEETK Indicator: Unlimited overdelivery allowed Type:CHAR Lgth:001 UNETO Underdelivery tolerance limit Type:DEC Lgth:004 WZEIT Total replenishment lead time (in workdays) Type:DEC Lgth:003 ATPKZ Replacement part Type:CHAR Lgth:001 VZUSL Surcharge factor for cost in percent Type:DEC Lgth:005 HERBL State of manufacture Type:CHAR Lgth:002 INSMK Post to inspection stock Type:CHAR Lgth:001 SSQSS QA control key Type:CHAR Lgth:008 KZDKZ Documentation required indicator Type:CHAR Lgth:001 UMLMC Stock in transfer (plant to plant) Type:QUAN Lgth:014 LADGR Loading group Type:CHAR Lgth:004 XCHPF Batch management requirement indicator Type:CHAR Lgth:001 USEQU Quota arrangement usage Type:CHAR Lgth:001 LGRAD Service level Type:DEC Lgth:004 AUFTL Splitting Indicator Type:CHAR Lgth:001 PLVAR Plan version Type:CHAR Lgth:002 OTYPE Object type Type:CHAR Lgth:002 OBJID Object ID Type:NUMC Lgth:008 MTVFP Checking group for availability check Type:CHAR Lgth:002 PERIV Fiscal year variant Type:CHAR Lgth:002 KZKFK Indicator: take correction factors into account Type:CHAR Lgth:001 VRVEZ Shipping setup time Type:DEC Lgth:006

26.04.23 - 4 -

LSMW - Examples

VBAMG Base quantity for capacity planning in shipping Type:QUAN Lgth:014 VBEAZ Shipping processing time Type:DEC Lgth:006 LIZYK Delivery cycle Type:CHAR Lgth:004 BWSCL Source of Supply Type:CHAR Lgth:001 KAUTB Indicator: "automatic purchase order allowed" Type:CHAR Lgth:001

KORDB Indicator: Source list requirement Type:CHAR Lgth:001 STAWN Commodity code / Import code number for foreign trade Type:CHAR Lgth:017 HERKL Country of origin of the material Type:CHAR Lgth:003 HERKR Region of origin of material (non-preferential origin) Type:CHAR Lgth:003 EXPME Unit of measure for commodity code (foreign trade) Type:UNIT Lgth:003 MTVER Export/import material group Type:CHAR Lgth:004 PRCTR Profit center Type:CHAR Lgth:010 TRAME Stock in transit Type:QUAN Lgth:015 MRPPP PPC planning calendar Type:CHAR Lgth:003 SAUFT Ind.: Repetitive mfg allowed Type:CHAR Lgth:001 FXHOR Planning time fence Type:NUMC Lgth:003 VRMOD Consumption mode Type:CHAR Lgth:001 VINT1 Consumption period: backward Type:NUMC Lgth:003 VINT2 Consumption period: forward Type:NUMC Lgth:003 STLAL Alternative BOM Type:CHAR Lgth:002 STLAN BOM usage Type:CHAR Lgth:001 PLNNR Key for task list group Type:CHAR Lgth:008 APLAL Group counter Type:CHAR Lgth:002 LOSGR Costing lot size Type:QUAN Lgth:014 SOBSK Special Procurement Type for Costing Type:CHAR Lgth:002 FRTME Production unit Type:UNIT Lgth:003 LGPRO Issue storage location Type:CHAR Lgth:004 DISGR MRP Group Type:CHAR Lgth:004 KAUSF Component scrap in percent Type:DEC Lgth:005 QZGTP Certificate Type Type:CHAR Lgth:004 TAKZT Takt time Type:DEC Lgth:003 RWPRO Range of coverage profile Type:CHAR Lgth:003 COPAM Local field name for CO/PA link to SOP Type:CHAR Lgth:010 ABCIN Physical inventory indicator for cycle counting Type:CHAR Lgth:001 AWSLS Variance key Type:CHAR Lgth:006 SERNP Serial Number Profile Type:CHAR Lgth:004 STDPD Configurable material Type:CHAR Lgth:018 SFEPR Repetitive manufacturing profile Type:CHAR Lgth:004 XMCNG Negative stocks allowed in plant Type:CHAR Lgth:001 QSSYS Required QM System for Vendor Type:CHAR Lgth:004 LFRHY Planning cycle Type:CHAR Lgth:003 RDPRF Rounding profile Type:CHAR Lgth:004 VRBMT Reference material for consumption Type:CHAR Lgth:018 VRBWK Reference plant for consumption Type:CHAR Lgth:004 VRBDT To date of the material to be copied for consumption Type:DATS Lgth:008 VRBFK Multiplier for reference material for consumption Type:DEC Lgth:005 AUTRU Reset forecast model automatically Type:CHAR Lgth:001 PREFE Preference indicator in export/import Type:CHAR Lgth:001 PRENC Exemption certificate: Indicator for legal control Type:CHAR Lgth:001 PRENO Number of exemption certificate in export/import Type:NUMC Lgth:008 PREND Issue date of exemption certificate Type:DATS Lgth:008 PRENE Indicator: Vendor declaration exists Type:CHAR Lgth:001 PRENG Validity date of vendor declaration Type:DATS Lgth:008 ITARK Indicator: Military goods Type:CHAR Lgth:001 PRFRQ Character field with field length 7 Type:CHAR Lgth:007 KZKUP Indicator: Material can be co-product Type:CHAR Lgth:001 STRGR Planning strategy group Type:CHAR Lgth:002 LGFSB Default storage location for external procurement Type:CHAR Lgth:004 SCHGT Indicator: bulk material Type:CHAR Lgth:001 CCFIX CC indicator is fixed Type:CHAR Lgth:001 EPRIO Withdrawal sequence group for stocks Type:CHAR Lgth:004 QMATA Material Authorization Group for Activities in QM Type:CHAR Lgth:006 PLNTY Task list type Type:CHAR Lgth:001 MMSTA Plant-Specific Material Status Type:CHAR Lgth:002 SFCPF Production scheduling profile Type:CHAR Lgth:006 SHFLG Safety time indicator (with or without safety time) Type:CHAR Lgth:001 SHZET Safety time (in workdays) Type:NUMC Lgth:002 MDACH Action control: planned order processing Type:CHAR Lgth:002

26.04.23 - 5 -

LSMW - Examples

KZECH Determination of batch entry in the production Type:CHAR Lgth:001 MMSTD Date from which plant-specific material status valid Type:DATS Lgth:008 MFRGR Material freight group Type:CHAR Lgth:008 FVIDK Production version to be costed Type:CHAR Lgth:004 INDUS Material CFOP category Type:CHAR Lgth:002 MOWNR CAP: Number of CAP products list Type:CHAR Lgth:012

MOGRU Common Agricultural Policy: Type:CHAR Lgth:006 CASNR CAS number for pharmaceutical products foreign trade Type:CHAR Lgth:015 GPNUM Production stat.: PRODCOM number for foreign trade Type:CHAR Lgth:009 STEUC Control code for consumption taxes in foreign trade Type:CHAR Lgth:016 FABKZ Indicator: Item relevant to JIT delivery schedules Type:CHAR Lgth:001 MATGR Group of materials for transition matrix Type:CHAR Lgth:020 LOGGR Logistics handling group for workload calculation Type:CHAR Lgth:004 VSPVB Proposed Supply Area in Material Master Record Type:CHAR Lgth:010 DPLFS Fair share rule Type:CHAR Lgth:002 DPLPU Indicator: push distribution Type:CHAR Lgth:001 DPLHO Deployment horizon in days Type:DEC Lgth:004 MINLS Minimum lot size for Supply Demand Match Type:QUAN Lgth:015 MAXLS Maximum lot size for Supply Demand Match Type:QUAN Lgth:015 FIXLS Fixed lot size for Supply Demand Match Type:QUAN Lgth:015 LTINC Lot size increment for Supply Demand Match Type:QUAN Lgth:015 COMPL Material completion level Type:NUMC Lgth:002 CONVT Conversion types for production figures Type:CHAR Lgth:002 FPRFM Distribution profile of material in plant Type:CHAR Lgth:003 SHPRO Period profile for safety time Type:CHAR Lgth:003 FXPRU Fixed-price co-product Type:CHAR Lgth:001 KZPSP Indicator for cross-project material Type:CHAR Lgth:001 OCMPF Profile for OCM PP / PS Type:CHAR Lgth:006 APOKZ Indicator: Is material relevant for APO Type:CHAR Lgth:001 AHDIS MRP relevancy for dependent requirements Type:CHAR Lgth:001 EISLO Minimum safety stock Type:QUAN Lgth:015 NCOST No Costing Type:CHAR Lgth:001 MEGRU Unit of measure group Type:CHAR Lgth:004

E1MVEGM - Master material total consumption MSGFN Function Type:CHAR Lgth:003 ERTAG First day of the period to which the values refer Type:DATS Lgth:008 VBWRT Consumption value Type:QUAN Lgth:015 KOVBW Corrected consumption value Type:QUAN Lgth:015 KZEXI Checkbox Type:CHAR Lgth:001 ANTEI Ratio of the corrected value to the original value Type:DEC Lgth:006

E1MARMM - Master material units of measure (MARM) MSGFN Function Type:CHAR Lgth:003 MEINH Alternative unit of measure for stockkeeping unit Type:UNIT Lgth:003 UMREZ Numerator for Conversion to Base Units of Measure Type:DEC Lgth:005 UMREN Denominator for conversion to base units of measure Type:DEC Lgth:005 EAN11 International Article Number (EAN/UPC) Type:CHAR Lgth:018 NUMTP Number category of International Article Number (EAN) Type:CHAR Lgth:002 LAENG Length Type:QUAN Lgth:014 BREIT Width Type:QUAN Lgth:014 HOEHE Height Type:QUAN Lgth:014 MEABM Unit of dimension for length/width/height Type:UNIT Lgth:003 VOLUM Volume Type:QUAN Lgth:014 VOLEH Volume unit Type:UNIT Lgth:003 BRGEW Gross weight Type:QUAN Lgth:014 GEWEI Weight Unit Type:UNIT Lgth:003 MESUB Lower-Level Unit of Measure in a Packing Hierarchy Type:UNIT Lgth:003

E1MBEWM - Master material material valuation (MBEW) MSGFN Function Type:CHAR Lgth:003 BWKEY Valuation area Type:CHAR Lgth:004 BWTAR Valuation type Type:CHAR Lgth:010 LVORM Deletion flag Type:CHAR Lgth:001 VPRSV Price control indicator Type:CHAR Lgth:001 VERPR Moving average price/periodic unit price Type:CURR Lgth:012 STPRS Standard price Type:CURR Lgth:012 PEINH Price unit Type:DEC Lgth:005

26.04.23 - 6 -

LSMW - Examples

BKLAS Valuation class Type:CHAR Lgth:004 VMVPR Price control indicator for previous period Type:CHAR Lgth:001 VMVER Moving average/periodic unit price in previous period Type:CURR Lgth:012 VMSTP Standard price in the previous period Type:CURR Lgth:012 VMPEI Price unit of previous period Type:DEC Lgth:005 VMBKL Valuation class of previous period Type:CHAR Lgth:004

VJVPR Price control indicator for previous year Type:CHAR Lgth:001 VJVER Moving average periodic unit price in previous year Type:CURR Lgth:012 VJSTP Standard price in previous year Type:CURR Lgth:012 LFGJA Fiscal year of current period Type:NUMC Lgth:004 LFMON Current period (posting period) Type:NUMC Lgth:002 BWTTY Valuation category Type:CHAR Lgth:001 ZKPRS Future price Type:CURR Lgth:012 ZKDAT Date as of which the price is valid Type:DATS Lgth:008 BWPRS Valuation price based on tax law: level 1 Type:CURR Lgth:012 BWPRH Valuation price based on commercial law: level 1 Type:CURR Lgth:012 VJBWS Valuation price based on tax law: level 3 Type:CURR Lgth:012 VJBWH Valuation price based on commercial law: level 3 Type:CURR Lgth:012 VVJLB Total valuated stock in year before last Type:QUAN Lgth:015 VVMLB Total valuated stock in period before last Type:QUAN Lgth:015 VVSAL Value of total valuated stock in period before last Type:CURR Lgth:015 ZPLPR Future planned price Type:CURR Lgth:012 ZPLP1 Future Planned Price 1 Type:CURR Lgth:012 ZPLP2 Future Planned Price 2 Type:CURR Lgth:012 ZPLP3 Future Planned Price 3 Type:CURR Lgth:012 ZPLD1 Date from Which Future Planned Price 1 Is Valid Type:DATS Lgth:008 ZPLD2 Date from Which Future Planned Price 2 Is Valid Type:DATS Lgth:008 ZPLD3 Date from Which Future Planned Price 3 Is Valid Type:DATS Lgth:008 KALKZ Indicator: Standard cost estimate for the period Type:CHAR Lgth:001 KALKL Indicator: standard cost estimate for current period Type:CHAR Lgth:001 XLIFO LIFO/FIFO-relevant Type:CHAR Lgth:001 MYPOL Pool number for LIFO valuation Type:CHAR Lgth:004 BWPH1 Valuation price based on commercial law: level 2 Type:CURR Lgth:012 BWPS1 Valuation price based on tax law: level 2 Type:CURR Lgth:012 ABWKZ Lowest value: devaluation indicator Type:NUMC Lgth:002 PSTAT Maintenance status Type:CHAR Lgth:015 KALN1 Cost estimate number - product costing Type:NUMC Lgth:012 KALNR Cost est number for cost est w/o qty structure Type:NUMC Lgth:012 BWVA1 Valuation variant for future standard cost estimate Type:CHAR Lgth:003 BWVA2 Valuation variant for current standard cost estimate Type:CHAR Lgth:003 BWVA3 Valuation variant for past standard cost estimate Type:CHAR Lgth:003 VERS1 Costing version of the future standard cost estimate Type:NUMC Lgth:002 VERS2 Costing version of the current standard cost estimate Type:NUMC Lgth:002 VERS3 Costing version of the previous standard cost estimate Type:NUMC Lgth:002 HRKFT Origin Group as Subdivision of Cost Element Type:CHAR Lgth:004 KOSGR Costing overhead group Type:CHAR Lgth:010 PPRDZ Period of future cost estimate Type:NUMC Lgth:003 PPRDL Period of the current cost estimate Type:NUMC Lgth:003 PPRDV Period of the previous cost estimate Type:NUMC Lgth:003 PDATZ Future fiscal year Type:NUMC Lgth:004 PDATL Fiscal year for current cost estimate Type:NUMC Lgth:004 PDATV Fiscal year of previous cost estimate Type:NUMC Lgth:004 EKALR Material is costed with quantity structure Type:CHAR Lgth:001 VPLPR Previous planned price Type:CURR Lgth:012 MLMAA Material ledger activated at material level Type:CHAR Lgth:001 MLAST Material Price Determination: Control Type:CHAR Lgth:001 VJBKL Valuation class from previous year Type:CHAR Lgth:004 VJPEI Price unit of previous year Type:DEC Lgth:007 HKMAT Material-related origin Type:CHAR Lgth:001 EKLAS Valuation Class for Sales Order Stock Type:CHAR Lgth:004 QKLAS Valuation Class for Project Stock Type:CHAR Lgth:004 MTUSE Usage of the material Type:CHAR Lgth:001 MTORG Origin of the material Type:CHAR Lgth:001 OWNPR Produced in-house Type:CHAR Lgth:001 BWPEI Price unit val. prices based on tax/commercial law Type:DEC Lgth:006

26.04.23 - 7 -

LSMW - Examples

Fieldmapping

All fields not listed of the R/3 structures keep their initial values.

Struct.: E1MARAM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MARAM001'.g_edidd_segnum = '0001'.g_edidd_psgnum = '000000'.g_edidd_hlevel = '02'.clear E1MARAM.

E1MARAM-MSGFN Rule type: Constant E1MARAM-MSGFN = '004'.

E1MARAM-MATNR <=== MATL-MATNR Rule type: Prefix concatenate 'GR00' MATL-MATNR into E1MARAM-MATNR.

E1MARAM-ERSDA Rule type: ABAP Coding * Zielfeld: E1MARAM-ERSDA Erstellungsdatum E1MARAM-ERSDA = SY-DATUM.

E1MARAM-ERNAM Rule type: ABAP Coding * Zielfeld: E1MARAM-ERNAM Name des Sachbearbeiters, der das Objekt hinzu E1MARAM-ERNAM = SY-UNAME.

E1MARAM-PSTAT Rule type: Constant E1MARAM-PSTAT = 'B'.

E1MARAM-MTART <=== MATL-MATTYPE Rule type: ABAP Coding E1MARAM-MTART = MATL-MATTYPE. TRANSLATE E1MARAM-MTART TO UPPER CASE.

E1MARAM-MBRSH <=== MATL-SECTOR Rule type: Translation (reusable) perform lsmw_translate using 'MBRSH' MATL-SECTOR changing E1MARAM-MBRSH.

E1MARAM-MATKL <=== MATL-MATGROUP Rule type: Translation (reusable) perform lsmw_translate using 'MATKL' MATL-MATGROUP changing E1MARAM-MATKL.

E1MARAM-MEINS <=== MATL-UNIT Rule type: ABAP Coding E1MARAM-MEINS = MATL-UNIT. TRANSLATE E1MARAM-MEINS TO UPPER CASE.

26.04.23 - 8 -

LSMW - Examples

E1MARAM-TRAGR <=== MATL-TRANSGR Rule type: Transfer (MOVE) E1MARAM-TRAGR = MATL-TRANSGR.

__END_OF_RECORD__transfer_record.

Struct.: E1MAKTM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MAKTM001'.g_edidd_segnum = '0002'.g_edidd_psgnum = '000001'.g_edidd_hlevel = '03'.clear E1MAKTM.

E1MAKTM-MSGFN Rule type: Constant E1MAKTM-MSGFN = '004'.

E1MAKTM-SPRAS Rule type: Constant E1MAKTM-SPRAS = 'D'.

E1MAKTM-MAKTX <=== MATL-TEXT Rule type: Transfer (MOVE) E1MAKTM-MAKTX = MATL-TEXT.

__END_OF_RECORD__transfer_record.

Struct.: E1MARCM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MARCM001'.g_edidd_segnum = '0003'.g_edidd_psgnum = '000001'.g_edidd_hlevel = '03'.clear E1MARCM.

E1MARCM-MSGFN Rule type: Constant E1MARCM-MSGFN = '004'.

E1MARCM-WERKS <=== MATL-PLANT Rule type: Transfer (MOVE) E1MARCM-WERKS = MATL-PLANT.

E1MARCM-PSTAT Rule type: Constant E1MARCM-PSTAT = 'ABCDEFGKLPQSVXZ'.

E1MARCM-BWTTY Rule type: Constant E1MARCM-BWTTY = 'B'.

E1MARCM-EKGRP <=== MATL-PURCHGR Rule type: Transfer (MOVE) E1MARCM-EKGRP = MATL-PURCHGR.

26.04.23 - 9 -

LSMW - Examples

E1MARCM-DISMM <=== MATL-MRP Rule type: ABAP Coding E1MARCM-DISMM = MATL-MRP. TRANSLATE E1MARCM-DISMM TO UPPER CASE.

E1MARCM-DISPO <=== MATL-MRPCONTR Rule type: Transfer (MOVE) E1MARCM-DISPO = MATL-MRPCONTR.

E1MARCM-PERKZ <=== MATL-PERIOD Rule type: Transfer (MOVE) E1MARCM-PERKZ = MATL-PERIOD.

E1MARCM-DISLS <=== MATL-LOT Rule type: ABAP Coding E1MARCM-DISLS = MATL-LOT. TRANSLATE E1MARCM TO UPPER CASE.

E1MARCM-LAGPR Rule type: Transfer (MOVE) E1MARCM-LAGPR = MATL-STORCOST.

E1MARCM-FHORI Rule type: Transfer (MOVE) E1MARCM-FHORI = MATL-SCHED.

E1MARCM-LADGR <=== MATL-LOADGR Rule type: Transfer (MOVE) E1MARCM-LADGR = MATL-LOADGR.

E1MARCM-MTVFP <=== MATL-CHECKGR Rule type: Transfer (MOVE) E1MARCM-MTVFP = MATL-CHECKGR.

E1MARCM-LOSGR Rule type: Constant E1MARCM-LOSGR = '1000'.

E1MARCM-LGPRO <=== MATL-LOCATION Rule type: Transfer (MOVE) E1MARCM-LGPRO = MATL-LOCATION.

__END_OF_RECORD__transfer_record.

Struct.: E1MVEGM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MVEGM'.g_edidd_segnum = '0009'.g_edidd_psgnum = '000003'.g_edidd_hlevel = '04'.clear E1MVEGM.

E1MVEGM-MSGFN Rule type: Constant E1MVEGM-MSGFN = '004'.

E1MVEGM-ERTAG <=== MATL2-CONDATE Rule type: Transfer (MOVE)

26.04.23 - 10 -

LSMW - Examples

E1MVEGM-ERTAG = MATL2-CONDATE.

E1MVEGM-VBWRT <=== MATL2-CONVALUE Rule type: Transfer (MOVE) E1MVEGM-VBWRT = MATL2-CONVALUE.

__END_OF_RECORD__transfer_record.

Struct.: E1MARMM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MARMM'.g_edidd_segnum = '0012'.g_edidd_psgnum = '000001'.g_edidd_hlevel = '03'.clear E1MARMM.

E1MARMM-MSGFN Rule type: Constant E1MARMM-MSGFN = '004'.

E1MARMM-MEINH Rule type: Constant E1MARMM-MEINH = 'ST'.

__END_OF_RECORD__transfer_record.

Struct.: E1MBEWM

__BEGIN_OF_RECORD__g_edidd_segnam = 'E2MBEWM001'.g_edidd_segnum = '0014'.g_edidd_psgnum = '000001'.g_edidd_hlevel = '03'.clear E1MBEWM.

E1MBEWM-MSGFN Rule type: Constant E1MBEWM-MSGFN = '004'.

E1MBEWM-BWKEY Rule type: Constant E1MBEWM-BWKEY = '0001'.

E1MBEWM-VPRSV Rule type: Constant E1MBEWM-VPRSV = 'S'.

E1MBEWM-PEINH Rule type: Constant E1MBEWM-PEINH = '10'.

E1MBEWM-BKLAS Rule type: Constant E1MBEWM-BKLAS = '3000'.

E1MBEWM-VMVPR Rule type: Constant

26.04.23 - 11 -

LSMW - Examples

E1MBEWM-VMVPR = 'S'.

E1MBEWM-VMPEI Rule type: Constant E1MBEWM-VMPEI = '10'.

E1MBEWM-VMBKL Rule type: Constant E1MBEWM-VMBKL = '3000'.

E1MBEWM-VJVPR Rule type: Constant E1MBEWM-VJVPR = 'S'.

E1MBEWM-VJBKL Rule type: Constant E1MBEWM-VJBKL = '3000'.

E1MBEWM-VJPEI Rule type: Constant E1MBEWM-VJPEI = '10'.

__END_OF_RECORD__transfer_record.

__END_OF_TRANSACTION__transfer_transaction.

26.04.23 - 12 -