| 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 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | CHAR | (N' ') | No | EINA | INFNR | Allow NULL? |
| 14 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 15 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 16 | PWMT1 | Points score 1 for quantity reliability | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWMT1 | |
| 17 | PWMT2 | Points score 2 for quantity reliability | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWMT2 | |
| 18 | PWTT1 | Points score 1 for on-time delivery performance | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWTT1 | |
| 19 | PWTT2 | Points score 2 for on-time delivery performance | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWTT2 | |
| 20 | PWEV1 | Points score 1 for compliance with shipping instructions | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWEV1 | |
| 21 | PWEV2 | Point score 2 for compliance with shipping instructions | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWEV2 | |
| 22 | PWWE1 | Points score 1 for service quality | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWWE1 | |
| 23 | PWWE2 | Points score 2 for quality of service | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWWE2 | |
| 24 | PWFR1 | Points score 1 for service timeliness | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWFR1 | |
| 25 | PWFR2 | Points score 2 for service timeliness | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWFR2 | |
| 26 | PWQA1 | Points score 1 for quality audit | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWQA1 | |
| 27 | PWQA2 | Points score 2 for quality audit | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWQA2 | |
| 28 | LAVI1 | Points score 1: Shipping notification | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_LAVI1 | |
| 29 | LAVI2 | Points score 2: Shipping notification | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_LAVI2 | |
| 30 | ALAV1 | Points score 1: Variance from shipping notification | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_ALAV1 | |
| 31 | ALAV2 | Points score 2: Variance from shipping notification | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_ALAV2 | |
