| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 3 | PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | NODE_CAT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 5 | OBJECT_ID | Object ID - Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ITM_NO | Internal Shopping Cart Item Number | int | 10 | 0 | | | | Allow NULL? |
| 7 | ITM_TYPE | Item Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | TXZ01 | Short Text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 10 | MENGE | Order Quantity | decimal | 13 | 3 | | | | |
| 11 | MEINS | Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | NETPR | Net Price in Purchasing Document (in Document Currency) | decimal | 11 | 2 | | | | |
| 13 | PEINH | Price Unit | decimal | 5 | 0 | | | | |
| 14 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | LGORT | Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | BEDNR | Requirement Tracking Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 20 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | CATALOG_ID | Technical Key of a Web Service (for Example - a Catalog) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | | | |
| 23 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 24 | IDNLF | Material Number Used by Vendor | nvarchar | 35 | 0 | | | | Allow NULL? |
| 25 | MPROF | Manufacturer Part Profile | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | MFRPN | Manufacturer Part Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 27 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | EMNFR | External manufacturer code name or number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | BMEIN | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | NETWR | Net Value in Document Currency | decimal | 15 | 2 | | | | |
| 31 | NETFW | Net Amount in Foreign Currency | decimal | 13 | 2 | | | | |
| 32 | WKURS | Exchange Rate | decimal | 9 | 5 | | | | |
| 33 | LPEIN | Category of Delivery Date | char | 1 | 0 | | | | Allow NULL? |
| 34 | LFDAT | Delivery date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | KNTTP | Account Assignment Category | char | 1 | 0 | | | | Allow NULL? |
| 36 | KZVBR | Consumption Posting | char | 1 | 0 | | | | Allow NULL? |
| 37 | VRTKZ | Distribution indicator for multiple account assignment | char | 1 | 0 | | | | Allow NULL? |
| 38 | TWRKZ | Partial Invoice Indicator | char | 1 | 0 | | | | Allow NULL? |
| 39 | WEPOS | Goods Receipt Indicator | char | 1 | 0 | | | | Allow NULL? |
| 40 | WEUNB | Goods Receipt, Non-Valuated | char | 1 | 0 | | | | Allow NULL? |
| 41 | REPOS | Invoice Receipt Indicator | char | 1 | 0 | | | | Allow NULL? |
| 42 | SOBKZ | Special Stock Indicator | char | 1 | 0 | | | | Allow NULL? |
| 43 | KZBWS | Valuation of Special Stock | char | 1 | 0 | | | | Allow NULL? |
| 44 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | XOBLR | Item affects commitments | char | 1 | 0 | | | | Allow NULL? |
| 46 | PACKNO | Package number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | AUTHOR_KEY | Author | varbinary | 16 | 0 | | | | |
| 48 | REQUESTER_KEY | Requester | varbinary | 16 | 0 | | | | |
| 49 | FOOBJ_TYPE | Follow-On Object Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 51 | ADRNR | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 52 | ADDRESS_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 53 | TXT_EXISTS | Text Exists | char | 1 | 0 | | | | Allow NULL? |
| 54 | DOC_EXISTS | Document Exists | char | 1 | 0 | | | | Allow NULL? |
| 55 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | SRM_CONTRACT_ID | Central Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | SRM_CONTRACT_ITM | Central Contract Item Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 58 | LIFNR | Desired Vendor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 59 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | | | | Allow NULL? |
| 60 | VRTYP | Purchasing Document Category | char | 1 | 0 | | | | Allow NULL? |
| 61 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 62 | KTPNR | Item Number of Principal Purchase Agreement | nvarchar | 5 | 0 | | | | Allow NULL? |
| 63 | RESWK | Supplying (Issuing) Plant in Stock Transport Order | nvarchar | 4 | 0 | | | | Allow NULL? |
| 64 | RESLO | Issuing Storage Location for Stock Transport Order | nvarchar | 4 | 0 | | | | Allow NULL? |
| 65 | BANFN | Purchase Requisition Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 66 | BNFPO | Item Number of Purchase Requisition | nvarchar | 5 | 0 | | | | Allow NULL? |
| 67 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 68 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | | | Allow NULL? |
| 69 | APPROVAL_STATUS | Approval Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 70 | DELIVERY_STATUS | Delivery Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 71 | CONSIST_STATUS | Consistency Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 72 | FOLLOW_ON_STATUS | Follow-On Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 73 | CANCELATN_STATUS | Cancelation Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 74 | ITM_LIFEC_STATUS | Life Cycle of Shopping Cart Item | nvarchar | 2 | 0 | | | | Allow NULL? |
| 75 | CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | | | |
| 76 | CREA_UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 77 | LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | | | |
| 78 | LCHG_UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 79 | /SRMERP/E_SC_ITM | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
