| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SNKOM | Record number of communication document for WMS link | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | LVS_SNKOM | Allow NULL? |
| 3 | LNKOM | Sequence Number in a Communication Record | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | LVS_LNKOM | Allow NULL? |
| 4 | SSKOM | Status of Communication Record for WMS Link | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_SSKOM | Allow NULL? |
| 5 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T300 | LGNUM | Allow NULL? |
| 6 | BWLVS | Movement Type for Warehouse Management | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T333 | BWLVS | Allow NULL? |
| 7 | BNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | LVS_BNAME | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 10 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
| 11 | BESTQ | Stock Category in the Warehouse Management System | char | 1 | 0 | CHAR | (N' ') | Yes | | BESTQ | Allow NULL? |
| 12 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T148 | SOBKZ | Allow NULL? |
| 13 | SONUM | Special Stock Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | LVS_SONUM | Allow NULL? |
| 14 | MENGE | Required quantity in stockkeeping unit (NUM format) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | LDK01MENGE | Allow NULL? |
| 15 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 16 | MENGA | Requirement qty in alternative unit of measure (NUM format) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | LDK01MENGA | Allow NULL? |
| 17 | ALTME | Alternative Unit of Measure for Stockkeeping Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | LRMEI | Allow NULL? |
| 18 | UMREZ | Numerator for converting to base unit of measure(NUM format) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | LDK01UMREZ | Allow NULL? |
| 19 | UMREN | Factor for converting to base unit of measure (NUM format) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | LDK01UMREN | Allow NULL? |
| 20 | LIFNR | Delivery document number from the R/2 system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LVS_R2LNR | Allow NULL? |
| 21 | LIFHP | Delivery document main item from the R/2 system | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LVS_R2LHP | Allow NULL? |
| 22 | LIFUP | Delivery document subitem from the R/2 system | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LVS_R2LUP | Allow NULL? |
| 23 | BRGEW | Gross weight (NUMC format) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | LDK01BRGEW | Allow NULL? |
| 24 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | GEWEI | Allow NULL? |
| 25 | BETYP | Requirement Type | char | 1 | 0 | CHAR | (N' ') | Yes | T308 | LVS_BETYP | Allow NULL? |
| 26 | BENUM | Requirement Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LVS_BENUM | Allow NULL? |
| 27 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 28 | PDATU | Date of Planned Execution of Transfer Request | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTBK_PDATU | Allow NULL? |
| 29 | PZEIT | Time of Planned Execution of Transfer Requirement | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LTBK_PZEIT | Allow NULL? |
