SAP Table VBAK stores Sales Document: Header Datadata

  

In this post, I will try and describe everything you need to know about the SAP vbak table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for VBAK what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from VBAK....Right lets get started!


SAP VBAK dictionary attributes

Object Name: VBAK
Dictionary Type: Transparent table
Description: Sales Document: Header Data


VBAK field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
VBELNVBELN_VACHAR10(0) VBUKSales DocumentVBELNAUNVA
ERDATERDATDATS8(0) Date on Which Record Was CreatedDATUMSAP
ERZETERZETTIMS6(0) Entry timeUZEITSAP
ERNAMERNAMCHAR12(0) Name of Person who Created the ObjectUSNAMSAP
ANGDTANGDT_VDATS8(0) Quotation/Inquiry is valid fromDATUMVA
BNDDTBNDDTDATS8(0) Date until which bid/quotation is binding (valid-to date)DATUMVA
AUDATAUDATDATS8(0) Document Date (Date Received/Sent)DATUMVA
VBTYPVBTYPCHAR1(0) SD document categoryVBTYPV
TRVOGTRVOGCHAR1(0) Transaction groupTRVOGVTVV
AUARTAUARTCHAR4(0) TVAKSales Document TypeAUARTAATVA
AUGRUAUGRUCHAR3(0) TVAUOrder reason (reason for the business transaction)AUGRUVA
GWLDTGWLDTDATS8(0) Warranty DateDATUMVA
SUBMISUBMI_SDCHAR10(0) Collective number (SD)CHAR10
LIFSKLIFSKCHAR2(0) TVLSDelivery block (document header)LIFSPVL
FAKSKFAKSKCHAR2(0) TVFSBilling block in SD documentFAKSPVF
NETWRNETWR_AKCURR15(2) Net Value of the Sales Order in Document CurrencyWERTV8VF
WAERKWAERKCUKY5(0) TCURCSD Document CurrencyWAERSFWSVF
VKORGVKORGCHAR4(0) TVKOSales OrganizationVKORGVKOVC_VKORGVKORG
VTWEGVTWEGCHAR2(0) TVKOVDistribution ChannelVTWEGVTWVC_VTWEGVTWEG
SPARTSPARTCHAR2(0) TVTADivisionSPARTSPAVC_SPARTSPART
VKGRPVKGRPCHAR3(0) TVBVKSales GroupVKGRPVKGV
VKBURVKBURCHAR4(0) TVKBZSales OfficeVKBURVKBV
GSBERGSBERCHAR4(0) TGSBBusiness AreaGSBERGSBFB
GSKSTGSKSTCHAR4(0) TGSBBusiness area from cost centerGSBERVA
GUEBGGUEBGDATS8(0) Valid-from date (outline agreements, product proposals)DATUMVA
GUEENGUEENDATS8(0) Valid-to date (outline agreements, product proposals)DATUMVA
KNUMVKNUMVCHAR10(0) Number of the document conditionKNUMVVF
VDATUEDATU_VBAKDATS8(0) Requested delivery dateDATUMVA
VPRGRPRGRS_VBAKCHAR1(0) Proposed date typePRGRSVA
AUTLFAUTLFCHAR1(0) Complete delivery defined for each sales order?XFELDVL
VBKLAVBKLACHAR9(0) Original system with release and transaction controlCHAR9V
VBKLTVBKLTCHAR1(0) SD document indicatorVBKLTV
KALSMKALSMASDCHAR6(0) T683Sales and Distribution: Pricing Procedure in PricingKALSMVF
VSBEDVSBEDCHAR2(0) TVSBShipping ConditionsVSBEDVV
FKARAFKARACHAR4(0) TVFKProposed billing type for an order-related billing documentFKARTVF
AWAHRAWAHR_AKNUMC3(0) Sales probabilityAWAHRVA
KTEXTKTEXT_VCHAR40(0) Search term for product proposalTEXT40VA
BSTNKBSTNKCHAR20(0) Customer purchase order numberBSTNKVA
BSARKBSARKCHAR4(0) T176Customer purchase order typeBSARKV
BSTDKBSTDKDATS8(0) Customer purchase order dateDATUMV
BSTZDBSTZDCHAR4(0) Purchase order number supplementBSTZDV
IHREZIHREZCHAR12(0) Your ReferenceTEXT12V
BNAMEBNAME_VCHAR35(0) Name of ordererNAMEVP
TELF1TELF1_VPCHAR16(0) Telephone NumberTELF1VP
MAHZAMAHZADEC3(0) Number of contacts from the customerPACK2V
MAHDTMAHDTDATS8(0) Last customer contact dateDATUMV
KUNNRKUNAGCHAR10(0) KNA1Sold-to partyKUNNRVAGVP
KOSTLKOSTLCHAR10(0) *Cost CenterKOSTLKOSKS
STAFOSTAFOCHAR6(0) *Update group for statistics updateSTAFOMCFMCS
STWAESTWAECUKY5(0) TCURCStatistics currencyWAERSV
AEDATAEDATDATS8(0) Changed OnDATUMSAP
KVGR1KVGR1CHAR3(0) TVV1Customer group 1KVGR1VP
KVGR2KVGR2CHAR3(0) TVV2Customer group 2KVGR2VP
KVGR3KVGR3CHAR3(0) TVV3Customer group 3KVGR3VP
KVGR4KVGR4CHAR3(0) TVV4Customer group 4KVGR4VP
KVGR5KVGR5CHAR3(0) TVV5Customer group 5KVGR5VP
KNUMAKNUMACHAR10(0) KONAAgreement (various conditions grouped together)KNUMAVFVMBOKNUMA
KOKRSKOKRSCHAR4(0) TKA01Controlling AreaCACCDCACKS
PS_PSP_PNRPS_PSP_PNRNUMC8(0) PRPSWork Breakdown Structure Element (WBS Element)PS_POSNR
KURSTKURSTCHAR4(0) TCURVExchange Rate TypeKURSTKUTSAP
KKBERKKBERCHAR4(0) T014Credit control areaKKBERKKBFB
KNKLIKNKLICHAR10(0) KNA1Customer's account number with credit limit referenceKUNNRFB
GRUPPGRUPP_CMCHAR4(0) *Customer Credit GroupGRUPP_CMFB
SBGRPSBGRP_CMCHAR3(0) T024BCredit representative group for credit managementSBGRP_CMKBGFB
CTLPCCTLPC_CMCHAR3(0) T691ACredit management: Risk categoryCTLPC_CMFB
CMWAEWAERS_CMCUKY5(0) TCURCCurrency key of credit control areaWAERSFB
CMFRECMFREDATS8(0) Release date of the document determined by credit managementDATUM
CMNUPCMNUPDATS8(0) Date of next credit check of documentDATUM
CMNGVCMNGVDATS8(0) Next dateDATUM
AMTBLAMTBL_CMCURR15(2) Released credit value of the documentWERTV8VF
HITYP_PRHITYP_PRCHAR1(0) THITHierarchy type for pricingHITYP
ABRVWABRVWCHAR3(0) TVLVUsage IndicatorABRVW
ABDISABDISCHAR1(0) MRP for delivery schedule typesABRAB
VGBELVGBELCHAR10(0) VBUKDocument number of the reference documentVBELNVS
OBJNROBJKOCHAR22(0) ONR00Object number at header levelJ_OBJNR
BUKRS_VFBUKRS_VFCHAR4(0) T001Company code to be billedBUKRSBUKFB
TAXK1TAXK1_AKCHAR1(0) *Alternative tax classificationTAXKDVF
TAXK2TAXK2CHAR1(0) *Tax classification 2 for customerTAXKDVF
TAXK3TAXK3CHAR1(0) *Tax classification 3 for customerTAXKDVF
TAXK4TAXK4CHAR1(0) *Tax Classification 4 CustomerTAXKDVF
TAXK5TAXK5CHAR1(0) *Tax classification 5 for customerTAXKDVF
TAXK6TAXK6CHAR1(0) *Tax classification 6 for customerTAXKDVF
TAXK7TAXK7CHAR1(0) *Tax classification 7 for customerTAXKDVF
TAXK8TAXK8CHAR1(0) *Tax classification 8 for customerTAXKDVF
TAXK9TAXK9CHAR1(0) *Tax classification 9 for customerTAXKDVF
XBLNRXBLNR_V1CHAR16(0) Reference Document NumberXBLNR1FB
ZUONRORDNR_VCHAR18(0) Assignment numberZUONRFB
VGTYPVBTYP_VCHAR1(0) Document category of preceding SD documentVBTYPV
KALSM_CHKALSMA_CHCHAR6(0) T683Search procedure for batch determinationKALSM
AGRZRAGRZRNUMC2(0) Accrual period for order-related billing docs.to be accruedNUM2
AUFNRAUFNRCHAR12(0) AUFKOrder NumberAUFNRANRSAP
QMNUMQMNUMCHAR12(0) QMELNotification NoQMNUMIQMINST
VBELN_GRPVBELN_GRPCHAR10(0) *Mster contract numberVBELN
SCHEME_GRPSCHEME_GRPCHAR4(0) TVGRPSReferencing requirement: ProcedureSCHEME_GRP
ABRUF_PARTABRUF_PARTCHAR1(0) Check partner authorizationsABRUF_PART
ABHODABHODDATS8(0) Pick up dateDATUMV
ABHOVABHOZTIMS6(0) Pick up timeUZEITVA
ABHOBABHOZTIMS6(0) Pick up timeUZEITVA
RPLNRRPLNRCHAR10(0) FPLANumber of payment card plan typeFPLNR
VZEITEZEIT_VBAKTIMS6(0) Proposed schedule line time (local with ref. to sales org.)TIME_SAORG
STCEG_LLAND1TXCHAR3(0) T005Tax Destination CountryLAND1LNDFB
LANDTXLANDTXCHAR3(0) T005Tax departure countryLAND1LNDFB
XEGDRXEGDRCHAR1(0) Indicator: Triangular deal within the EU ?XFELD
ENQUEUE_GRPENQUEUE_GRPCHAR1(0) Block master contr. until all lower level contracts updatedENQUEUE_GRP
DAT_FZAUDAT_FZAUDATS8(0) Cml delivery order qty dateDATUMVA
FMBDATMBDATDATS8(0) Material Staging/Availability DateDATUMV
VSNMR_VVSNMR_VCHAR12(0) Sales document version numberVSNMR
HANDLETSEGGUID_VBAKCHAR22(0) International unique key for VBAK-VBELNSYSUUID_22
PROLIADGE_PROLICHAR3(0) TDGC5Dangerous Goods Management Profile in SD DocumentsADGD_PROLITDGC5_PROLI_01PROLI
CONT_DGADGE_NCDGCHAR1(0) Indicator: Document contains dangerous goodsX
CRM_GUIDCHAR70CHAR70(0) Character field, length 70CHAR70SBTC
UPD_TMSTMPTIMESTAMPLDEC21(7) UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TZNTSTMPL
MSR_IDMSR_PROCESS_IDCHAR10(0) Process Identification NumberMSR_PROCESS_ID
TM_CTRL_KEYTM_CTRL_KEYCHAR4(0) Control Key for Document Transfer to TM
HANDOVERLOCHANDOVER_LOCCHAR10(0) Location for a physical handover of goodsHANDOVER_LOC
.INCLU--AP0(0)
FPARTFPARTCHAR2(0) TFPLABilling/Invoicing Plan TypeFPART
VCLASSIFIC/SAPHT/SW_CONTRCLASSCHAR1(0) Contract classification SD customizing/SAPHT/SW_CONTRCLASS
.INCLU--AP0(0)
/XLSO/SO_VALD_FMDATSDATS8(0) Field of type DATSDATS
/XLSO/SO_VALD_TODATSDATS8(0) Field of type DATSDATS
/XLSO/PAYMENT_OP/XLSO/E_PAY_METHODCHAR2(0) Payment Method/XLSO/D_PAY_METHOD
/XLSO/TRANS_CTXT/XLSO/E_TRANS_CTXTNUMC8(0) Transaction Context GUID/XLSO/D_TRANS_CTXT
/XLSO/CATALOG_IDWMINRCHAR10(0) *Product catalog numberWMINRWMIWPC1WMINR
/XLSO/VARIANT_IDWMVARDCHAR3(0) *Product catalog variantWMVAR
.INCLU--AP0(0)
AD01FAREGAD01FAREGCHAR1(0) Rule for billingAD01FAREG
AD01BASDOCAD01BASDOCCHAR10(0) *Initial documentVBELN
.INCLU--AP0(0)
LASTVCHRAD04LVCHNRNUMC8(0) Last voucher numberAD04VCHNR
.INCLU--AP0(0)
PLCADSPCM_PLCCHAR1(0) PACKAGING LEVEL CODECHAR1
SMBADSPCM_SMBCHAR6(0) SUPPLY MANAG. BRANCH INDICATORCHAR6
ECCADSPCM_ECCCHAR7(0) EVIDENCE CONTROL CODECHAR7
IPPADSPCM_IPPCHAR9(0) INITIAL PROVISIONING PROJECT NUMBERCHAR9
CURADSPCM_CURCHAR3(0) CURRENCY CODECHAR3
ECOADSPCM_ECOCHAR13(0) Economic Conditions for Spec2000MCHAR13
PCOADSPCM_PCOCHAR3(0) PRICE CONDITIONCHAR3
DPTADSPCM_DPTCHAR15(0) DELIVERY POINTCHAR15
TOPADSPCM_TOPCHAR2(0) TYPE OF PRICECHAR2
SUSADSPCM_SUSCHAR5(0) SUPPLIERCHAR5
PCNADSPCM_PCNCHAR16(0) Prime Contract Number for Spec2000MCHAR16
TRUADSPCM_TRUCHAR20(0) CUSTOMER TAX REGISTRATION NUMBERCHAR20
PCYADSPCM_PCYCHAR3(0) Provisioning CategoryCHAR3
PCDADSPCM_PCDCHAR2(0) Procurement CodeCHAR2
PBNADSPCM_PBNCHAR14(0) Procurement Budget NumberCHAR14
AMNADSPCM_AMNCHAR3(0) AMENDMENT NUMBERCHAR3
DNOADSPCM_DNOCHAR12(0) DIVERSION NUMBERCHAR12
.INCLU--AP0(0)
PSM_BUDATPSM_BUDATDATS8(0) Posting Date in the DocumentDATUMFB
.INCLU--AP0(0)
SWENRHB_SWENRCHAR8(0) VIOB01Business Entity NumberSWENRWEH
SMENRHB_SMENRCHAR8(0) VIMI01Number of Sales UnitSMENRMEH
PHASEHB_SPHSECHAR11(0) HBSSPHSales PhaseHBS_PHASE
MTLAURHB_MTLAURCHAR1(0) CHBSNCMMarker for Low Income HousingHBS_MTLAUR
STAGEHB_STAGEINT410(0) Construction StageINT4
HB_CONT_REASONHB_CONTCHAR2(0) HBSCREASONContingency dataCHAR2
HB_EXPDATEHB_EXPDATS8(0) Expiration dateDATS
HB_RESDATEHB_RESDATS8(0) Resolution dateDATS
.INCLU--AP0(0)
J_3GKBAULJ_3GKBAULCHAR1(0) ETM-Relevant IndicatorJ_3GKBAUL
.INCLU--AP0(0)
MILL_APPL_IDMILL_APPL_IDCHAR2(0) Application ID Category for ConfigurationMILL_APPL_ID
.INCLU--AP0(0)
TASFMFG_TASCHAR30(0) Treasury Account SymbolCHAR30
BETCFMFG_BETCCHAR10(0) Business Event Type CodeCHAR10
MOD_ALLOWFMFG_MOD_ALLOWCHAR1(0) Modification AllowedCHAR1
CANCEL_ALLOWFMFG_CANCEL_ALLOWCHAR1(0) Cancellation AllowedCHAR1
PAY_METHODDZWELSCHAR10(0) List of the Payment Methods to be ConsideredZWELSFB
BPNFMFG_BPNCHAR6(0) T880Business Partner NumberRCOMP
REP_FREQFMFG_REP_FREQCHAR3(0) Reporting FrequencyCHAR3
.INCLU--AP0(0)
LOGSYSBLOGSYSBCHAR10(0) *Logical system with which document was createdLOGSYS
.INCLU--AP0(0)
KALCDKALCDCHAR6(0) *Procedure for Campaign DeterminationKALSM
MULTICMPC_MULT_CAMPAIGNCHAR1(0) Multiple Campaigns/Trade Promotions Active IndicatorCMPGN_MULT_CAMPAIGN
.INCLU--AP0(0)
SPPAYMSPPAYMCHAR2(0) Payment Form for Special Payment MethodSPPAYM
.INCLU--AP0(0)
WTYSC_CLM_HDRWTYSC_CLM_HDRCHAR16(0) Claim headerWTYSC_CLM_HDR
.INCLU--AP0(0)
ZZ_STRMNZZ_STRMNDATS8(0)
ZZ_STRURZZ_STRURTIMS6(0)
ZZ_LTRMNZZ_LTRMNDATS8(0)
ZZ_LTRURZZ_LTRURTIMS6(0)