| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | TXW_MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TXW_VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | VBELN | Delivery | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | LFDAT | Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | VBTYP | SD document category | char | 1 | 0 | | | | Allow NULL? |
| 7 | WADAT_IST | Actual Goods Movement Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | BOLNR | Bill of lading | nvarchar | 35 | 0 | | | | Allow NULL? |
| 9 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | WAERK | SD Document Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | VSTEL | Shipping Point/Receiving Point | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | BUKRS | Company code of the sales organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |