| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | TBNUM | Transfer Requirement Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | TBPOS | Transfer Requirement Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BUKRS | Company code for WM link | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | LIFNR | Delivery document number from the R/2 system | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | LIFHP | Delivery document main item from the R/2 system | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | LIFUP | Delivery document subitem from the R/2 system | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | KOMNR | Picking number from delivery document for WM link | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | VSENR | Shipment number from delivery document for WMS link | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TOURN | Route number from delivery document for WMS link | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | VSART | Dispatch type from delivery document for WMS link | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | KNDNR | Sold-to party from delivery document for WMS link | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | KDLIF | Consignee from delivery document for WMS link | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | BNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |