SAP TABLES
| Sales and Distribution | Sales | Remaining Beverage - Obsolete Objects(SD-SLS-PLL-OBS) SAP SD
/BEV3/CHVABRSTZS SAP CH Settlement Statistics Table and data
/BEV3/CHVABRSTZS is a standard SAP Table which is used to store CH Settlement Statistics data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP /BEV3/CHVABRSTZS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
Dictionary fields for SAP /BEV3/CHVABRSTZS Table
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 |
* | Client | |
| BLG_NR | /BEV3/CHXBLNR | CHAR | 10 | CH Reference Document Number | ||
| POS_NR | /BEV3/CHVPOSNR | NUMC | 6 | CH Item Number | ||
| POS_ZHL | /BEV3/CHPOSZHL | NUMC | 6 | CH Settlement Record Statistics Item Counter | ||
| YVORGE | /BEV3/CHOE | NUMC | 4 |
* | CH Organizational Unit | |
| ABR_NR | /BEV3/CHABRNR | NUMC | 10 | Settlement Number | ||
| YVWDNR | /BEV3/CHDTWDNR | NUMC | 13 | CHD Contract Number | ||
| VBKL_SUPER | /BEV3/CHBKL_SPR | CHAR | 4 |
* | Agreement Class - Caller | |
| RI_SUPER | /BEV3/CHRI_SPR | NUMC | 6 |
* | Rule Identifier - Caller | |
| VBIN_SUPER | /BEV3/CHBIN_SPR | NUMC | 4 | Agreement Entity - Calling Program | ||
| PART_SUPER | /BEV3/CHBTMPART_SPR | CHAR | 8 | Part of the Agreement Date - Caller | ||
| PTIN_SUPER | /BEV3/CHTMINSTANZ_SPR | NUMC | 4 | Identification of the individual date parts - Caller | ||
| VBKL | /BEV3/CHBKL_SLF | CHAR | 4 |
* | Agreement Class - Contract Called | |
| RI | /BEV3/CHRI_SLF | NUMC | 6 |
* | Rule Identifier - Contract Called | |
| VBIN | /BEV3/CHBIN_SLF | NUMC | 4 | Agreement Entity - Contract Called | ||
| VBNR | /BEV3/CHBNR_SLF | NUMC | 9 | Agreement Number in Seq. Time Order - Contract Called | ||
| VBDTA | /BEV3/CHBDTA_SLF | DATS | 8 | Date (Valid from) - Contract Called | ||
| ABR_KZ | /BEV3/CHABRFID | NUMC | 4 | Settlement Method Identifier | ||
| VBEWAR | /BEV3/CHBEWAR | CHAR | 4 |
* | Contract Movement Type | |
| STR_VRG | /BEV3/CHSTRVRG | CHAR | 1 | Tax transaction | ||
| VWD_LAND | /BEV3/CHWD_LAND | CHAR | 3 |
* | Country Key of CHD | |
| VWD_STRKZ | /BEV3/CHWD_STRKZ | CHAR | 1 |
* | Tax Classification of Contract Handling Document | |
| ERG_NR | /BEV3/CHXBLNR_ERGZ | CHAR | 10 | CH Reference Document Number of Date Supplement | ||
| STAT_KZ | /BEV3/CHSTATKZ | CHAR | 1 | Statistics Indicator | ||
| STAT_BZNR | /BEV3/CHVPOSNR | NUMC | 6 | CH Item Number | ||
| VERD_KZ | /BEV3/CHRDKZ | CHAR | 1 | Compression Indicator | ||
| SP_TAG | /BEV3/CHERDICHTET_ZUM | DATS | 8 | Compression Day | ||
| VB_STRKZ | /BEV3/CHB_STRKZ | CHAR | 1 |
* | Tax Classification of Agreement | |
| VERTSI_BCH | /BEV3/CHERTSI_BCH | CHAR | 1 | Contract View - Post | ||
| ABR_KZ_BCH | /BEV3/CHABRFID_BCH | NUMC | 4 | Settlement Method Identifier - Post | ||
| PARTTM_BCH | /BEV3/CHBTMPART_BCH | CHAR | 8 | Part of the Agreement Date - Post | ||
| RI_BCH | /BEV3/CHRI_BCH | NUMC | 6 |
* | Rule Identifier - Post | |
| VKORG_BCH | /BEV3/CHKORG_BCH | CHAR | 4 |
* | Sales Organization - Post | |
| VTWEG_BCH | /BEV3/CHTWEG_BCH | CHAR | 2 |
* | Distribution Channel - Post | |
| SPART_BCH | /BEV3/CHSPART_BCH | CHAR | 2 |
* | Division - Post | |
| BUKRS_BCH | /BEV3/CHBUKRS_BCH | CHAR | 4 |
* | Company Code - Post | |
| WERK_BCH | /BEV3/CHWERK_BCH | CHAR | 4 |
* | Plant - Post | |
| VWDNR_BCH | /BEV3/CHWDNR_BCH | NUMC | 13 | CHD Contract Number - Post | ||
| RG_BCH | /BEV3/CHRG_BCH | CHAR | 10 |
* | Customer Number of Payer - Post | ALPHA |
| WE_BCH | /BEV3/CHWE_BCH | CHAR | 10 |
* | Customer Number of Ship-to Party - Post | ALPHA |
| AG_BCH | /BEV3/CHAG_BCH | CHAR | 10 |
* | Customer Number of Sold-to Party - Post | ALPHA |
| RE_BCH | /BEV3/CHRE_BCH | CHAR | 10 |
* | Customer Number of Bill-to Party - Post | ALPHA |
| DE_BCH | /BEV3/CHDE_BCH | CHAR | 10 |
* | Customer Number - Post | ALPHA |
| VRL_BCH | /BEV3/CHRL_BCH | CHAR | 10 |
* | Distributor Number - Post | ALPHA |
| SPD_BCH | /BEV3/CHSPD_BCH | CHAR | 10 |
* | Forwarding Agent - Post | ALPHA |
| RG_STAT | /BEV3/CHRG_STAT | CHAR | 10 |
* | Customer Number of Payer - Statistics | ALPHA |
| WE_STAT | /BEV3/CHWE_STAT | CHAR | 10 |
* | Customer Number of Ship-to Party - Statistics | ALPHA |
| AG_STAT | /BEV3/CHAG_STAT | CHAR | 10 |
* | Customer Number of Sold-to Party - Statistics | ALPHA |
| RE_STAT | /BEV3/CHRE_STAT | CHAR | 10 |
* | Customer Number of Bill-to Party - Statistics | ALPHA |
| VB_PERSNO | /BEV3/CHBPERSNO | NUMC | 8 |
* | Personnel Number Sales Representative | |
| BTRG_BCH | /BEV3/CHBTRG_BCH | CURR | 16(2) | Amount - Post | ||
| WAERK_BCH | /BEV3/CHWAERK_BCH | CUKY | 5 |
* | Currency Indicator - Post | |
| LAST_BDG | /BEV3/CHLASTBDG | NUMC | 4 |
* | Condition that Modified Posting Data | |
| SPRAS | /BEV3/CHSPRAS_BLG | LANG | 1 | T002 | Language Key for Documents | ISOLA |
| ZUORDNR | DZUONR | CHAR | 18 | Assignment Number | ||
| BSCHL | BSCHL | CHAR | 2 |
* | Posting Key | |
| PBANKTYP | BVTYP | CHAR | 4 | Partner Bank Type | ||
| ZAHLWEG | DZLSCH | CHAR | 1 |
* | Payment Method | |
| ZAHLSP | DZAHLS | CHAR | 1 |
* | Block Key for Payment | |
| MAHNSP | MANSP | CHAR | 1 |
* | Dunning block | |
| MSCHL | MSCHL | CHAR | 1 |
* | Dunning key | |
| ZAHLBED | DZTERM | CHAR | 4 | Terms of Payment Key | ||
| MAHNBER | MABER | CHAR | 2 |
* | Dunning Area | |
| BUCHDT_AB | /BEV3/CHBUCHDAT_AB | DATS | 8 | From Date of Settlement Period | ||
| BUCHDT_BIS | /BEV3/CHBUCHDAT_BIS | DATS | 8 | To Date of Settlement Period | ||
| BRCHDT_AB | /BEV3/CHBRCHDAT_AB | DATS | 8 | From Date of Calculation Interval | ||
| BRCHDT_BIS | /BEV3/CHBRCHDAT_BIS | DATS | 8 | To Date of Calculation Interval | ||
| VKORG_LSTG | /BEV3/CHKORG_LSTG | CHAR | 4 |
* | Sales Organization - Performance | |
| VTWEG_LSTG | /BEV3/CHTWEG_LSTG | CHAR | 2 |
* | Distribution Channel - Performance | |
| SPART_LSTG | /BEV3/CHSPART_LSTG | CHAR | 2 |
* | Division - Performance | |
| BUKRS_LSTG | /BEV3/CHBUKRS_LSTG | CHAR | 4 |
* | Company Code - Payment | |
| WERK_LSTG | /BEV3/CHWERK_LSTG | CHAR | 4 |
* | Plant - Performance | |
| VWDNR_LSTG | /BEV3/CHWDNR_LSTG | NUMC | 13 | CHD Contract Number - Performance | ||
| BTRG_LSTG | /BEV3/CHBTRG_LSTG | CURR | 16(2) | Amount - Payment | ||
| WAERK_LSTG | /BEV3/CHWAERK_LSTG | CUKY | 5 |
* | Currency Indicator - Performance | |
| UKURS | /BEV3/CHUKURS | DEC | 9(5) | Exchange Rate Performance -> Post | EXCRT | |
| KURSTYP | /BEV3/CHKURST_CURR | CHAR | 4 |
* | Exchange Rate Type of Conversion Performance -> Post | |
| PRZSTZ_ZNS | /BEV3/CHZNSTZ | DEC | 7(3) | Percentage | ||
| PRZSTZ_MAX | /BEV3/CHZNSTZ_MAX | DEC | 7(3) | Percentage Maximum | ||
| PRZSTZ_MIN | /BEV3/CHZNSTZ_MIN | DEC | 7(3) | Percentage Minimum | ||
| PRZSTZ_ABW | /BEV3/CHZNSTZ_ABW | DEC | 7(3) | Percentage Variance | ||
| BTRG_ZNS | /BEV3/CHBTRG_ZNS | CURR | 16(2) | Amount - Interest Basis | ||
| WAERK_ZNS | /BEV3/CHWAERK_ZNS | CUKY | 5 |
* | Currency Indicator - Interest | |
| I_ZNSCHL | /BEV3/CHZNSCHL_I | CHAR | 6 | CH - Interest Key (Internal) | ||
| E_ZNSCHL | /BEV3/CHZNSCHL_E | CHAR | 10 |
* | CH - Interest Key (External); Reference Interest Rate | |
| SZBMETH | SZBMETH | CHAR | 1 | Interest Calculation Method | ||
| STGBASIS | VVSTGBASIS | NUMC | 1 | Base Days Method | ||
| ABASTAGE | ABASTAGE | NUMC | 6 | Number of base days in a calculation period | ||
| ATAGE | TFMATAGE | INT4 | 10 | Number of Days | ||
| MAT_NR | MATNR | CHAR | 18 |
* | Material Number | MATN1 |
| SORTIMENT | W_SORTK | CHAR | 18 |
* | Assortment module | ALPHA |
| MENGE | /BEV3/CHMNGE | QUAN | 15(5) | Minimum Purchase | ||
| MEINH | /BEV3/CHMEINH_ABN | UNIT | 3 |
* | Unit of Measure of Minimum Purchase | CUNIT |
| MENGE_LSTG | /BEV3/CHMNGE_LSTG | QUAN | 15(5) | Quantity of Purchase Performance | ||
| MEINH_LSTG | /BEV3/CHMEINH_LSTG | UNIT | 3 |
* | Unit of Measure for Performance Quantity | CUNIT |
| BTRG_UMS | /BEV3/CHBTRG_UMS | CURR | 16(2) | Amount - Sales | ||
| WAERK_UMS | /BEV3/CHWAERK_UMS | CUKY | 5 |
* | Currency Indicator - Sales | |
| SACHKTO | SAKNR | CHAR | 10 |
* | G/L Account Number | ALPHA |
| KOST_ST | KOSTL | CHAR | 10 |
* | Cost Center | ALPHA |
| I_AUFTRG | AUFNR | CHAR | 12 |
* | Order Number | ALPHA |
| PRFTCNTR | PRCTR | CHAR | 10 |
* | Profit Center | ALPHA |
| MWSKZ | MWSKZ | CHAR | 2 |
* | Tax on sales/purchases code | |
| BTRG_STR | MWSTS | CURR | 13(2) | Tax Amount in Local Currency | ||
| BTRG_STRBAS | HWBAS | CURR | 13(2) | Tax Base Amount in Local Currency | ||
| WAERK_STR | /BEV3/CHWAERK_STR | CUKY | 5 |
* | Currency Indicator - Tax | |
| EVENT_NR | /BEV3/CHEVENR | NUMC | 16 | CH BTE Sequence Number of Event Receipt | ||
| BUZEI | BUZEI | NUMC | 3 | Number of Line Item Within Accounting Document | ||
| TXT_BCH | /BEV3/CHTXTBCH | CHAR | 50 | Individual Posting Text | ||
| BK_LFDNR | /BEV3/CHLFDNR16 | NUMC | 16 | Sequence Number | ||
| UMSSTAFFEL | /BEV3/CHSTAF_RA | CHAR | 6 |
* | Scale ID | |
| ABSSTAFFEL | /BEV3/CHSTAF_RA | CHAR | 6 |
* | Scale ID | |
| GLTG_AB | /BEV3/CHDATABV | DATS | 8 | CH Date Valid From | ||
| MEINH_VG | /BEV3/CHMEINH | UNIT | 3 |
* | Unit of Measure | CUNIT |
| WAERK_VG | /BEV3/CHWAERK | CUKY | 5 |
* | Currency indicator | |
| ABSBASIS_VG | /BEV3/CHABSBAS | QUAN | 15(5) | Sales Basis | ||
| BTRG_VG | /BEV3/CHBTRG | CURR | 16(2) | Amount | ||
| Key field | |
| Non-key field |
