SAP VBKD Sales Document: Business Data Table data and field list

VBKD is a standard SAP Table which is used to store Sales Document: Business Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VBKD table consists of various fields, each holding specific information or linking keys about Sales Document: Business Data data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), KONDA (Price group (customer)), KDGRP (Customer group)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VBKD table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VBKD table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VBKD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNSales and Distribution Document Number VBELNCHAR10VBUKALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6VBUPPOSNR
KONDAPrice group (customer) KONDACHAR2T188KONDAVKA
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
PLTYPPrice list type PLTYPCHAR2T189PLTYPVPL
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2TFACDWFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2TFACDWFCID
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZLSCHPayment Method SCHZW_BSEGCHAR1T042ZZLSCH
KTGRDAccount assignment group for this customer KTGRDCHAR2TVKTKTGRD
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FKDATBilling date for billing index and printout FKDATDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
POPERPosting period POPERNUMC3POPERPOPR
STCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
MSCHLDunning key MSCHLCHAR1T040MSCHL
MANSPDunning block MANSPCHAR1T040SMANSP
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10FPLAFPLNR
WAKTIONCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
ABSSCPayment guarantee procedure ABSSCHE_CMCHAR6T691MABSSCHE_CM
LCNUMFinancial doc. processing: Internal financial doc. number LCNUMCHAR10AKKPALPHALCNUMAKN
J_1AFITPTax type J_1AFITP_DCHAR2J_1AFITPJ_1AFITP
J_1ARFZReason for zero VAT J_1ARFZVATCHAR1J_1ARFZJ_1ARFZVAT
J_1AREGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
J_1AGICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICDJ_1AGICD2
J_1ADTYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYPJ_1ADTYP
J_1ATXRELTax relevant classification J_1ATXREL_CHAR10J_1ATXRELJ_1ATXREL
ABTNRDepartment number ABTNRCHAR4TSABABTNR
EMPSTReceiving point EMPSTCHAR25TEXT25
BSTKDCustomer purchase order number BSTKDCHAR35BSTKD
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BSARKCustomer purchase order type BSARKCHAR4T176BSARK
IHREZYour Reference IHREZCHAR12TEXT12
BSTKD_EShip-to Party's Purchase Order Number BSTKD_ECHAR35BSTKD
BSTDK_EShip-to party's PO date BSTDK_EDATS8DATUM
BSARK_EShip-to party purchase order type BSARK_ECHAR4T176BSARK
IHREZ_EShip-to party character IHREZ_ECHAR12TEXT12
POSEX_EItem Number of the Underlying Purchase Order POSEX_ECHAR6ALPHAPOSEX
KURSK_DATTranslation Date WWERT_DDATS8DATUM
KURRF_DATTranslation Date WWERT_DDATS8DATUM
KDKG1Customer condition group 1 KDKG1CHAR2TVKGGKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2TVKGGKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2TVKGGKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2TVKGGKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2TVKGGKDKGR
WKWAEValue contract currency WKWAECUKY5TCURCWAERS
WKKURExchange rate in value contract currency WKKURDEC9(5) KURRF
AKWAECurrency key for letter-of-credit procg in foreign trade AKWAECUKY5TCURCWAERSFWS
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
AKPRZDepreciation percentage for financial document processing AKPRZDEC5(2) PRZ32
J_1AINDXPInflation Index J_1AINDXPCHAR5J_1AINFT20J_1AINDXP
J_1AIDATEPIndexing base date J_1AIDATESDATS8J_1AUDATEP
BSTKD_MCustomer PO number as matchcode field BSTKD_MCHAR35CHAR35
DELCOAgreed delivery time DELCOCHAR3TVDCDELCO
FFPRFDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
FAKTFBilling form FAKTFCHAR2FAKTF
RRRELRevenue recognition category RR_RELTYPCHAR1RR_RELTYP
ACDATVProposed start date for accrual period RR_ACDATVCHAR1RR_ACDATV
VSARTShipping type VSARTTRCHAR2T173VERSART
TRATYMeans-of-Transport Type TRATYCHAR4TVTYTRATY
TRMTYPMeans of Transport TRMTYPCHAR18MARAMATN1MATNR
SDABWSpecial processing indicator SDABWCHAR4TVSAKSDABW
WMINRProduct catalog number WMINRCHAR10WWMIWMINRWMIWPC1
FKBERFunctional Area FKBERCHAR16TFKBFKBERFBE
PODKZRelevant for POD processing PODKZCHAR1XFELD
CAMPAIGNGeneric project planning: GUID from external R/3 system CGPL_GUID16_R3RAW16SYSUUID
VKONTContract Account Number CORR_VKONT_KKCHAR12ALPHACORR_VKONT_KK
DPBP_REF_FPLNRBilling plan number / invoicing plan number FPLNRCHAR10Assigned to domainFPLNR
DPBP_REF_FPLTRItem for billing plan/invoice plan/payment cards FPLTRNUMC6Assigned to domainFPLTR
REVSPRevenue Distribution Type RR_REVSPCHAR1RR_REVSP
REVEVTYPRevenue Event Type (Customizing) RR_REVEVTYP_CUSTCHAR1RR_REVEVTYP_CUST
VTREFReference Specifications from Contract CORR_VTREF_KKCHAR20ALPHACORR_VTREF_KK
.INCLU--AP 0
BOOKING_FRBooking Date- From /SAPHT/DRM_BOOK_FROMDATS8DATS
BOOKING_TOBooking Date - To /SAPHT/DRM_BOOK_TODATS8DATS
SHIPPING_FRShipping Date - From /SAPHT/DRM_SHIP_FROMDATS8DATS
SHIPPING_TOShipping Date - To /SAPHT/DRM_SHIP_TODATS8DATS
BILLING_FRBilling Date - From /SAPHT/DRM_BILL_FROMDATS8DATS
BILLING_TOBilling Date - To /SAPHT/DRM_BILL_TODATS8DATS
EXERCISE_FRExercise Date -To /SAPHT/DRM_EXER_FROMDATS8DATS
EXERCISE_TOExercise Date - From /SAPHT/DRM_EXER_TODATS8DATS
DESIGN_REG_NODesign registration number /SAPHT/DRM_DESIGN_REG_NOCHAR30CHAR30
DROP_SHIPDropship indicator /SAPHT/DRM_DS_INDCHAR1/SAPHT/DRM_DS_IND
.INCLU--AP 0
RFPLNStandard Billing/Invoicing Plan Number RFPLN_DCHAR10FPLAFPLNR
SYNCHAutomatic Synchronization of Billing Plan SYNCHCHAR1SYNCH
.INCLU--AP 0
PACKNOPackage number PACKNONUMC10ESLHPACKNO
.INCLU--AP 0
PEROP_BEGPeriod of Performance Start Date FM_PEROP_SD_LOWDATS8DATUM
PEROP_ENDPeriod of Performance End Date FM_PEROP_SD_HIGHDATS8DATUM
.INCLU--AP 0
STCODELST CST applicability code J_1ISTCODECHAR3Assigned to domainJ_1ISTCODE
FORMC1Form Type J_1IFORTYPCHAR3Assigned to domainJ_1IFORTYP
FORMC2Form Type J_1IFORTYPCHAR3Assigned to domainJ_1IFORTYP
STEUCControl code for consumption taxes in foreign trade STEUCCHAR16Assigned to domainSTEUC
.INCLU--AP 0
COMPREASAbbreviation for Complaints Reason CMP_COMPREAS_COPYCHAR4CMP_COMPREAS_COPY
.INCLU--AP 0
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
PAY_TYPESEPA: Transaction Type SEPA_PAY_TYPECHAR1SEPA_PAY_TYPE
SEPONSEPA-Relevance SD_SEPA_FLAGCHAR1SD_SEPA_FLAG
MNDVGSEPA-Relevance SD_SEPA_FLAGCHAR1SD_SEPA_FLAG

Key field Non-key field



How do I retrieve data from SAP table VBKD using ABAP code

The following ABAP code Example will allow you to do a basic selection on VBKD to SELECT all data from the table
DATA: WA_VBKD TYPE VBKD.

SELECT SINGLE *
FROM VBKD
INTO CORRESPONDING FIELDS OF WA_VBKD
WHERE...

How to access SAP table VBKD

Within an ECC or HANA version of SAP you can also view further information about VBKD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VBKD

    ADMIX - Help structure for reading via ADK in LDB(SD)
        VBUK - Sales Doc.: Header Status and Administrative Data
    VBPA - Sales Document: Partner
    SADR - Address Management: Company data
    VBUV - Sales Document: Incompletion Log
    STXH - STXD SAPscript text file header
    STXL - STXD SAPscript text file lines
    CDHDR - Change document header
    CDPOS - Change document items
    VBAK - Sales Document: Header Data
        VBFA - Sales Document Flow
        NAST - Message status
        VBKD - Sales Document: Business Data
        VBUP - Sales Document: Item Status
        VBAP - Sales Document: Item Data
        VBEP - Sales Document: Schedule Line Data
        KONV - Conditions (Transaction Data)

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
        PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
        VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
        VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
        VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS

    VAKPA - vakpa
        VBAK - Sales Document: Header Data
    VBFAVG - Sales document: Cumulative records,followed by doc
    KONV - Conditions (Transaction Data)
    FPLT - SD document: Billing plan item
        VBUP - Sales Document: Item Status
        VEDAPO - SD document: Contract data item
        VBUK - SD document: Header status and administration
        VBKD - Sales Document: Business Data
        VEDA - SD document: Contract data header
        VFPLA - SD document: Billing plan header
            VFPLT - SD document: Billing plan item
        VBUV - SD document: Incompletion log
        VBPA - Sales Document: Partner
            VBADR - Address work area
        VBAP - Sales Document: Item Data
            VBKDPO - SD document: Business item data
            VBPAPO - Item partner for SD document
            VBEP - Sales Document: Schedule Line Data
            VBFA - Sales Document Flow

    VAKPA - SD document: Indices
        VBUK - SD document: Header status and administration
        VFPLA - SD document: Billing plan payment cards
            VFPLT - SD document: Billing plan payment cards
        VBUP - Sales Document: Item Status
            VBAP - Sales Document: Item Data
                VBKDPO - SD document: Business item data
                    FPLAPO - SD document: Billing plan
                        FPLTPO - SD document: Billing plan dates
                VBPAPO - Item partner for SD document
                    VBADRPO - Address work area
                VEDAPO - SD document: Contract data item
    VBAK - Sales Document: Header Data
                VBEP - Sales Document: Schedule Line Data
                VBFA - Sales Document Flow
                VBFAVG - Sales document: Cumulative records,followed by doc
                KONV - Conditions (Transaction Data)
        VBKD - Sales Document: Business Data
            FPLA - SD document: Billing plan
                FPLT - SD document: Billing plan dates
        VBUV - SD document: Incompletion log
        VBPA - SD document: Partner
            VBADR - Address work area
        VEDA - SD document: Contract data header

    VBAK - Sales Document: Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
                VBFA - Sales Document Flow
                VBFAVG - Sales document: Cumulative records,followed by doc
                KONV - Conditions (Transaction Data)
    VBKD - Sales Document: Business Data
        VBPA - Sales Document: Partner
    VBUV - Sales Document: Incompletion Log
        VBAP - Sales Document: Item Data
            VBUP - Sales Document: Item Status
            VBKDPO - Sales document: Business item data (POSNR > 0)
            VBPAPO - Item partner of sales document (for LDB)
            VBEP - Sales Document: Schedule Line Data

    VBAK - Sales Document: Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
            VBFA - Sales Document Flow
            VBFAVG - Sales document: Cumulative records,followed by doc
            KONV - Conditions (Transaction Data)
    VBKD - Sales Document: Business Data
        VBPA - Sales Document: Partner
    VBUV - Sales Document: Incompletion Log
        VBAP - Sales Document: Item Data
            VBUP - Sales Document: Item Status
            VBKDPO - Sales document: Business item data (POSNR > 0)
            VBPAPO - Item partner of sales document (for LDB)
            VBEP - Sales Document: Schedule Line Data