| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 11 | LNRZB | Agency business: Payee | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | W_LIFZE | Allow NULL? |
| 12 | LFTYP | Agency business: Billing category | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WFTYP | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 14 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 15 | WSTWAE | Agency Business: Statistics Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WSTWAE | Allow NULL? |
| 16 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEWEI | Allow NULL? |
| 17 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VOLEH | Allow NULL? |
| 18 | PUNEI | Points unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | PUNEI | Allow NULL? |
| 19 | BRTWR_LF | Key figure: Gross value of vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BRTWRLF | |
| 20 | NETWR_LF | Key figure: net value of vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_NETWRLF | |
| 21 | BRTWR_LFRL | Key fig.: Final Amt, Remuneration List (Vendor Billing Doc.) | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BRTLFRL | |
| 22 | NETWR_LFRL | Key Fig: Net Value of Remuneration List, Vendor Billing Doc. | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_NETLFRL | |
| 23 | KWERT_LFRL | Key figure: Value of Remuneration List Conditions: VBD | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KWERTLF | |
| 24 | MWSRL_LFRL | Key fig.: Tax Remuneration List Conditions (del credere) VBD | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_MWSRLLF | |
| 25 | MWSBP_LFRL | Key Figure: Tax Amount Remuneratn List, Vendor Billing Doc. | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_MWSBPLF | |
| 26 | NAVNW_LFRL | Key Figure: Non-Deductible Input Tax, Remuneration List VBD | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_NAVNWLF | |
| 27 | BRGEW_P_LF | Key figure: gross weight of vendor billing document | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_BRGEWLF | |
| 28 | NTGEW_P_LF | Key figure: Net weight of vendor billing document | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_NTGEWLF | |
| 29 | VOLUM_P_LF | Key figure: volume of vendor billing document | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_VOLUMLF | |
| 30 | ANZPU_P_LF | Key figure: Points, vendor billing document | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_PUNKTLF | |
| 31 | KZWI1_P_LF | Key figure: condition subtotal 1, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI1LF | |
| 32 | KZWI2_P_LF | Key figure: condition subtotal 2, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI2LF | |
| 33 | KZWI3_P_LF | Key figure: condition subtotal 3, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI3LF | |
| 34 | KZWI4_P_LF | Key figure: condition subtotal 4, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI4LF | |
| 35 | KZWI5_P_LF | Key figure: condition subtotal 5, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI5LF | |
| 36 | KZWI6_P_LF | Key figure: condition subtotal 6, vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_KZWI6LF | |
| 37 | BONBA_P_LF | Key figure: Rebate basis (subtotal 7), vendor billing doc. | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_BONBALF | |
| 38 | KZWIS_P_LF | Key figure: effective value of vendor billing document | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_EFFEKLF | |
| 39 | AWBRK_LF | Key figure: Number of vendor billing documents | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AWBRKRL | |
| 40 | AWBRP_LF | Key figure: No. of vendor billing document items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_AWBRPRL | |
| 41 | AWBRK_LFRL | Key Figure: No. of Invoice Lists (Vendor Billing Document) | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ARLRKRL | |
| 42 | AWBRL_LFRL | Key figure: no. of documents in invoice lists (VBD) | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ARLRPRL | |
