| 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 | T000 | MANDT | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | VSTEL | Shipping Point/Receiving Point | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVST | VSTEL | Allow NULL? |
| 9 | ROUTE | Route | nvarchar | 6 | 0 | CHAR | (N' ') | No | TVRO | ROUTE | Allow NULL? |
| 10 | SPDNR | Forwarding agent | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | SPDNR | Allow NULL? |
| 11 | LLAND | Country of Destination | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | LLAND | Allow NULL? |
| 12 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 13 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 14 | GEWEI | Unit of weight for statistics (kg) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCGEWEI | Allow NULL? |
| 15 | VOLEH | Volume unit for statistics (CDM) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MCVOLEH | Allow NULL? |
| 16 | NTGEW | Net weight of deliveries | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_LINTGEW | |
| 17 | BRGEW | Gross weight of deliveries | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_LIBRGEW | |
| 18 | VOLUM | Volume of deliveries | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_LIVOLUM | |
| 19 | ARBLA | Labor Required for Deliveries on Hand | decimal | 5 | 2 | DEC | ((0)) | Yes | | MC_LIARBLA | |
| 20 | RLNTGEW | Net weight of returns deliveries | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_RLNTGEW | |
| 21 | RLBRGEW | Gross weight of returns deliveries | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_RLBRGEW | |
| 22 | RLVOLUM | Volume of returns delivery | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_RLVOLUM | |
| 23 | RLARBLA | Labor required for returns deliveries on hand | decimal | 5 | 2 | DEC | ((0)) | Yes | | MC_RLARBLA | |
