| 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 no.of communication doc.for decentralized shipping | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | SNKOM | Allow NULL? |
| 3 | LNKOM | Sequence Number in a Communication Record | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | LNKOM | Allow NULL? |
| 4 | SSKOM | Status of communication record for decentralized shipping | char | 1 | 0 | CHAR | (N' ') | Yes | | SSKOM | Allow NULL? |
| 5 | POSNR | Delivery Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VL | Allow NULL? |
| 6 | UEPOS | Higher-level item in bill of material structures | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | UEPOS | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 9 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGORT_D | Allow NULL? |
| 10 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
| 11 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 12 | LFIMG | Delivery quantity (special storage for decentral.shipping) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | LFIMG_DV | Allow NULL? |
| 13 | UMVKZ | Counter for converting to base unit (spec.stor.dec.ship) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | UMVKZ_DV | Allow NULL? |
| 14 | UMVKN | Denominator for converting to base qty (spec.stor.dec.ship) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | UMVKN_DV | Allow NULL? |
| 15 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 16 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VRKME | Allow NULL? |
| 17 | BRGEW | Gross weight (special storage for decentralized shipping) | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | BRGEW_DV | Allow NULL? |
| 18 | NTGEW | Net weight (special storage for decentralized shipping) | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | NTGEW_DV | Allow NULL? |
| 19 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | GEWEI | Allow NULL? |
| 20 | VOLUM | Volume (special storage for decentralized shipping) | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | VOLUM_DV | Allow NULL? |
| 21 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VOLEH | Allow NULL? |
| 22 | KZTLF | Partial delivery at item level | char | 1 | 0 | CHAR | (N' ') | Yes | | KZTLF | Allow NULL? |
| 23 | ARKTX | Short text for sales order item | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ARKTX | Allow NULL? |
| 24 | UEBTK | Indicator: Unlimited Overdelivery Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBTK | Allow NULL? |
| 25 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VGBEL | Allow NULL? |
| 26 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | VGPOS | Allow NULL? |
