SAP table reference

VBRK

Billing Document: Header Data

Explore another table

Enter a table code or keyword to continue exploring.

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: MANDT,VBELN.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

VBRK fields.

155 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key VBELN Billing DocumentCHAR100 VBELN_VF
FKART Billing TypeCHAR40 TVFK FKART
FKTYP Billing CategoryCHAR10 FKTYP
VBTYP SD Document CategoryCHAR40 VBTYPL
WAERK SD Document CurrencyCUKY50 TCURC WAERK
VKORG Sales OrganizationCHAR40 TVKO VKORG
VTWEG Distribution ChannelCHAR20 TVTW VTWEG
KALSM Pricing Procedure in PricingCHAR60 T683 KALSMASD
KNUMV Number of the Document ConditionCHAR100 KNUMV
VSBED Shipping ConditionsCHAR20 TVSB VSBED
FKDAT Billing DateDATS80 FKDAT
BELNR Document Number of an Accounting DocumentCHAR100 BELNR_D
GJAHR Fiscal YearNUMC40 GJAHR
POPER Posting periodNUMC30 POPER
KONDA Customer Price GroupCHAR20 T188 KONDA
KDGRP Customer GroupCHAR20 T151 KDGRP
BZIRK Sales DistrictCHAR60 T171 BZIRK
PLTYP Price List TypeCHAR20 T189 PLTYP
INCO1 Incoterms (Part 1)CHAR30 TINC INCO1
INCO2 Incoterms (Part 2)CHAR280 INCO2
RFBSK Status for Transfer to AccountingCHAR10 RFBSK
MRNKZ Manual Invoice MaintenanceCHAR10 MRNKZ
KURRF Exchange Rate for Postings to Financial AccountingDEC95 KURRF
CPKUR Exchange Rate SettingCHAR10 CPKUR
VALTG Additional Value DaysNUMC20 VALTG
VALDT Fixed Value DateDATS80 VALDT
ZTERM Terms of payment keyCHAR40 DZTERM
ZLSCH Payment MethodCHAR10 T042Z SCHZW_BSEG
KTGRD Account Assignment Group for this CustomerCHAR20 TVKT KTGRD
LAND1 Destination Country/RegionCHAR30 T005 LLAND
REGIO Region (State, Province, County)CHAR30 T005S REGIO
COUNC County CodeCHAR30 T005E COUNC
CITYC City CodeCHAR40 T005G CITYC
BUKRS Company CodeCHAR40 T001 BUKRS
TAXK1 Tax Classification 1 for CustomerCHAR10 TAXK1
TAXK2 Tax Classification 2 for CustomerCHAR10 TAXK2
TAXK3 Tax Classification 3 for CustomerCHAR10 TAXK3
TAXK4 Tax Classification 4 for CustomerCHAR10 TAXK4
TAXK5 Tax Classification 5 for CustomerCHAR10 TAXK5
TAXK6 Tax Classification 6 for CustomerCHAR10 TAXK6
TAXK7 Tax Classification 7 for CustomerCHAR10 TAXK7
TAXK8 Tax Classification 8 for CustomerCHAR10 TAXK8
TAXK9 Tax Classification 9 for CustomerCHAR10 TAXK9
NETWR Net Value in Document CurrencyCURR152 NETWR
ZUKRI Combination criteria in the billing documentCHAR400 DZUKRI
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
ERZET Entry timeTIMS60 ERZET
ERDAT Date on which the record was createdDATS80 ERDAT
STAFO Update Group for statistics updateCHAR60 STAFO
KUNRG PayerCHAR100 KNA1 KUNRG
KUNAG Sold-to PartyCHAR100 KNA1 KUNAG
MABER Dunning AreaCHAR20 T047M MABER
STWAE Statistics CurrencyCUKY50 TCURC STWAE
STCEG VAT Registration NumberCHAR200 STCEG
AEDAT Last Changed OnDATS80 AEDAT
SFAKN Number of canceled billing documentCHAR100 VBRK SFAKN
KNUMA Agreement (various conditions grouped together)CHAR100 KONA KNUMA
FKART_RL Invoice List TypeCHAR40 TVFK FKART_RL
FKDAT_RL Billing date for the invoice listDATS80 FKDAT_RL
KURST Exchange Rate TypeCHAR40 TCURV KURST
MSCHL Dunning KeyCHAR10 T040 MSCHL
MANSP Dunning BlockCHAR10 T040S MANSP
SPART DivisionCHAR20 TSPA SPART
KKBER Credit control areaCHAR40 T014 KKBER
KNKLI Customer's Account Number with Credit Limit ReferenceCHAR100 KNA1 KNKLI
CMWAE Currency key of credit control areaCUKY50 TCURC WAERS_CM
CMKUF Credit data exchange rate at billing document rateDEC95 CMKUF
HITYP_PR Hierarchy type for pricingCHAR10 THIT HITYP_PR
BSTNK_VF Customer ReferenceCHAR350 BSTKD
VBUND Company ID of Trading PartnerCHAR60 T880 RASSC
FKART_AB Accrual Billing TypeCHAR40 FKART_AB
KAPPL ApplicationCHAR20 KAPPL
LANDTX Tax Departure Country/RegionCHAR30 LANDTX
STCEG_H Origin of Sales Tax ID NumberCHAR10 STCEG_H
STCEG_L Country/Region of Sales Tax ID NumberCHAR30 STCEG_L
XBLNR Reference Document NumberCHAR160 XBLNR_V1
ZUONR Assignment NumberCHAR180 ORDNR_V
MWSBK Tax Amount in Document CurrencyCURR132 MWSBP
LOGSYS Logical systemCHAR100 LOGSYS
FKSTO Billing document is canceledCHAR10 FKSTO
XEGDR Indicator: Triangular Deal Within the EUCHAR10 XEGDR
RPLNR Number of payment card plan typeCHAR100 FPLA RPLNR
J_1AFITP Tax typeCHAR20 J_1AFITP J_1AFITP_D
KURRF_DAT Translation dateDATS80 WWERT_D
KIDNO Payment ReferenceCHAR300 KIDNO
BVTYP Partner bank typeCHAR40 BVTYP
NUMPG Number of pages of invoiceNUMC30 J_1ANOPG
BUPLA Business PlaceCHAR40 PBUSINESSPLACE BUPLA
VKONT Contract Account NumberCHAR120 CORR_VKONT_KK
FKK_DOCSTAT Additional Status Transfer to Fin. Accounting (Res. RFBSK)CHAR10 DOCSTAT_KK
NRZAS Character Field of Length 12CHAR120 CHAR12
SPE_BILLING_IND EWM Billing IndicatorCHAR10 /SPE/DE_BILLING_IND
VTREF Reference Specifications from ContractCHAR200 CORR_VTREF_KK
FK_SOURCE_SYS Source SystemCHAR100 FK_SOURCE_SYS
FKTYP_CRM Billing category in SAP S/4HANA for customer managementCHAR10 FKTYP_CRM
STGRD Reason for Reversal or Inverse PostingCHAR20 T041C STGRD
CHANGED_ON UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)DEC217 TIMESTAMPL
EXPKZ Export indicatorCHAR10 EXPKZ
EXNUM Number of foreign trade data in MM and SD documentsCHAR100 EXNUM
AKWAE Currency key for letter-of-credit procg in foreign tradeCUKY50 AKWAE
AKKUR Exchange rate for letter-of-credit procg in foreign tradeDEC95 AKKUR
LCNUM Financial doc. processing: Internal financial doc. numberCHAR100 LCNUM
_DATAAGING Data Filter Value for Data AgingDATS80 DATA_TEMPERATURE
BUCHK Posting Status of Billing DocumentCHAR10 BUCHK
GBSTK Overall Processing Status (Header/All Items)CHAR10 GBSTK
RELIK Invoice list status of billing documentCHAR10 RELIK
UVALS Incompletion Status (All Items)CHAR10 UVALL_SU
UVPRS Pricing Incompletion Status (All Items)CHAR10 UVPRS_UK
CLRST Clearing Status of Billing DocumentCHAR10 CLRST
FKSAK Order-Related Billing Status (All Items)CHAR10 FKSAK
FKARA Proposed billing type for an order-related billing documentCHAR40 FKARA
VF_STATUS SD Billing StatusCHAR10 VF_STATUS
VF_TODO Billing Issue TypeCHAR10 VF_TODO
BDR_STATUS Billing Document Request StatusCHAR10 BDR_STATUS
BDR_REF Source document on which a billing document request is basedCHAR100 BDR_REF
BDR_REF_LOGSYS Logical system containing source document of BDRCHAR100 BDR_REF_LOGSYS
BDR_REF_VBTYP SD document category of BDR source documentCHAR40 BDR_REF_VBTYP
PBD_STATUS Preliminary Billing Document StatusCHAR10 PBD_STATUS
ABSTK Rejection Status (All Items)CHAR10 ABSTK
DRAFT IsDraft IndicatorCHAR10 VF_DRAFT_INDICATOR
ACTIVEDOCUMENT Sales and Distribution Document NumberCHAR100 VBELN
GRWCU Currency of statistical values for foreign tradeCUKY50 GRWCU
BLART Document TypeCHAR20 BLART
INTRA_REL Relevant for Intrastat ReportingCHAR10 INTRA_REL
INTRA_EXCL Exclude from Intrastat ReportingCHAR10 INTRA_EXCL
ACCRREL Is relevant for accrualCHAR10 ISACCRUALRELEVANT
PSPSD Payment Split Predecessor Sales DocumentCHAR100 PSPSD
APM_APPROVAL_STATUS Document Approval StatusCHAR10 SD_APM_APPROVAL_STATUS
APM_APPROVAL_REASON Approval Request Reason IDCHAR40 SD_APM_APPROVAL_REASON
SRCEDOC_EXT_COMM_SYST_TYPE External Communication System Type of Source DocumentCHAR20 SRCE_DOC_EXT_COMM_SYST_TYPE
ICO_LIFNR Supplier Number of PlantCHAR100 LIFNR_WK
J_1TPBUPL Branch CodeCHAR50 BCODE
INCOV Incoterms VersionCHAR40 TINCV INCOV
INCO2_L Incoterms Location 1CHAR700 INCO2_L
INCO3_L Incoterms Location 2CHAR700 INCO3_L
SDM_VERSION SDM: Version field for VBRKCHAR20 SDBIL_SDM_VERSION_VBRK
DUMMY_BILLINGDOC_INCL_EEW_PS Dummy function in length 1CHAR10 DUMMY
GLO_LOG_REF1_HD Business Process Indicator for PolandCHAR250 GLO_LOG_REF1_HD
ZAPCGKH Annexing package keyNUMC40 /ILE/TV01 /ILE/TAPCGK
APCGK_EXTENDH Extended key for annexing packageNUMC100 /ILE/TAPCGK_EXT
ZABDATH Annexing base dateDATS80 /ILE/TABDAT
DPC_REL Flag: DPC relevantCHAR10 /SAPPCE/DPC_REL
AD01BASDOC Initial documentCHAR100 AD01BASDOC
AD01FAREG Rule for BillingCHAR10 AD01FAREG
VCHRNMBR Voucher NumberNUMC80 AD04VCHNR
J_3GKBAUL ETM-Relevant IndicatorCHAR10 J_3GKBAUL
J_3GKENIE Indicator for I(nternal) or E(xternal) PostingCHAR10 J_3GKENIE
KUNWE Ship-to PartyCHAR100 * KUNWE
MNDID Unique Reference to Mandate for each PayeeCHAR350 SEPA_MNDID
PAY_TYPE SEPA: Payment TypeCHAR10 SEPA_PAY_TYPE
SEPON SEPA-RelevanceCHAR10 SD_SEPA_FLAG
MNDVG SEPA-RelevanceCHAR10 SD_SEPA_FLAG
SPPAYM Payment Form for Special Payment MethodCHAR20 SPPAYM
SPPORD Sales Order for Special Payment MethodCHAR100 SPPORD
/ Relationships

VBRK relationships.

73 relationships
TableFieldCheck tableDescriptionCheck field
VBRKBUKRST001Company CodesBUKRS
VBRKBUPLAPBUSINESSPLACEGenerated Table for ViewBUKRS
VBRKBUPLAPBUSINESSPLACEGenerated Table for ViewBRANCH
VBRKBZIRKT171Customers: Sales DistrictsMANDT
VBRKBZIRKT171Customers: Sales DistrictsBZIRK
VBRKCITYCT005GCityMANDT
VBRKCITYCT005GCityLAND1
VBRKCITYCT005GCityREGIO
VBRKCITYCT005GCityCITYC
VBRKCMWAETCURCCurrency CodesMANDT
VBRKCMWAETCURCCurrency CodesWAERS
VBRKCOUNCT005ECountyMANDT
VBRKCOUNCT005ECountyLAND1
VBRKCOUNCT005ECountyREGIO
VBRKCOUNCT005ECountyCOUNC
VBRKFKARTTVFKBilling: Document TypesMANDT
VBRKFKARTTVFKBilling: Document TypesFKART
VBRKFKART_RLTVFKBilling: Document TypesMANDT
VBRKFKART_RLTVFKBilling: Document TypesFKART
VBRKHITYP_PRTHITCustomer Hierarchy TypesMANDT
VBRKHITYP_PRTHITCustomer Hierarchy TypesHITYP
VBRKINCO1TINCCustomers: IncotermsINCO1
VBRKINCOVTINCVIncoterms VersionsMANDT
VBRKINCOVTINCVIncoterms VersionsINCOV
VBRKJ_1AFITPJ_1AFITPTax TypesMANDT
VBRKKALSMT683Pricing proceduresKAPPL
VBRKKALSMT683Pricing proceduresKALSM
VBRKKDGRPT151Customers: Customer GroupsMANDT
VBRKKDGRPT151Customers: Customer GroupsKDGRP
VBRKKKBERT014Credit control areasKKBER
VBRKKNKLIKNA1General Data in Customer MasterMANDT
VBRKKNKLIKNA1General Data in Customer MasterKUNNR
VBRKKNUMAKONAAgreementsMANDT
VBRKKNUMAKONAAgreementsKNUMA
VBRKKONDAT188Conditions: Groups for Customer ClassificationsMANDT
VBRKKONDAT188Conditions: Groups for Customer ClassificationsKONDA
VBRKKTGRDTVKTCustomers: Account Assignment GroupsKTGRD
VBRKKUNAGKNA1General Data in Customer MasterMANDT
VBRKKUNAGKNA1General Data in Customer MasterKUNNR
VBRKKUNRGKNA1General Data in Customer MasterMANDT
VBRKKUNRGKNA1General Data in Customer MasterKUNNR
VBRKKURSTTCURVExchange rate types for currency translationMANDT
VBRKKURSTTCURVExchange rate types for currency translationKURST
VBRKLAND1T005CountriesMANDT
VBRKLAND1T005CountriesLAND1
VBRKMABERT047MDunning areasMANDT
VBRKMABERT047MDunning areasBUKRS
VBRKMANDTT000ClientsMANDT
VBRKMSCHLT040Dunning keysMSCHL
VBRKPLTYPT189Conditions: Price List TypesMANDT
VBRKPLTYPT189Conditions: Price List TypesPLTYP
VBRKREGIOT005STaxes: Region (Province) KeyLAND1
VBRKRPLNRFPLABilling PlanFPLNR
VBRKSFAKNVBRKBilling Document: Header DataVBELN
VBRKSPARTTSPAOrganizational Unit: Sales DivisionsMANDT
VBRKSPARTTSPAOrganizational Unit: Sales DivisionsSPART
VBRKSTGRDT041CReasons for Reverse PostingMANDT
VBRKSTGRDT041CReasons for Reverse PostingSTGRD
VBRKSTWAETCURCCurrency CodesMANDT
VBRKSTWAETCURCCurrency CodesWAERS
VBRKVBUNDT880Global Company Data (for KONS Ledger)MANDT
VBRKVBUNDT880Global Company Data (for KONS Ledger)RCOMP
VBRKVKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
VBRKVKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
VBRKVSBEDTVSBShipping ConditionsMANDT
VBRKVSBEDTVSBShipping ConditionsVSBED
VBRKVTWEGTVTWOrganizational Unit: Distribution ChannelsMANDT
VBRKVTWEGTVTWOrganizational Unit: Distribution ChannelsVTWEG
VBRKWAERKTCURCCurrency CodesMANDT
VBRKWAERKTCURCCurrency CodesWAERS
VBRKZLSCHT042ZPayment Methods for Automatic PaymentMANDT
VBRKZLSCHT042ZPayment Methods for Automatic PaymentLAND1
VBRKZLSCHT042ZPayment Methods for Automatic PaymentZLSCH