| 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 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | EKGRP | Allow NULL? |
| 10 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 11 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 12 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART | Allow NULL? |
| 13 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 14 | LNRZB | Agency business: Payee | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | W_LIFZE | Allow NULL? |
| 15 | KUNRG | Payer | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNRG | Allow NULL? |
| 16 | LFTYP | Agency business: Billing category | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WFTYP | Allow NULL? |
| 17 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 18 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 19 | WSTWAE | Agency Business: Statistics Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WSTWAE | Allow NULL? |
| 20 | BRTWR_RG | Key figure: Gross value of payment request (vendor) | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BRTWRRG | |
| 21 | NETWR_RG | Key figure: Net value of payment request to vendor | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_NETWRRG | |
| 22 | BRTWR_RGRL | Key Fig.: Final Amt of Remuneration List, Payment: Customer | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BRTRGRL | |
| 23 | NETWR_RGRL | Key Figure: Net Value of Remuneration List, Payment: Vendor | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_NETRGRL | |
| 24 | KZWI2_P_RG | Key Figure: Payment based on Remuneration List Conditions | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_DELKRRG | |
| 25 | KWERT_RGRL | Key figure: Value of Remuneration List Conditions, Payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KWERTRG | |
| 26 | MWSRL_RGRL | Key figure: Tax invoice list cond. (del credere), payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_MWSRLRG | |
| 27 | MWSBP_RGRL | Key Figure: Tax Amount Remuneration List, Payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_MWSBPRG | |
| 28 | KZWI1_P_RG | Key figure: condition subtotal 1, payment: vendor | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI1RG | |
| 29 | KZWI3_P_RG | Key figure: condition subtotal 3, payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI3RG | |
| 30 | KZWI4_P_RG | Key figure: condition subtotal 4, payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI4RG | |
| 31 | KZWI5_P_RG | Key figure: condition subtotal 5, payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI5RG | |
| 32 | KZWI6_P_RG | Key figure: Condition subtotal 6, payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI6RG | |
| 33 | BONBA_P_RG | Key fig: Rebate basis (condition subtotal 7), payt: vendor | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BONBARG | |
| 34 | KZWIS_P_RG | Key figure: Effective value of payment (vendor) | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_EFFEKRG | |
| 35 | AWBRK_RG | Key figure: Number of payment requests | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AWBRKRG | |
| 36 | AWBRP_RG | Key figure: Number of payment request items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AWBRPRG | |
| 37 | AWBRK_RLRG | Key Figure: Number of Remuneration Lists (Payment) | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ARLRKRG | |
| 38 | AWBRL_RLRG | Key Figure: No. of Documents in Remuneration Lists (Payment) | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ARLRPRG | |