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:

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

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Billing Document CHAR 10 0 VBELN_VF
FKART Billing Type CHAR 4 0 TVFK FKART
FKTYP Billing Category CHAR 1 0 FKTYP
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
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
Error in Accounting Interface
A Billing document blocked for forwarding to FI
B Journal entry not created (account determination error)
C Journal entry has been created
D Billing document is not relevant for accounting
E Billing document canceled
F Journal entry not created (pricing error)
G Journal entry not created (export data missing)
H Posted via invoice list
I Posted via invoice list (account determination error)
K Journal entry not created (no authorization)
L Billing doc. blocked for transfer to manager (only IS-OIL)
M Analyst Approval refused (only IS-OIL)
N No Journal entry due to fund management (only IS-PS)
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
A Ship-to Party
B Payer
C Sold-to Party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold-to Party (segment KNAS)
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
1 FI-CA-Inv.: Invoicing Order Created
2 FI-CA-Inv.: Invoicing Document Created
3 FI-CA-Inv.: Invoicing Order Cancelled
A Journal Entry Generated in FI
B Journal Entry Generated in FI-CA
C Billing Doc. Transferred to IS-U, Billing Request Generated
D Billing Doc. Transferred to IS-U, IS-U Billing Doc Generated
E Billing Doc. Transferred to IS-U, Billing Request Cancelled
F Transferral to Financial Accounting Not Neccessary
G Billing Block IDoc Processing
NRZAS Character Field of Length 12 CHAR 12 0 CHAR12
SPE_BILLING_IND EWM Billing Indicator CHAR 1 0 /SPE/DE_BILLING_IND
No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
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
Not Relevant
A To Be Cleared
B Partially Cleared
C Fully Cleared
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
Not Relevant
A Completed
B To Be Posted
C Canceled
D Incomplete
VF_TODO Billing Issue Type CHAR 1 0 VF_TODO
A Accounting Interface
B Account Determination
C Pricing
D Accounting Access
BDR_STATUS Billing Document Request Status CHAR 1 0 BDR_STATUS
Not Relevant
A To Be Invoiced
B Partially Invoiced
C Invoiced
D Rejected
E Incomplete
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
Not Relevant
A In Progress
B Finalized
C Completed
D Rejected
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
Not Relevant
A In Approval
B Released
C Rejected
D To Be Reworked
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
01 Analytics fields in VBRP #1
02 Set RFBSK in VBRK for incomplete data #2
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
A Billing of costs & fees
B Billing of costs only
C Billing of fees only
VCHRNMBR Voucher Number NUMC 8 0 AD04VCHNR
J_3GKBAUL ETM-Relevant Indicator CHAR 1 0 J_3GKBAUL
SAP standard
1 Relevant to CEM with CEM posting rules
2 Relevant to CEM with SAP standard posting rules
3 Program-internal: CEM-relevant co. code to co. code (EDI)
J_3GKENIE Indicator for I(nternal) or E(xternal) Posting CHAR 1 0 J_3GKENIE
E External posting
I Internal posting
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
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance CHAR 1 0 SD_SEPA_FLAG
No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
SPPAYM Payment Form for Special Payment Method CHAR 2 0 SPPAYM
01 Payment Service Provider
SPPORD Sales Order for Special Payment Method CHAR 10 0 SPPORD

VBRK foreign key relationships

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