MCVBRKB SAP (Reference Structure from MCVBRK for Function Module) Structure details
Description: Reference Structure from MCVBRK for Function Module
Structure field list including key, data, relationships and ABAP select examples
MCVBRKB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Reference Structure from MCVBRK for Function Module" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCVBRKB TYPE MCVBRKB.
The MCVBRKB table consists of various fields, each holding specific information or linking keys about Reference Structure from MCVBRK for Function Module data available in SAP. These include SUPKZ (Statistics update indicator (post in/post out)), MANDT (Client), VBELN (Billing Document), FKART (Billing Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCVBRKB structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ | ||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
FKART | Billing Type | FKART | CHAR | 4 | TVFK | FKART | |||
FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
RFBSK | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
LAND1 | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
COUNC | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD | |||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
FKART_RL | Invoice list type | FKART_RL | CHAR | 4 | TVFK | FKART | |||
FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | DATUM | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | TCURC | WAERS | |||
CMKUF | Credit data exchange rate at billing document rate | CMKUF | DEC | 9(5) | KURRF | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
FKART_AB | Accrual billing type | FKART_AB | CHAR | 4 | Assigned to domain | FKART | |||
KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLA | FPLNR | |||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | AKKP | ALPHA | LCNUM | AKN | |
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | J_1AFITP | |||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | TCURC | WAERS | FWS | ||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
NUMPG | Number of pages of invoice | J_1ANOPG | NUMC | 3 | J_1ANOPG | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | DOCSTAT_KK | CHAR | 1 | DOCSTAT_KK | ||||
NRZAS | Character Field of Length 12 | CHAR12 | CHAR | 12 | CHAR12 | ||||
SPE_BILLING_IND | EWM Billing Indicator | /SPE/DE_BILLING_IND | CHAR | 1 | /SPE/DE_BILLING_IND | ||||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
FK_SOURCE_SYS | Source System | FK_SOURCE_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
FKTYP_CRM | Billing Category in CRM | FKTYP_CRM | CHAR | 1 | FKTYP | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | T041C | STGRD | FSG | ||
VBTYP_EXT | Extension of SD Document Category | TDD_VBTYP_EXT | CHAR | 4 | DOM_VBTYP_EXT | ||||
.INCLU--AP | 0 | ||||||||
DPC_REL | Flag: DPC relevant | /SAPPCE/DPC_REL | CHAR | 1 | CHAR01 | ||||
.INCLU--AP | 0 | ||||||||
AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
AD01FAREG | Rule for billing | AD01FAREG | CHAR | 1 | AD01FAREG | ||||
.INCLU--AP | 0 | ||||||||
VCHRNMBR | Voucher Number | AD04VCHNR | NUMC | 8 | AD04VCHNR | ||||
.INCLU--AP | 0 | ||||||||
SWENR | Business Entity Number | HB_SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | |
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | |
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBSSPH | HBS_PHASE | |||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | CHBSNCM | HBS_MTLAUR | |||
STAGE | Construction Stage | HB_STAGE | INT4 | 10 | INT4 | ||||
HB_CONT_REASON | Contingency data | HB_CONT | CHAR | 2 | CHAR2 | ||||
HB_EXPDATE | Expiration date | HB_EXP | DATS | 8 | DATS | ||||
HB_RESDATE | Resolution date | HB_RES | DATS | 8 | DATS | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | J_3GKENIE | CHAR | 1 | J_3GKENIE | ||||
KUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
.INCLU--AP | 0 | ||||||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
.INCLU--AP | 0 | ||||||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
SPPORD | Sales Order for Special Payment Method | SPPORD | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
.INCLU--AP | 0 | ||||||||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
RFBSK_OLD | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
PERIV_CM | Fiscal Year Variant of Credit Control Area | PERIV_CM | CHAR | 2 | Assigned to domain | PERIV | |||
PKUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
PKUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PKUNRE | Bill-to party | KUNRE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
PKUNRG | Payer | KUNRG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PSPDNR | Forwarding agent | SPDNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PVRTNR | Sales employee | VRTNR | NUMC | 8 | PERNR | PREMV | |||
PLAAG | Country of the sold-to party | PLAAG | CHAR | 3 | Assigned to domain | LAND1 | |||
PLAWE | Country of ship-to party | PLAWE | CHAR | 3 | Assigned to domain | LAND1 | |||
PLARE | Country of the bill-to party | PLARE | CHAR | 3 | Assigned to domain | LAND1 | |||
PLARG | Country of the payer | PLARG | CHAR | 3 | Assigned to domain | LAND1 | |||
PLASP | Country of the carrier | PLASP | CHAR | 3 | Assigned to domain | LAND1 | |||
PLAVE | Country of the representative | PLAVE | CHAR | 3 | Assigned to domain | LAND1 | |||
PABLA | Unloading point of the ship-to party | PABLA | CHAR | 25 | TEXT25 | ||||
PZONE | Transportation zone of the ship-to party | PZONE | CHAR | 10 | Assigned to domain | ZONE | |||
PDUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
PZPERS | Person responsible | DZPERS | NUMC | 8 | PERNR | ||||
PLAZM | Country of Employee Responsible | PLAZM | CHAR | 3 | Assigned to domain | LAND1 | |||
HIEZU01 | Customer hierarchy Level 1 | HIEZU01 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU02 | Customer hierarchy Level 2 | HIEZU02 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU03 | Customer hierarchy Level 3 | HIEZU03 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU04 | Customer hierarchy Level 4 | HIEZU04 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU05 | Customer hierarchy Level 5 | HIEZU05 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU06 | Customer hierarchy Level 6 | HIEZU06 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU07 | Customer hierarchy Level 7 | HIEZU07 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU08 | Customer hierarchy Level 8 | HIEZU08 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU09 | Customer hierarchy Level 9 | HIEZU09 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HIEZU10 | Customer hierarchy Level 10 | HIEZU10 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
MERK4 | Characteristic Value | ATWRT | CHAR | 30 | ATWRT | ||||
MERK5 | Characteristic Value | ATWRT | CHAR | 30 | ATWRT | ||||
MERK6 | Characteristic Value | ATWRT | CHAR | 30 | ATWRT | ||||
MERK7 | Characteristic Value | ATWRT | CHAR | 30 | ATWRT | ||||
ATINM4 | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ATINM5 | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ATINM6 | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ATINM7 | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
MCBONUS | LIS Link to Rebates: Update Group | MC_BONUS | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCFINANZ | LIS link to cash management and forecast: update group | MC_FINANZ | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCPROJEKT | LIS link to CO/Projects: update group | MC_PROJEKT | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCKREDIT | LIS link to credit limits: update group | MC_KREDIT | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCCAS | LIS link to Sales Support (CAS): update group | MC_CAS | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCKOUPD | LIS link condition update: update group | MC_KOUPD | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCLIPLAN | LIS interface to scheduling agreement: update group | MC_LIPLAN | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCWERTKON | LIS link to value contract: Update group | MC_WERTKON | CHAR | 6 | Assigned to domain | ALPHA | STAFO | ||
MCBIW | LIS connection BIW export SD documents: update group | MC_BIW | CHAR | 6 | Assigned to domain | ALPHA | STAFO |
Key field | Non-key field |
How do I retrieve data from SAP structure MCVBRKB using ABAP code?
As MCVBRKB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCVBRKB as there is no data to select.How to access SAP table MCVBRKB
Within an ECC or HANA version of SAP you can also view further information about MCVBRKB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects