SAP VBRK Billing Document: Header Data Table

Overview

VBRK is a standard SAP S/4HANA table that stores Billing Document: Header Data data. There are total 156 fields in the VBRK table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VBRK belongs to Billing (SD-BIL) module and is located in the package Application development R/3 invoice (VF).

In addition, following links provide an overview of foreign key relationships, if any, that link VBRK to other SAP tables and standard CDS views available based on VBRK table in S/4HANA 2020.

Techincal Settings of VBRK

Below are technical details of the table VBRK

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VBRK Fields

The following table gives you an overview of the fields available in VBRK

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
VBELNBilling DocumentVBELN_VFCHAR10
FKARTBilling TypeFKARTTVFKCHAR4
FKTYPBilling CategoryFKTYPCHAR1
VBTYPSD Document CategoryVBTYPLCHAR4
WAERKSD document currencyWAERKTCURCCUKY5
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVTWCHAR2
KALSMPricing Procedure in PricingKALSMASDT683CHAR6
KNUMVNumber of the Document ConditionKNUMVCHAR10
VSBEDShipping ConditionsVSBEDTVSBCHAR2
FKDATBilling DateFKDATDATS8
BELNRAccounting Document NumberBELNR_DCHAR10
GJAHRFiscal YearGJAHRNUMC4
POPERPosting periodPOPERNUMC3
KONDACustomer Price GroupKONDAT188CHAR2
KDGRPCustomer GroupKDGRPT151CHAR2
BZIRKSales DistrictBZIRKT171CHAR6
PLTYPPrice List TypePLTYPT189CHAR2
INCO1Incoterms (Part 1)INCO1TINCCHAR3
INCO2Incoterms (Part 2)INCO2CHAR28
RFBSKStatus for Transfer to AccountingRFBSKCHAR1
MRNKZManual Invoice MaintenanceMRNKZCHAR1
KURRFExchange rate for FI postingsKURRFDEC9
CPKURID:Exchange rate setting (no new rate determ.in bill.doc.)CPKURCHAR1
VALTGAdditional Value DaysVALTGNUMC2
VALDTFixed Value DateVALDTDATS8
ZTERMTerms of payment keyDZTERMCHAR4
ZLSCHPayment MethodSCHZW_BSEGT042ZCHAR1
KTGRDAccount Assignment Group for this customerKTGRDTVKTCHAR2
LAND1Destination Country/RegionLLANDT005CHAR3
REGIORegion (State Province County)REGIOT005SCHAR3
COUNCCounty CodeCOUNCT005ECHAR3
CITYCCity CodeCITYCT005GCHAR4
BUKRSCompany CodeBUKRST001CHAR4
TAXK1Tax Classification 1 for CustomerTAXK1CHAR1
TAXK2Tax Classification 2 for CustomerTAXK2CHAR1
TAXK3Tax classification 3 for customerTAXK3CHAR1
TAXK4Tax Classification 4 CustomerTAXK4CHAR1
TAXK5Tax Classification 5 for CustomerTAXK5CHAR1
TAXK6Tax Classification 6 for CustomerTAXK6CHAR1
TAXK7Tax Classification 7 for CustomerTAXK7CHAR1
TAXK8Tax Classification 8 for CustomerTAXK8CHAR1
TAXK9Tax Classification 9 for CustomerTAXK9CHAR1
NETWRNet Value in Document CurrencyNETWRCURR15
ZUKRICombination criteria in the billing documentDZUKRICHAR40
ERNAMName of Person who Created the ObjectERNAMCHAR12
ERZETEntry timeERZETTIMS6
ERDATDate on which the record was createdERDATDATS8
STAFOUpdate Group for statistics updateSTAFOCHAR6
KUNRGPayerKUNRGKNA1CHAR10
KUNAGSold-To PartyKUNAGKNA1CHAR10
MABERDunning AreaMABERT047MCHAR2
STWAEStatistics CurrencySTWAETCURCCUKY5
STCEGVAT Registration NumberSTCEGCHAR20
AEDATDate of Last ChangeAEDATDATS8
SFAKNNumber of canceled billing documentSFAKNVBRKCHAR10
KNUMAAgreement (various conditions grouped together)KNUMAKONACHAR10
FKART_RLInvoice List TypeFKART_RLTVFKCHAR4
FKDAT_RLBilling date for the invoice listFKDAT_RLDATS8
KURSTExchange Rate TypeKURSTTCURVCHAR4
MSCHLDunning KeyMSCHLT040CHAR1
MANSPDunning BlockMANSPT040SCHAR1
SPARTDivisionSPARTTSPACHAR2
KKBERCredit control areaKKBERT014CHAR4
KNKLICustomer's Account Number with Credit Limit ReferenceKNKLIKNA1CHAR10
CMWAECurrency key of credit control areaWAERS_CMTCURCCUKY5
CMKUFCredit data exchange rate at billing document rateCMKUFDEC9
HITYP_PRHierarchy type for pricingHITYP_PRTHITCHAR1
BSTNK_VFCustomer ReferenceBSTKDCHAR35
VBUNDCompany ID of Trading PartnerRASSCT880CHAR6
FKART_ABAccrual Billing TypeFKART_ABCHAR4
KAPPLApplicationKAPPLCHAR2
LANDTXTax Departure CountryLANDTXCHAR3
STCEG_HOrigin of Sales Tax ID NumberSTCEG_HCHAR1
STCEG_LCountry of Sales Tax ID NumberSTCEG_LCHAR3
XBLNRReference Document NumberXBLNR_V1CHAR16
ZUONRAssignment numberORDNR_VCHAR18
MWSBKTax amount in document currencyMWSBPCURR13
LOGSYSLogical systemLOGSYSCHAR10
FKSTOBilling document is canceledFKSTOCHAR1
XEGDRIndicator: Triangular Deal Within the EUXEGDRCHAR1
RPLNRNumber of payment card plan typeRPLNRFPLACHAR10
J_1AFITPTax typeJ_1AFITP_DJ_1AFITPCHAR2
KURRF_DATTranslation dateWWERT_DDATS8
KIDNOPayment ReferenceKIDNOCHAR30
BVTYPPartner bank typeBVTYPCHAR4
NUMPGNumber of pages of invoiceJ_1ANOPGNUMC3
BUPLABusiness PlaceBUPLAJ_1BBRANCHCHAR4
VKONTContract Account NumberCORR_VKONT_KKCHAR12
FKK_DOCSTATAdditional Status Transfer to Fin. Accounting (Res. RFBSK)DOCSTAT_KKCHAR1
NRZASCharacter Field of Length 12CHAR12CHAR12
SPE_BILLING_INDEWM Billing Indicator/SPE/DE_BILLING_INDCHAR1
VTREFReference Specifications from ContractCORR_VTREF_KKCHAR20
FK_SOURCE_SYSSource SystemFK_SOURCE_SYSCHAR10
FKTYP_CRMBilling category in SAP S/4HANA for customer managementFKTYP_CRMCHAR1
STGRDReason for ReversalSTGRDT041CCHAR2
CHANGED_ONUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21
EXPKZExport indicatorEXPKZCHAR1
EXNUMNumber of foreign trade data in MM and SD documentsEXNUMCHAR10
AKWAECurrency key for letter-of-credit procg in foreign tradeAKWAECUKY5
AKKURExchange rate for letter-of-credit procg in foreign tradeAKKURDEC9
LCNUMFinancial doc. processing: Internal financial doc. numberLCNUMCHAR10
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8
BUCHKPosting Status of Billing DocumentBUCHKCHAR1
GBSTKOverall Processing Status (Header/All Items)GBSTKCHAR1
RELIKInvoice list status of billing documentRELIKCHAR1
UVALSIncompletion Status (All Items)UVALL_SUCHAR1
UVPRSPricing Incompletion Status (All Items)UVPRS_UKCHAR1
CLRSTClearing Status of Billing DocumentCLRSTCHAR1
FKSAKOrder-Related Billing Status (All Items)FKSAKCHAR1
FKARAProposed billing type for an order-related billing documentFKARACHAR4
VF_STATUSSD Billing StatusVF_STATUSCHAR1
VF_TODOSD Billing Document IssueVF_TODOCHAR1
BDR_STATUSBilling Document Request StatusBDR_STATUSCHAR1
BDR_REFSource document on which a billing document request is basedBDR_REFCHAR10
BDR_REF_LOGSYSLogical system containing source document of BDRBDR_REF_LOGSYSCHAR10
BDR_REF_VBTYPSD document category of BDR source documentBDR_REF_VBTYPCHAR4
PBD_STATUSPreliminary Billing Document StatusPBD_STATUSCHAR1
ABSTKRejection Status (All Items)ABSTKCHAR1
DRAFTIsDraft IndicatorVF_DRAFT_INDICATORCHAR1
ACTIVEDOCUMENTSales and Distribution Document NumberVBELNCHAR10
GRWCUCurrency of statistical values for foreign tradeGRWCUCUKY5
BLARTDocument TypeBLARTCHAR2
INTRA_RELRelevant for Intrastat ReportingINTRA_RELCHAR1
INTRA_EXCLExclude from Intrastat ReportingINTRA_EXCLCHAR1
ACCRRELIs relevant for accrualISACCRUALRELEVANTCHAR1
PSPSDPayment Split Predecessor Sales DocumentPSPSDCHAR10
APM_APPROVAL_STATUSDocument Approval StatusSD_APM_APPROVAL_STATUSCHAR1
APM_APPROVAL_REASONApproval Request Reason IDSD_APM_APPROVAL_REASONCHAR4
J_1TPBUPLBranch CodeBCODECHAR5
INCOVIncoterms VersionINCOVTINCVCHAR4
INCO2_LIncoterms Location 1INCO2_LCHAR70
INCO3_LIncoterms Location 2INCO3_LCHAR70
SDM_VERSIONSDM: Version field for VBRKSDBIL_SDM_VERSION_VBRKCHAR2
DUMMY_BILLINGDOC_INCL_EEW_PSDummy function in length 1DUMMYCHAR1
GLO_LOG_REF1_HDCountry Specific Reference 1 in the DocumentGLO_LOG_REF1_HDCHAR25
ZAPCGKHAnnexing package key/ILE/TAPCGK/ILE/TV01NUMC4
APCGK_EXTENDHExtended key for annexing package/ILE/TAPCGK_EXTNUMC10
ZABDATHAnnexing base date/ILE/TABDATDATS8
DPC_RELFlag: DPC relevant/SAPPCE/DPC_RELCHAR1
AD01BASDOCInitial documentAD01BASDOCCHAR10
AD01FAREGRule for BillingAD01FAREGCHAR1
VCHRNMBRVoucher NumberAD04VCHNRNUMC8
J_3GKBAULETM-Relevant IndicatorJ_3GKBAULCHAR1
J_3GKENIEIndicator for I(nternal) or E(xternal) PostingJ_3GKENIECHAR1
KUNWEShip-to partyKUNWE*CHAR10
MNDIDUnique Reference to Mandate for each PayeeSEPA_MNDIDCHAR35
PAY_TYPESEPA: Payment TypeSEPA_PAY_TYPECHAR1
SEPONSEPA-RelevanceSD_SEPA_FLAGCHAR1
MNDVGSEPA-RelevanceSD_SEPA_FLAGCHAR1
SPPAYMPayment Form for Special Payment MethodSPPAYMCHAR2
SPPORDSales Order for Special Payment MethodSPPORDCHAR10
ZCUSMResellerZRESELLER*CHAR10
RESELLERResellerZRESELLER*CHAR10
END_CUSTOMEREnd CustomerZEND_CUSTOMER*CHAR10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBRK

Table NameFieldCardinalityCheck Table
VBRKBUKRS1: CNT001
VBRKBUPLAC: CNJ_1BBRANCH
VBRKBZIRKC: CNT171
VBRKCITYCC: CNT005G
VBRKCMWAEC: CNTCURC
VBRKCOUNCC: CNT005E
VBRKFKART1: CNTVFK
VBRKFKART_RLC: CNTVFK
VBRKHITYP_PRC: CNTHIT
VBRKINCO1C: CNTINC
VBRKINCOV1: CNTINCV
VBRKJ_1AFITP1: CNJ_1AFITP
VBRKKALSM1: CNT683
VBRKKDGRPC: CNT151
VBRKKKBERC: CNT014
VBRKKNKLIC: CNKNA1
VBRKKNUMAC: CNKONA
VBRKKONDAC: CNT188
VBRKKTGRDC: CNTVKT
VBRKKUNAG1: CNKNA1
VBRKKUNRG1: CNKNA1
VBRKKURSTC: CNTCURV
VBRKLAND1C: CNT005
VBRKMABERC: CNT047M
VBRKMANDT1: CNT000
VBRKMANSPC: CNT040S
VBRKMSCHLC: CNT040
VBRKPLTYPC: CNT189
VBRKREGIOC: CNT005S
VBRKRPLNRC: CFPLA
VBRKSFAKN:VBRK
VBRKSPARTC: CNTSPA
VBRKSTGRD1: CNT041C
VBRKSTWAEC: CNTCURC
VBRKVBUNDC: CNT880
VBRKVKORGC: CNTVKO
VBRKVSBEDC: CNTVSB
VBRKVTWEGC: CNTVTW
VBRKWAERK1: CNTCURC
VBRKZAPCGKH:/ILE/TV01
VBRKZLSCHC: CNT042Z

Other References