SAP Table VBRK

Billing Document: Header Data

VBRK (Billing Document: Header Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBRK to other SAP tables.

VBRK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Billing Document VBELN_VF VBUK CHAR 10 0
FKART Billing Type FKART TVFK CHAR 4 0
FKTYP Billing category FKTYP CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
WAERK SD Document Currency WAERK TCURC CUKY 5 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
KONDA Price group (customer) KONDA T188 CHAR 2 0
KDGRP Customer group KDGRP T151 CHAR 2 0
BZIRK Sales district BZIRK T171 CHAR 6 0
PLTYP Price list type PLTYP T189 CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
EXPKZ Export indicator EXPKZ CHAR 1 0
RFBSK Status for transfer to accounting RFBSK CHAR 1 0
NULL Error in Accounting Interface
A Billing document blocked for forwarding to FI
B Posting document not created (account determ.error)
C Posting document has been created
D Billing document is not relevant for accounting
E Billing Document Canceled
F Posting document not created (pricing error)
G Posting document not created (export data missing)
H Posted via invoice list
I Posted via invoice list (account determination error)
K Accounting document not created (no authorization)
L Billing doc. blocked for transfer to manager (only IS-OIL)
M Analyst Approval refused (only IS-OIL)
N No posting document due to fund management (only IS-PS)
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
KURRF Exchange rate for FI postings KURRF DEC 9 5
CPKUR ID:Exchange rate setting (no new rate determ.in bill.doc.) CPKUR CHAR 1 0
NULL No exchange rate setting
X Exchange rate setting
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
KTGRD Account assignment group for this customer KTGRD TVKT CHAR 2 0
LAND1 Country of Destination LLAND T005 CHAR 3 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
NETWR Net Value in Document Currency NETWR CURR 15 2
ZUKRI Combination criteria in the billing document DZUKRI CHAR 40 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
STAFO Update group for statistics update STAFO CHAR 6 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
MABER Dunning Area MABER T047M CHAR 2 0
STWAE Statistics currency STWAE TCURC CUKY 5 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM EIKP CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
AEDAT Changed On AEDAT DATS 8 0
SFAKN Cancelled billing document number SFAKN VBUK CHAR 10 0
KNUMA Agreement (various conditions grouped together) KNUMA KONA CHAR 10 0
FKART_RL Invoice list type FKART_RL TVFK CHAR 4 0
FKDAT_RL Billing date for the invoice list FKDAT_RL DATS 8 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
MSCHL Dunning key MSCHL T040 CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
SPART Division SPART TSPA CHAR 2 0
KKBER Credit control area KKBER T014 CHAR 4 0
KNKLI Customer's account number with credit limit reference KNKLI KNA1 CHAR 10 0
CMWAE Currency key of credit control area WAERS_CM TCURC CUKY 5 0
CMKUF Credit data exchange rate at billing document rate CMKUF DEC 9 5
HITYP_PR Hierarchy type for pricing HITYP_PR THIT CHAR 1 0
BSTNK_VF Customer purchase order number BSTKD CHAR 35 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
FKART_AB Accrual billing type FKART_AB CHAR 4 0
KAPPL Application KAPPL CHAR 2 0
LANDTX Tax departure country LANDTX CHAR 3 0
STCEG_H Origin of sales tax ID number STCEG_H CHAR 1 0
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 of Sales Tax ID Number STCEG_L CHAR 3 0
XBLNR Reference Document Number XBLNR_V1 CHAR 16 0
ZUONR Assignment number ORDNR_V CHAR 18 0
MWSBK Tax amount in document currency MWSBP CURR 13 2
LOGSYS Logical system LOGSYS CHAR 10 0
FKSTO Billing document is cancelled FKSTO CHAR 1 0
X Yes
NULL No
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
RPLNR Number of payment card plan type RPLNR FPLA CHAR 10 0
LCNUM Financial doc. processing: Internal financial doc. number LCNUM AKKP CHAR 10 0
J_1AFITP Tax type J_1AFITP_D J_1AFITP CHAR 2 0
KURRF_DAT Translation Date WWERT_D DATS 8 0
AKWAE Currency key for letter-of-credit procg in foreign trade AKWAE TCURC CUKY 5 0
AKKUR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
KIDNO Payment Reference KIDNO CHAR 30 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
NUMPG Number of pages of invoice J_1ANOPG NUMC 3 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
VKONT Contract Account Number CORR_VKONT_KK CHAR 12 0
FKK_DOCSTAT Additional Status Transfer to Fin. Accounting (Res. RFBSK) DOCSTAT_KK CHAR 1 0
A Accounting Document Generated in FI
B Accounting Document 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
1 FI-CA-Inv.: Invoicing Order Created
2 FI-CA-Inv.: Invoicing Document Created
3 FI-CA-Inv.: Invoicing Order Cancelled
G Billing Block IDoc Processing
NRZAS Character Field of Length 12 CHAR12 CHAR 12 0
SPE_BILLING_IND EWM Billing Indicator /SPE/DE_BILLING_IND CHAR 1 0
NULL No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
VTREF Reference Specifications from Contract CORR_VTREF_KK CHAR 20 0
FK_SOURCE_SYS Source System FK_SOURCE_SYS CHAR 10 0
FKTYP_CRM Billing Category in CRM FKTYP_CRM CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
STGRD Reason for Reversal STGRD T041C CHAR 2 0
VBTYP_EXT Extension of SD Document Category TDD_VBTYP_EXT CHAR 4 0
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
DPC_REL Flag: DPC relevant /SAPPCE/DPC_REL CHAR 1 0
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
OIC_INPD Invoice pricing date rule OIC_INPD CHAR 1 0
NULL Ref Sales Order (VBKD-PRSDT VBKD-OIC_TIME)
1 Invoice Creation (SY-UZEIT SY-DATUM at Inv Creatn)
2 Delivery (LIKP-LFDAT LIKP-LFUHR)
3 Actual Goods Issue (LIKP-WADAT_IST LIKP-OIWATIM)
4 Loading (LIKP-LDDAT LIKP-OILDTIM)
5 Planned Goods Issue (LIKP-WADAT LIKP-WAUHR)
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC T008 CHAR 1 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEEPD Fee pricing date OIA_FEEPD CHAR 1 0
NULL Ref Sales Order (VBKD-PRSDT VBKD-OIC_TIME)
1 Invoice Creation (SY-UZEIT SY-DATUM at Inv Creatn)
2 Delivery (LIKP-LFDAT LIKP-LFUHR)
3 Actual Goods Issue (LIKP-WADAT_IST LIKP-OIWATIM)
4 Loading (LIKP-LDDAT LIKP-OILDTIM)
5 Planned Goods Issue (LIKP-WADAT LIKP-WAUHR)
OIRIINVDOC SSR invoicing - invoicing document type OIRI_INVDOC CHAR 3 0
OIRIPBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
OIRICOMMCAL Calendar for monthly commission recalculation OIRI_COMMCAL CHAR 2 0
OIRIDCLAIM Daily claim document OIRI_DCLAIM CHAR 1 0
NULL Not a daily claim document
A Non fleet (Cash/Credit card daily claim document
B Fleet card daily claim document
OIRIPCTOT Payment card total OIRI_PCTOT CURR 15 2
OIRICHIND Clearing house document indicator OIRI_CHIND CHAR 1 0
OIRMATHANDGRP Material handling group (IS-Oil SSR) OIRA_MATHANDGRP CHAR 2 0
OIR_CHOBJ SSR PC: Clearing house OIRE_CHOBJ CHAR 6 0
OICSDPORGINV Original billing document OIC_VBELN_ORG CHAR 10 0
OICSDPVERNO Version number sequence OIC_SDP_DVERNO CHAR 2 0
OIU_DN_NO CHAR 20 0
OIU_WL_NO CHAR 15 0
OIU_WC_NO CHAR 5 0
OIU_MP_NO CHAR 20 0
OIU_MAJPD_CD CHAR 1 0
OIU_VNAME CHAR 6 0
OIU_DOI_NO CHAR 5 0
OIU_VBELN CHAR 10 0
OIU_PPA_RSN_CD CHAR 2 0
OIU_PRCS_DT DATS 8 0
OIU_FREQ_CD CHAR 1 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
MNDVG SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
SPPAYM Payment Form for Special Payment Method SPPAYM CHAR 2 0
01 Payment Service Provider
SPPORD Sales Order for Special Payment Method SPPORD CHAR 10 0

VBRK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBRK AKWAE VBRK AKWAE TCURC Currency Codes WAERS
VBRK AKWAE VBRK MANDT TCURC Currency Codes MANDT
VBRK BUKRS VBRK MANDT T001 Company Codes MANDT
VBRK BUKRS VBRK BUKRS T001 Company Codes BUKRS
VBRK BUPLA VBRK MANDT J_1BBRANCH Business Place MANDT
VBRK BUPLA VBRK BUKRS J_1BBRANCH Business Place BUKRS
VBRK BUPLA VBRK BUPLA J_1BBRANCH Business Place BRANCH
VBRK BZIRK VBRK MANDT T171 Customers: Sales Districts MANDT
VBRK BZIRK VBRK BZIRK T171 Customers: Sales Districts BZIRK
VBRK CITYC VBRK LAND1 T005G City LAND1
VBRK CITYC VBRK REGIO T005G City REGIO
VBRK CITYC VBRK CITYC T005G City CITYC
VBRK CITYC VBRK MANDT T005G City MANDT
VBRK CMWAE VBRK MANDT TCURC Currency Codes MANDT
VBRK CMWAE VBRK CMWAE TCURC Currency Codes WAERS
VBRK COUNC VBRK MANDT T005E County MANDT
VBRK COUNC VBRK LAND1 T005E County LAND1
VBRK COUNC VBRK REGIO T005E County REGIO
VBRK COUNC VBRK COUNC T005E County COUNC
VBRK EXNUM VBRK EXNUM EIKP Foreign Trade: Export/Import Header Data EXNUM
VBRK EXNUM VBRK MANDT EIKP Foreign Trade: Export/Import Header Data MANDT
VBRK FKART VBRK FKART TVFK Billing: Document Types FKART
VBRK FKART VBRK MANDT TVFK Billing: Document Types MANDT
VBRK FKART_RL VBRK MANDT TVFK Billing: Document Types MANDT
VBRK FKART_RL VBRK FKART_RL TVFK Billing: Document Types FKART
VBRK HITYP_PR VBRK MANDT THIT Customer Hierarchy Types MANDT
VBRK HITYP_PR VBRK HITYP_PR THIT Customer Hierarchy Types HITYP
VBRK INCO1 VBRK MANDT TINC Customers: Incoterms MANDT
VBRK INCO1 VBRK INCO1 TINC Customers: Incoterms INCO1
VBRK J_1AFITP VBRK J_1AFITP J_1AFITP Tax Types J_1AFITP
VBRK J_1AFITP SY MANDT J_1AFITP Tax Types MANDT
VBRK J_1AFITP 'D' J_1AFITP Tax Types KOART
VBRK KALSM T681Z KAPPL T683 Pricing procedures KAPPL
VBRK KALSM VBRK KALSM T683 Pricing procedures KALSM
VBRK KALSM VBRK MANDT T683 Pricing procedures MANDT
VBRK KALSM T681Z KVEWE T683 Pricing procedures KVEWE
VBRK KDGRP VBRK MANDT T151 Customers: Customer Groups MANDT
VBRK KDGRP VBRK KDGRP T151 Customers: Customer Groups KDGRP
VBRK KKBER VBRK MANDT T014 Credit control areas MANDT
VBRK KKBER VBRK KKBER T014 Credit control areas KKBER
VBRK KNKLI VBRK MANDT KNA1 General Data in Customer Master MANDT
VBRK KNKLI VBRK KNKLI KNA1 General Data in Customer Master KUNNR
VBRK KNUMA VBRK KNUMA KONA Agreements KNUMA
VBRK KNUMA VBRK MANDT KONA Agreements MANDT
VBRK KONDA VBRK MANDT T188 Conditions: Groups for Customer Classifications MANDT
VBRK KONDA VBRK KONDA T188 Conditions: Groups for Customer Classifications KONDA
VBRK KTGRD VBRK MANDT TVKT Customers: Account Assignment Groups MANDT
VBRK KTGRD VBRK KTGRD TVKT Customers: Account Assignment Groups KTGRD
VBRK KUNAG VBRK MANDT KNA1 General Data in Customer Master MANDT
VBRK KUNAG VBRK KUNAG KNA1 General Data in Customer Master KUNNR
VBRK KUNRG VBRK MANDT KNA1 General Data in Customer Master MANDT
VBRK KUNRG VBRK KUNRG KNA1 General Data in Customer Master KUNNR
VBRK KURST VBRK MANDT TCURV Exchange rate types for currency translation MANDT
VBRK KURST VBRK KURST TCURV Exchange rate types for currency translation KURST
VBRK LAND1 VBRK LAND1 T005 Countries LAND1
VBRK LAND1 VBRK MANDT T005 Countries MANDT
VBRK LCNUM VBRK MANDT AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data MANDT
VBRK LCNUM VBRK LCNUM AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data LCNUM
VBRK MABER VBRK MABER T047M Dunning areas MABER
VBRK MABER VBRK MANDT T047M Dunning areas MANDT
VBRK MABER VBRK BUKRS T047M Dunning areas BUKRS
VBRK MANDT VBRK MANDT T000 Clients MANDT
VBRK MANSP VBRK MANDT T040S Blocking reasons for dunning notices MANDT
VBRK MANSP VBRK MANSP T040S Blocking reasons for dunning notices MANSP
VBRK MSCHL VBRK MANDT T040 Dunning keys MANDT
VBRK MSCHL VBRK MSCHL T040 Dunning keys MSCHL
VBRK OINETCYC VBRK MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
VBRK OINETCYC VBRK OINETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
VBRK PLTYP VBRK MANDT T189 Conditions: Price List Categories MANDT
VBRK PLTYP VBRK PLTYP T189 Conditions: Price List Categories PLTYP
VBRK REGIO VBRK REGIO T005S Taxes: Region (Province) Key BLAND
VBRK REGIO VBRK MANDT T005S Taxes: Region (Province) Key MANDT
VBRK REGIO VBRK LAND1 T005S Taxes: Region (Province) Key LAND1
VBRK RPLNR VBRK MANDT FPLA Billing Plan MANDT
VBRK RPLNR VBRK RPLNR FPLA Billing Plan FPLNR
VBRK SFAKN VBRK MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBRK SFAKN VBRK SFAKN VBUK Sales Document: Header Status and Administrative Data VBELN
VBRK SPART VBRK MANDT TSPA Organizational Unit: Sales Divisions MANDT
VBRK SPART VBRK SPART TSPA Organizational Unit: Sales Divisions SPART
VBRK STGRD VBRK MANDT T041C Reasons for Reverse Posting MANDT
VBRK STGRD VBRK STGRD T041C Reasons for Reverse Posting STGRD
VBRK STWAE VBRK MANDT TCURC Currency Codes MANDT
VBRK STWAE VBRK STWAE TCURC Currency Codes WAERS
VBRK VBELN VBRK MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBRK VBELN VBRK VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBRK VBUND VBRK MANDT T880 Global Company Data (for KONS Ledger) MANDT
VBRK VBUND VBRK VBUND T880 Global Company Data (for KONS Ledger) RCOMP
VBRK VKORG VBRK MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBRK VKORG VBRK VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBRK VSBED VBRK MANDT TVSB Shipping Conditions MANDT
VBRK VSBED VBRK VSBED TVSB Shipping Conditions VSBED
VBRK VTWEG VBRK MANDT TVTW Organizational Unit: Distribution Channels MANDT
VBRK VTWEG VBRK VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
VBRK WAERK VBRK MANDT TCURC Currency Codes MANDT
VBRK WAERK VBRK WAERK TCURC Currency Codes WAERS
VBRK ZLSCH VBRK MANDT T042Z Payment Methods for Automatic Payment MANDT
VBRK ZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
VBRK ZLSCH VBRK ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH