Welcome!
By Felipe Lamounier, state of Minas Gerais, Brazil – powered by 🙂My Easy B.I.
🏁 Introduction:
In this article we will identify the tables that are part of the SAP MM module (Material Management) in the SAP ECC on HANA version.
In addition to listing these tables, their relationships and key fields and the full table structure will be shown. So you will have an overview of the SAP MM structure.
🔭 Veja também Posts Relacionados:
📑 Table of Contents:
Relationships:
SAP MM – Materials Management – Overview
SAP MM – Table Mapping
SAP MM – Purchasing Requisition
SAP MM – Purchasing – Purchase Orders
SAP MM – Purchasing – Goods Receipt
SAP MM – Master Data
SAP MM – Purchasing – Info Record
Tables covered – only keys:
EBAN – Purchase Requisition
EBKN – Purchase Requisition Account Assignment
EINA – Purchasing Info Record: General Data
EINE – Purchasing Info Record: Purchasing Organization Data
EKBE – History per Purchasing Document
EKET – Scheduling Agreement Schedule Lines
EKKN – Account Assignment in Purchasing Document
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EORD – Purchasing Source List
KNMT – Customer-Material Info Record Data Table
KONH – Conditions (Header)
KONP – Conditions (Item)
MARA – General Material Data
MDKP – Header Data for MRP Document
MDTB – MRP Table
MKPF – Header: Material Document
MSEG – Document Segment: Material
MVER – Material Consumption
Tables covered – full table structure:
EBAN – Purchase Requisition
EBKN – Purchase Requisition Account Assignment
EINA – Purchasing Info Record: General Data
EINE – Purchasing Info Record: Purchasing Organization Data
EKBE – History per Purchasing Document
EKET – Scheduling Agreement Schedule Lines
EKKN – Account Assignment in Purchasing Document
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EORD – Purchasing Source List
KNMT – Customer-Material Info Record Data Table
KONH – Conditions (Header)
KONP – Conditions (Item)
MARA – General Material Data
MDKP – Header Data for MRP Document
MDTB – MRP Table
MKPF – Header: Material Document
MSEG – Document Segment: Material
MVER – Material Consumption
Want to learn more? Access our area 🎓🚀Training&Education↗
📖 Content – Relationships:
SAP MM – Materials Management – Overview:
![SAP MM Materials Management Relationship Overview showing the relationship between table of MM (Material management), Purchasing, Invoice Verification, Financial Accouting e Accounts Payable](https://myeasybi.com/wp-content/uploads/2022/05/image-17.png)
SAP MM – Table Mapping:
![SAP MM Table Mapping, with tables KNMT (Customer Material Info Record), MAKT (Material Description), EKKO (Purchasing Doc Header), EKPO (Purchasing Doc Item), MDKP (MRP Header) and MDTB (MRP Detail)](https://myeasybi.com/wp-content/uploads/2022/05/image-18.png)
SAP MM – Purchasing Requisition:
![SAP MM Purchasing Requisition Relationship diagram with tables STXH, STXL, EBAN (Purchase Requisition) and EKBN (Purchase Requisition Account)](https://myeasybi.com/wp-content/uploads/2022/05/image-19.png)
SAP MM – Purchasing – Purchase Orders:
![SAP MM – Purchasing – Purchase Orders Relationship diagram with tables S011, EKET (Delivery Schedules), EKKN (Account Assignment in Purchasing Document), S012, EKPO (Purchasing
Document Item) , EKKO (Purchasing Document Header) , EINE, EINA, EORD](https://myeasybi.com/wp-content/uploads/2022/05/image-20.png)
SAP MM – Purchasing – Goods Receipt:
![SAP MM – Purchasing – Goods Receipt, relationship diagram with tables MKPF (Header: Material Document) , MSEG (Document Segment: Material) , EKBE (History of Purchasing Document) , MVER (Material consumption) , S031 (Statistics: Movements for current stocks) , S011 (PURCHIS: Purchasing Group Statistics) and S013 (PURCHIS: Statistics for Vendor Evaluation)](https://myeasybi.com/wp-content/uploads/2022/05/image-21.png)
SAP MM – Master Data:
![SAP MM – Master Data, relationship diagram with tables MARC (Material Master: C Segment) , MLAN (Tax Classification: Material) , MAKT (Material Description) , MARA (Material Master: General Data) , MARM (Units of Measure) and MBEW (Material Valuation)](https://myeasybi.com/wp-content/uploads/2022/05/image-22.png)
SAP MM – Purchasing – Info Record:
![SAP MM – Purchasing – Info Record, relationship diagram with tableas KONP (Conditions Item) , KONH (Conditions Header) , EINA (Purchasing Info Record: General Data) , EINE (Purchasing Info Record: Purchasing Organization Data) , A017 (Material Info Record Plant specific)](https://myeasybi.com/wp-content/uploads/2022/05/image-23.png)
📖 Content – Tables covered – only keys:
EBAN – Purchase Requisition:
Fields | Data Type | Description |
---|---|---|
🔑BANFN | CHAR (10) | Purchase Requisition Number |
🔑BNFPO | NUMC (5) | Item number of purchase requisition |
EBKN – Purchase Requisition Account Assignment:
Fields | Data Type | Description |
---|---|---|
🔑BANFN | CHAR (10) | Purchase Requisition Number |
🔑BNFPO | NUMC (5) | Item number of purchase requisition |
🔑ZEBKN | NUMC (2) | Serial number for PReq account assignment segment |
EINA – Purchasing Info Record: General Data:
Fields | Data Type | Description |
---|---|---|
🔑INFNR | CHAR (10) | Number of purchasing info record |
EINE – Purchasing Info Record: Purchasing Organization Data:
Fields | Data Type | Description |
---|---|---|
🔑INFNR | CHAR (10) | Number of purchasing info record |
🔑EKORG | CHAR (4) | Purchasing Organization |
🔑ESOKZ | CHAR (1) | Purchasing info record category |
🔑WERKS | CHAR (4) | Plant |
EKBE – History per Purchasing Document:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ZEKKN | NUMC (2) | Sequential Number of Account Assignment |
🔑VGABE | CHAR (1) | Transaction/event type, purchase order history |
🔑GJAHR | NUMC (4) | Material Document Year |
🔑BELNR | CHAR (10) | Number of Material Document |
🔑BUZEI | NUMC (4) | Item in Material Document |
EKET – Scheduling Agreement Schedule Lines:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ETENR | NUMC (4) | Delivery Schedule Line Counter |
EKKN – Account Assignment in Purchasing Document:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ZEKKN | NUMC (2) | Sequential Number of Account Assignment |
EKKO – Purchasing Document Header:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
EKPO – Purchasing Document Item:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
EORD – Purchasing Source List:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
🔑WERKS | CHAR (4) | Plant |
🔑ZEORD | NUMC (5) | Number of Source List Record |
KNMT – Customer-Material Info Record Data Table:
Fields | Data Type | Description |
---|---|---|
🔑VKORG | CHAR (4) | Sales Organization |
🔑VTWEG | CHAR (2) | Distribution Channel |
🔑KUNNR | CHAR (10) | Customer number |
🔑MATNR | CHAR (18) | Material Number |
KONH – Conditions (Header):
Fields | Data Type | Description |
---|---|---|
🔑KNUMH | CHAR (10) | Condition record number |
KONP – Conditions (Item):
Fields | Data Type | Description |
---|---|---|
🔑KNUMH | CHAR (10) | Condition record number |
🔑KOPOS | NUMC (2) | Sequential number of the condition |
MARA – General Material Data:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
MDKP – Header Data for MRP Document:
Fields | Data Type | Description |
---|---|---|
🔑DTART | CHAR (2) | Type of MRP list |
🔑MATNR | CHAR (18) | Material Number |
🔑PLWRK | CHAR (4) | Plant |
🔑PLSCN | NUMC (3) | Planning Scenario of Long-Term Planning |
MDTB – MRP Table:
Fields | Data Type | Description |
---|---|---|
🔑DTNUM | NUMC (10) | Number of material requirements planning table |
🔑DTPOS | NUMC (6) | Item number of MRP list |
MKPF – Header: Material Document:
Fields | Data Type | Description |
---|---|---|
🔑MBLNR | CHAR (10) | Number of Material Document |
🔑MJAHR | NUMC (4) | Material Document Year |
MSEG – Document Segment: Material:
Fields | Data Type | Description |
---|---|---|
🔑MBLNR | CHAR (10) | Number of Material Document |
🔑MJAHR | NUMC (4) | Material Document Year |
🔑ZEILE | NUMC (4) | Item in Material Document |
MVER – Material Consumption:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
🔑WERKS | CHAR (4) | Plant |
🔑GJAHR | NUMC (4) | Fiscal Year |
🔑PERKZ | CHAR (1) | Period Indicator |
🔑ZAHLR | NUMC (2) | Number of follow-on records in Table MVER |
📖 Content – Tables covered – full table structure:
EBAN – Purchase Requisition:
Fields | Data Type | Description |
---|---|---|
🔑BANFN | CHAR (10) | Purchase Requisition Number |
🔑BNFPO | NUMC (5) | Item number of purchase requisition |
BSART | CHAR (4) | Purchase Requisition Document Type |
BSTYP | CHAR (1) | Purchasing document category |
BSAKZ | CHAR (1) | Control indicator for purchasing document type |
LOEKZ | CHAR (1) | Deletion indicator in purchasing document |
STATU | CHAR (1) | Processing status of purchase requisition |
ESTKZ | CHAR (1) | Creation indicator (purchase requisition/schedule lines) |
FRGKZ | CHAR (1) | Release Indicator |
FRGZU | CHAR (8) | Release State |
FRGST | CHAR (2) | Release strategy in the purchase requisition |
EKGRP | CHAR (3) | Purchasing Group |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
ERDAT | DATS (8) | Date of Last Change |
AFNAM | CHAR (12) | Name of requisitioner/requester |
TXZ01 | CHAR (40) | Short Text |
MATNR | CHAR (18) | Material Number |
EMATN | CHAR (18) | Material number corresponding to manufacturer part number |
WERKS | CHAR (4) | Plant |
LGORT | CHAR (4) | Storage Location |
BEDNR | CHAR (10) | Requirement Tracking Number |
MATKL | CHAR (9) | Material Group |
RESWK | CHAR (4) | Supplying (issuing) plant in case of stock transport order |
MENGE | QUAN (13) | Purchase requisition quantity |
MEINS | UNIT (3) | Purchase requisition unit of measure |
BUMNG | QUAN (13) | Shortage (stock undercoverage) quantity |
BADAT | DATS (8) | Requisition (Request) Date |
LPEIN | CHAR (1) | Category of delivery date |
LFDAT | DATS (8) | Item delivery date |
FRGDT | DATS (8) | Purchase Requisition Release Date |
WEBAZ | DEC (3) | Goods receipt processing time in days |
PREIS | CURR (11) | Price in Purchase Requisition |
PEINH | DEC (5) | Price unit |
PSTYP | CHAR (1) | Item category in purchasing document |
KNTTP | CHAR (1) | Account Assignment Category |
KZVBR | CHAR (1) | Consumption posting |
KFLAG | CHAR (1) | Acct.asst.modifiable |
VRTKZ | CHAR (1) | Distribution indicator for multiple account assignment |
TWRKZ | CHAR (1) | Partial invoice indicator |
WEPOS | CHAR (1) | Goods Receipt Indicator |
WEUNB | CHAR (1) | Goods Receipt, Non-Valuated |
REPOS | CHAR (1) | Invoice receipt indicator |
LIFNR | CHAR (10) | Desired Vendor |
FLIEF | CHAR (10) | Fixed vendor |
EKORG | CHAR (4) | Purchasing Organization |
VRTYP | CHAR (1) | Purchasing document category |
KONNR | CHAR (10) | Number of principal purchase agreement |
KTPNR | NUMC (5) | Item number of principal purchase agreement |
INFNR | CHAR (10) | Number of purchasing info record |
ZUGBA | CHAR (1) | Assigned Source of Supply |
QUNUM | CHAR (10) | Number of quota arrangement |
QUPOS | NUMC (3) | Quota arrangement item |
DISPO | CHAR (3) | MRP Controller |
SERNR | CHAR (8) | BOM explosion number |
BVDAT | DATS (8) | Date of last resubmission |
BATOL | DEC (3) | Resubmission interval of purchase requisition |
BVDRK | DEC (7) | Number of resubmissions |
EBELN | CHAR (10) | Purchase order number |
EBELP | NUMC (5) | Purchase order item number |
BEDAT | DATS (8) | Purchase Order Date |
BSMNG | QUAN (13) | Quantity ordered against this purchase requisition |
LBLNI | CHAR (10) | Entry Sheet Number |
BWTAR | CHAR (10) | Valuation Type |
XOBLR | CHAR (1) | Item affects commitments |
EBAKZ | CHAR (1) | Purchase requisition closed |
RSNUM | NUMC (10) | Number of reservation/dependent requirements |
SOBKZ | CHAR (1) | Special Stock Indicator |
ARSNR | NUMC (10) | Settlement reservation number |
ARSPS | NUMC (4) | Item number of the settlement reservation |
FIXKZ | CHAR (1) | Purchase requisition is fixed |
BMEIN | UNIT (3) | Purchase Order Unit of Measure |
REVLV | CHAR (2) | Revision level |
VORAB | CHAR (1) | Advance procurement: project stock |
PACKNO | NUMC (10) | Package number |
KANBA | CHAR (1) | Kanban Indicator |
BPUEB | CHAR (1) | Use Requisition Price in Purchase Order |
CUOBJ | NUMC (18) | Configuration (internal object number) |
FRGGR | CHAR (2) | Release group |
FRGRL | CHAR (1) | Release Not Yet Completely Effected |
AKTNR | CHAR (10) | Promotion |
CHARG | CHAR (10) | Batch Number |
UMSOK | CHAR (1) | Special stock indicator for physical stock transfer |
VERID | CHAR (4) | Production Version |
FIPOS | CHAR (14) | Commitment Item |
FISTL | CHAR (16) | Funds Center |
GEBER | CHAR (10) | Fund |
KZKFG | CHAR (1) | Origin of Configuration |
SATNR | CHAR (18) | Cross-Plant Configurable Material |
MNG02 | QUAN (13) | Committed Quantity |
DAT01 | DATS (8) | Committed date |
ATTYP | CHAR (2) | Material Category |
ADRNR | CHAR (10) | Manual address number in purchasing document item |
ADRN2 | CHAR (10) | Number of delivery address |
KUNNR | CHAR (10) | Customer |
EMLIF | CHAR (10) | Vendor to be supplied/who is to receive delivery |
LBLKZ | CHAR (1) | Subcontracting vendor |
KZBWS | CHAR (1) | Valuation of Special Stock |
WAERS | CUKY (5) | Currency Key |
IDNLF | CHAR (35) | Material Number Used by Vendor |
GSFRG | CHAR (1) | Overall release of purchase requisitions |
MPROF | CHAR (4) | Mfr part profile |
KZFME | CHAR (1) | Units of measure usage |
SPRAS | LANG (1) | Language Key |
TECHS | CHAR (12) | Parameter Variant/Standard Variant |
MFRPN | CHAR (40) | Manufacturer Part Number |
MFRNR | CHAR (10) | Manufacturer number |
EMNFR | CHAR (10) | External manufacturer code name or number |
FORDN | CHAR (10) | Framework Order |
FORDP | NUMC (5) | Item of framework order |
PLIFZ | DEC (3) | Planned Delivery Time in Days |
BERID | CHAR (10) | MRP Area |
UZEIT | TIMS (6) | Delivery Date Time-Spot |
FKBER | CHAR (16) | Functional Area |
GRANT_NBR | CHAR (20) | Grant |
MEMORY | CHAR (1) | Purchase Requisition not yet Complete |
BANPR | CHAR (2) | Requisition Processing State |
RLWRT | CURR (15) | Total value at time of release |
BLCKD | CHAR (1) | Purchase Requisition Blocked |
REVNO | CHAR (8) | Version number in Purchasing |
BLCKT | CHAR (60) | Reason for Item Block |
BESWK | CHAR (4) | Procuring Plant |
EPROFILE | CHAR (2) | External Procurement Profile |
EPREFDOC | CHAR (10) | External Procurement Reference Document |
EPREFITM | NUMC (5) | External Procurement Reference Item |
GMMNG | QUAN (13) | PO Quantity of Purchase Requisition in POs on Hold |
WRTKZ | CHAR (1) | Value-Based Commitment Reduction for Service Purchase Reqs |
RESLO | CHAR (4) | Issuing Storage Location for Stock Transport Order |
KBLNR | CHAR (10) | Document Number for Earmarked Funds |
KBLPOS | NUMC (3) | Earmarked Funds: Document Item |
PRIO_URG | NUMC (2) | Requirement Urgency |
PRIO_REQ | NUMC (3) | Requirement Priority |
MEMORYTYPE | CHAR (1) | Category of Incompleteness |
ANZSN | INT4 (10) | Number of serial numbers |
MHDRZ | DEC (4) | Minimum Remaining Shelf Life |
IPRKZ | CHAR (1) | Period Indicator for Shelf Life Expiration Date |
NODISP | CHAR (1) | Ind: Reserv. not applicable to MRP;Purc. req. not created |
SRM_CONTRACT_ID | CHAR (10) | Central Contract |
SRM_CONTRACT_ITM | NUMC (10) | Central Contract Item Number |
BUDGET_PD | CHAR (10) | FM: Budget Period |
EBKN – Purchase Requisition Account Assignment:
Fields | Data Type | Description |
---|---|---|
🔑BANFN | CHAR (10) | Purchase Requisition Number |
🔑BNFPO | NUMC (5) | Item number of purchase requisition |
🔑ZEBKN | NUMC (2) | Serial number for PReq account assignment segment |
LOEKZ | CHAR (1) | Deletion indicator in purchasing document |
ERDAT | DATS (8) | Date on Which Record Was Created |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
MENGE | QUAN (13) | Purchase requisition quantity |
VPROZ | DEC (3) | Distribution percentage in the case of multiple acct assgt |
SAKTO | CHAR (10) | G/L Account Number |
GSBER | CHAR (4) | Business Area |
KOSTL | CHAR (10) | Cost Center |
PROJN | CHAR (16) | Old: Project number : No longer used –> PS_POSNR |
VBELN | CHAR (10) | Sales and Distribution Document Number |
VBELP | NUMC (6) | Sales Document Item |
VETEN | NUMC (4) | Schedule Line Number |
ANLN1 | CHAR (12) | Main Asset Number |
ANLN2 | CHAR (4) | Asset Subnumber |
AUFNR | CHAR (12) | Order Number |
WEMPF | CHAR (12) | Goods recipient |
ABLAD | CHAR (25) | Unloading Point |
KOKRS | CHAR (4) | Controlling Area |
XBKST | CHAR (1) | Posting to cost center? |
XBAUF | CHAR (1) | Post To Order |
XBPRO | CHAR (1) | Post to project |
KSTRG | CHAR (12) | Cost Object |
PAOBJNR | NUMC (10) | Profitability Segment Number (CO-PA) |
PRCTR | CHAR (10) | Profit Center |
PS_PSP_PNR | NUMC (8) | Work Breakdown Structure Element (WBS Element) |
NPLNR | CHAR (12) | Network Number for Account Assignment |
AUFPL | NUMC (10) | Routing number of operations in the order |
IMKEY | CHAR (8) | Internal Key for Real Estate Object |
APLZL | NUMC (8) | Internal counter |
VPTNR | CHAR (10) | Partner account number |
FIPOS | CHAR (14) | Commitment Item |
RECID | CHAR (2) | Recovery Indicator |
EINA – Purchasing Info Record: General Data:
Fields | Data Type | Description |
---|---|---|
🔑INFNR | CHAR (10) | Number of purchasing info record |
MATNR | CHAR (18) | Material Number |
MATKL | CHAR (9) | Material Group |
LIFNR | CHAR (10) | Vendor’s account number |
LOEKZ | CHAR (1) | Purchasing info: General data flagged for deletion |
ERDAT | DATS (8) | Date on Which Record Was Created |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
TXZ01 | CHAR (40) | Short Text for Purchasing Info Record |
SORTL | CHAR (10) | Sort Term for Non-Stock Info Records |
MEINS | UNIT (3) | Purchase Order Unit of Measure |
UMREZ | DEC (5) | Numerator for Conversion of Order Unit to Base Unit |
UMREN | DEC (5) | Denominator for Conversion of Order Unit to Base Unit |
IDNLF | CHAR (35) | Material Number Used by Vendor |
VERKF | CHAR (30) | Salesperson Responsible in the Event of Queries |
TELF1 | CHAR (16) | Vendor’s Telephone Number |
MAHN1 | DEC (3) | Number of Days for First Reminder/Expediter |
MAHN2 | DEC (3) | Number of Days for Second Reminder/Expediter |
MAHN3 | DEC (3) | Number of Days for Third Reminder/Expediter |
URZNR | CHAR (10) | Certificate Number |
URZDT | DATS (8) | Certificate of Origin Valid Until |
URZLA | CHAR (3) | Country of Issue of Certificate of Origin |
URZTP | CHAR (1) | Certificate Category |
URZZT | CHAR (16) | Number |
LMEIN | UNIT (3) | Base Unit of Measure |
REGIO | CHAR (3) | Region (State, Province, County) |
VABME | CHAR (1) | Variable Purchase Order Unit Active |
LTSNR | CHAR (6) | Vendor Subrange |
LTSSF | NUMC (5) | Sort Sequence Number |
WGLIF | CHAR (18) | Vendor Material Group |
RUECK | CHAR (2) | Return Agreement |
LIFAB | DATS (8) | Available (Deliverable) From |
LIFBI | DATS (8) | Available (Deliverable) Until |
KOLIF | CHAR (10) | Prior Vendor |
ANZPU | QUAN (13) | Number of Points |
PUNEI | UNIT (3) | Points unit |
RELIF | CHAR (1) | Regular Vendor |
MFRNR | CHAR (10) | Manufacturer |
EINE – Purchasing Info Record: Purchasing Organization Data:
Fields | Data Type | Description |
---|---|---|
🔑INFNR | CHAR (10) | Number of purchasing info record |
🔑EKORG | CHAR (4) | Purchasing Organization |
🔑ESOKZ | CHAR (1) | Purchasing info record category |
🔑WERKS | CHAR (4) | Plant |
LOEKZ | CHAR (1) | Purch. info: Purch. organization data flagged for deletion |
ERDAT | DATS (8) | Date on Which Record Was Created |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
EKGRP | CHAR (3) | Purchasing Group |
WAERS | CUKY (5) | Currency Key |
BONUS | CHAR (1) | Indicator: Volume-Based Rebate |
MGBON | CHAR (1) | Indicator: Quantity-Based Volume Rebate |
MINBM | QUAN (13) | Minimum Purchase Order Quantity |
NORBM | QUAN (13) | Standard Purchase Order Quantity |
APLFZ | DEC (3) | Planned Delivery Time in Days |
UEBTO | DEC (3) | Overdelivery Tolerance Limit |
UEBTK | CHAR (1) | Indicator: Unlimited Overdelivery Allowed |
UNTTO | DEC (3) | Underdelivery Tolerance Limit |
ANGNR | CHAR (10) | Quotation Number |
ANGDT | DATS (8) | Quotation Validity Date |
ANFNR | CHAR (10) | RFQ Number |
ANFPS | NUMC (5) | Item Number of RFQ |
ABSKZ | CHAR (1) | Rejection Indicator |
AMODV | DATS (8) | Amortization period from |
AMODB | DATS (8) | Amortization period to |
AMOBM | QUAN (15) | Amortized planned quantity |
AMOBW | CURR (15) | Amortized planned value |
AMOAM | QUAN (15) | Amortized actual quantity |
AMOAW | CURR (15) | Amortized actual value |
AMORS | CHAR (1) | Indicator: Amortization reset |
BSTYP | CHAR (1) | Purchasing document category |
EBELN | CHAR (10) | Purchasing Document Number |
EBELP | NUMC (5) | Item Number of Purchasing Document |
DATLB | DATS (8) | Date of Last PO or Sched. Agreement Document in Info Record |
NETPR | CURR (11) | Net Price in Purchasing Info Record |
PEINH | DEC (5) | Price unit |
BPRME | UNIT (3) | Order Price Unit (Purchasing) |
PRDAT | DATS (8) | Price Valid Until |
BPUMZ | DEC (5) | Numerator for Conversion of Order Price Unit into Order Unit |
BPUMN | DEC (5) | Denominator for Conv. of Order Price Unit into Order Unit |
MTXNO | CHAR (1) | Material Master Record PO Text Not Relevant |
WEBRE | CHAR (1) | Indicator: GR-Based Invoice Verification |
EFFPR | CURR (11) | Effective Price in Purchasing Info Record |
EKKOL | CHAR (4) | Condition Group with Vendor |
SKTOF | CHAR (1) | Item Does Not Qualify for Cash Discount |
KZABS | CHAR (1) | Order Acknowledgment Requirement |
MWSKZ | CHAR (2) | Tax on Sales/Purchases Code |
BWTAR | CHAR (10) | Valuation Type |
EBONU | CHAR (2) | Settlement Group 1 (Purchasing) |
EVERS | CHAR (2) | Shipping Instructions |
EXPRF | CHAR (8) | Export/Import Procedure for Foreign Trade |
BSTAE | CHAR (4) | Confirmation Control Key |
MEPRF | CHAR (1) | Price Determination (Pricing) Date Control |
INCO1 | CHAR (3) | Incoterms (Part 1) |
INCO2 | CHAR (28) | Incoterms (Part 2) |
XERSN | CHAR (1) | No Evaluated Receipt Settlement (ERS) |
EBON2 | CHAR (2) | Settlement Group 2 (Rebate Settlement, Purchasing) |
EBON3 | CHAR (2) | Settlement Group 3 (Rebate Settlement, Purchasing) |
EBONF | CHAR (1) | Item Not Relevant to Subseq. (Period-End Rebate) Settlement |
MHDRZ | DEC (4) | Minimum Remaining Shelf Life |
VERID | CHAR (4) | Production Version |
BSTMA | QUAN (13) | Maximum Purchase Order Quantity |
RDPRF | CHAR (4) | Rounding Profile |
MEGRU | CHAR (4) | Unit of Measure Group |
J_1BNBM | CHAR (16) | Brazilian NCM Code |
SPE_CRE_REF_DOC | CHAR (1) | Create Purchase Order for Delivery Without Reference |
IPRKZ | CHAR (1) | Period Indicator for Shelf Life Expiration Date |
CO_ORDER | CHAR (1) | Real-Time Consumption Posting of Subcontracting Components |
VENDOR_RMA_REQ | CHAR (1) | Vendor RMA Number Required |
DIFF_INVOICE | CHAR (2) | Differential Invoicing |
CO_ORDER | CHAR (1) | Real-Time Consumption Posting of Subcontracting Components |
VENDOR_RMA_REQ | CHAR (1) | Vendor RMA Number Required |
DIFF_INVOICE | CHAR (2) | Differential Invoicing |
INCOV | CHAR (4) | Incoterms Version |
INCO2_L | CHAR (70) | Incoterms Location 1 |
INCO3_L | CHAR (70) | Incoterms Location 2 |
FSH_DCI_CORR | CHAR (1) | Delivery Completion Indicator Correlation |
FSH_RLT | DEC (3) | Replenishment Lead Time for Raw Material |
FSH_MLT | DEC (3) | Manufacturing Lead Time |
FSH_PLT | DEC (3) | Packing Lead time |
FSH_TLT | DEC (3) | Transportation Lead time |
MRPIND | CHAR (1) | Max. Retail Price Relevant |
SGT_SSREL | CHAR (1) | Stock Segment Relevant Indicator |
TRANSPORT_CHAIN | CHAR (10) | Transportation Chain |
STAGING_TIME | DEC (3) | Staging Time in Days |
EKBE – History per Purchasing Document:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ZEKKN | NUMC (2) | Sequential Number of Account Assignment |
🔑VGABE | CHAR (1) | Transaction/event type, purchase order history |
🔑GJAHR | NUMC (4) | Material Document Year |
🔑BELNR | CHAR (10) | Number of Material Document |
🔑BUZEI | NUMC (4) | Item in Material Document |
BEWTP | CHAR (1) | Purchase Order History Category |
BWART | CHAR (3) | Movement type (inventory management) |
BUDAT | DATS (8) | Posting Date in the Document |
MENGE | QUAN (13) | Quantity |
BPMNG | QUAN (13) | Quantity in purchase order price unit |
DMBTR | CURR (13) | Amount in local currency |
WRBTR | CURR (13) | Amount in document currency |
WAERS | CUKY (5) | Currency Key |
AREWR | CURR (13) | GR/IR account clearing value in local currency |
WESBS | QUAN (13) | Goods Receipt Blocked Stock in Order Unit |
BPWES | QUAN (13) | Quantity in GR blocked stock in order price unit |
SHKZG | CHAR (1) | Debit/Credit Indicator |
BWTAR | CHAR (10) | Valuation Type |
ELIKZ | CHAR (1) | Delivery Completed Indicator |
XBLNR | CHAR (16) | Reference Document Number |
LFGJA | NUMC (4) | Fiscal Year of a Reference Document |
LFBNR | CHAR (10) | Document No. of a Reference Document |
LFPOS | NUMC (4) | Item of a Reference Document |
GRUND | NUMC (4) | Reason for Movement |
CPUDT | DATS (8) | Day On Which Accounting Document Was Entered |
CPUTM | TIMS (6) | Time of Entry |
REEWR | CURR (13) | Invoice Value Entered (in Local Currency) |
EVERE | CHAR (2) | Compliance with Shipping Instructions |
REFWR | CURR (13) | Invoice Value in Foreign Currency |
MATNR | CHAR (18) | Material Number |
WERKS | CHAR (4) | Plant |
XWSBR | CHAR (1) | Reversal of GR allowed for GR-based IV despite invoice |
ETENS | NUMC (4) | Sequential Number of Vendor Confirmation |
KNUMV | CHAR (10) | Number of the document condition |
MWSKZ | CHAR (2) | Tax on Sales/Purchases Code |
LSMNG | QUAN (13) | Quantity in Unit of Measure from Delivery Note |
LSMEH | UNIT (3) | Unit of Measure From Delivery Note |
EMATN | CHAR (18) | Material number |
AREWW | CURR (13) | Clearing value on GR/IR clearing account (transac. currency) |
HSWAE | CUKY (5) | Local currency key |
BAMNG | QUAN (13) | Quantity |
CHARG | CHAR (10) | Batch Number |
BLDAT | DATS (8) | Document Date in Document |
XWOFF | CHAR (1) | Calculation of val. open |
XUNPL | CHAR (1) | Unplanned Account Assignment from Invoice Verification |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
SRVPOS | CHAR (18) | Service number |
PACKNO | NUMC (10) | Package Number of Service |
INTROW | NUMC (10) | Line Number of Service |
BEKKN | NUMC (2) | Number of PO Account Assignment |
LEMIN | CHAR (1) | Returns Indicator |
AREWB | CURR (13) | Clearing Value on GR/IR Account in PO Currency |
REWRB | CURR (13) | Invoice Amount in PO Currency |
SAPRL | CHAR (4) | SAP Release |
MENGE_POP | QUAN (13) | Quantity |
BPMNG_POP | QUAN (13) | Quantity in purchase order price unit |
DMBTR_POP | CURR (13) | Amount in local currency |
WRBTR_POP | CURR (13) | Amount in document currency |
WESBB | QUAN (13) | Valuated Goods Receipt Blocked Stock in Order Unit |
BPWEB | QUAN (13) | Quantity in Valuated GR Blocked Stock in Order Price Unit |
WEORA | CHAR (1) | Acceptance At Origin |
AREWR_POP | CURR (13) | GR/IR account clearing value in local currency |
KUDIF | CURR (13) | Exchange Rate Difference Amount |
KUDIF | CURR (13) | Exchange Rate Difference Amount |
RETAMT_FC | CURR (13) | Retention Amount in Document Currency |
RETAMT_LC | CURR (13) | Retention Amount in Company Code Currency |
RETAMTP_FC | CURR (13) | Posted Retention Amount in Document Currency |
RETAMTP_LC | CURR (13) | Posted Security Retention Amount in Company Code Currency |
XMACC | CHAR (1) | Multiple Account Assignment |
WKURS | DEC (9) | Exchange Rate |
INV_ITEM_ORIGIN | CHAR (1) | Origin of an Invoice Item |
VBELN_ST | CHAR (10) | Delivery |
VBELP_ST | NUMC (6) | Delivery Item |
SGT_SCAT | CHAR (16) | Stock Segment |
KUDIF | CURR (13) | Exchange Rate Difference Amount |
RETAMT_FC | CURR (13) | Retention Amount in Document Currency |
RETAMT_LC | CURR (13) | Retention Amount in Company Code Currency |
RETAMTP_FC | CURR (13) | Posted Retention Amount in Document Currency |
RETAMTP_LC | CURR (13) | Posted Security Retention Amount in Company Code Currency |
XMACC | CHAR (1) | Multiple Account Assignment |
WKURS | DEC (9) | Exchange Rate |
INV_ITEM_ORIGIN | CHAR (1) | Origin of an Invoice Item |
VBELN_ST | CHAR (10) | Delivery |
VBELP_ST | NUMC (6) | Delivery Item |
SGT_SCAT | CHAR (16) | Stock Segment |
ET_UPD | CHAR (1) | Procedure for Updating the Schedule Line Quantity |
J_SC_DIE_COMP_F | CHAR (1) | Depreciation completion flag |
FSH_SEASON_YEAR | CHAR (4) | Season Year |
FSH_SEASON | CHAR (4) | Season |
FSH_COLLECTION | CHAR (2) | Fashion Collection |
FSH_THEME | CHAR (4) | Fashion Theme |
WRF_CHARSTC1 | CHAR (18) | Characteristic Value 1 |
WRF_CHARSTC2 | CHAR (18) | Characteristic Value 2 |
WRF_CHARSTC3 | CHAR (18) | Characteristic Value 3 |
EKET – Scheduling Agreement Schedule Lines:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ETENR | NUMC (4) | Delivery Schedule Line Counter |
EINDT | DATS (8) | Item delivery date |
SLFDT | DATS (8) | Statistics-Relevant Delivery Date |
LPEIN | CHAR (1) | Category of delivery date |
MENGE | QUAN (13) | Scheduled Quantity |
AMENG | QUAN (13) | Previous Quantity (Delivery Schedule Lines) |
WEMNG | QUAN (13) | Quantity of goods received |
WAMNG | QUAN (13) | Issued Quantity |
UZEIT | TIMS (6) | Delivery Date Time-Spot |
BANFN | CHAR (10) | Purchase Requisition Number |
BNFPO | NUMC (5) | Item number of purchase requisition |
ESTKZ | CHAR (1) | Creation indicator (purchase requisition/schedule lines) |
QUNUM | CHAR (10) | Number of quota arrangement |
QUPOS | NUMC (3) | Quota arrangement item |
MAHNZ | DEC (3) | No. of Reminders/Expediters for Schedule Line |
BEDAT | DATS (8) | Order date of schedule line |
RSNUM | NUMC (10) | Number of reservation/dependent requirements |
SERNR | CHAR (8) | BOM explosion number |
FIXKZ | CHAR (1) | Schedule Line is “Fixed” |
GLMNG | QUAN (13) | Quantity Delivered (Stock Transfer) |
DABMG | QUAN (13) | Quantity Reduced (MRP) |
CHARG | CHAR (10) | Batch Number |
LICHA | CHAR (15) | Vendor Batch Number |
CHKOM | CHAR (1) | Components |
VERID | CHAR (4) | Production Version |
ABART | CHAR (1) | Scheduling agreement release type |
MNG02 | QUAN (13) | Committed Quantity |
DAT01 | DATS (8) | Committed date |
ALTDT | DATS (8) | Previous delivery date |
AULWE | CHAR (10) | Route Schedule |
MBDAT | DATS (8) | Material Availability Date |
MBUHR | TIMS (6) | Material Staging Time (Local, Relating to a Plant) |
LDDAT | DATS (8) | Loading Date |
LDUHR | TIMS (6) | Loading Time (Local Time Relating to a Shipping Point) |
TDDAT | DATS (8) | Transportation Planning Date |
TDUHR | TIMS (6) | Transp. Planning Time (Local, Relating to a Shipping Point) |
WADAT | DATS (8) | Goods Issue Date |
WAUHR | TIMS (6) | Time of Goods Issue (Local, Relating to a Plant) |
ELDAT | DATS (8) | Goods Receipt End Date |
ELUHR | TIMS (6) | Goods Receipt End Time (Local, Relating to a Plant) |
ANZSN | INT4 (10) | Number of serial numbers |
NODISP | CHAR (1) | Ind: Reserv. not applicable to MRP;Purc. req. not created |
GEO_ROUTE | CHAR (10) | Description of a Geographical Route |
ROUTE_GTS | CHAR (10) | Route Code for SAP Global Trade Services |
GTS_IND | CHAR (2) | Goods Traffic Type |
TSP | CHAR (10) | Forwarding agent |
CD_LOCNO | CHAR (20) | Location number in APO |
CD_LOCTYPE | CHAR (4) | APO location type |
HANDOVERDATE | DATS (8) | Handover Date at the Handover Location |
HANDOVERTIME | TIMS (6) | Handover time at the handover location |
FSH_RALLOC_QTY | QUAN (13) | ARun Requirement Allocated Quantity |
FSH_SALLOC_QTY | QUAN (13) | Allocated Stock Quantity |
FSH_OS_ID | NUMC (4) | Order Scheduling Group ID |
KEY_ID | NUMC (16) | Unique Number of Budget |
OTB_VALUE | CURR (17) | Required Budget |
OTB_CURR | CUKY (5) | OTB Currency |
OTB_RES_VALUE | CURR (17) | Reserved Budget for OTB-Relevant Purchasing Document |
OTB_SPEC_VALUE | CURR (17) | Special Release Budget |
SPR_RSN_PROFILE | CHAR (4) | Reason Profile for OTB Special Release |
BUDG_TYPE | CHAR (2) | Budget Type |
OTB_STATUS | CHAR (1) | OTB Check Status |
OTB_REASON | CHAR (3) | Reason Indicator for OTB Check Status |
CHECK_TYPE | CHAR (1) | Type of OTB Check |
DL_ID | CHAR (22) | Dateline ID (GUID) |
HANDOVER_DATE | DATS (8) | Transfer Date |
NO_SCEM | CHAR (1) | Purchase Order Not Transferred to SCEM |
DNG_DATE | DATS (8) | Creation Date of Reminder Message Record |
DNG_TIME | TIMS (6) | Creation Time of Reminder Message Record |
CNCL_ANCMNT_DONE | CHAR (1) | Cancellation Threat Made |
DATESHIFT_NUMBER | DEC (3) | Number of Current Date Shifts |
EKKN – Account Assignment in Purchasing Document:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
🔑ZEKKN | NUMC (2) | Sequential Number of Account Assignment |
LOEKZ | CHAR (1) | Deletion Indicator: Purchasing Document Account Assignment |
AEDAT | DATS (8) | Date on Which Record Was Created |
KFLAG | CHAR (1) | Change flag: Purchasing (currently not used) |
MENGE | QUAN (13) | Quantity |
VPROZ | DEC (3) | Distribution percentage in the case of multiple acct assgt |
NETWR | CURR (13) | Net Order Value in PO Currency |
SAKTO | CHAR (10) | G/L Account Number |
GSBER | CHAR (4) | Business Area |
KOSTL | CHAR (10) | Cost Center |
PROJN | CHAR (16) | Old: Project number : No longer used –> PS_POSNR |
VBELN | CHAR (10) | Sales and Distribution Document Number |
VBELP | NUMC (6) | Sales Document Item |
VETEN | NUMC (4) | Schedule Line Number |
KZBRB | CHAR (1) | Gross requirements indicator |
ANLN1 | CHAR (12) | Main Asset Number |
ANLN2 | CHAR (4) | Asset Subnumber |
AUFNR | CHAR (12) | Order Number |
WEMPF | CHAR (12) | Goods recipient |
ABLAD | CHAR (25) | Unloading Point |
KOKRS | CHAR (4) | Controlling Area |
XBKST | CHAR (1) | Posting to cost center? |
XBAUF | CHAR (1) | Post To Order |
XBPRO | CHAR (1) | Post to project |
EREKZ | CHAR (1) | Final Invoice Indicator |
KSTRG | CHAR (12) | Cost Object |
PAOBJNR | NUMC (10) | Profitability Segment Number (CO-PA) |
PRCTR | CHAR (10) | Profit Center |
PS_PSP_PNR | NUMC (8) | Work Breakdown Structure Element (WBS Element) |
NPLNR | CHAR (12) | Network Number for Account Assignment |
AUFPL | NUMC (10) | Routing number of operations in the order |
IMKEY | CHAR (8) | Internal Key for Real Estate Object |
APLZL | NUMC (8) | Internal counter |
VPTNR | CHAR (10) | Partner account number |
FIPOS | CHAR (14) | Commitment Item |
RECID | CHAR (2) | Recovery Indicator |
FISTL | CHAR (16) | Funds Center |
GEBER | CHAR (10) | Fund |
FKBER | CHAR (16) | Functional Area |
DABRZ | DATS (8) | Reference date for settlement |
AUFPL_ORD | NUMC (10) | Routing number of operations in the order |
APLZL_ORD | NUMC (8) | General counter for order |
MWSKZ | CHAR (2) | Tax on Sales/Purchases Code |
TXJCD | CHAR (15) | Tax Jurisdiction |
NAVNW | CURR (13) | Non-deductible input tax |
KBLNR | CHAR (10) | Document Number for Earmarked Funds |
KBLPOS | NUMC (3) | Earmarked Funds: Document Item |
LSTAR | CHAR (6) | Activity Type |
PRZNR | CHAR (12) | Business Process |
GRANT_NBR | CHAR (20) | Grant |
BUDGET_PD | CHAR (10) | FM: Budget Period |
FM_SPLIT_BATCH | NUMC (3) | Batch to group results from an PSM assignment distribution |
FM_SPLIT_BEGRU | CHAR (4) | Authorization group for PSM account assignment distribution |
AA_FINAL_IND | CHAR (1) | Final Account Assignment Indicator |
AA_FINAL_REASON | CHAR (2) | Final Account Assignment Reason Code |
AA_FINAL_QTY | QUAN (13) | Final Account Assignment Quantity |
AA_FINAL_QTY_F | FLTP (16) | Final Account Assignment Quantity (Floating Point Number) |
MENGE_F | FLTP (16) | Quantity (Floating Point Number – Internal Field) |
FMFGUS_KEY | CHAR (22) | United States Federal Government Fields |
EGRUP | CHAR (3) | Equity group |
VNAME | CHAR (6) | Joint venture |
TCOBJNR | CHAR (22) | Object number |
DATEOFSERVICE | DATS (8) | Date of Service |
NOTAXCORR | CHAR (1) | Do Not Consider Item in Input Tax Correction |
DIFFOPTRATE | DEC (9) | Real Estate Option Rate |
HASDIFFOPTRATE | CHAR (1) | Use Different Option Rate |
EKKO – Purchasing Document Header:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
BUKRS | CHAR (4) | Company Code |
BSTYP | CHAR (1) | Purchasing Document Category |
BSART | CHAR (4) | Purchasing Document Type |
BSAKZ | CHAR (1) | Control indicator for purchasing document type |
LOEKZ | CHAR (1) | Deletion indicator in purchasing document |
STATU | CHAR (1) | Status of Purchasing Document |
AEDAT | DATS (8) | Date on Which Record Was Created |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
PINCR | NUMC (5) | Item Number Interval |
LPONR | NUMC (5) | Last Item Number |
LIFNR | CHAR (10) | Vendor’s account number |
SPRAS | LANG (1) | Language Key |
ZTERM | CHAR (4) | Terms of Payment Key |
ZBD1T | DEC (3) | Cash (Prompt Payment) Discount Days |
ZBD2T | DEC (3) | Cash (Prompt Payment) Discount Days |
ZBD3T | DEC (3) | Cash (Prompt Payment) Discount Days |
ZBD1P | DEC (5) | Cash discount percentage 1 |
ZBD2P | DEC (5) | Cash Discount Percentage 2 |
EKORG | CHAR (4) | Purchasing Organization |
EKGRP | CHAR (3) | Purchasing Group |
WAERS | CUKY (5) | Currency Key |
WKURS | DEC (9) | Exchange Rate |
KUFIX | CHAR (1) | Indicator: Fixing of Exchange Rate |
BEDAT | DATS (8) | Purchasing Document Date |
KDATB | DATS (8) | Start of Validity Period |
KDATE | DATS (8) | End of Validity Period |
BWBDT | DATS (8) | Closing Date for Applications |
ANGDT | DATS (8) | Deadline for Submission of Bid/Quotation |
BNDDT | DATS (8) | Binding Period for Quotation |
GWLDT | DATS (8) | Warranty Date |
AUSNR | CHAR (10) | Bid invitation number |
ANGNR | CHAR (10) | Quotation Number |
IHRAN | DATS (8) | Quotation Submission Date |
IHREZ | CHAR (12) | Your Reference |
VERKF | CHAR (30) | Responsible Salesperson at Vendor’s Office |
TELF1 | CHAR (16) | Vendor’s Telephone Number |
LLIEF | CHAR (10) | Supplying Vendor |
KUNNR | CHAR (10) | Customer Number |
KONNR | CHAR (10) | Number of principal purchase agreement |
ABGRU | CHAR (2) | Field Not Used |
AUTLF | CHAR (1) | Complete Delivery Stipulated for Each Purchase Order |
WEAKT | CHAR (1) | Indicator: Goods Receipt Message |
RESWK | CHAR (4) | Supplying (issuing) plant in case of stock transport order |
LBLIF | CHAR (10) | Field not used |
INCO1 | CHAR (3) | Incoterms (Part 1) |
INCO2 | CHAR (28) | Incoterms (Part 2) |
KTWRT | CURR (15) | Target Value for Header Area per Distribution |
SUBMI | CHAR (10) | Collective Number |
KNUMV | CHAR (10) | Number of the document condition |
KALSM | CHAR (6) | Procedure (Pricing, Output Control, Acct. Det., Costing,…) |
STAFO | CHAR (6) | Update group for statistics update |
LIFRE | CHAR (10) | Different Invoicing Party |
EXNUM | CHAR (10) | Number of foreign trade data in MM and SD documents |
UNSEZ | CHAR (12) | Our Reference |
LOGSY | CHAR (10) | Logical System |
UPINC | NUMC (5) | Item Number Interval for Subitems |
STAKO | CHAR (1) | Document with time-dependent conditions |
FRGGR | CHAR (2) | Release group |
FRGSX | CHAR (2) | Release Strategy |
FRGKE | CHAR (1) | Release Indicator: Purchasing Document |
FRGZU | CHAR (8) | Release State |
FRGRL | CHAR (1) | Release Not Yet Completely Effected |
LANDS | CHAR (3) | Country for Tax Return |
LPHIS | CHAR (1) | Indicator for scheduling agreement release documentation |
LPHIS | CHAR (1) | Indicator for scheduling agreement release documentation |
ADRNR | CHAR (10) | Address Number |
STCEG_L | CHAR (3) | Country of Sales Tax ID Number |
STCEG | CHAR (20) | VAT Registration Number |
ABSGR | NUMC (2) | Reason for Cancellation |
ADDNR | CHAR (10) | Document number for additional |
KORNR | CHAR (1) | Correction of miscellaneous provisions |
MEMORY | CHAR (1) | Purchase order not yet complete |
PROCSTAT | CHAR (2) | Purchasing document processing state |
RLWRT | CURR (15) | Total value at time of release |
REVNO | CHAR (8) | Version number in Purchasing |
SCMPROC | CHAR (1) | SCM Process That Created the Purchase Order |
REASON_CODE | CHAR (4) | Goods Receipt Reason Code |
MEMORYTYPE | CHAR (1) | Category of Incompleteness |
RETTP | CHAR (1) | Retention Indicator |
RETPC | DEC (5) | Retention in Percent |
DPTYP | CHAR (4) | Down Payment Indicator |
DPPCT | DEC (5) | Down Payment Percentage |
DPAMT | CURR (11) | Down Payment Amount in Document Currency |
DPDAT | DATS (8) | Due Date for Down Payment |
MSR_ID | CHAR (10) | Process Identification Number |
HIERARCHY_EXISTS | CHAR (1) | Part of a Contract Hierarchy |
THRESHOLD_EXISTS | CHAR (1) | Threshold Value for Exchange Rates Exists |
LEGAL_CONTRACT | CHAR (40) | Legal Contract Number |
DESCRIPTION | CHAR (40) | Contract Name |
RELEASE_DATE | DATS (8) | Release Date of Contract |
VSART | CHAR (2) | Shipping type |
HANDOVERLOC | CHAR (10) | Location for a physical handover of goods |
SHIPCOND | CHAR (2) | Shipping Conditions |
.INCLUDE | STRU (0) | Incoterms – Long |
INCOV | CHAR (4) | Incoterms Version |
INCO2_L | CHAR (70) | Incoterms Location 1 |
INCO3_L | CHAR (70) | Incoterms Location 2 |
EXTERNALSYSTEM | CHAR (60) | ID of External Reference System |
EXTERNALREFERENCEID | CHAR (70) | External Reference ID |
FORCE_ID | CHAR (32) | Internal Key for Force Element |
FORCE_CNT | NUMC (6) | Internal (Version) Counter |
RELOC_ID | CHAR (10) | Relocation ID |
RELOC_SEQ_ID | CHAR (4) | Relocation Step ID |
SOURCE_LOGSYS | CHAR (10) | Logical System |
FSH_TRANSACTION | CHAR (10) | Transaction Number |
FSH_ITEM_GROUP | NUMC (5) | Item Group |
FSH_VAS_LAST_ITEM | NUMC (5) | Last VAS Item Number |
FSH_OS_STG_CHANGE | CHAR (1) | Order Scheduling Strategy specific fields change manually |
VZSKZ | CHAR (2) | Interest calculation indicator |
FSH_SNST_STATUS | CHAR (2) | Snapshot Status |
EQ_EINDT | DATS (8) | Delivery Date Header: All Items Have Same Delivery Date |
EQ_WERKS | CHAR (4) | Plant Header: All Items Have Same Receiving Plant |
FIXPO | CHAR (1) | Firm Deal Indicator |
EKGRP_ALLOW | CHAR (1) | Take Account of Purch. Group |
WERKS_ALLOW | CHAR (1) | Take Account of Plants |
CONTRACT_ALLOW | CHAR (1) | Take Account of Contracts |
PSTYP_ALLOW | CHAR (1) | Take Account of Item Categories |
FIXPO_ALLOW | CHAR (1) | Take Account of Fixed-Date Purchases Indicator |
KEY_ID_ALLOW | CHAR (1) | Consider Budget |
AUREL_ALLOW | CHAR (1) | Take Account of Alloc. Table Relevance |
DELPER_ALLOW | CHAR (1) | Take Account of Dlvy Period |
EINDT_ALLOW | CHAR (1) | Take Account of Delivery Date |
LTSNR_ALLOW | CHAR (1) | Include Vendor Subrange |
OTB_LEVEL | CHAR (1) | OTB Check Level |
OTB_COND_TYPE | CHAR (4) | OTB Condition Type |
OTB_CURR | CUKY (5) | OTB Currency |
OTB_RES_VALUE | CURR (17) | Reserved Budget for OTB-Relevant Purchasing Document |
OTB_SPEC_VALUE | CURR (17) | Special Release Budget |
SPR_RSN_PROFILE | CHAR (4) | Reason Profile for OTB Special Release |
BUDG_TYPE | CHAR (2) | Budget Type |
OTB_STATUS | CHAR (1) | OTB Check Status |
OTB_REASON | CHAR (3) | Reason Indicator for OTB Check Status |
CHECK_TYPE | CHAR (1) | Type of OTB Check |
CON_OTB_REQ | CHAR (1) | OTB-Relevant Contract |
CON_PREBOOK_LEV | CHAR (1) | OTB Indicator Level for Contracts |
CON_DISTR_LEV | CHAR (1) | Distribution Using Target Value or Item Data |
EKPO – Purchasing Document Item:
Fields | Data Type | Description |
---|---|---|
🔑EBELN | CHAR (10) | Purchasing Document Number |
🔑EBELP | NUMC (5) | Item Number of Purchasing Document |
LOEKZ | CHAR (1) | Deletion indicator in purchasing document |
STATU | CHAR (1) | RFQ status |
AEDAT | DATS (8) | Purchasing Document Item Change Date |
TXZ01 | CHAR (40) | Short Text |
MATNR | CHAR (18) | Material Number |
EMATN | CHAR (18) | Material number |
BUKRS | CHAR (4) | Company Code |
WERKS | CHAR (4) | Plant |
LGORT | CHAR (4) | Storage Location |
BEDNR | CHAR (10) | Requirement Tracking Number |
MATKL | CHAR (9) | Material Group |
INFNR | CHAR (10) | Number of purchasing info record |
IDNLF | CHAR (35) | Material Number Used by Vendor |
KTMNG | QUAN (13) | Target Quantity |
MENGE | QUAN (13) | Purchase Order Quantity |
MEINS | UNIT (3) | Purchase Order Unit of Measure |
BPRME | UNIT (3) | Order Price Unit (Purchasing) |
BPUMZ | DEC (5) | Numerator for Conversion of Order Price Unit into Order Unit |
BPUMN | DEC (5) | Denominator for Conv. of Order Price Unit into Order Unit |
UMREZ | DEC (5) | Numerator for Conversion of Order Unit to Base Unit |
UMREN | DEC (5) | Denominator for Conversion of Order Unit to Base Unit |
NETPR | CURR (11) | Net Price in Purchasing Document (in Document Currency) |
PEINH | DEC (5) | Price unit |
NETWR | CURR (13) | Net Order Value in PO Currency |
BRTWR | CURR (13) | Gross order value in PO currency |
AGDAT | DATS (8) | Deadline for Submission of Bid/Quotation |
WEBAZ | DEC (3) | Goods receipt processing time in days |
MWSKZ | CHAR (2) | Tax on Sales/Purchases Code |
BONUS | CHAR (2) | Settlement Group 1 (Purchasing) |
INSMK | CHAR (1) | Stock Type |
SPINF | CHAR (1) | Indicator: Update Info Record |
PRSDR | CHAR (1) | Price Printout |
SCHPR | CHAR (1) | Indicator: Estimated Price |
MAHNZ | DEC (3) | Number of Reminders/Expediters |
MAHN1 | DEC (3) | Number of Days for First Reminder/Expediter |
MAHN2 | DEC (3) | Number of Days for Second Reminder/Expediter |
MAHN3 | DEC (3) | Number of Days for Third Reminder/Expediter |
UEBTO | DEC (3) | Overdelivery Tolerance Limit |
UEBTK | CHAR (1) | Indicator: Unlimited Overdelivery Allowed |
UNTTO | DEC (3) | Underdelivery Tolerance Limit |
BWTAR | CHAR (10) | Valuation Type |
BWTTY | CHAR (1) | Valuation Category |
ABSKZ | CHAR (1) | Rejection Indicator |
AGMEM | CHAR (3) | Internal Comment on Quotation |
ELIKZ | CHAR (1) | Delivery Completed Indicator |
EREKZ | CHAR (1) | Final Invoice Indicator |
PSTYP | CHAR (1) | Item category in purchasing document |
KNTTP | CHAR (1) | Account Assignment Category |
KZVBR | CHAR (1) | Consumption posting |
VRTKZ | CHAR (1) | Distribution indicator for multiple account assignment |
TWRKZ | CHAR (1) | Partial invoice indicator |
WEPOS | CHAR (1) | Goods Receipt Indicator |
WEUNB | CHAR (1) | Goods Receipt, Non-Valuated |
REPOS | CHAR (1) | Invoice receipt indicator |
WEBRE | CHAR (1) | Indicator: GR-Based Invoice Verification |
KZABS | CHAR (1) | Order Acknowledgment Requirement |
LABNR | CHAR (20) | Order Acknowledgment Number |
KONNR | CHAR (10) | Number of principal purchase agreement |
KTPNR | NUMC (5) | Item number of principal purchase agreement |
ABDAT | DATS (8) | Reconciliation date for agreed cumulative quantity |
ABFTZ | QUAN (13) | Agreed Cumulative Quantity |
ETFZ1 | DEC (3) | Firm Zone (Go-Ahead for Production) |
ETFZ2 | DEC (3) | Trade-Off Zone (Go-Ahead for Materials Procurement) |
KZSTU | CHAR (1) | Firm/Trade-Off Zones Binding with Regard to Mat. Planning |
NOTKZ | CHAR (1) | Exclusion in Outline Agreement Item with Material Class |
LMEIN | UNIT (3) | Base Unit of Measure |
EVERS | CHAR (2) | Shipping Instructions |
ZWERT | CURR (13) | Target Value for Outline Agreement in Document Currency |
NAVNW | CURR (13) | Non-deductible input tax |
ABMNG | QUAN (13) | Standard release order quantity |
PRDAT | DATS (8) | Date of Price Determination |
BSTYP | CHAR (1) | Purchasing document category |
EFFWR | CURR (13) | Effective value of item |
XOBLR | CHAR (1) | Item affects commitments |
KUNNR | CHAR (10) | Customer |
ADRNR | CHAR (10) | Manual address number in purchasing document item |
EKKOL | CHAR (4) | Condition Group with Vendor |
SKTOF | CHAR (1) | Item Does Not Qualify for Cash Discount |
STAFO | CHAR (6) | Update group for statistics update |
PLIFZ | DEC (3) | Planned Delivery Time in Days |
NTGEW | QUAN (13) | Net Weight |
GEWEI | UNIT (3) | Unit of Weight |
TXJCD | CHAR (15) | Tax Jurisdiction |
ETDRK | CHAR (1) | Indicator: Print-relevant schedule lines exist |
SOBKZ | CHAR (1) | Special Stock Indicator |
ARSNR | NUMC (10) | Settlement reservation number |
ARSPS | NUMC (4) | Item number of the settlement reservation |
INSNC | CHAR (1) | Quality inspection indicator cannot be changed |
SSQSS | CHAR (8) | Control Key for Quality Management in Procurement |
ZGTYP | CHAR (4) | Certificate Type |
EAN11 | CHAR (18) | International Article Number (EAN/UPC) |
BSTAE | CHAR (4) | Confirmation Control Key |
REVLV | CHAR (2) | Revision level |
GEBER | CHAR (10) | Fund |
FISTL | CHAR (16) | Funds Center |
FIPOS | CHAR (14) | Commitment Item |
KO_GSBER | CHAR (4) | Business area reported to the partner |
KO_PARGB | CHAR (4) | assumed business area of the business partner |
KO_PRCTR | CHAR (10) | Profit Center |
KO_PPRCTR | CHAR (10) | Partner Profit Center |
MEPRF | CHAR (1) | Price Determination (Pricing) Date Control |
BRGEW | QUAN (13) | Gross Weight |
VOLUM | QUAN (13) | Volume |
VOLEH | UNIT (3) | Volume Unit |
INCO1 | CHAR (3) | Incoterms (Part 1) |
INCO2 | CHAR (28) | Incoterms (Part 2) |
VORAB | CHAR (1) | Advance procurement: project stock |
KOLIF | CHAR (10) | Prior Vendor |
LTSNR | CHAR (6) | Vendor Subrange |
PACKNO | NUMC (10) | Package number |
FPLNR | CHAR (10) | Invoicing plan number |
GNETWR | CURR (13) | Currently not used |
STAPO | CHAR (1) | Item is statistical |
UEBPO | NUMC (5) | Higher-Level Item in Purchasing Documents |
LEWED | DATS (8) | Latest Possible Goods Receipt |
EMLIF | CHAR (10) | Vendor to be supplied/who is to receive delivery |
LBLKZ | CHAR (1) | Subcontracting vendor |
SATNR | CHAR (18) | Cross-Plant Configurable Material |
ATTYP | CHAR (2) | Material Category |
VSART | CHAR (2) | Shipping type |
HANDOVERLOC | CHAR (10) | Location for a physical handover of goods |
KANBA | CHAR (1) | Kanban Indicator |
ADRN2 | CHAR (10) | Number of delivery address |
CUOBJ | NUMC (18) | Configuration (internal object number) |
XERSY | CHAR (1) | Evaluated Receipt Settlement (ERS) |
EILDT | DATS (8) | Start Date for GR-Based Settlement |
DRDAT | DATS (8) | Last Transmission |
DRUHR | TIMS (6) | Time |
DRUNR | NUMC (4) | Sequential Number |
AKTNR | CHAR (10) | Promotion |
ABELN | CHAR (10) | Allocation Table Number |
ABELP | NUMC (5) | Item number of allocation table |
ANZPU | QUAN (13) | Number of Points |
PUNEI | UNIT (3) | Points unit |
SAISO | CHAR (4) | Season Category |
SAISJ | CHAR (4) | Season Year |
EBON2 | CHAR (2) | Settlement Group 2 (Rebate Settlement, Purchasing) |
EBON3 | CHAR (2) | Settlement Group 3 (Rebate Settlement, Purchasing) |
EBONF | CHAR (1) | Item Relevant to Subsequent (Period-End Rebate) Settlement |
MLMAA | CHAR (1) | Material ledger activated at material level |
MHDRZ | DEC (4) | Minimum Remaining Shelf Life |
ANFNR | CHAR (10) | RFQ Number |
ANFPS | NUMC (5) | Item Number of RFQ |
KZKFG | CHAR (1) | Origin of Configuration |
USEQU | CHAR (1) | Quota arrangement usage |
UMSOK | CHAR (1) | Special stock indicator for physical stock transfer |
BANFN | CHAR (10) | Purchase Requisition Number |
BNFPO | NUMC (5) | Item number of purchase requisition |
MTART | CHAR (4) | Material Type |
UPTYP | CHAR (1) | Subitem Category, Purchasing Document |
UPVOR | CHAR (1) | Subitems Exist |
KZWI1 | CURR (13) | Subtotal 1 from pricing procedure for condition |
KZWI2 | CURR (13) | Subtotal 2 from pricing procedure for condition |
KZWI3 | CURR (13) | Subtotal 3 from pricing procedure for condition |
KZWI4 | CURR (13) | Subtotal 4 from pricing procedure for condition |
KZWI5 | CURR (13) | Subtotal 5 from pricing procedure for condition |
KZWI6 | CURR (13) | Subtotal 6 from pricing procedure for condition |
SIKGR | CHAR (3) | Processing key for sub-items |
MFZHI | QUAN (15) | Maximum Cumulative Material Go-Ahead Quantity |
FFZHI | QUAN (15) | Maximum Cumulative Production Go-Ahead Quantity |
RETPO | CHAR (1) | Returns Item |
AUREL | CHAR (1) | Relevant to Allocation Table |
BSGRU | CHAR (3) | Reason for Ordering |
LFRET | CHAR (4) | Delivery Type for Returns to Vendors |
MFRGR | CHAR (8) | Material freight group |
NRFHG | CHAR (1) | Material qualifies for discount in kind |
J_1BNBM | CHAR (16) | Brazilian NCM Code |
J_1BMATUSE | CHAR (1) | Usage of the material |
J_1BMATORG | CHAR (1) | Origin of the material |
J_1BOWNPRO | CHAR (1) | Produced in-house |
J_1BINDUST | CHAR (2) | Material CFOP category |
ABUEB | CHAR (4) | Release Creation Profile |
NLABD | DATS (8) | Next Forecast Delivery Schedule Transmission |
NFABD | DATS (8) | Next JIT Delivery Schedule Transmission |
KZBWS | CHAR (1) | Valuation of Special Stock |
BONBA | CURR (13) | Rebate basis 1 |
FABKZ | CHAR (1) | Indicator: Item Relevant to JIT Delivery Schedules |
J_1AINDXP | CHAR (5) | Inflation Index |
J_1AIDATEP | DATS (8) | Inflation Index Date |
MPROF | CHAR (4) | Mfr part profile |
EGLKZ | CHAR (1) | Outward Delivery Completed Indicator |
KZTLF | CHAR (1) | Partial Delivery at Item Level (Stock Transfer) |
KZFME | CHAR (1) | Units of measure usage |
RDPRF | CHAR (4) | Rounding Profile |
TECHS | CHAR (12) | Parameter Variant/Standard Variant |
CHG_SRV | CHAR (1) | Configuration changed |
CHG_FPLNR | CHAR (1) | No invoice for this item although not free of charge |
MFRPN | CHAR (40) | Manufacturer Part Number |
MFRNR | CHAR (10) | Manufacturer number |
EMNFR | CHAR (10) | External manufacturer code name or number |
NOVET | CHAR (1) | Item blocked for SD delivery |
AFNAM | CHAR (12) | Name of requisitioner/requester |
TZONRC | CHAR (6) | Time zone of recipient location |
IPRKZ | CHAR (1) | Period Indicator for Shelf Life Expiration Date |
LEBRE | CHAR (1) | Indicator for Service-Based Invoice Verification |
BERID | CHAR (10) | MRP Area |
XCONDITIONS | CHAR (1) | Conditions for item although no invoice |
APOMS | CHAR (1) | APO as Planning System |
CCOMP | CHAR (1) | Posting Logic in the Case of Stock Transfers |
GRANT_NBR | CHAR (20) | Grant |
FKBER | CHAR (16) | Functional Area |
STATUS | CHAR (1) | Status of Purchasing Document Item |
RESLO | CHAR (4) | Issuing Storage Location for Stock Transport Order |
KBLNR | CHAR (10) | Document Number for Earmarked Funds |
KBLPOS | NUMC (3) | Earmarked Funds: Document Item |
WEORA | CHAR (1) | Acceptance At Origin |
SRV_BAS_COM | CHAR (1) | Service-Based Commitment |
PRIO_URG | NUMC (2) | Requirement Urgency |
PRIO_REQ | NUMC (3) | Requirement Priority |
EMPST | CHAR (25) | Receiving point |
DIFF_INVOICE | CHAR (2) | Differential Invoicing |
TRMRISK_RELEVANT | CHAR (2) | Risk Relevancy in Purchasing |
CREATIONDATE | DATS (8) | Purchasing Document Creation Date |
CREATIONTIME | TIMS (6) | Purchasing Document Creation Time |
SPE_ABGRU | CHAR (2) | Reason for rejection of quotations and sales orders |
SPE_CRM_SO | CHAR (10) | CRM Sales Order Number for TPOP Process |
SPE_CRM_SO_ITEM | NUMC (6) | CRM Sales Order Item Number in TPOP Process |
SPE_CRM_REF_SO | CHAR (35) | CRM Reference Order Number for TPOP Process |
SPE_CRM_REF_ITEM | CHAR (6) | CRM Reference Sales Order Item Number in TPOP Process |
SPE_CRM_FKREL | CHAR (1) | Billing Relevance CRM |
SPE_CHNG_SYS | CHAR (1) | Last Changer’s System Type |
SPE_INSMK_SRC | CHAR (1) | Stock Type of Source Storage Location in STO |
SPE_CQ_CTRLTYPE | CHAR (1) | CQ Control Type |
SPE_CQ_NOCQ | CHAR (1) | No Transmission of Cumulative Quantities in SA Release |
REASON_CODE | CHAR (4) | Goods Receipt Reason Code |
CQU_SAR | QUAN (15) | Cumulative Goods Receipts from Redirected Purchase Orders |
ANZSN | INT4 (10) | Number of serial numbers |
SPE_EWM_DTC | CHAR (1) | EWM Delivery Based Tolerance Check |
EXLIN | CHAR (40) | Item Number Length |
EXSNR | NUMC (5) | External Sorting |
EHTYP | CHAR (4) | External Hierarchy Category |
RETPC | DEC (5) | Retention in Percent |
DPTYP | CHAR (4) | Down Payment Indicator |
DPPCT | DEC (5) | Down Payment Percentage |
DPAMT | CURR (11) | Down Payment Amount in Document Currency |
DPDAT | DATS (8) | Due Date for Down Payment |
FLS_RSTO | CHAR (1) | Store Return with Inbound and Outbound Delivery |
EXT_RFX_NUMBER | CHAR (35) | Document Number of External Document |
EXT_RFX_ITEM | CHAR (10) | Item Number of External Document |
EXT_RFX_SYSTEM | CHAR (10) | Logical System |
SRM_CONTRACT_ID | CHAR (10) | Central Contract |
SRM_CONTRACT_ITM | NUMC (10) | Central Contract Item Number |
BLK_REASON_ID | CHAR (4) | Blocking Reason – ID |
BLK_REASON_TXT | CHAR (40) | Blocking Reason – Text |
ITCONS | CHAR (1) | Real-Time Consumption Posting of Subcontracting Components |
FIXMG | CHAR (1) | Delivery Date and Quantity Fixed |
WABWE | CHAR (1) | Indicator for GI-based goods receipt |
CMPL_DLV_ITM | CHAR (1) | Complete Delivery Requested for Purchase Order Item |
INCO2_L | CHAR (70) | Incoterms Location 1 |
INCO3_L | CHAR (70) | Incoterms Location 2 |
TC_AUT_DET | CHAR (2) | Tax Code Automatically Determined |
MANUAL_TC_REASON | CHAR (2) | Manual Tax Code Reason |
FISCAL_INCENTIVE | CHAR (4) | Tax Incentive Type |
TAX_SUBJECT_ST | CHAR (1) | Tax Subject to Substituição Tributária |
FISCAL_INCENTIVE_ID | CHAR (4) | Incentive ID |
SF_TXJCD | CHAR (15) | Jurisdiction Code of the Point of Origin |
/BEV1/NEGEN_ITEM | CHAR (1) | Indicator: Item Is Generated |
/BEV1/NEDEPFREE | CHAR (1) | Indicator: Dependent Items Are Free of Charge |
/BEV1/NESTRUCCAT | CHAR (1) | Structure Category for Material Relationship |
ADVCODE | CHAR (2) | Advice Code |
BUDGET_PD | CHAR (10) | FM: Budget Period |
EXCPE | NUMC (2) | Acceptance Period |
FMFGUS_KEY | CHAR (22) | United States Federal Government Fields |
IUID_RELEVANT | CHAR (1) | IUID-Relevant |
MRPIND | CHAR (1) | Max. Retail Price Relevant |
SGT_SCAT | CHAR (16) | Stock Segment |
SGT_RCAT | CHAR (16) | Requirement Segment |
WRF_CHARSTC1 | CHAR (18) | Characteristic Value 1 |
WRF_CHARSTC2 | CHAR (18) | Characteristic Value 2 |
WRF_CHARSTC3 | CHAR (18) | Characteristic Value 3 |
SERRU | CHAR (1) | Type of subcontracting |
SERNP | CHAR (4) | Serial Number Profile |
DISUB_SOBKZ | CHAR (1) | Special stock indicator Subcontracting |
DISUB_PSPNR | NUMC (8) | Work Breakdown Structure Element (WBS Element) |
DISUB_KUNNR | CHAR (10) | Customer Number |
DISUB_VBELN | CHAR (10) | Sales and Distribution Document Number |
DISUB_POSNR | NUMC (6) | Item number of the SD document |
DISUB_OWNER | CHAR (10) | Owner of stock |
FSH_SEASON_YEAR | CHAR (4) | Season Year |
FSH_SEASON | CHAR (4) | Season |
FSH_COLLECTION | CHAR (2) | Fashion Collection |
FSH_THEME | CHAR (4) | Fashion Theme |
FSH_ATP_DATE | DATS (8) | Starting Date with ATP |
FSH_VAS_REL | CHAR (1) | VAS Relevant |
FSH_VAS_PRNT_ID | NUMC (5) | Item Number of Purchasing Document |
FSH_TRANSACTION | CHAR (10) | Transaction Number |
FSH_ITEM_GROUP | NUMC (5) | Item Group |
FSH_ITEM | NUMC (5) | Item Number |
FSH_SS | CHAR (3) | Order Scheduling Strategy |
FSH_GRID_COND_REC | CHAR (32) | Grid Condition Record Number |
FSH_PSM_PFM_SPLIT | CHAR (15) | PSM and PFM Split ID |
CNFM_QTY | QUAN (13) | Committed Quantity |
FSH_PQR_UEPOS | NUMC (6) | Higher-level item in Partial Quantity Rejection |
REF_ITEM | NUMC (5) | Reference Item for Remaining Qty Cancellation |
SOURCE_ID | CHAR (3) | Origin Profile |
SOURCE_KEY | CHAR (32) | Key in Source System |
PUT_BACK | CHAR (1) | Indicator for Putting Back from Grouped PO Document |
POL_ID | CHAR (10) | Order List Item Number |
CONS_ORDER | CHAR (1) | Purchase Order for Consignment |
EORD – Purchasing Source List:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
🔑WERKS | CHAR (4) | Plant |
🔑ZEORD | NUMC (5) | Number of Source List Record |
ERDAT | DATS (8) | Date on Which Record Was Created |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
VDATU | DATS (8) | Source List Record Valid From |
BDATU | DATS (8) | Source List Record Valid To |
LIFNR | CHAR (10) | Vendor’s account number |
FLIFN | CHAR (1) | Indicator: Fixed vendor |
EBELN | CHAR (10) | Agreement Number |
EBELP | NUMC (5) | Agreement Item |
FEBEL | CHAR (1) | Fixed Outline Purchase Agreement Item |
RESWK | CHAR (4) | Plant from Which Material is Procured |
FRESW | CHAR (1) | Fixed issuing plant in case of stock transport order |
EMATN | CHAR (18) | Material number corresponding to manufacturer part number |
NOTKZ | CHAR (1) | Blocked Source of Supply |
EKORG | CHAR (4) | Purchasing Organization |
VRTYP | CHAR (1) | Purchasing document category |
EORTP | CHAR (1) | Category of Source List Record |
AUTET | CHAR (1) | Source List Usage in Materials Planning |
MEINS | UNIT (3) | Purchase Order Unit of Measure |
LOGSY | CHAR (10) | Logical System |
SOBKZ | CHAR (1) | Special Stock Indicator |
SRM_CONTRACT_ID | CHAR (10) | Central Contract |
SRM_CONTRACT_ITM | NUMC (10) | Central Contract Item Number |
KNMT – Customer-Material Info Record Data Table:
Fields | Data Type | Description |
---|---|---|
🔑VKORG | CHAR (4) | Sales Organization |
🔑VTWEG | CHAR (2) | Distribution Channel |
🔑KUNNR | CHAR (10) | Customer number |
🔑MATNR | CHAR (18) | Material Number |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
ERDAT | DATS (8) | Date on Which Record Was Created |
SORTL | CHAR (10) | Sort field |
KDMAT | CHAR (35) | Material Number Used by Customer |
POSTX | CHAR (40) | Customer description of material |
LPRIO | NUMC (2) | Delivery Priority |
MINLF | QUAN (13) | Minimum delivery quantity in delivery note processing |
MEINS | UNIT (3) | Base Unit of Measure |
CHSPL | CHAR (1) | Batch split allowed |
KZTLF | CHAR (1) | Partial Delivery at Item Level |
ANTLF | DEC (1) | Maximum Number of Partial Deliveries Allowed Per Item |
UNTTO | DEC (3) | Underdelivery Tolerance Limit |
UEBTO | DEC (3) | Overdelivery Tolerance Limit |
UEBTK | CHAR (1) | Unlimited overdelivery allowed |
WERKS | CHAR (4) | Plant (Own or External) |
RDPRF | CHAR (4) | Rounding Profile |
MEGRU | CHAR (4) | Unit of Measure Group |
J_1BTXSDC | CHAR (2) | SD tax code |
VWPOS | CHAR (4) | Item usage |
VRKME_T | UNIT (3) | Sales Unit |
UMVKN_T | DEC (5) | Denominator (Divisor) for Conversion of Sales Qty into SKU |
UMVKZ_T | DEC (5) | Numerator (factor) for conversion of sales quantity into SKU |
GUID | RAW (16) | 16 Byte UUID in 16 Bytes (Raw Format) |
KONH – Conditions (Header):
Fields | Data Type | Description |
---|---|---|
🔑KNUMH | CHAR (10) | Condition record number |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
ERDAT | DATS (8) | Date on Which Record Was Created |
KVEWE | CHAR (1) | Usage of the condition table |
KOTABNR | CHAR (3) | Condition table |
KAPPL | CHAR (2) | Application |
KSCHL | CHAR (4) | Condition Type |
VAKEY | CHAR (100) | Variable key 100 bytes |
DATAB | DATS (8) | Valid-From Date |
DATBI | DATS (8) | Valid To Date |
KOSRT | CHAR (10) | Search term for conditions |
KZUST | CHAR (3) | Responsibility in SD for condition/material |
KNUMA_PI | CHAR (10) | Promotion |
KNUMA_AG | CHAR (10) | Sales deal |
KNUMA_SQ | CHAR (10) | Sales quote |
KNUMA_SD | CHAR (10) | Standard agreement |
AKTNR | CHAR (10) | Promotion |
KNUMA_BO | CHAR (10) | Agreement (subsequent settlement) |
LICNO | CHAR (20) | Tax exemption license number |
LICDT | DATS (8) | Date license granted |
VADAT | CHAR (100) | Variable Data Part |
KONP – Conditions (Item):
Fields | Data Type | Description |
---|---|---|
🔑KNUMH | CHAR (10) | Condition record number |
🔑KOPOS | NUMC (2) | Sequential number of the condition |
KAPPL | CHAR (2) | Application |
KSCHL | CHAR (4) | Condition Type |
KNUMT | CHAR (10) | Number of texts |
STFKZ | CHAR (1) | Scale Type |
KZBZG | CHAR (1) | Scale basis indicator |
KSTBM | QUAN (15) | Condition scale quantity |
KONMS | UNIT (3) | Condition scale unit of measure |
KSTBW | CURR (15) | Scale value |
KONWS | CUKY (5) | Scale currency |
KRECH | CHAR (1) | Calculation type for condition |
KBETR | CURR (11) | Rate (condition amount or percentage) where no scale exists |
KONWA | CUKY (5) | Rate unit (currency or percentage) |
KPEIN | DEC (5) | Condition pricing unit |
KMEIN | UNIT (3) | Condition unit |
PRSCH | CHAR (4) | Scale Group |
KUMZA | DEC (5) | Numerator for converting condition units to base units |
KUMNE | DEC (5) | Denominator for converting condition units to base units |
MEINS | UNIT (3) | Base Unit of Measure |
MXWRT | CURR (11) | Lower limit of the condition rate/amount |
GKWRT | CURR (11) | Upper limit for the condition rate |
PKWRT | CURR (15) | Planned condition value |
FKWRT | CURR (15) | Cumulative guaranteed discount (not used) |
RSWRT | CURR (15) | Accumulated accruals values (not used) |
KWAEH | CUKY (5) | Condition Currency (for Cumulation Fields) |
UKBAS | CURR (15) | Planned condition basis |
KZNEP | CHAR (1) | Condition exclusion indicator |
KUNNR | CHAR (10) | Customer Number |
LIFNR | CHAR (10) | Account Number of Vendor or Creditor |
MWSK1 | CHAR (2) | Tax on Sales/Purchases Code |
LOEVM_KO | CHAR (1) | Deletion Indicator for Condition Item |
ZAEHK_IND | NUMC (2) | Condition item index |
BOMAT | CHAR (18) | Material for rebate settlement |
KBRUE | CURR (11) | Accrual Amount |
KSPAE | CHAR (1) | Rebate was set up retroactively |
BOSTA | CHAR (1) | Condition Record Status (Rebate) |
KNUMA_PI | CHAR (10) | Promotion |
KNUMA_AG | CHAR (10) | Sales deal |
KNUMA_SQ | CHAR (10) | Sales quote |
VALTG | NUMC (2) | Additional value days |
VALDT | DATS (8) | Fixed value date |
ZTERM | CHAR (4) | Terms of Payment Key |
ANZAUF | NUMC (2) | Maximum number of sales orders per condition record |
MIKBAS | QUAN (15) | Minimum condition base value |
MXKBAS | QUAN (15) | Maximum condition base value |
KOMXWRT | CURR (13) | Maximum condition value |
KLF_STG | NUMC (4) | Number of incremental scale |
KLF_KAL | NUMC (4) | Scale number for pricing |
VKKAL | CHAR (1) | Sales Price Calculation: Relevant to pricing |
AKTNR | CHAR (10) | Promotion |
KNUMA_BO | CHAR (10) | Agreement (subsequent settlement) |
MWSK2 | CHAR (2) | Withholding tax code |
VERTT | CHAR (1) | Contract Type |
VERTN | CHAR (13) | Contract Number |
VBEWA | CHAR (4) | Flow Type |
MDFLG | CHAR (1) | Indicator: Matrix maintenance |
KFRST | CHAR (1) | Release status |
UASTA | CHAR (1) | Status of business volume comparison for a condition |
/BEV1/ECRTT | CHAR (1) | Contract Type |
/BEV1/ECRTN | CHAR (13) | Contract Number |
/BEV1/ECEWA | CHAR (4) | Flow Type |
MARA – General Material Data:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
ERSDA | DATS (8) | Created On |
ERNAM | CHAR (12) | Name of Person Who Created the Object |
LAEDA | DATS (8) | Date of Last Change |
AENAM | CHAR (12) | Name of person who changed object |
VPSTA | CHAR (15) | Maintenance status of complete material |
PSTAT | CHAR (15) | Maintenance status |
LVORM | CHAR (1) | Flag Material for Deletion at Client Level |
MTART | CHAR (4) | Material Type |
MBRSH | CHAR (1) | Industry Sector |
MATKL | CHAR (9) | Material Group |
BISMT | CHAR (18) | Old material number |
MEINS | UNIT (3) | Base Unit of Measure |
BSTME | UNIT (3) | Purchase Order Unit of Measure |
ZEINR | CHAR (22) | Document number (without document management system) |
ZEIAR | CHAR (3) | Document type (without Document Management system) |
ZEIVR | CHAR (2) | Document version (without Document Management system) |
ZEIFO | CHAR (4) | Page format of document (without Document Management system) |
AESZN | CHAR (6) | Document change number (without document management system) |
BLATT | CHAR (3) | Page number of document (without Document Management system) |
BLANZ | NUMC (3) | Number of sheets (without Document Management system) |
FERTH | CHAR (18) | Production/inspection memo |
FORMT | CHAR (4) | Page Format of Production Memo |
GROES | CHAR (32) | Size/dimensions |
WRKST | CHAR (48) | Basic Material |
NORMT | CHAR (18) | Industry Standard Description (such as ANSI or ISO) |
LABOR | CHAR (3) | Laboratory/design office |
EKWSL | CHAR (4) | Purchasing Value Key |
BRGEW | QUAN (13) | Gross Weight |
NTGEW | QUAN (13) | Net Weight |
GEWEI | UNIT (3) | Weight Unit |
VOLUM | QUAN (13) | Volume |
VOLEH | UNIT (3) | Volume Unit |
BEHVO | CHAR (2) | Container requirements |
RAUBE | CHAR (2) | Storage conditions |
TEMPB | CHAR (2) | Temperature conditions indicator |
DISST | CHAR (3) | Low-Level Code |
TRAGR | CHAR (4) | Transportation Group |
STOFF | CHAR (18) | Hazardous material number |
SPART | CHAR (2) | Division |
KUNNR | CHAR (10) | Competitor |
EANNR | CHAR (13) | European Article Number (EAN) – obsolete!!!!! |
WESCH | QUAN (13) | Quantity: Number of GR/GI slips to be printed |
BWVOR | CHAR (1) | Procurement rule |
BWSCL | CHAR (1) | Source of Supply |
SAISO | CHAR (4) | Season Category |
ETIAR | CHAR (2) | Label type |
ETIFO | CHAR (2) | Label form |
ENTAR | CHAR (1) | Deactivated |
EAN11 | CHAR (18) | International Article Number (EAN/UPC) |
NUMTP | CHAR (2) | Category of International Article Number (EAN) |
LAENG | QUAN (13) | Length |
BREIT | QUAN (13) | Width |
HOEHE | QUAN (13) | Height |
MEABM | UNIT (3) | Unit of Dimension for Length/Width/Height |
PRDHA | CHAR (18) | Product Hierarchy |
AEKLK | CHAR (1) | Stock Transfer Net Change Costing |
CADKZ | CHAR (1) | CAD Indicator |
QMPUR | CHAR (1) | QM in Procurement is Active |
ERGEW | QUAN (13) | Allowed packaging weight |
ERGEI | UNIT (3) | Unit of weight (allowed packaging weight) |
ERVOL | QUAN (13) | Allowed packaging volume |
ERVOE | UNIT (3) | Volume unit (allowed packaging volume) |
GEWTO | DEC (3) | Excess Weight Tolerance for Handling unit |
VOLTO | DEC (3) | Excess Volume Tolerance of the Handling Unit |
VABME | CHAR (1) | Variable Purchase Order Unit Active |
KZREV | CHAR (1) | Revision Level Has Been Assigned to the Material |
KZKFG | CHAR (1) | Configurable Material |
XCHPF | CHAR (1) | Batch management requirement indicator |
VHART | CHAR (4) | Packaging Material Type |
FUELG | DEC (3) | Maximum level (by volume) |
STFAK | INT2 (5) | Stacking factor |
MAGRV | CHAR (4) | Material Group: Packaging Materials |
BEGRU | CHAR (4) | Authorization Group |
DATAB | DATS (8) | Valid-From Date |
LIQDT | DATS (8) | Deletion date |
SAISJ | CHAR (4) | Season Year |
PLGTP | CHAR (2) | Price Band Category |
MLGUT | CHAR (1) | Empties Bill of Material |
EXTWG | CHAR (18) | External Material Group |
SATNR | CHAR (18) | Cross-Plant Configurable Material |
ATTYP | CHAR (2) | Material Category |
KZKUP | CHAR (1) | Indicator: Material can be co-product |
KZNFM | CHAR (1) | Indicator: The material has a follow-up material |
PMATA | CHAR (18) | Pricing Reference Material |
MSTAE | CHAR (2) | Cross-Plant Material Status |
MSTAV | CHAR (2) | Cross-distribution-chain material status |
MSTDE | DATS (8) | Date from which the cross-plant material status is valid |
MSTDV | DATS (8) | Date from which the X-distr.-chain material status is valid |
TAKLV | CHAR (1) | Tax classification of the material |
RBNRM | CHAR (9) | Catalog Profile |
MHDRZ | DEC (4) | Minimum Remaining Shelf Life |
MHDHB | DEC (4) | Total shelf life |
MHDLP | DEC (3) | Storage percentage |
INHME | UNIT (3) | Content unit |
INHAL | QUAN (13) | Net contents |
VPREH | DEC (5) | Comparison price unit |
ETIAG | CHAR (18) | IS-R Labeling: material grouping (deactivated in 4.0) |
INHBR | QUAN (13) | Gross contents |
CMETH | CHAR (1) | Quantity Conversion Method |
CUOBF | NUMC (18) | Internal object number |
KZUMW | CHAR (1) | Environmentally Relevant |
KOSCH | CHAR (18) | Product allocation determination procedure |
SPROF | CHAR (1) | Pricing profile for variants |
NRFHG | CHAR (1) | Material qualifies for discount in kind |
MFRPN | CHAR (40) | Manufacturer Part Number |
MFRNR | CHAR (10) | Manufacturer number |
BMATN | CHAR (18) | Number of firm’s own (internal) inventory-managed material |
MPROF | CHAR (4) | Mfr part profile |
KZWSM | CHAR (1) | Units of measure usage |
SAITY | CHAR (2) | Rollout in a Season |
PROFL | CHAR (3) | Dangerous Goods Indicator Profile |
IHIVI | CHAR (1) | Indicator: Highly Viscous |
ILOOS | CHAR (1) | Indicator: In Bulk/Liquid |
SERLV | CHAR (1) | Level of Explicitness for Serial Number |
KZGVH | CHAR (1) | Packaging Material is Closed Packaging |
XGCHP | CHAR (1) | Indicator: Approved batch record required |
KZEFF | CHAR (1) | Assign effectivity parameter values/ override change numbers |
COMPL | NUMC (2) | Material completion level |
IPRKZ | CHAR (1) | Period Indicator for Shelf Life Expiration Date |
RDMHD | CHAR (1) | Rounding rule for calculation of SLED |
PRZUS | CHAR (1) | Indicator: Product composition printed on packaging |
MTPOS_MARA | CHAR (4) | General item category group |
BFLME | CHAR (1) | Generic Material with Logistical Variants |
MATFI | CHAR (1) | Material Is Locked |
CMREL | CHAR (1) | Relevant for Configuration Management |
BBTYP | CHAR (1) | Assortment List Type |
SLED_BBD | CHAR (1) | Expiration Date |
GTIN_VARIANT | CHAR (2) | Global Trade Item Number Variant |
GENNR | CHAR (18) | Material Number of the Generic Material in Prepack Materials |
RMATP | CHAR (18) | Reference material for materials packed in same way |
GDS_RELEVANT | CHAR (1) | Indicator: Global Data Synchronization-Relevant |
WEORA | CHAR (1) | Acceptance At Origin |
HUTYP_DFLT | CHAR (4) | Standard HU Type |
PILFERABLE | CHAR (1) | Pilferable |
WHSTC | CHAR (2) | Warehouse Storage Condition |
WHMATGR | CHAR (4) | Warehouse Material Group |
HNDLCODE | CHAR (4) | Handling Indicator |
HAZMAT | CHAR (1) | Relevant for Hazardous Substances |
HUTYP | CHAR (4) | Handling Unit Type |
TARE_VAR | CHAR (1) | Variable Tare Weight |
MAXC | DEC (15) | Maximum Allowed Capacity of Packaging Material |
MAXC_TOL | DEC (3) | Overcapacity Tolerance of the Handling Unit |
MAXL | QUAN (15) | Maximum Packing Length of Packaging Material |
MAXB | QUAN (15) | Maximum Packing Width of Packaging Material |
MAXH | QUAN (15) | Maximum Packing Height of Packaging Material |
MAXDIM_UOM | UNIT (3) | Unit of Measure for Maximum Packing Length/Width/Height |
HERKL | CHAR (3) | Country of Origin of Material (Non-Preferential Origin) |
MFRGR | CHAR (8) | Material freight group |
QQTIME | QUAN (3) | Quarantine Period |
QQTIMEUOM | UNIT (3) | Time Unit for Quarantine Period |
QGRP | CHAR (4) | Quality Inspection Group |
SERIAL | CHAR (4) | Serial Number Profile |
PS_SMARTFORM | CHAR (30) | Form Name |
LOGUNIT | UNIT (3) | EWM CW: Logistics Unit of Measure |
CWQREL | CHAR (1) | EWM CW: Material Is a Catch Weight Material |
CWQPROC | CHAR (2) | EWM CW: Catch Weight Profile for Entering CW Quantity |
CWQTOLGR | CHAR (9) | EWM-CW: Catch Weight Tolerance Group for EWM |
ADPROF | CHAR (3) | Adjustment Profile |
IPMIPPRODUCT | CHAR (40) | ID for an Intellectual Property (CRM Product) |
ALLOW_PMAT_IGNO | CHAR (1) | Variant Price Allowed (for Material Master) |
MEDIUM | CHAR (6) | Medium |
COMMODITY | CHAR (18) | Physical Commodity |
ANIMAL_ORIGIN | CHAR (1) | Indicator: Contains Non-Textile Parts of Animal Origin |
TEXTILE_COMP_IND | CHAR (1) | Indicator: New Textile Composition Function |
SGT_CSGR | CHAR (4) | Segmentation Structure |
SGT_COVSA | CHAR (8) | Segmentation Strategy |
SGT_STAT | CHAR (1) | Segmentation Material Master Status |
SGT_SCOPE | CHAR (1) | Segmentation Strategy Scope |
SGT_REL | CHAR (1) | Segmentation Relevant |
FSH_MG_AT1 | CHAR (10) | Fashion Information Field: 1 |
FSH_MG_AT2 | CHAR (10) | Fashion Information Field: 2 |
FSH_MG_AT3 | CHAR (6) | Fashion Information Field: 3 |
FSH_SEALV | CHAR (1) | Indicator: Use of Season |
FSH_SEAIM | CHAR (1) | Indicator: Season Active in Inventory Management |
FSH_SC_MID | CHAR (2) | Material Conversion ID for Characteristic Value Conversion |
ANP | NUMC (9) | ANP Code |
PSM_CODE | CHAR (2) | Code of Protected Species Management |
/BEV1/LULEINH | NUMC (8) | Loading Units |
/BEV1/LULDEGRP | CHAR (3) | Loading Unit Group: IS Beverage |
/BEV1/NESTRUCCAT | CHAR (1) | Structure Category for Material Relationship |
/DSD/SL_TOLTYP | CHAR (4) | Tolerance Type ID |
/DSD/SV_CNT_GRP | CHAR (10) | Counting Group |
/DSD/VC_GROUP | CHAR (6) | DSD Grouping |
/VSO/R_TILT_IND | CHAR (1) | Material may be Tilted (Vehicle Space Optimization) |
/VSO/R_STACK_IND | CHAR (1) | Stacking not Allowed (VSO) |
/VSO/R_BOT_IND | CHAR (1) | Bottom Layer (Vehicle Space Optimization) |
/VSO/R_TOP_IND | CHAR (1) | Top Layer (VSO) |
/VSO/R_STACK_NO | NUMC (3) | Stacking Factor (Vehicle Space Optimization) |
/VSO/R_PAL_IND | CHAR (1) | Load without Packaging Material (VSO) |
/VSO/R_PAL_OVR_D | QUAN (13) | Permissible Overhang (Depth) of Packaging Material (VSO) |
/VSO/R_PAL_OVR_W | QUAN (13) | Permissible Overhang (Width) of Shipping Material (VSO) |
/VSO/R_PAL_B_HT | QUAN (13) | Maximum Stacking Height of the Packaging Material (VSO) |
/VSO/R_PAL_MIN_H | QUAN (13) | Minimum Stacking Height of the Packaging Material (VSO) |
/VSO/R_TOL_B_HT | QUAN (13) | Tolerance to Exceed the Max. Stacking Height (VSO) |
/VSO/R_NO_P_GVH | NUMC (2) | Number of Materials for each Closed PKM (VSO) |
/VSO/R_QUAN_UNIT | UNIT (3) | Unit of Measure Vehicle Space Optimization |
/VSO/R_KZGVH_IND | CHAR (1) | Closed Packaging Material Required (VSO) |
PACKCODE | CHAR (10) | Packaging Code |
DG_PACK_STATUS | CHAR (10) | Dangerous Goods Packaging Status |
MCOND | CHAR (1) | Material Condition Management |
RETDELC | CHAR (1) | Return Code |
LOGLEV_RETO | CHAR (1) | Return to Logistics Level |
NSNID | CHAR (9) | NATO Item Identification Number |
ADSPC_SPC | NUMC (1) | Spare Part Class Code |
IMATN | CHAR (18) | FFF class |
PICNUM | CHAR (18) | Supersession chain number |
BSTAT | CHAR (2) | Creation Status – Seasonal Procurement |
COLOR_ATINN | NUMC (10) | Internal Charactieristic Number for Color Characteristics |
SIZE1_ATINN | NUMC (10) | Internal Char. Number for Characteristics for Main Sizes |
SIZE2_ATINN | NUMC (10) | Internal Char. Number for Characteristics for Second Sizes |
COLOR | CHAR (18) | Characteristic Value for Colors of Variants |
SIZE1 | CHAR (18) | Characteristic Value for Main Sizes of Variants |
SIZE2 | CHAR (18) | Characteristic Value for Second Size for Variants |
FREE_CHAR | CHAR (18) | Characteristic Value for Evaluation Purposes |
CARE_CODE | CHAR (16) | Care Codes (such as Washing Code, Ironing Code, etc.) |
BRAND_ID | CHAR (4) | Brand |
FIBER_CODE1 | CHAR (3) | Fiber Code for Textiles (Component 1) |
FIBER_PART1 | NUMC (3) | Percentage Share of Fiber (Component 1) |
FIBER_CODE2 | CHAR (3) | Fiber Code for Textiles (Component 2) |
FIBER_PART2 | NUMC (3) | Percentage Share of Fiber (Component 2) |
FIBER_CODE3 | CHAR (3) | Fiber Code for Textiles (Component 3) |
FIBER_PART3 | NUMC (3) | Percentage Share of Fiber (Component 3) |
FIBER_CODE4 | CHAR (3) | Fiber Code for Textiles (Component 4) |
FIBER_PART4 | NUMC (3) | Percentage Share of Fiber (Component 4) |
FIBER_CODE5 | CHAR (3) | Fiber Code for Textiles (Component 5) |
FIBER_PART5 | NUMC (3) | Percentage Share of Fiber (Component 5) |
FASHGRD | CHAR (4) | Fashion Grade |
MDKP – Header Data for MRP Document:
Fields | Data Type | Description |
---|---|---|
🔑DTART | CHAR (2) | Type of MRP list |
🔑MATNR | CHAR (18) | Material Number |
🔑PLWRK | CHAR (4) | Plant |
🔑PLSCN | NUMC (3) | Planning Scenario of Long-Term Planning |
DTNUM | NUMC (10) | Number of material requirements planning table |
DSDAT | DATS (8) | MRP date |
BDBKZ | CHAR (1) | Selection indicator for processed MRP lists |
SLKZ1 | CHAR (1) | Selection indicator for exception groups |
SLKZ2 | CHAR (1) | Selection indicator for exception groups |
SLKZ3 | CHAR (1) | Selection indicator for exception groups |
SLKZ4 | CHAR (1) | Selection indicator for exception groups |
SLKZ5 | CHAR (1) | Selection indicator for exception groups |
SLKZ6 | CHAR (1) | Selection indicator for exception groups |
SLKZ7 | CHAR (1) | Selection indicator for exception groups |
SLKZ8 | CHAR (1) | Selection indicator for exception groups |
VRKZ1 | CHAR (1) | Processing indicator 01 |
VRKZ2 | CHAR (1) | Processing indicator 02 |
VRKZ3 | CHAR (1) | Processing indicator – 03 |
MTART | CHAR (4) | Material Type |
MEINS | UNIT (3) | Base Unit of Measure |
DISST | CHAR (3) | Low-Level Code |
BESKZ | CHAR (1) | Procurement Type |
SOBSL | CHAR (2) | Special procurement type |
SOBES | CHAR (1) | Special procurement type |
WRK02 | CHAR (4) | Planning/production plant |
DISMM | CHAR (2) | MRP Type |
DISVF | CHAR (1) | MRP procedure |
DISPO | CHAR (3) | MRP Controller |
PLDIS | CHAR (3) | Planning controller (no longer used) |
EKGRP | CHAR (3) | Purchasing Group |
MTWZT | DEC (3) | Material replenishment lead time |
WEBAZ | DEC (3) | Goods receipt processing time in days |
BEAZT | DEC (3) | Processing time for purchase order proposal |
FIXTR | DATS (8) | End of planning time fence (date) |
MFHKZ | CHAR (1) | Planning time fence set manually (MFXDT) |
DISLS | CHAR (2) | Lot size (materials planning) |
LOSVF | CHAR (1) | Lot-sizing procedure for short-term period |
LOSKZ | CHAR (1) | Lot-size indicator for the short-term period |
PERAZ | DEC (3) | Number of periods for the short-term area |
EISBE | QUAN (13) | Safety stock |
MINBE | QUAN (13) | Reorder Point |
HOEBE | QUAN (13) | Maximum stock level |
BSTMI | QUAN (13) | Minimum Lot Size |
BSTMA | QUAN (13) | Maximum Lot Size |
BSTFX | QUAN (13) | Fixed lot size |
BSTRF | QUAN (13) | Rounding value for purchase order quantity |
SUM01 | QUAN (13) | Plant stock / only plant segment |
SUM02 | QUAN (13) | No longer used/do not use!! |
SUM03 | QUAN (13) | No longer used/do not use!! |
SUM04 | QUAN (13) | No longer used/do not use!! |
SUM05 | QUAN (13) | No longer used/do not use!! |
NEGBS | QUAN (13) | Negative stock |
MSGID | CHAR (20) | Message identification |
MSGAR | CHAR (1) | Message Type |
MSGNR | CHAR (3) | Message number |
MSGV1 | CHAR (50) | Message variable 01 |
MSGV2 | CHAR (50) | Message variable 02 |
MSGV3 | CHAR (50) | Message variable 03 |
MSGV4 | CHAR (50) | Message variable 04 |
DISGR | CHAR (4) | MRP Group |
PERIV | CHAR (2) | Fiscal Year Variant |
MRPPP | CHAR (3) | PPC planning calendar |
BDARF | QUAN (13) | Requirements quantity from material requirements planning |
LFRHY | CHAR (3) | Planning cycle |
RDPRF | CHAR (4) | Rounding Profile |
BERW1 | DEC (4) | Stock Days’ Supply Without Receipts |
BERW2 | DEC (4) | First Receipt Days’ Supply |
KZAUS | CHAR (1) | Discontinuation indicator |
AUSDT | DATS (8) | Effective-Out Date |
NFMAT | CHAR (18) | Follow-Up Material |
AUSZ1 | CHAR (2) | Exception group in the MRP list |
AUSZ2 | CHAR (2) | Exception group in the MRP list |
AUSZ3 | CHAR (2) | Exception group in the MRP list |
AUSZ4 | CHAR (2) | Exception group in the MRP list |
AUSZ5 | CHAR (2) | Exception group in the MRP list |
AUSZ6 | CHAR (2) | Exception group in the MRP list |
AUSZ7 | CHAR (2) | Exception group in the MRP list |
AUSZ8 | CHAR (2) | Exception group in the MRP list |
BEADA | DATS (8) | MRP list processing date |
NAUKZ | CHAR (1) | Indicator: new exception in the MRP list |
SAUFT | CHAR (1) | Ind.: Repetitive mfg allowed |
KZPROMO | CHAR (1) | Indicator: Material in promotion |
SHFLG | CHAR (1) | Safety time indicator (with or without safety time) |
SHZET | NUMC (2) | Safety time (in workdays) |
FABKZ | CHAR (1) | Indicator: Item Relevant to JIT Delivery Schedules |
MFXDT | DATS (8) | Manual firming date |
BSKFL | CHAR (1) | Flag whether stock correction factors exist |
MAABC | CHAR (1) | ABC Indicator |
CFLAG | CHAR (1) | Aggregated MRP list |
GRREL | CHAR (1) | Relevant for requirements grouping for project stock |
RWPRO | CHAR (3) | Range of coverage profile |
SHPRO | CHAR (3) | Period Profile for Safety Time |
AHDIS | CHAR (1) | MRP relevancy for dependent requirements |
BERW4 | DEC (4) | Second Receipt Days’ Supply |
BADON | CHAR (1) | Indicator: BAdI is Active |
SGT_STATC | CHAR (1) | Segmentation Status |
HANAON | CHAR (1) | HANA Optimizations Active / Inactive |
MDTB – MRP Table:
Fields | Data Type | Description |
---|---|---|
🔑DTNUM | NUMC (10) | Number of material requirements planning table |
🔑DTPOS | NUMC (6) | Item number of MRP list |
PLAKZ | CHAR (1) | Indicator for planning segment |
PLANR | CHAR (20) | Planning segment number |
DAT00 | DATS (8) | Receipt/Requirements date |
SORT1 | CHAR (1) | Sort indicator 01 |
SORT2 | CHAR (2) | Sort indicator 02 |
DELKZ | CHAR (2) | MRP element |
VSTAT | CHAR (1) | Processing Status |
VRFKZ | CHAR (1) | Availability indicator |
PLUMI | CHAR (1) | Receipt/issue indicator |
MNG01 | QUAN (13) | Quantity received or quantity required |
MNG02 | QUAN (13) | Variable scrap quantity |
MNG03 | QUAN (13) | Shortage Quantity |
DAT01 | DATS (8) | Delivery/order finish date |
DAT02 | DATS (8) | Start/release date |
DAT03 | DATS (8) | Opening date |
PERKZ | CHAR (1) | Period Indicator |
PRPER | NUMC (6) | Forecast period |
WEBAZ | DEC (3) | Goods receipt processing time in days |
FIX01 | CHAR (1) | Indicator: Fixing of Lot Size in Planned Order |
FIX02 | CHAR (1) | Indicator: fixing explosion in planned order |
BAART | CHAR (4) | P.O./Order type |
BESKZ | CHAR (1) | Procurement Type |
SOBES | CHAR (1) | Special procurement type |
UMSKZ | CHAR (1) | Special G/L Indicator |
PLART | CHAR (1) | Planning type |
AUSSL | CHAR (2) | Exception message key |
WRK02 | CHAR (4) | Planning/production plant |
LGORT | CHAR (4) | Storage Location |
DELNR | CHAR (10) | MRP element number |
DELPS | NUMC (6) | MRP element item |
DELET | NUMC (4) | Schedule Line Number MRP Element |
AUFVR | CHAR (10) | Source number for order |
POSVR | NUMC (6) | Source item number |
EINVR | NUMC (4) | Source schedule line number |
UKZ01 | CHAR (1) | Indicator: MRP element can be brought forward |
UMDAT | DATS (8) | Rescheduling date |
DEL12 | CHAR (12) | MRP element number |
BAUGR | CHAR (18) | Material number of higher-level assembly |
DELVR | CHAR (2) | MRP element |
VERSB | CHAR (2) | Version Number for Independent Requirements |
OLDSL | CHAR (2) | Key of the second exception message |
RDMNG | QUAN (13) | Excess stock quantity |
PLAAB | NUMC (2) | Material requirements planning segment |
TAG00 | NUMC (2) | Daily shift (sort indicator 0) |
ABEKZ | CHAR (1) | Exception indicator |
MDFST | CHAR (1) | Production order status: internal ind. for MRP |
MDMNG | QUAN (13) | MRP: quantity field (stock in transit, receipt qty, …) |
VERID | CHAR (4) | Production Version |
WRK01 | CHAR (4) | Planning Plant |
SERNR | CHAR (8) | BOM explosion number |
REVLV | CHAR (2) | Revision level |
DBSKZ | CHAR (1) | Direct procurement indicator |
EXTNL | CHAR (1) | Indicator for External Procurement |
ADINF | CHAR (4) | Field for Additional Information |
RESLO | CHAR (4) | Issuing Storage Location for Stock Transport Order |
PRIO_URG | NUMC (2) | Requirement Urgency |
PRIO_REQ | NUMC (3) | Requirement Priority |
MKPF – Header: Material Document:
Fields | Data Type | Description |
---|---|---|
🔑MBLNR | CHAR (10) | Number of Material Document |
🔑MJAHR | NUMC (4) | Material Document Year |
VGART | CHAR (2) | Transaction/Event Type |
BLART | CHAR (2) | Document type |
BLAUM | CHAR (2) | Document type of revaluation document |
BLDAT | DATS (8) | Document Date in Document |
BUDAT | DATS (8) | Posting Date in the Document |
CPUDT | DATS (8) | Day On Which Accounting Document Was Entered |
CPUTM | TIMS (6) | Time of Entry |
AEDAT | DATS (8) | Date of Last Change |
USNAM | CHAR (12) | User Name |
TCODE | CHAR (4) | Not More Closely Defined Area, Possibly Used for Patchlevels |
XBLNR | CHAR (16) | Reference Document Number |
BKTXT | CHAR (25) | Document Header Text |
FRATH | CURR (13) | Unplanned delivery costs |
FRBNR | CHAR (16) | Number of Bill of Lading at Time of Goods Receipt |
WEVER | CHAR (1) | Version for Printing GR/GI Slip |
XABLN | CHAR (10) | Goods Receipt/Issue Slip Number |
AWSYS | CHAR (10) | Logical System |
BLA2D | CHAR (2) | Doc. type for additional doc. in purchase account management |
TCODE2 | CHAR (20) | Transaction Code |
BFWMS | CHAR (1) | Control posting for external WMS |
EXNUM | CHAR (10) | Number of foreign trade data in MM and SD documents |
SPE_BUDAT_UHR | TIMS (6) | Time of Goods Issue (Local, Relating to a Plant) |
SPE_BUDAT_ZONE | CHAR (6) | Time Zone |
LE_VBELN | CHAR (10) | Delivery |
SPE_LOGSYS | CHAR (10) | Logical System of EWM Material Document |
SPE_MDNUM_EWM | CHAR (16) | Number of Material Document in EWM |
GTS_CUSREF_NO | CHAR (35) | Customs Reference Number for Scrapping |
FLS_RSTO | CHAR (1) | Store Return with Inbound and Outbound Delivery |
MSR_ACTIVE | CHAR (1) | Advanced Returns Management Active |
KNUMV | CHAR (10) | Number of the document condition |
TRANSP | CHAR (10) | Vendor’s account number |
MUNORI | CHAR (35) | City |
MSEG – Document Segment: Material:
Fields | Data Type | Description |
---|---|---|
🔑MBLNR | CHAR (10) | Number of Material Document |
🔑MJAHR | NUMC (4) | Material Document Year |
🔑ZEILE | NUMC (4) | Item in Material Document |
LINE_ID | NUMC (6) | Unique identification of document line |
PARENT_ID | NUMC (6) | Identifier of immediately superior line |
LINE_DEPTH | NUMC (2) | Hierarchy level of line in document |
MAA_URZEI | NUMC (4) | Original Line for Account Assignment Item in Material Doc. |
BWART | CHAR (3) | Movement type (inventory management) |
XAUTO | CHAR (1) | Item automatically created |
MATNR | CHAR (18) | Material Number |
WERKS | CHAR (4) | Plant |
LGORT | CHAR (4) | Storage Location |
CHARG | CHAR (10) | Batch Number |
INSMK | CHAR (1) | Stock Type |
ZUSCH | CHAR (1) | Batch status key |
ZUSTD | CHAR (1) | Batch in Restricted-Use Stock |
SOBKZ | CHAR (1) | Special Stock Indicator |
LIFNR | CHAR (10) | Vendor’s account number |
KUNNR | CHAR (10) | Account number of customer |
KDAUF | CHAR (10) | Sales Order Number |
KDPOS | NUMC (6) | Item number in Sales Order |
KDEIN | NUMC (4) | Delivery schedule for sales order |
PLPLA | CHAR (10) | Distribution of Differences |
SHKZG | CHAR (1) | Debit/Credit Indicator |
WAERS | CUKY (5) | Currency Key |
DMBTR | CURR (13) | Amount in local currency |
BNBTR | CURR (13) | Delivery costs in local currency |
BUALT | CURR (13) | Amount Posted in Alternative Price Control |
SHKUM | CHAR (1) | Debit/credit indicator in revaluation |
DMBUM | CURR (13) | Revaluation amount on back-posting to a previous period |
BWTAR | CHAR (10) | Valuation Type |
MENGE | QUAN (13) | Quantity |
MEINS | UNIT (3) | Base Unit of Measure |
ERFMG | QUAN (13) | Quantity in unit of entry |
ERFME | UNIT (3) | Unit of entry |
BPMNG | QUAN (13) | Quantity in Purchase Order Price Unit |
BPRME | UNIT (3) | Order Price Unit (Purchasing) |
EBELN | CHAR (10) | Purchase order number |
EBELP | NUMC (5) | Item Number of Purchasing Document |
LFBJA | NUMC (4) | Fiscal Year of a Reference Document |
LFBNR | CHAR (10) | Document No. of a Reference Document |
LFPOS | NUMC (4) | Item of a Reference Document |
SJAHR | NUMC (4) | Material Document Year |
SMBLN | CHAR (10) | Number of Material Document |
SMBLP | NUMC (4) | Item in Material Document |
ELIKZ | CHAR (1) | Delivery Completed Indicator |
SGTXT | CHAR (50) | Item Text |
EQUNR | CHAR (18) | Equipment Number |
WEMPF | CHAR (12) | Goods recipient |
ABLAD | CHAR (25) | Unloading Point |
GSBER | CHAR (4) | Business Area |
KOKRS | CHAR (4) | Controlling Area |
PARGB | CHAR (4) | Trading partner’s business area |
PARBU | CHAR (4) | Clearing company code |
KOSTL | CHAR (10) | Cost Center |
PROJN | CHAR (16) | Old: Project number : No longer used –> PS_POSNR |
AUFNR | CHAR (12) | Order Number |
ANLN1 | CHAR (12) | Main Asset Number |
ANLN2 | CHAR (4) | Asset Subnumber |
XSKST | CHAR (1) | Indicator: Statistical Posting to Cost Center |
XSAUF | CHAR (1) | Indicator: Posting to Order Is Statistical |
XSPRO | CHAR (1) | Indicator: Posting to Project Is Statistical |
XSERG | CHAR (1) | Indicator: Posting to Profitability Analysis Is Statistical |
GJAHR | NUMC (4) | Fiscal Year |
XRUEM | CHAR (1) | Allow Posting to Previous Period (Backposting) |
XRUEJ | CHAR (1) | Indicator: post to previous year |
BUKRS | CHAR (4) | Company Code |
BELNR | CHAR (10) | Accounting Document Number |
BUZEI | NUMC (3) | Number of Line Item Within Accounting Document |
BELUM | CHAR (10) | Accounting Document Number |
BUZUM | NUMC (3) | Number of Line Item Within Accounting Document |
RSNUM | NUMC (10) | Number of reservation/dependent requirements |
RSPOS | NUMC (4) | Item Number of Reservation / Dependent Requirements |
KZEAR | CHAR (1) | Final issue for this reservation |
PBAMG | QUAN (13) | Quantity |
KZSTR | CHAR (1) | Transaction/event is relevant to statistics |
UMMAT | CHAR (18) | Receiving/Issuing Material |
UMWRK | CHAR (4) | Receiving plant/issuing plant |
UMLGO | CHAR (4) | Receiving/issuing storage location |
UMCHA | CHAR (10) | Receiving/Issuing Batch |
UMZST | CHAR (1) | Status of Transfer Batch |
UMZUS | CHAR (1) | Status key of transfer batch |
UMBAR | CHAR (10) | Valuation Type of Transfer Batch |
UMSOK | CHAR (1) | Special stock indicator for physical stock transfer |
KZBEW | CHAR (1) | Movement Indicator |
KZVBR | CHAR (1) | Consumption posting |
KZZUG | CHAR (1) | Receipt Indicator |
WEUNB | CHAR (1) | Goods Receipt, Non-Valuated |
PALAN | DEC (11) | WMS Number of pallets |
LGNUM | CHAR (3) | Warehouse Number / Warehouse Complex |
LGTYP | CHAR (3) | Storage Type |
LGPLA | CHAR (10) | Storage Bin |
BESTQ | CHAR (1) | Stock Category in the Warehouse Management System |
BWLVS | NUMC (3) | Movement Type for Warehouse Management |
TBNUM | NUMC (10) | Transfer Requirement Number |
TBPOS | NUMC (4) | Transfer Requirement Item |
XBLVS | CHAR (1) | Indicator: posting in warehouse management system |
VSCHN | CHAR (1) | Ind: interim storage posting for source stor.type and bin |
NSCHN | CHAR (1) | Ind.: interim storage posting for dest.stor.type and bin |
DYPLA | CHAR (1) | Indicator: dynamic storage bin |
UBNUM | NUMC (10) | Posting Change Number |
TBPRI | CHAR (1) | Transfer Priority |
TANUM | NUMC (10) | Transfer Order Number |
WEANZ | NUMC (3) | Number of GR/GI Slips to Be Printed |
GRUND | NUMC (4) | Reason for Movement |
EVERS | CHAR (2) | Shipping Instructions |
EVERE | CHAR (2) | Compliance with Shipping Instructions |
IMKEY | CHAR (8) | Internal Key for Real Estate Object |
KSTRG | CHAR (12) | Cost Object |
PAOBJNR | NUMC (10) | Profitability Segment Number (CO-PA) |
PRCTR | CHAR (10) | Profit Center |
PS_PSP_PNR | NUMC (8) | Work Breakdown Structure Element (WBS Element) |
NPLNR | CHAR (12) | Network Number for Account Assignment |
AUFPL | NUMC (10) | Routing number of operations in the order |
APLZL | NUMC (8) | Internal counter |
AUFPS | NUMC (4) | Order item number |
VPTNR | CHAR (10) | Partner account number |
FIPOS | CHAR (14) | Commitment Item |
SAKTO | CHAR (10) | G/L Account Number |
BSTMG | QUAN (13) | Goods receipt quantity in order unit |
BSTME | UNIT (3) | Purchase Order Unit of Measure |
XWSBR | CHAR (1) | Reversal of GR allowed for GR-based IV despite invoice |
EMLIF | CHAR (10) | Vendor to be supplied/who is to receive delivery |
EXBWR | CURR (13) | Externally Entered Posting Amount in Local Currency |
VKWRT | CURR (13) | Value at Sales Prices Including Value-Added Tax |
AKTNR | CHAR (10) | Promotion |
ZEKKN | NUMC (2) | Sequential Number of Account Assignment |
VFDAT | DATS (8) | Shelf Life Expiration or Best-Before Date |
CUOBJ_CH | NUMC (18) | Internal object number of the batch classification |
EXVKW | CURR (13) | Externally Entered Sales Value in Local Currency |
PPRCTR | CHAR (10) | Partner Profit Center |
RSART | CHAR (1) | Record type |
GEBER | CHAR (10) | Fund |
FISTL | CHAR (16) | Funds Center |
MATBF | CHAR (18) | Material in Respect of Which Stock is Managed |
UMMAB | CHAR (18) | Receiving/Issuing Material |
BUSTM | CHAR (4) | Posting string for quantities |
BUSTW | CHAR (4) | Posting String for Values |
MENGU | CHAR (1) | Quantity Updating in Material Master Record |
WERTU | CHAR (1) | Value Updating in Material Master Record |
LBKUM | QUAN (13) | Total valuated stock before the posting |
SALK3 | CURR (13) | Value of total valuated stock before the posting |
VPRSV | CHAR (1) | Price control indicator |
FKBER | CHAR (16) | Functional Area |
DABRBZ | DATS (8) | Reference date for settlement |
VKWRA | CURR (13) | Value at sales prices excluding value-added tax |
DABRZ | DATS (8) | Reference date for settlement |
XBEAU | CHAR (1) | Purchase order created at time of goods receipt |
LSMNG | QUAN (13) | Quantity in Unit of Measure from Delivery Note |
LSMEH | UNIT (3) | Unit of Measure From Delivery Note |
KZBWS | CHAR (1) | Valuation of Special Stock |
QINSPST | CHAR (1) | Status of Goods Receipt Inspection |
URZEI | NUMC (4) | Original line in material document |
J_1BEXBASE | CURR (13) | Alternate base amount in document currency |
MWSKZ | CHAR (2) | Tax on Sales/Purchases Code |
TXJCD | CHAR (15) | Tax Jurisdiction |
EMATN | CHAR (18) | Material number corresponding to manufacturer part number |
J_1AGIRUPD | CHAR (1) | Goods issue revaluation performed |
VKMWS | CHAR (2) | Tax on Sales/Purchases Code |
HSDAT | DATS (8) | Date of Manufacture |
BERKZ | CHAR (1) | Material Staging Indicator for Production Supply |
MAT_KDAUF | CHAR (10) | Sales order number of valuated sales order stock |
MAT_KDPOS | NUMC (6) | Sales Order Item of Valuated Sales Order Stock |
MAT_PSPNR | NUMC (8) | Valuated Sales Order Stock WBS Element |
XWOFF | CHAR (1) | Calculation of val. open |
BEMOT | CHAR (2) | Accounting Indicator |
PRZNR | CHAR (12) | Business Process |
LLIEF | CHAR (10) | Supplying Vendor |
LSTAR | CHAR (6) | Activity Type |
XOBEW | CHAR (1) | Vendor Stock Valuation Indicator |
GRANT_NBR | CHAR (20) | Grant |
ZUSTD_T156M | CHAR (1) | Stock Type Modification (Read from Table T156M) |
SPE_GTS_STOCK_TY | CHAR (1) | GTS Stock Type |
KBLNR | CHAR (10) | Document number for earmarked funds |
KBLPOS | NUMC (3) | Earmarked Funds: Document Item |
XMACC | CHAR (1) | Multiple Account Assignment |
VGART_MKPF | CHAR (2) | Transaction/Event Type |
BUDAT_MKPF | DATS (8) | Posting Date in the Document |
CPUDT_MKPF | DATS (8) | Day On Which Accounting Document Was Entered |
CPUTM_MKPF | TIMS (6) | Time of Entry |
USNAM_MKPF | CHAR (12) | User Name |
XBLNR_MKPF | CHAR (16) | Reference Document Number |
TCODE2_MKPF | CHAR (20) | Transaction Code |
VBELN_IM | CHAR (10) | Delivery |
VBELP_IM | NUMC (6) | Delivery Item |
SGT_SCAT | CHAR (16) | Stock Segment |
SGT_UMSCAT | CHAR (16) | Receiving/Issuing Stock Segment |
SGT_RCAT | CHAR (16) | Requirement Segment |
/BEV2/ED_KZ_VER | CHAR (1) | Processing Status of Material Document for Excise Duties |
/BEV2/ED_USER | CHAR (12) | User Name |
/BEV2/ED_AEDAT | DATS (8) | Date of Last Change |
/BEV2/ED_AETIM | TIMS (6) | System Time |
DISUB_OWNER | CHAR (10) | Owner of stock |
FSH_SEASON_YEAR | CHAR (4) | Season Year |
FSH_SEASON | CHAR (4) | Season |
FSH_COLLECTION | CHAR (2) | Fashion Collection |
FSH_THEME | CHAR (4) | Fashion Theme |
FSH_UMSEA_YR | CHAR (4) | Receiving/Issuing Season Year |
FSH_UMSEA | CHAR (4) | Receiving/Issuing Season |
FSH_UMCOLL | CHAR (2) | Receiving/Issuing Collection |
FSH_UMTHEME | CHAR (4) | Receiving/Issuing Theme |
SGT_CHINT | CHAR (1) | Discrete Batch Number |
FSH_DEALLOC_QTY | QUAN (13) | ARun Allocated Quantity |
OINAVNW | CURR (13) | Non-deductible input tax |
OICONDCOD | CHAR (2) | Joint Venture Indicator (Condition Key) |
CONDI | CHAR (2) | Joint Venture Indicator (Condition Key) |
WRF_CHARSTC1 | CHAR (18) | Characteristic Value 1 |
WRF_CHARSTC2 | CHAR (18) | Characteristic Value 2 |
WRF_CHARSTC3 | CHAR (18) | Characteristic Value 3 |
MVER – Material Consumption:
Fields | Data Type | Description |
---|---|---|
🔑MATNR | CHAR (18) | Material Number |
🔑WERKS | CHAR (4) | Plant |
🔑GJAHR | NUMC (4) | Fiscal Year |
🔑PERKZ | CHAR (1) | Period Indicator |
🔑ZAHLR | NUMC (2) | Number of follow-on records in Table MVER |
GSV01 | QUAN (13) | Total consumption |
GSV02 | QUAN (13) | Total consumption |
GSV03 | QUAN (13) | Total consumption |
GSV04 | QUAN (13) | Total consumption |
GSV05 | QUAN (13) | Total consumption |
GSV06 | QUAN (13) | Total consumption |
GSV07 | QUAN (13) | Total consumption |
GSV08 | QUAN (13) | Total consumption |
GSV09 | QUAN (13) | Total consumption |
GSV10 | QUAN (13) | Total consumption |
GSV11 | QUAN (13) | Total consumption |
GSV12 | QUAN (13) | Total consumption |
GSV13 | QUAN (13) | Total consumption |
UNV01 | QUAN (13) | Unplanned consumption |
UNV02 | QUAN (13) | Unplanned consumption |
UNV03 | QUAN (13) | Unplanned consumption |
UNV04 | QUAN (13) | Unplanned consumption |
UNV05 | QUAN (13) | Unplanned consumption |
UNV06 | QUAN (13) | Unplanned consumption |
UNV07 | QUAN (13) | Unplanned consumption |
UNV08 | QUAN (13) | Unplanned consumption |
UNV09 | QUAN (13) | Unplanned consumption |
UNV10 | QUAN (13) | Unplanned consumption |
UNV11 | QUAN (13) | Unplanned consumption |
UNV12 | QUAN (13) | Unplanned consumption |
UNV13 | QUAN (13) | Unplanned consumption |
MGV01 | QUAN (13) | Manually corrected total consumption |
MGV02 | QUAN (13) | Manually corrected total consumption |
MGV03 | QUAN (13) | Manually corrected total consumption |
MGV04 | QUAN (13) | Manually corrected total consumption |
MGV05 | QUAN (13) | Manually corrected total consumption |
MGV06 | QUAN (13) | Manually corrected total consumption |
MGV07 | QUAN (13) | Manually corrected total consumption |
MGV08 | QUAN (13) | Manually corrected total consumption |
MGV09 | QUAN (13) | Manually corrected total consumption |
MGV10 | QUAN (13) | Manually corrected total consumption |
MGV11 | QUAN (13) | Manually corrected total consumption |
MGV12 | QUAN (13) | Manually corrected total consumption |
MGV13 | QUAN (13) | Manually corrected total consumption |
MUV01 | QUAN (13) | Manually corrected unplanned consumption |
MUV02 | QUAN (13) | Manually corrected unplanned consumption |
MUV03 | QUAN (13) | Manually corrected unplanned consumption |
MUV04 | QUAN (13) | Manually corrected unplanned consumption |
MUV05 | QUAN (13) | Manually corrected unplanned consumption |
MUV06 | QUAN (13) | Manually corrected unplanned consumption |
MUV07 | QUAN (13) | Manually corrected unplanned consumption |
MUV08 | QUAN (13) | Manually corrected unplanned consumption |
MUV09 | QUAN (13) | Manually corrected unplanned consumption |
MUV10 | QUAN (13) | Manually corrected unplanned consumption |
MUV11 | QUAN (13) | Manually corrected unplanned consumption |
MUV12 | QUAN (13) | Manually corrected unplanned consumption |
MUV13 | QUAN (13) | Manually corrected unplanned consumption |
✅ Conclusion:
In this article you saw the tables of the SAP MM module (Material Management). Mainly you got to know how they interact with each other in the system knowing the relationship between the tables. All key fields were also shown.
Use this article as a guide for the SAP MM module and whenever you have questions, come back here to make your life easier!
Keywords: SAP MM; SAP MM Material Management; sap mm tables; tables sap mm; SAP Material Management table; tabelas sap mm; List of SAP MM tables; Relationship between SAP MM tables; SAP MM tables conectivity
Did you like the content? Want to get more tips? Subscribe ↗ for free!
![](https://myeasybi.com/wp-content/uploads/2022/01/capalivro2-1.jpg)
Follow on social media:
3 comentários em “📦Mastering SAP MM Tables and Relationships [See the Definitive Guide right now!]”