| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POSNR | Sales Order Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | POSEX | External Item Number (Purchase Order Item) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | GUELTIGVON | Valid-From Date of Sales Order Item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | GUELTIGBIS | Date to which Sales Order Item is Valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | DELIVSPLIT | IS-M/SD: Alternating Address Element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | FUNKTION | Processing function for data transfer in sales order | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | UNTBRGRD | Reason for Suspension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | REFUNDTYPE | IS-M/SD: Refund Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | BEZUGGRD | Purchase Reason | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | KUNWE | IS-M: Business Partner Ship-to Party | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | ADRNR_WE | IS-M: Address Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | ADRESSVAR_WE | IS-M: Address Variant | char | 1 | 0 | | | | Allow NULL? |
| 15 | DRERZ | Publication | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | PVA | Edition | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | LIEFERART | Delivery Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | XDELIV_FIXED | IS-M/SD: No Del.Viability Optimization (Parameters Fixed) | char | 1 | 0 | | | | Allow NULL? |
| 20 | BEZPER | Service Type | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | | | |
| 22 | BEABLST | IS-M: Unloading Point | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | ETMENGE | IS-M: Sales Order Schedule Line Quantity | decimal | 10 | 0 | | | | |
| 24 | XVACPACK | Vacation Service: Postponed Delivery | char | 1 | 0 | | | | Allow NULL? |