| 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 | ROOT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 5 | MENGE | Quantity | decimal | 13 | 3 | | | | |
| 6 | VPROZ | Distribution Percentage in Case of Multiple Account Assgt | decimal | 3 | 1 | | | | |
| 7 | NETWR | Net Order Value in PO Currency | decimal | 13 | 2 | | | | |
| 8 | PARENT_NODE_KEY | Node | varbinary | 16 | 0 | | | | |
| 9 | ZEXKN | Sequential Number of Account Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | LOEKZ | Deletion Indicator: Purchasing Document Account Assignment | char | 1 | 0 | | | | Allow NULL? |
| 11 | AEDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | SAKTO | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | VBELP | Sales Document Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | VETEN | Delivery Schedule Line Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | ABLAD | Unloading Point | nvarchar | 25 | 0 | | | | Allow NULL? |
| 22 | KOKRS | Controlling Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | KSTRG | Cost Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | APLZL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | VPTNR | Partner account number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | | | Allow NULL? |
| 33 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | FISTL | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 35 | GEBER | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | GRANT_NBR | Grant | nvarchar | 20 | 0 | | | | Allow NULL? |
| 37 | FKBER | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 38 | DABRZ | Reference Date for Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | AUFPL_ORD | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | APLZL_ORD | General counter for order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 43 | LSTAR | Activity Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | PRZNR | Business Process | nvarchar | 12 | 0 | | | | Allow NULL? |
| 45 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | PSP_PNR | Work breakdown structure element (WBS element) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 47 | MENGE_F | Quantity (Floating Point Number - Internal Field) | float | 15 | 16 | | | | |
| 48 | BUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | KBLNR | Document Number for Earmarked Funds | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | FM_SPLIT_BATCH | Batch to group results from an PSM assignment distribution | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | FM_SPLIT_BEGRU | Authorization group for PSM account assignment distribution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | RECIPIENT_KEY | Recipient | varbinary | 16 | 0 | | | | |
