SAP VBRK Billing Document: Header Data Table
Overview
VBRK is a standard SAP S/4HANA table that stores Billing Document: Header Data data. There are total 156 fields in the VBRK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBRK belongs to Billing (SD-BIL) module and is located in the package Application development R/3 invoice (VF).
In addition, following links provide an overview of foreign key relationships, if any, that link VBRK to other SAP tables and standard CDS views available based on VBRK table in S/4HANA 2020.
Techincal Settings of VBRK
Below are technical details of the table VBRK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBRK Fields
The following table gives you an overview of the fields available in VBRK
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Billing Document | VBELN_VF | CHAR | 10 | |
| FKART | Billing Type | FKART | TVFK | CHAR | 4 |
| FKTYP | Billing Category | FKTYP | CHAR | 1 | |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| WAERK | SD document currency | WAERK | TCURC | CUKY | 5 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| KALSM | Pricing Procedure in Pricing | KALSMASD | T683 | CHAR | 6 |
| KNUMV | Number of the Document Condition | KNUMV | CHAR | 10 | |
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 |
| FKDAT | Billing Date | FKDAT | DATS | 8 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| POPER | Posting period | POPER | NUMC | 3 | |
| KONDA | Customer Price Group | KONDA | T188 | CHAR | 2 |
| KDGRP | Customer Group | KDGRP | T151 | CHAR | 2 |
| BZIRK | Sales District | BZIRK | T171 | CHAR | 6 |
| PLTYP | Price List Type | PLTYP | T189 | CHAR | 2 |
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 |
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | |
| RFBSK | Status for Transfer to Accounting | RFBSK | CHAR | 1 | |
| MRNKZ | Manual Invoice Maintenance | MRNKZ | CHAR | 1 | |
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9 | |
| CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | |
| VALTG | Additional Value Days | VALTG | NUMC | 2 | |
| VALDT | Fixed Value Date | VALDT | DATS | 8 | |
| ZTERM | Terms of payment key | DZTERM | CHAR | 4 | |
| ZLSCH | Payment Method | SCHZW_BSEG | T042Z | CHAR | 1 |
| KTGRD | Account Assignment Group for this customer | KTGRD | TVKT | CHAR | 2 |
| LAND1 | Destination Country/Region | LLAND | T005 | CHAR | 3 |
| REGIO | Region (State Province County) | REGIO | T005S | CHAR | 3 |
| COUNC | County Code | COUNC | T005E | CHAR | 3 |
| CITYC | City Code | CITYC | T005G | CHAR | 4 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| TAXK1 | Tax Classification 1 for Customer | TAXK1 | CHAR | 1 | |
| TAXK2 | Tax Classification 2 for Customer | TAXK2 | CHAR | 1 | |
| TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | |
| TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | |
| TAXK5 | Tax Classification 5 for Customer | TAXK5 | CHAR | 1 | |
| TAXK6 | Tax Classification 6 for Customer | TAXK6 | CHAR | 1 | |
| TAXK7 | Tax Classification 7 for Customer | TAXK7 | CHAR | 1 | |
| TAXK8 | Tax Classification 8 for Customer | TAXK8 | CHAR | 1 | |
| TAXK9 | Tax Classification 9 for Customer | TAXK9 | CHAR | 1 | |
| NETWR | Net Value in Document Currency | NETWR | CURR | 15 | |
| ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| STAFO | Update Group for statistics update | STAFO | CHAR | 6 | |
| KUNRG | Payer | KUNRG | KNA1 | CHAR | 10 |
| KUNAG | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| MABER | Dunning Area | MABER | T047M | CHAR | 2 |
| STWAE | Statistics Currency | STWAE | TCURC | CUKY | 5 |
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| SFAKN | Number of canceled billing document | SFAKN | VBRK | CHAR | 10 |
| KNUMA | Agreement (various conditions grouped together) | KNUMA | KONA | CHAR | 10 |
| FKART_RL | Invoice List Type | FKART_RL | TVFK | CHAR | 4 |
| FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | |
| KURST | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| MSCHL | Dunning Key | MSCHL | T040 | CHAR | 1 |
| MANSP | Dunning Block | MANSP | T040S | CHAR | 1 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| KKBER | Credit control area | KKBER | T014 | CHAR | 4 |
| KNKLI | Customer's Account Number with Credit Limit Reference | KNKLI | KNA1 | CHAR | 10 |
| CMWAE | Currency key of credit control area | WAERS_CM | TCURC | CUKY | 5 |
| CMKUF | Credit data exchange rate at billing document rate | CMKUF | DEC | 9 | |
| HITYP_PR | Hierarchy type for pricing | HITYP_PR | THIT | CHAR | 1 |
| BSTNK_VF | Customer Reference | BSTKD | CHAR | 35 | |
| VBUND | Company ID of Trading Partner | RASSC | T880 | CHAR | 6 |
| FKART_AB | Accrual Billing Type | FKART_AB | CHAR | 4 | |
| KAPPL | Application | KAPPL | CHAR | 2 | |
| LANDTX | Tax Departure Country | LANDTX | CHAR | 3 | |
| STCEG_H | Origin of Sales Tax ID Number | STCEG_H | CHAR | 1 | |
| STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | |
| XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | |
| ZUONR | Assignment number | ORDNR_V | CHAR | 18 | |
| MWSBK | Tax amount in document currency | MWSBP | CURR | 13 | |
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | |
| FKSTO | Billing document is canceled | FKSTO | CHAR | 1 | |
| XEGDR | Indicator: Triangular Deal Within the EU | XEGDR | CHAR | 1 | |
| RPLNR | Number of payment card plan type | RPLNR | FPLA | CHAR | 10 |
| J_1AFITP | Tax type | J_1AFITP_D | J_1AFITP | CHAR | 2 |
| KURRF_DAT | Translation date | WWERT_D | DATS | 8 | |
| KIDNO | Payment Reference | KIDNO | CHAR | 30 | |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| NUMPG | Number of pages of invoice | J_1ANOPG | NUMC | 3 | |
| BUPLA | Business Place | BUPLA | J_1BBRANCH | CHAR | 4 |
| VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | |
| FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | DOCSTAT_KK | CHAR | 1 | |
| NRZAS | Character Field of Length 12 | CHAR12 | CHAR | 12 | |
| SPE_BILLING_IND | EWM Billing Indicator | /SPE/DE_BILLING_IND | CHAR | 1 | |
| VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | |
| FK_SOURCE_SYS | Source System | FK_SOURCE_SYS | CHAR | 10 | |
| FKTYP_CRM | Billing category in SAP S/4HANA for customer management | FKTYP_CRM | CHAR | 1 | |
| STGRD | Reason for Reversal | STGRD | T041C | CHAR | 2 |
| CHANGED_ON | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21 | |
| EXPKZ | Export indicator | EXPKZ | CHAR | 1 | |
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | |
| AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | |
| AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9 | |
| LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| BUCHK | Posting Status of Billing Document | BUCHK | CHAR | 1 | |
| GBSTK | Overall Processing Status (Header/All Items) | GBSTK | CHAR | 1 | |
| RELIK | Invoice list status of billing document | RELIK | CHAR | 1 | |
| UVALS | Incompletion Status (All Items) | UVALL_SU | CHAR | 1 | |
| UVPRS | Pricing Incompletion Status (All Items) | UVPRS_UK | CHAR | 1 | |
| CLRST | Clearing Status of Billing Document | CLRST | CHAR | 1 | |
| FKSAK | Order-Related Billing Status (All Items) | FKSAK | CHAR | 1 | |
| FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | |
| VF_STATUS | SD Billing Status | VF_STATUS | CHAR | 1 | |
| VF_TODO | SD Billing Document Issue | VF_TODO | CHAR | 1 | |
| BDR_STATUS | Billing Document Request Status | BDR_STATUS | CHAR | 1 | |
| BDR_REF | Source document on which a billing document request is based | BDR_REF | CHAR | 10 | |
| BDR_REF_LOGSYS | Logical system containing source document of BDR | BDR_REF_LOGSYS | CHAR | 10 | |
| BDR_REF_VBTYP | SD document category of BDR source document | BDR_REF_VBTYP | CHAR | 4 | |
| PBD_STATUS | Preliminary Billing Document Status | PBD_STATUS | CHAR | 1 | |
| ABSTK | Rejection Status (All Items) | ABSTK | CHAR | 1 | |
| DRAFT | IsDraft Indicator | VF_DRAFT_INDICATOR | CHAR | 1 | |
| ACTIVEDOCUMENT | Sales and Distribution Document Number | VBELN | CHAR | 10 | |
| GRWCU | Currency of statistical values for foreign trade | GRWCU | CUKY | 5 | |
| BLART | Document Type | BLART | CHAR | 2 | |
| INTRA_REL | Relevant for Intrastat Reporting | INTRA_REL | CHAR | 1 | |
| INTRA_EXCL | Exclude from Intrastat Reporting | INTRA_EXCL | CHAR | 1 | |
| ACCRREL | Is relevant for accrual | ISACCRUALRELEVANT | CHAR | 1 | |
| PSPSD | Payment Split Predecessor Sales Document | PSPSD | CHAR | 10 | |
| APM_APPROVAL_STATUS | Document Approval Status | SD_APM_APPROVAL_STATUS | CHAR | 1 | |
| APM_APPROVAL_REASON | Approval Request Reason ID | SD_APM_APPROVAL_REASON | CHAR | 4 | |
| J_1TPBUPL | Branch Code | BCODE | CHAR | 5 | |
| INCOV | Incoterms Version | INCOV | TINCV | CHAR | 4 |
| INCO2_L | Incoterms Location 1 | INCO2_L | CHAR | 70 | |
| INCO3_L | Incoterms Location 2 | INCO3_L | CHAR | 70 | |
| SDM_VERSION | SDM: Version field for VBRK | SDBIL_SDM_VERSION_VBRK | CHAR | 2 | |
| DUMMY_BILLINGDOC_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| GLO_LOG_REF1_HD | Country Specific Reference 1 in the Document | GLO_LOG_REF1_HD | CHAR | 25 | |
| ZAPCGKH | Annexing package key | /ILE/TAPCGK | /ILE/TV01 | NUMC | 4 |
| APCGK_EXTENDH | Extended key for annexing package | /ILE/TAPCGK_EXT | NUMC | 10 | |
| ZABDATH | Annexing base date | /ILE/TABDAT | DATS | 8 | |
| DPC_REL | Flag: DPC relevant | /SAPPCE/DPC_REL | CHAR | 1 | |
| AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | |
| AD01FAREG | Rule for Billing | AD01FAREG | CHAR | 1 | |
| VCHRNMBR | Voucher Number | AD04VCHNR | NUMC | 8 | |
| J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | |
| J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | J_3GKENIE | CHAR | 1 | |
| KUNWE | Ship-to party | KUNWE | * | CHAR | 10 |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| PAY_TYPE | SEPA: Payment Type | SEPA_PAY_TYPE | CHAR | 1 | |
| SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | |
| MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | |
| SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | |
| SPPORD | Sales Order for Special Payment Method | SPPORD | CHAR | 10 | |
| ZCUSM | Reseller | ZRESELLER | * | CHAR | 10 |
| RESELLER | Reseller | ZRESELLER | * | CHAR | 10 |
| END_CUSTOMER | End Customer | ZEND_CUSTOMER | * | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBRK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBRK | BUKRS | 1: CN | T001 |
| VBRK | BUPLA | C: CN | J_1BBRANCH |
| VBRK | BZIRK | C: CN | T171 |
| VBRK | CITYC | C: CN | T005G |
| VBRK | CMWAE | C: CN | TCURC |
| VBRK | COUNC | C: CN | T005E |
| VBRK | FKART | 1: CN | TVFK |
| VBRK | FKART_RL | C: CN | TVFK |
| VBRK | HITYP_PR | C: CN | THIT |
| VBRK | INCO1 | C: CN | TINC |
| VBRK | INCOV | 1: CN | TINCV |
| VBRK | J_1AFITP | 1: CN | J_1AFITP |
| VBRK | KALSM | 1: CN | T683 |
| VBRK | KDGRP | C: CN | T151 |
| VBRK | KKBER | C: CN | T014 |
| VBRK | KNKLI | C: CN | KNA1 |
| VBRK | KNUMA | C: CN | KONA |
| VBRK | KONDA | C: CN | T188 |
| VBRK | KTGRD | C: CN | TVKT |
| VBRK | KUNAG | 1: CN | KNA1 |
| VBRK | KUNRG | 1: CN | KNA1 |
| VBRK | KURST | C: CN | TCURV |
| VBRK | LAND1 | C: CN | T005 |
| VBRK | MABER | C: CN | T047M |
| VBRK | MANDT | 1: CN | T000 |
| VBRK | MANSP | C: CN | T040S |
| VBRK | MSCHL | C: CN | T040 |
| VBRK | PLTYP | C: CN | T189 |
| VBRK | REGIO | C: CN | T005S |
| VBRK | RPLNR | C: C | FPLA |
| VBRK | SFAKN | : | VBRK |
| VBRK | SPART | C: CN | TSPA |
| VBRK | STGRD | 1: CN | T041C |
| VBRK | STWAE | C: CN | TCURC |
| VBRK | VBUND | C: CN | T880 |
| VBRK | VKORG | C: CN | TVKO |
| VBRK | VSBED | C: CN | TVSB |
| VBRK | VTWEG | C: CN | TVTW |
| VBRK | WAERK | 1: CN | TCURC |
| VBRK | ZAPCGKH | : | /ILE/TV01 |
| VBRK | ZLSCH | C: CN | T042Z |