SAP Table

VBRK Billing Document: Header Data

SAP table VBRK contains the header data of billing documents in the Sales and Distribution (SD) module. This table is crucial for storing and managing summary-level information about billing documents, such as invoices, credit memos, and debit memos. The data in VBRK represents key information that applies to the entire billing document, rather than individual line items (which are stored in the related table VBRP).

A billing document in SAP represents a financial transaction in the Sales and Distribution (SD) module. It is the formal record of a business transaction between a company and a customer, typically generated at the end of the sales process. Billing documents serve as the basis for financial postings in the Finance (FI) and Controlling (CO) modules, ensuring that revenue and accounts receivable are accurately recorded.

Types of Billing Documents:

  • Invoice: For billing customers for goods delivered or services rendered.
  • Credit Memo: Issued when a reduction or refund needs to be applied to an invoice.
  • Debit Memo: Issued when additional charges need to be billed to the customer.
  • Pro Forma Invoice: A non-binding document used for informational purposes, not for posting to financial accounts.

SAP table VBRK has 2 primary key fields being MANDT,VBELN.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

VBRK columns.

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

VBRK foreign keys.

Table Field Check Table Description Check Field
VBRK BUKRS T001 Company Codes BUKRS
VBRK BUPLA PBUSINESSPLACE Generated Table for View BUKRS
VBRK BUPLA PBUSINESSPLACE Generated Table for View BRANCH
VBRK BZIRK T171 Customers: Sales Districts MANDT
VBRK BZIRK T171 Customers: Sales Districts BZIRK
VBRK CITYC T005G City MANDT
VBRK CITYC T005G City LAND1
VBRK CITYC T005G City REGIO
VBRK CITYC T005G City CITYC
VBRK CMWAE TCURC Currency Codes MANDT
VBRK CMWAE TCURC Currency Codes WAERS
VBRK COUNC T005E County MANDT
VBRK COUNC T005E County LAND1
VBRK COUNC T005E County REGIO
VBRK COUNC T005E County COUNC
VBRK FKART TVFK Billing: Document Types MANDT
VBRK FKART TVFK Billing: Document Types FKART
VBRK FKART_RL TVFK Billing: Document Types MANDT
VBRK FKART_RL TVFK Billing: Document Types FKART
VBRK HITYP_PR THIT Customer Hierarchy Types MANDT
VBRK HITYP_PR THIT Customer Hierarchy Types HITYP
VBRK INCO1 TINC Customers: Incoterms INCO1
VBRK INCOV TINCV Incoterms Versions MANDT
VBRK INCOV TINCV Incoterms Versions INCOV
VBRK J_1AFITP J_1AFITP Tax Types MANDT
VBRK KALSM T683 Pricing procedures KAPPL
VBRK KALSM T683 Pricing procedures KALSM
VBRK KDGRP T151 Customers: Customer Groups MANDT
VBRK KDGRP T151 Customers: Customer Groups KDGRP
VBRK KKBER T014 Credit control areas KKBER
VBRK KNKLI KNA1 General Data in Customer Master MANDT
VBRK KNKLI KNA1 General Data in Customer Master KUNNR
VBRK KNUMA KONA Agreements MANDT
VBRK KNUMA KONA Agreements KNUMA
VBRK KONDA T188 Conditions: Groups for Customer Classifications MANDT
VBRK KONDA T188 Conditions: Groups for Customer Classifications KONDA
VBRK KTGRD TVKT Customers: Account Assignment Groups KTGRD
VBRK KUNAG KNA1 General Data in Customer Master MANDT
VBRK KUNAG KNA1 General Data in Customer Master KUNNR
VBRK KUNRG KNA1 General Data in Customer Master MANDT
VBRK KUNRG KNA1 General Data in Customer Master KUNNR
VBRK KURST TCURV Exchange rate types for currency translation MANDT
VBRK KURST TCURV Exchange rate types for currency translation KURST
VBRK LAND1 T005 Countries MANDT
VBRK LAND1 T005 Countries LAND1
VBRK MABER T047M Dunning areas MANDT
VBRK MABER T047M Dunning areas BUKRS
VBRK MANDT T000 Clients MANDT
VBRK MSCHL T040 Dunning keys MSCHL
VBRK PLTYP T189 Conditions: Price List Types MANDT
VBRK PLTYP T189 Conditions: Price List Types PLTYP
VBRK REGIO T005S Taxes: Region (Province) Key LAND1
VBRK RPLNR FPLA Billing Plan FPLNR
VBRK SFAKN VBRK Billing Document: Header Data VBELN
VBRK SPART TSPA Organizational Unit: Sales Divisions MANDT
VBRK SPART TSPA Organizational Unit: Sales Divisions SPART
VBRK STGRD T041C Reasons for Reverse Posting MANDT
VBRK STGRD T041C Reasons for Reverse Posting STGRD
VBRK STWAE TCURC Currency Codes MANDT
VBRK STWAE TCURC Currency Codes WAERS
VBRK VBUND T880 Global Company Data (for KONS Ledger) MANDT
VBRK VBUND T880 Global Company Data (for KONS Ledger) RCOMP
VBRK VKORG TVKO Organizational Unit: Sales Organizations MANDT
VBRK VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBRK VSBED TVSB Shipping Conditions MANDT
VBRK VSBED TVSB Shipping Conditions VSBED
VBRK VTWEG TVTW Organizational Unit: Distribution Channels MANDT
VBRK VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
VBRK WAERK TCURC Currency Codes MANDT
VBRK WAERK TCURC Currency Codes WAERS
VBRK ZLSCH T042Z Payment Methods for Automatic Payment MANDT
VBRK ZLSCH T042Z Payment Methods for Automatic Payment LAND1
VBRK ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH