SAP Table VBKD stores Sales Document: Business Datadata

  

In this post, I will try and describe everything you need to know about the SAP vbkd 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 VBKD 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 VBKD....Right lets get started!


SAP VBKD dictionary attributes

Object Name: VBKD
Dictionary Type: Transparent table
Description: Sales Document: Business Data


VBKD 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
VBELNVBELNCHAR10(0) VBUKSales and Distribution Document NumberVBELNAUNV
POSNRPOSNRNUMC6(0) VBUPItem number of the SD documentPOSNRV
KONDAKONDACHAR2(0) T188Price group (customer)KONDAVKAVF
KDGRPKDGRPCHAR2(0) T151Customer groupKDGRPVKDV
BZIRKBZIRKCHAR6(0) T171Sales districtBZIRKBZIV
PLTYPPLTYPCHAR2(0) T189Price list typePLTYPVPLV
INCO1INCO1CHAR3(0) TINCIncoterms (Part 1)INCO1V
INCO2INCO2CHAR28(0) Incoterms (Part 2)INCO2V
KZAZUKZAZU_DCHAR1(0) Order Combination IndicatorXFELDVA
PERFKPERFKCHAR2(0) TFACDInvoice dates (calendar identification)WFCIDVF
PERRLPERRLCHAR2(0) TFACDInvoice list schedule (calendar identification)WFCIDVF
MRNKZMRNKZCHAR1(0) Manual invoice maintenanceXFELDVF
KURRFKURRFDEC9(5) Exchange rate for FI postingsKURRFVF
VALTGVALTGNUMC2(0) Additional value daysTAGE2V
VALDTVALDTDATS8(0) Fixed value dateDATUMV
ZTERMDZTERMCHAR4(0) Terms of Payment KeyZTERMFB
ZLSCHSCHZW_BSEGCHAR1(0) T042ZPayment MethodZLSCHFB
KTGRDKTGRDCHAR2(0) TVKTAccount assignment group for this customerKTGRDVF
KURSKKURSKDEC9(5) Exchange Rate for Price DeterminationKURRFVS
PRSDTPRSDTDATS8(0) Date for pricing and exchange rateDATUMVS
FKDATFKDATDATS8(0) Billing date for billing index and printoutDATUMVF
FBUDAFBUDADATS8(0) Date on which services renderedDATUMVF
GJAHRGJAHRNUMC4(0) Fiscal YearGJAHRGJRFB
POPERPOPERNUMC3(0) Posting periodPOPERPOPRFB
STCURSTCURDEC9(5) Exchange rate for statisticsKURRFVS
MSCHLMSCHLCHAR1(0) T040Dunning keyMSCHLFB
MANSPMANSPCHAR1(0) T040SDunning blockMANSPFB
FPLNRFPLNRCHAR10(0) FPLABilling plan number / invoicing plan numberFPLNR
WAKTIONWAKTIONCHAR10(0) WAKHCOUPONWAKTIONWAK
ABSSCABSSCHE_CMCHAR6(0) T691MPayment guarantee procedureABSSCHE_CM
LCNUMLCNUMCHAR10(0) AKKPFinancial doc. processing: Internal financial doc. numberLCNUMAKN
J_1AFITPJ_1AFITP_DCHAR2(0) J_1AFITPTax typeJ_1AFITP
J_1ARFZJ_1ARFZVATCHAR1(0) J_1ARFZReason for zero VATJ_1ARFZVAT
J_1AREGIOREGIOCHAR3(0) T005SSTATE (State, Province, County)REGIOFB
J_1AGICDJ_1AGICD_DCHAR2(0) J_1AGICDActivity Code for Gross Income TaxJ_1AGICD2
J_1ADTYPJ_1ADTYP_DCHAR2(0) J_1ADTYPDistribution Type for Employment TaxJ_1ADTYP
J_1ATXRELJ_1ATXREL_CHAR10(0) J_1ATXRELTax relevant classificationJ_1ATXREL
ABTNRABTNRCHAR4(0) TSABDepartment numberABTNRV
EMPSTEMPSTCHAR25(0) Receiving pointTEXT25
BSTKDBSTKDCHAR35(0) Customer purchase order numberBSTKDVA
BSTDKBSTDKDATS8(0) Customer purchase order dateDATUMV
BSARKBSARKCHAR4(0) T176Customer purchase order typeBSARKV
IHREZIHREZCHAR12(0) Your ReferenceTEXT12V
BSTKD_EBSTKD_ECHAR35(0) Ship-to Party's Purchase Order NumberBSTKDVA
BSTDK_EBSTDK_EDATS8(0) Ship-to party's PO dateDATUMV
BSARK_EBSARK_ECHAR4(0) T176Ship-to party purchase order typeBSARKV
IHREZ_EIHREZ_ECHAR12(0) Ship-to party characterTEXT12V
POSEX_EPOSEX_ECHAR6(0) Item Number of the Underlying Purchase OrderPOSEXVA
KURSK_DATWWERT_DDATS8(0) Translation DateDATUMFB
KURRF_DATWWERT_DDATS8(0) Translation DateDATUMFB
KDKG1KDKG1CHAR2(0) TVKGGCustomer condition group 1KDKGR
KDKG2KDKG2CHAR2(0) TVKGGCustomer condition group 2KDKGR
KDKG3KDKG3CHAR2(0) TVKGGCustomer condition group 3KDKGR
KDKG4KDKG4CHAR2(0) TVKGGCustomer condition group 4KDKGR
KDKG5KDKG5CHAR2(0) TVKGGCustomer condition group 5KDKGR
WKWAEWKWAECUKY5(0) TCURCValue contract currencyWAERS
WKKURWKKURDEC9(5) Exchange rate in value contract currencyKURRF
AKWAEAKWAECUKY5(0) TCURCCurrency key for letter-of-credit procg in foreign tradeWAERSFWS
AKKURAKKURDEC9(5) Exchange rate for letter-of-credit procg in foreign tradeKURRF
AKPRZAKPRZDEC5(2) Depreciation percentage for financial document processingPRZ32
J_1AINDXPJ_1AINDXPCHAR5(0) J_1AINFT20Inflation IndexJ_1AINDXP
J_1AIDATEPJ_1AIDATESDATS8(0) Indexing base dateJ_1AUDATEP
BSTKD_MBSTKD_MCHAR35(0) Customer PO number as matchcode fieldCHAR35VA
DELCODELCOCHAR3(0) TVDCAgreed delivery timeDELCO
FFPRFAD01PROFNRCHAR8(0) AD01C_PROFDynamic Item Processor ProfileAD01PROFNRAD0DIP_PROFILEPROFNR
BEMOTBEMOTCHAR2(0) TBMOTAccounting IndicatorBEMOT
FAKTFFAKTFCHAR2(0) Billing formFAKTF
RRRELRR_RELTYPCHAR1(0) Revenue recognition categoryRR_RELTYP
ACDATVRR_ACDATVCHAR1(0) Proposed start date for accrual periodRR_ACDATV
VSARTVSARTTRCHAR2(0) T173Shipping typeVERSARTVV
TRATYTRATYCHAR4(0) TVTYMeans-of-Transport TypeTRATY
TRMTYPTRMTYPCHAR18(0) MARAMeans of TransportMATNR
SDABWSDABWCHAR4(0) TVSAKSpecial processing indicatorSDABW
WMINRWMINRCHAR10(0) WWMIProduct catalog numberWMINRWMIWPC1WMINR
FKBERFKBERCHAR16(0) TFKBFunctional AreaFKBERFBE
PODKZPODKZCHAR1(0) Relevant for POD processingXFELD
CAMPAIGNCGPL_GUID16_R3RAW16(0) Generic project planning: GUID from external R/3 systemSYSUUID
VKONTCORR_VKONT_KKCHAR12(0) Contract Account NumberCORR_VKONT_KK
DPBP_REF_FPLNRFPLNRCHAR10(0) *Billing plan number / invoicing plan numberFPLNR
DPBP_REF_FPLTRFPLTRNUMC6(0) *Item for billing plan/invoice plan/payment cardsFPLTR
REVSPRR_REVSPCHAR1(0) Revenue Distribution TypeRR_REVSP
REVEVTYPRR_REVEVTYP_CUSTCHAR1(0) Revenue Event Type (Customizing)RR_REVEVTYP_CUST
VTREFCORR_VTREF_KKCHAR20(0) Reference Specifications from ContractCORR_VTREF_KK
.INCLU--AP0(0)
BOOKING_FR/SAPHT/DRM_BOOK_FROMDATS8(0) Booking Date- FromDATS
BOOKING_TO/SAPHT/DRM_BOOK_TODATS8(0) Booking Date - ToDATS
SHIPPING_FR/SAPHT/DRM_SHIP_FROMDATS8(0) Shipping Date - FromDATS
SHIPPING_TO/SAPHT/DRM_SHIP_TODATS8(0) Shipping Date - ToDATS
BILLING_FR/SAPHT/DRM_BILL_FROMDATS8(0) Billing Date - FromDATS
BILLING_TO/SAPHT/DRM_BILL_TODATS8(0) Billing Date - ToDATS
EXERCISE_FR/SAPHT/DRM_EXER_FROMDATS8(0) Exercise Date -ToDATS
EXERCISE_TO/SAPHT/DRM_EXER_TODATS8(0) Exercise Date - FromDATS
DESIGN_REG_NO/SAPHT/DRM_DESIGN_REG_NOCHAR30(0) Design registration numberCHAR30
DROP_SHIP/SAPHT/DRM_DS_INDCHAR1(0) Dropship indicator/SAPHT/DRM_DS_IND
.INCLU--AP0(0)
RFPLNRFPLN_DCHAR10(0) FPLAStandard Billing/Invoicing Plan NumberFPLNR
SYNCHSYNCHCHAR1(0) Automatic Synchronization of Billing PlanSYNCH
.INCLU--AP0(0)
PACKNOPACKNONUMC10(0) ESLHPackage numberPACKNO
.INCLU--AP0(0)
PEROP_BEGFM_PEROP_SD_LOWDATS8(0) Period of Performance Start DateDATUM
PEROP_ENDFM_PEROP_SD_HIGHDATS8(0) Period of Performance End DateDATUM
.INCLU--AP0(0)
STCODEJ_1ISTCODECHAR3(0) *LST CST applicability codeJ_1ISTCODE
FORMC1J_1IFORTYPCHAR3(0) *Form TypeJ_1IFORTYP
FORMC2J_1IFORTYPCHAR3(0) *Form TypeJ_1IFORTYP
STEUCSTEUCCHAR16(0) *Control code for consumption taxes in foreign tradeSTEUC
.INCLU--AP0(0)
COMPREASCMP_COMPREAS_COPYCHAR4(0) Abbreviation for Complaints ReasonCMP_COMPREAS_COPY
.INCLU--AP0(0)
MNDIDSEPA_MNDIDCHAR35(0) Unique Referene to Mandate per Payment RecipientID035
PAY_TYPESEPA_PAY_TYPECHAR1(0) SEPA: Transaction TypeSEPA_PAY_TYPE
SEPONSD_SEPA_FLAGCHAR1(0) SEPA-RelevanceSD_SEPA_FLAG
MNDVGSD_SEPA_FLAGCHAR1(0) SEPA-RelevanceSD_SEPA_FLAG