SAP VBAK Sales Document: Header Data Table

Overview

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

The table VBAK belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).

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

Techincal Settings of VBAK

Below are technical details of the table VBAK

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

List of VBAK Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
VBELNSales DocumentVBELN_VACHAR10
ERDATDate on which the record was createdERDATDATS8
ERZETEntry timeERZETTIMS6
ERNAMName of Person who Created the ObjectERNAMCHAR12
ANGDTQuotation/Inquiry is Valid FromANGDT_VDATS8
BNDDTDate Until Which Bid/Quotation is Binding (Valid-To Date)BNDDTDATS8
AUDATDocument Date (Date Received/Sent)AUDATDATS8
VBTYPSD Document CategoryVBTYPLCHAR4
TRVOGTransaction GroupTRVOGCHAR1
AUARTSales Document TypeAUARTTVAKCHAR4
AUGRUOrder Reason (Reason for the Business Transaction)AUGRUTVAUCHAR3
GWLDTGuarantee dateGWLDTDATS8
SUBMICollective Number (SD)SUBMI_SDCHAR10
LIFSKDelivery Block (Document Header)LIFSKTVLSCHAR2
FAKSKBilling Block in SD DocumentFAKSKTVFSCHAR2
NETWRNet Value of the Sales Order in Document CurrencyNETWR_AKCURR15
WAERKSD document currencyWAERKTCURCCUKY5
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVKOVCHAR2
SPARTDivisionSPARTTVTACHAR2
VKGRPSales groupVKGRPTVBVKCHAR3
VKBURSales officeVKBURTVKBZCHAR4
GSBERBusiness AreaGSBERTGSBCHAR4
GSKSTBusiness Area from Cost CenterGSKSTTGSBCHAR4
GUEBGValid-From Date (Outline Agreements Product Proposals)GUEBGDATS8
GUEENValid-To Date (Outline Agreements Product Proposals)GUEENDATS8
KNUMVNumber of the Document ConditionKNUMVCHAR10
VDATURequested Delivery DateEDATU_VBAKDATS8
DELIVERY_DATE_TYPE_RULEDelivery Date RuleSD_DELIVERY_DATE_TYPE_RULECHAR1
VPRGRProposed date typePRGRS_VBAKCHAR1
AUTLFComplete Delivery Defined for Each Sales Order?AUTLFCHAR1
VBKLAOriginal system with release and transaction controlVBKLACHAR9
VBKLTSD document indicatorVBKLTCHAR1
KALSMPricing Procedure in PricingKALSMASDT683CHAR6
VSBEDShipping ConditionsVSBEDTVSBCHAR2
FKARAProposed billing type for an order-related billing documentFKARATVFKCHAR4
AWAHRSales probabilityAWAHR_AKNUMC3
KTEXTSearch term for product proposalKTEXT_VCHAR40
BSTNKCustomer ReferenceBSTNKCHAR20
BSARKCustomer Purchase Order TypeBSARKT176CHAR4
BSTDKCustomer Reference DateBSTDKDATS8
BSTZDPurchase order number supplementBSTZDCHAR4
IHREZYour ReferenceIHREZCHAR12
BNAMEName of ordererBNAME_VCHAR35
TELF1Telephone NumberTELF1_VPCHAR16
MAHZANumber of Contacts from the CustomerMAHZADEC3
MAHDTLast Customer Contact DateMAHDTDATS8
KUNNRSold-To PartyKUNAGKNA1CHAR10
KOSTLCost CenterKOSTLCHAR10
STAFOUpdate Group for statistics updateSTAFOCHAR6
STWAEStatistics CurrencySTWAETCURCCUKY5
AEDATDate of Last ChangeAEDATDATS8
KVGR1Customer group 1KVGR1TVV1CHAR3
KVGR2Customer group 2KVGR2TVV2CHAR3
KVGR3Customer group 3KVGR3TVV3CHAR3
KVGR4Customer group 4KVGR4TVV4CHAR3
KVGR5Customer group 5KVGR5TVV5CHAR3
KNUMAAgreement (various conditions grouped together)KNUMAKONACHAR10
KOKRSControlling AreaKOKRSTKA01CHAR4
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPRPSNUMC8
KURSTExchange Rate TypeKURSTTCURVCHAR4
KKBERCredit control areaKKBERT014CHAR4
KNKLICustomer's Account Number with Credit Limit ReferenceKNKLIKNA1CHAR10
GRUPPCustomer Credit GroupGRUPP_CMCHAR4
SBGRPCredit Representative Group for Credit ManagementSBGRP_CMT024BCHAR3
CTLPCCredit Management: Risk CategoryCTLPC_CMT691ACHAR3
CMWAECurrency key of credit control areaWAERS_CMTCURCCUKY5
CMFRERelease date of the document determined by credit managementCMFREDATS8
CMNUPDate of Next Credit Check of DocumentCMNUPDATS8
CMNGVNext dateCMNGVDATS8
AMTBLReleased credit value of the documentAMTBL_CMCURR15
HITYP_PRHierarchy type for pricingHITYP_PRTHITCHAR1
ABRVWUsage IndicatorABRVWTVLVCHAR3
ABDISMRP for delivery schedule typesABDISCHAR1
VGBELDocument number of the reference documentVGBELCHAR10
OBJNRObject Number at Header LevelOBJKOONR00CHAR22
BUKRS_VFCompany Code to Be BilledBUKRS_VFT001CHAR4
TAXK1Alternative Tax ClassificationTAXK1_AKCHAR1
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
XBLNRReference Document NumberXBLNR_V1CHAR16
ZUONRAssignment numberORDNR_VCHAR18
VGTYPDocument Category of Preceding SD DocumentVBTYPL_VCHAR4
KALSM_CHSearch procedure for batch determinationKALSMA_CHT683CHAR6
AGRZRAccrual period for order-related billing docs.to be accruedAGRZRNUMC2
AUFNROrder NumberAUFNRAUFKCHAR12
QMNUMNotification NumberQMNUMQMELCHAR12
VBELN_GRPMaster Contract NumberVBELN_GRPCHAR10
SCHEME_GRPReferencing requirement: ProcedureSCHEME_GRPTVGRPSCHAR4
ABRUF_PARTCheck partner authorizationsABRUF_PARTCHAR1
ABHODPick-Up DateABHODDATS8
ABHOVPick-Up TimeABHOZTIMS6
ABHOBPick-Up TimeABHOZTIMS6
RPLNRNumber of payment card plan typeRPLNRFPLACHAR10
VZEITProposed schedule line time (local with ref. to sales org.)EZEIT_VBAKTIMS6
STCEG_LTax Destination CountryLAND1TXT005CHAR3
LANDTXTax Departure CountryLANDTXT005CHAR3
XEGDRIndicator: Triangular Deal Within the EUXEGDRCHAR1
ENQUEUE_GRPBlock master contr. until all lower level contracts updatedENQUEUE_GRPCHAR1
DAT_FZAUCml delivery order qty dateDAT_FZAUDATS8
FMBDATMaterial Staging/Availability DateMBDATDATS8
VSNMR_VSales document version numberVSNMR_VCHAR12
HANDLEInternational unique key for VBAK-VBELNTSEGGUID_VBAKCHAR22
PROLIDangerous Goods Management Profile in SD DocumentsADGE_PROLITDGC5CHAR3
CONT_DGIndicator: Document contains dangerous goodsADGE_NCDGCHAR1
CRM_GUIDCharacter field length 70CHAR70CHAR70
UPD_TMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21
MSR_IDProcess Identification NumberMSR_PROCESS_IDCHAR10
OIPBLBusiness location identifier (IS-Oil MRN)OIF_PBLNRCHAR10
LAST_CHANGED_BY_USERUser Who Last Changed the Business DocumentLAST_CHANGED_BY_USERCHAR12
HANDOVERLOCLocation for a physical handover of goodsHANDOVER_LOCCHAR10
EXT_BUS_SYST_IDExternal Business System IDSD_EXT_BUS_SYST_IDCHAR60
EXT_REF_DOC_IDExternal Document IDSD_EXT_REF_DOC_IDCHAR40
EXT_REV_TMSTMPTimestamp for Revision of External CallsEXT_REV_TMSTMPDEC21
APM_APPROVAL_STATUSDocument Approval StatusSD_APM_APPROVAL_STATUSCHAR1
APM_APPROVAL_REASONApproval Request Reason IDSD_APM_APPROVAL_REASONSDAPMAPRRCHAR4
APM_REJECTION_REASONID of Reason for Rejection of Approval RequestSD_APM_REJECTION_REASONSDAPMREJRCHAR4
SOLUTION_ORDER_IDSolution OrderCRMS4_SOLO_OBJECT_IDCHAR10
EXT_COMM_SYST_TYPEType of communication systemTDD_COMM_SYST_TYPECHAR2
RETRO_PURCHDOC_CREATIONCreate Purchasing Document RetroactivelyEDI_RETRO_PURCHDOC_CREATIONCHAR1
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8
ABSTKRejection Status (All Items)ABSTKCHAR1
BESTKDelivery Confirmation Status (All Items)BESTKCHAR1
CMPSCStatus of Credit Check Against Maximum Document ValueCMPSCCHAR1
CMPSDStatus of Credit Check Against Terms of PaymentCMPSDCHAR1
CMPSIStatus of Credit Check Against Financial DocumentCMPSICHAR1
CMPSJStatus of Credit Check Against Export Credit InsuranceCMPSJCHAR1
CMPSKStatus of Credit Check Against Payment Card AuthorizationCMPSKCHAR1
CMPS_CMStatus of Credit Check SAP Credit ManagementCMPS_CMCHAR1
CMPS_TEStatus of Technical Error SAP Credit ManagementCMPS_TECHAR1
CMGSTOverall Status of Credit ChecksCMGSTCHAR1
COSTAConfirmation Status for ALECOSTA_DCHAR1
DCSTKDelay Status (All Items)DCSTKCHAR1
FKSAKOrder-Related Billing Status (All Items)FKSAKCHAR1
FMSTKStatus Funds ManagementFMSTKCHAR1
FSSTKBilling Block Status (All Items)FSSTKCHAR1
GBSTKOverall Processing Status (Header/All Items)GBSTKCHAR1
LFGSKOverall Delivery Status (All Items)LKGSKCHAR1
LFSTKDelivery Status (All Items)LFSTKCHAR1
LSSTKOverall Delivery Block Status (All Items)LSSTK_GCHAR1
MANEKManual Completion of ContractMANEKCHAR1
RFGSKOverall Reference Status (All Items)RFGSKCHAR1
RFSTKReference Status (All Items)RFSTKCHAR1
SPSTGOverall Block Status (Header)SPSTGCHAR1
TRSTATransportation Planning Status (Header)TRSTACHAR1
UVALLIncompletion Status (Header)UVALL_UKCHAR1
UVALSIncompletion Status (All Items)UVALL_SUCHAR1
UVFAKBilling Incompletion Status (Header)UVFAK_UKCHAR1
UVFASBilling Incompletion Status (All Items)UVFAK_SUCHAR1
UVPRSPricing Incompletion Status (All Items)UVPRS_UKCHAR1
UVVLKDelivery Incompletion Status (Header)UVVLK_UKCHAR1
UVVLSDelivery Incompletion Status (All Items)UVVLS_SUCHAR1
UVK01Customer reserves 1: Header statusUVK01CHAR1
UVK02Customer reserves 2: Header statusUVK02CHAR1
UVK03Customer reserves 3: Header statusUVK03CHAR1
UVK04Custmer reserves 4: Header statusUVK04CHAR1
UVK05Customer reserves 5: Header statusUVK05CHAR1
UVS01Customer reserves 1: Sum of all itemsUVS01CHAR1
UVS02Customer reserves 2: Sum of all itemsUVS02CHAR1
UVS03Customer reserves 3: Sum of all itemsUVS03CHAR1
UVS04Customer reserves 4: Sum of all itemsUVS04CHAR1
UVS05Customer reserves 5: Sum of all itemsUVS05CHAR1
WBSTKGoods Movement Status (All Items)WBSTKCHAR1
TOTAL_EMCSTEmbargo Status (All Items)TDD_TOTAL_EMCSTCHAR1
TOTAL_SLCSTWatch List Screening Status (All Items)TDD_TOTAL_SLCSTCHAR1
TOTAL_LCCSTLegal Control StatusTDD_TOTAL_LCCSTCHAR1
TOTAL_PCSTAProduct Marketability Status (All Items)TDD_TOTAL_PCSTACHAR1
TOTAL_DGSTADangerous Goods Status (All Items)TDD_TOTAL_DGSTACHAR1
TOTAL_SDSSTASafety Data Sheet Status (All Items)TDD_TOTAL_SDSSTACHAR1
DP_CLEAR_STA_HDRDown Payment StatusDP_CLEAR_STACHAR1
B2B_MSG_PROCESSING_STATUSB2B Message Processing StatusTDD_B2B_MSG_PROCESSING_STATUSCHAR1
SDM_VERSIONSDM: Version field for VBAKSD_SDM_VERSION_VBAKCHAR2
DUMMY_SALESDOC_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
AD01FAREGRule for BillingAD01FAREGCHAR1
AD01BASDOCInitial documentAD01BASDOCCHAR10
LASTVCHRLast voucher numberAD04LVCHNRNUMC8
PSM_BUDATPosting Date in the DocumentPSM_BUDATDATS8
FSH_KVGR6Customer Group 6FSH_KVGR6FSH_TVV6CHAR3
FSH_KVGR7Customer Group 7FSH_KVGR7FSH_TVV7CHAR3
FSH_KVGR8Customer Group 8FSH_KVGR8FSH_TVV8CHAR3
FSH_KVGR9Customer Group 9FSH_KVGR9FSH_TVV9CHAR3
FSH_KVGR10Customer Group 10FSH_KVGR10FSH_TVV10CHAR3
FSH_REREGRelease RuleARUN_REREGARUN_RELEASECHAR4
FSH_CQ_CHECKRequirement Relevance for ContractFSH_CQ_CHECKCHAR1
FSH_VRSN_STATUSSnapshot StatusFSH_SNST_STATUSCHAR2
FSH_TRANSACTIONTransaction NumberFSH_TRANSACTIONCHAR10
FSH_VAS_CGValue-Added Services Customer GroupFSH_VAS_CG_DCHAR3
FSH_CANDATECancellation DateFSH_CANDATEDATS8
FSH_SSOrder Scheduling StrategyFSH_SCH_STYFSH_OSSCHAR3
FSH_OS_STG_CHANGEOrder Scheduling Strategy Fields Changed ManuallyFSH_OS_STG_CHANGECHAR1
J_3GKBAULETM-Relevant IndicatorJ_3GKBAULCHAR1
MILL_APPL_IDApplication ID Category for ConfigurationMILL_APPL_IDCHAR2
TASTreasury Account SymbolFMFG_TASCHAR30
BETCBusiness Event Type CodeFMFG_BETCCHAR10
MOD_ALLOWModification AllowedFMFG_MOD_ALLOWCHAR1
CANCEL_ALLOWCancellation AllowedFMFG_CANCEL_ALLOWCHAR1
PAY_METHODList of Respected Payment MethodsDZWELSCHAR10
BPNBusiness Partner NumberFMFG_BPNT880CHAR6
REP_FREQReporting FrequencyFMFG_REP_FREQCHAR3
LOGSYSBLogical system with which document was createdLOGSYSB*CHAR10
KALCDProcedure for Campaign DeterminationKALCD*CHAR6
MULTIMultiple Campaigns/Trade Promotions Active IndicatorCMPC_MULT_CAMPAIGNCHAR1
SPPAYMPayment Form for Special Payment MethodSPPAYMCHAR2
WTYSC_CLM_HDRClaim headerWTYSC_CLM_HDRCHAR16
DUMMY11Dummy function in length 1DUMMYCHAR1
TEST1Material NumberMATNRCHAR40
ZDBTFLGCustom field for VBAKZZDBTFLGCHAR40

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 VBAK

