Follow us on LinkedIn for your next SAP project

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 Possible values
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
VBTYP
SD document category
VBTYP
CHAR
1 0
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
MRNKZ
Manual invoice maintenance
MRNKZ
CHAR
1 0
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
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
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
XEGDR
Indicator: Triangular deal within the EU ?
XEGDR
CHAR
1 0
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
NRZAS
Character Field of Length 12
CHAR12
CHAR
12 0
SPE_BILLING_IND
EWM Billing Indicator
/SPE/DE_BILLING_IND
CHAR
1 0
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
STGRD
Reason for Reversal
STGRD T041C
CHAR
2 0
VBTYP_EXT
Extension of SD Document Category
TDD_VBTYP_EXT
CHAR
4 0
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
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
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
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
SEPON
SEPA-Relevance
SD_SEPA_FLAG
CHAR
1 0
MNDVG
SEPA-Relevance
SD_SEPA_FLAG
CHAR
1 0
SPPAYM
Payment Form for Special Payment Method
SPPAYM
CHAR
2 0
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 MANDT TCURC
Currency Codes
MANDT
VBRK AKWAE VBRK AKWAE TCURC
Currency Codes
WAERS
VBRK BUKRS VBRK BUKRS T001
Company Codes
BUKRS
VBRK BUKRS VBRK MANDT T001
Company Codes
MANDT
VBRK BUPLA VBRK BUPLA J_1BBRANCH
Business Place
BRANCH
VBRK BUPLA VBRK MANDT J_1BBRANCH
Business Place
MANDT
VBRK BUPLA VBRK BUKRS J_1BBRANCH
Business Place
BUKRS
VBRK BZIRK VBRK MANDT T171
Customers: Sales Districts
MANDT
VBRK BZIRK VBRK BZIRK T171
Customers: Sales Districts
BZIRK
VBRK CITYC VBRK CITYC T005G
City
CITYC
VBRK CITYC VBRK MANDT T005G
City
MANDT
VBRK CITYC VBRK LAND1 T005G
City
LAND1
VBRK CITYC VBRK REGIO T005G
City
REGIO
VBRK CMWAE VBRK MANDT TCURC
Currency Codes
MANDT
VBRK CMWAE VBRK CMWAE TCURC
Currency Codes
WAERS
VBRK COUNC VBRK REGIO T005E
County
REGIO
VBRK COUNC VBRK COUNC T005E
County
COUNC
VBRK COUNC VBRK MANDT T005E
County
MANDT
VBRK COUNC VBRK LAND1 T005E
County
LAND1
VBRK EXNUM VBRK MANDT EIKP
Foreign Trade: Export/Import Header Data
MANDT
VBRK EXNUM VBRK EXNUM EIKP
Foreign Trade: Export/Import Header Data
EXNUM
VBRK FKART VBRK MANDT TVFK
Billing: Document Types
MANDT
VBRK FKART VBRK FKART TVFK
Billing: Document Types
FKART
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 SY MANDT J_1AFITP
Tax Types
MANDT
VBRK J_1AFITP 'D' J_1AFITP
Tax Types
KOART
VBRK J_1AFITP VBRK J_1AFITP J_1AFITP
Tax Types
J_1AFITP
VBRK KALSM VBRK MANDT T683
Pricing procedures
MANDT
VBRK KALSM T681Z KVEWE T683
Pricing procedures
KVEWE
VBRK KALSM T681Z KAPPL T683
Pricing procedures
KAPPL
VBRK KALSM VBRK KALSM T683
Pricing procedures
KALSM
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 MANDT KONA
Agreements
MANDT
VBRK KNUMA VBRK KNUMA KONA
Agreements
KNUMA
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 KURST TCURV
Exchange rate types for currency translation
KURST
VBRK KURST VBRK MANDT TCURV
Exchange rate types for currency translation
MANDT
VBRK LAND1 VBRK MANDT T005
Countries
MANDT
VBRK LAND1 VBRK LAND1 T005
Countries
LAND1
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 MANDT T047M
Dunning areas
MANDT
VBRK MABER VBRK BUKRS T047M
Dunning areas
BUKRS
VBRK MABER VBRK MABER T047M
Dunning areas
MABER
VBRK MANDT VBRK MANDT T000
Clients
MANDT
VBRK MANSP VBRK MANSP T040S
Blocking reasons for dunning notices
MANSP
VBRK MANSP VBRK MANDT T040S
Blocking reasons for dunning notices
MANDT
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 PLTYP T189
Conditions: Price List Categories
PLTYP
VBRK PLTYP VBRK MANDT T189
Conditions: Price List Categories
MANDT
VBRK REGIO VBRK MANDT T005S
Taxes: Region (Province) Key
MANDT
VBRK REGIO VBRK LAND1 T005S
Taxes: Region (Province) Key
LAND1
VBRK REGIO VBRK REGIO T005S
Taxes: Region (Province) Key
BLAND
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 VSBED TVSB
Shipping Conditions
VSBED
VBRK VSBED VBRK MANDT TVSB
Shipping Conditions
MANDT
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 ZLSCH T042Z
Payment Methods for Automatic Payment
ZLSCH
VBRK ZLSCH VBRK MANDT T042Z
Payment Methods for Automatic Payment
MANDT
VBRK ZLSCH T001 LAND1 T042Z
Payment Methods for Automatic Payment
LAND1