| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | FPLTR | Item for billing plan/invoice plan/payment cards | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | STUNR | Step number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | ZAEHK | Condition counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | ZAEHLER | Counter for errors in SD sales orders | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | VBTYP | SD document category | char | 1 | 0 | | | | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | VRKME | Sales unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | | | | Allow NULL? |
| 23 | KWERT | Condition value | decimal | 13 | 2 | | | | |
| 24 | WAERK | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | HWAER | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | KZZUAB | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 27 | KINAK | Condition is inactive | char | 1 | 0 | | | | Allow NULL? |
| 28 | KSTAT | Condition is used for statistics | char | 1 | 0 | | | | Allow NULL? |
| 29 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | ERZET | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | VDATU | Date of update for statistics updating | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | NTGEW | Net weight | decimal | 15 | 3 | | | | |
| 35 | BRGEW | Gross weight | decimal | 15 | 3 | | | | |
| 36 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | VOLUM | Volume | decimal | 15 | 3 | | | | |
| 38 | VOLEH | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | KBMENG | Cumulative confirmed quantity in sales unit | decimal | 15 | 3 | | | | |
| 40 | KLMENG | Cumulative confirmed quantity in base unit | decimal | 15 | 3 | | | | |
| 41 | LSMENG | Cumulative required delivery qty (all dlv-relev.sched.lines) | decimal | 15 | 3 | | | | |
| 42 | KWMENG | Cumulative Order Quantity in Sales Units | decimal | 15 | 3 | | | | |
| 43 | MSGID | Message Class | nvarchar | 20 | 0 | | | | Allow NULL? |
| 44 | MSGTY | Message Type | char | 1 | 0 | | | | Allow NULL? |
| 45 | MSGNO | Message Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | MSGV1 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 47 | MSGV2 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 48 | MSGV3 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 49 | MSGV4 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 50 | BTCI | General Flag | char | 1 | 0 | | | | Allow NULL? |
| 51 | FKART | Billing Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 54 | LOEKZ | Data Record Was Deleted | char | 1 | 0 | | | | Allow NULL? |
| 55 | WMENG | Order quantity in sales units | decimal | 13 | 3 | | | | |
| 56 | BMENG | Confirmed Quantity | decimal | 13 | 3 | | | | |
| 57 | LMENG | Required quantity for mat.management in stockkeeping units | decimal | 13 | 3 | | | | |
| 58 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | | | Allow NULL? |
| 59 | EDATU | Schedule line date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 60 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 61 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 62 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | AWSYS | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 64 | VRGNG | CO Business Transaction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 65 | NETWR | Net Value in Document Currency | decimal | 15 | 2 | | | | |
| 66 | FAKWR | Value to be billed/calc. on date in billing/invoice plan | decimal | 15 | 2 | | | | |
