| 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 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 9 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | ELIFN | Allow NULL? |
| 10 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 11 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | EWERK | Allow NULL? |
| 12 | ESOKZ | Purchasing info record category | char | 1 | 0 | CHAR | (N' ') | No | | ESOKZ | Allow NULL? |
| 13 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 14 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | CHAR | (N' ') | No | EINA | INFNR | Allow NULL? |
| 15 | LAND1 | Country key of vendor | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | MCLANDL | Allow NULL? |
| 16 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 17 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 18 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 19 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 20 | MENGE | Purchase order quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_MENGE | |
| 21 | WEMNG | Quantity of goods received | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_WEMNG | |
| 22 | WEMGM | Goods receipt qty in base unit (calculate wtd.delivery time) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_WEMGMAX | |
| 23 | REMNG | Invoice receipt quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_REMNG | |
| 24 | LSMNG | Target delivery quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_LSMNG | |
| 25 | NETWR | Effective order value | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_EFFWR | |
| 26 | REWRT | Invoice Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_REWRT | |
| 27 | ABSTP | Number of purchase order items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ABSTP | |
| 28 | ABSTE | Number of purchase order item schedule lines | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ABSTE | |
| 29 | AANFP | Number of requests for quotation items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AANFP | |
| 30 | AANGP | Number of Quotation Items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AANGP | |
| 31 | AKONP | Number of contract items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AKONP | |
| 32 | ALFPP | Number of scheduling agreement items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ALFPP | |
| 33 | ALFPE | Number of delivery schedules | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ALFPE | |
| 34 | ALIEF | Number of deliveries | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ALIEF | |
| 35 | MABW1 | Deviation 1 in the quantity delivered | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_MABW1 | |
| 36 | MABW2 | Variance 2 in the quantity delivered | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_MABW2 | |
| 37 | MABW3 | Variance 3 in the quantity delivered | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_MABW3 | |
| 38 | MABW4 | Variance 4 in the quantity delivered | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_MABW4 | |
| 39 | MABW5 | Variance 5 in the quantity delivered | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_MABW5 | |
| 40 | TABW1 | Delivery date variance 1 in days | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_TABW1 | |
| 41 | TABW2 | Delivery date variance 2 in days | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_TABW2 | |
| 42 | TABW3 | Delivery date variance 3 in days | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_TABW3 | |
| 43 | TABW4 | Delivery date variance 4 in days | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_TABW4 | |
| 44 | TABW5 | Delivery date variance 5 in days | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_TABW5 | |
| 45 | LFZTA | Total delivery time in days | decimal | 13 | 0 | DEC | ((0)) | Yes | | MC_LFZTA | |
| 46 | LFZTG | Weighted total delivery time | decimal | 15 | 1 | DEC | ((0)) | Yes | | MC_LFZTG | |
| 47 | MENGE_R | Order quantity (returns) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_MENGE_R | |
| 48 | REMNG_R | Invoice receipt quantity of returns | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_REMNG_R | |
| 49 | WEMNG_R | Goods receipt quantity of returns | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_WEMNG_R | |
| 50 | REWRT_R | Invoice amount: Returns | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_REWRT_R | |
| 51 | EFFWR_R | Effective order value of returns | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_EFFWR_R | |
| 52 | WEWRT | Value of goods received in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MC_WEWERT | |
| 53 | REMNG_B | Invoice receipt quantity as at posting date | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_REMNG_B | |
| 54 | WEWRT_B | Goods receipt value as at posting date | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_WEWRT_B | |
| 55 | REWRT_B | Invoice Amount as at Posting Date | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_REWRT_B | |
| 56 | REMNG_R_B | IR quantity: Returns as at posting date | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_REMNG_R_B | |
| 57 | REWRT_R_B | IR value: Returns as at posting date | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_REWRT_R_B | |
| 58 | WEWRT_R_B | GR value: Returns as at posting date | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_WEWRT_R_B | |