Table NameFieldCardinalityCheck Table
VBAKABRVWC: CNTVLV
VBAKAPM_APPROVAL_REASON1: CNSDAPMAPRR
VBAKAPM_REJECTION_REASON1: CNSDAPMREJR
VBAKAUART1: CNTVAK
VBAKAUFNRC: CNAUFK
VBAKAUGRUC: CNTVAU
VBAKBPN:T880
VBAKBSARKC: CNT176
VBAKBUKRS_VFC: CNT001
VBAKCMWAEC: CNTCURC
VBAKCTLPCC: CNT691A
VBAKFAKSKC: CNTVFS
VBAKFKARAC: CNTVFK
VBAKFSH_KVGR10C: CNFSH_TVV10
VBAKFSH_KVGR6C: CNFSH_TVV6
VBAKFSH_KVGR7C: CNFSH_TVV7
VBAKFSH_KVGR8C: CNFSH_TVV8
VBAKFSH_KVGR9C: CNFSH_TVV9
VBAKFSH_REREG:ARUN_RELEASE
VBAKFSH_SS:FSH_OSS
VBAKGSBERC: CNTGSB
VBAKGSKSTC: CNTGSB
VBAKHITYP_PRC: CNTHIT
VBAKKALSMC: CNT683
VBAKKALSM_CHC: CNT683
VBAKKKBERC: CNT014
VBAKKNKLIC: CNKNA1
VBAKKNUMA1: CNKONA
VBAKKOKRSC: CNTKA01
VBAKKUNNRC: CNKNA1
VBAKKURSTC: CNTCURV
VBAKKVGR1C: CNTVV1
VBAKKVGR2C: CNTVV2
VBAKKVGR3C: CNTVV3
VBAKKVGR4C: CNTVV4
VBAKKVGR5C: CNTVV5
VBAKLANDTXC: CNT005
VBAKLIFSKC: CNTVLS
VBAKMANDT1: CNT000
VBAKOBJNRC: CNONR00
VBAKPROLI:TDGC5
VBAKPS_PSP_PNRC: CNPRPS
VBAKQMNUMC: CNQMEL
VBAKRPLNRC: 1FPLA
VBAKSBGRPC: CNT024B
VBAKSCHEME_GRP1: CNTVGRPS
VBAKSPART1: CNTVTA
VBAKSTCEG_LC: CNT005
VBAKSTWAEC: CNTCURC
VBAKVKBURC: CNTVKBZ
VBAKVKGRPC: CNTVBVK
VBAKVKORG1: CNTVKO
VBAKVSBEDC: CNTVSB
VBAKVTWEG1: CNTVKOV
VBAKWAERKC: CNTCURC
VBAKZAPCGKH:/ILE/TV01
VBAKZZ1_SHIP_TYPE_SDH:ZZ1_4064E5A46361

Other References