VBKD

Transparent Table Application Table
105 Fields 10 CDS Views

Sales Document: Business Data

VBKD is an SAP database table in S/4HANA. Sales Document: Business Data. It contains 105 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
I_ComSDOpenBillingPlan view inner BASIC Sales Order Item Open Billing Plans
I_RetailStoreOrderBusinessData view_entity from BASIC Business Data for Retail Store Order
I_SalesDocumentVb view from BASIC Sales Document Business Data
I_SupDmndAllDocRetSlsOrd view left_outer BASIC View for Return Sales Orders
P_Bpsddata view inner BASIC
P_ComSDOpenBillingPlan view inner BASIC
P_SalesDocumentBusinessData view from BASIC
RFM_SD_SEASONS_BASIC_VIEW view left_outer RFM Sales Document Seasons Basic View

Fields (105)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN SD Document
KEY posnr POSNR Item
konda KONDA CustPrice Group
kdgrp KDGRP Customer Group
bzirk BZIRK Sales District
pltyp PLTYP Price List Tp.
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
kzazu KZAZU_D Order Combinat.
perfk PERFK Invoicing Dates
perrl PERRL Inv.List Sched.
mrnkz MRNKZ Man.Inv.Maint.
kurrf KURRF Exch.Rate Acct.
valtg VALTG Add. Value Days
valdt VALDT Fixed Val. Date
zterm DZTERM Pyt Terms
zlsch SCHZW_BSEG Payt Method
ktgrd KTGRD AccAssmtGrpCust
kursk KURSK Exchange Rate
prsdt PRSDT Pricing Date
fkdat FKDAT Billing Date
fbuda FBUDA Serv. Rend. Dte
gjahr GJAHR Fiscal Year
poper POPER Posting Period
stcur STCUR Exch.rate stats
mschl MSCHL Dunning key
mansp MANSP Dunn. Block
fplnr FPLNR Bill. Plan No.
waktion WAKTION Promotion
abssc ABSSCHE_CM Paym.Guar.Proc.
lcnum LCNUM Financ.Doc.No.
j_1afitp J_1AFITP_D Tax Type
j_1arfz J_1ARFZVAT Reason for Zero VAT
j_1aregio REGIO Region
j_1agicd J_1AGICD_D Activity Code
j_1adtyp J_1ADTYP_D Distr. Type
j_1atxrel J_1ATXREL_ Tax Rel. Class.
abtnr ABTNR Department
empst EMPST Recv. Point
bstkd BSTKD Cust. Reference
bstdk BSTDK Cust. Ref. Date
bsark BSARK Pur. Ord. Type
ihrez IHREZ Your Reference
bstkd_e BSTKD_E Cust. Reference
bstdk_e BSTDK_E Cust. Ref. Date
bsark_e BSARK_E Pur. Ord. Type
ihrez_e IHREZ_E Your Reference
posex_e POSEX_E PO Item
kursk_dat WWERT_D Translatn Date
kurrf_dat WWERT_D Translatn Date
kdkg1 KDKG1 Condition grp 1
kdkg2 KDKG2 Condition grp 2
kdkg3 KDKG3 Condition grp 3
kdkg4 KDKG4 Condition grp 4
kdkg5 KDKG5 Condition grp 5
wkwae WKWAE Currency
wkkur WKKUR Exchange rate
akwae AKWAE LettOfCredCrcy
akkur AKKUR LettofCredRate
akprz AKPRZ Depreciation
j_1aindxp J_1AINDXP Inflation index
j_1aidatep J_1AIDATES Index base date
bstkd_m BSTKD_M Cust. Reference
delco DELCO Delivery Time
ffprf AD01PROFNR DIP Profile
bemot BEMOT AcctIndicator
faktf FAKTF Billing form
rrrel RR_RELTYP Rev. Recognition
acdatv RR_ACDATV Acc. Period Start
vsart VSARTTR Shipping Type
traty TRATY MnsOfTrns Type
trmtyp TRMTYP MeansTransp.
sdabw SDABW Spec.Processing
wminr WMINR Catalog
fkber FKBER Functional Area
podkz PODKZ POD-relevant
campaign CGPL_GUID16_R3 CGPL_GUID
vkont CORR_VKONT_KK Contract Acct
dpbp_ref_fplnr FPLNR Bill. Plan No.
dpbp_ref_fpltr FPLTR Item
revsp RR_REVSP Revenue Dist.
revevtyp RR_REVEVTYP_CUST Revenue Event
farr_reltype FARR_RELTYPE Type
vtref CORR_VTREF_KK Contract
_dataaging DATA_TEMPERATURE Data Aging
j_1tpbupl BCODE Branch Code
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination
packno PACKNO Package number
perop_beg FM_PEROP_SD_LOW Per. of Perf. Start
perop_end FM_PEROP_SD_HIGH Per. of Perf. End
stcode J_1ISTCODE LST-CST Code
formc1 J_1IFORTYP Form Type
formc2 J_1IFORTYP Form Type
steuc STEUC Control Code
compreas CMP_COMPREAS_COPY Abbreviation
mndid SEPA_MNDID Mandate Ref.
pay_type SEPA_PAY_TYPE Payment Type
sepon SD_SEPA_FLAG SEPA-Relevant
mndvg SD_SEPA_FLAG SEPA-Relevant

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Document: Business Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBKD (
    MANDT,           -- Client [MANDT]
    VBELN,           -- SD Document [VBELN]
    POSNR,           -- Item [POSNR]
    KONDA,           -- CustPrice Group [KONDA]
    KDGRP,           -- Customer Group [KDGRP]
    BZIRK,           -- Sales District [BZIRK]
    PLTYP,           -- Price List Tp. [PLTYP]
    INCO1,           -- Incoterms [INCO1]
    INCO2,           -- Incoterms 2 [INCO2]
    KZAZU,           -- Order Combinat. [KZAZU_D]
    PERFK,           -- Invoicing Dates [PERFK]
    PERRL,           -- Inv.List Sched. [PERRL]
    MRNKZ,           -- Man.Inv.Maint. [MRNKZ]
    KURRF,           -- Exch.Rate Acct. [KURRF]
    VALTG,           -- Add. Value Days [VALTG]
    VALDT,           -- Fixed Val. Date [VALDT]
    ZTERM,           -- Pyt Terms [DZTERM]
    ZLSCH,           -- Payt Method [SCHZW_BSEG]
    KTGRD,           -- AccAssmtGrpCust [KTGRD]
    KURSK,           -- Exchange Rate [KURSK]
    PRSDT,           -- Pricing Date [PRSDT]
    FKDAT,           -- Billing Date [FKDAT]
    FBUDA,           -- Serv. Rend. Dte [FBUDA]
    GJAHR,           -- Fiscal Year [GJAHR]
    POPER,           -- Posting Period [POPER]
    STCUR,           -- Exch.rate stats [STCUR]
    MSCHL,           -- Dunning key [MSCHL]
    MANSP,           -- Dunn. Block [MANSP]
    FPLNR,           -- Bill. Plan No. [FPLNR]
    WAKTION,         -- Promotion [WAKTION]
    ABSSC,           -- Paym.Guar.Proc. [ABSSCHE_CM]
    LCNUM,           -- Financ.Doc.No. [LCNUM]
    J_1AFITP,        -- Tax Type [J_1AFITP_D]
    J_1ARFZ,         -- Reason for Zero VAT [J_1ARFZVAT]
    J_1AREGIO,       -- Region [REGIO]
    J_1AGICD,        -- Activity Code [J_1AGICD_D]
    J_1ADTYP,        -- Distr. Type [J_1ADTYP_D]
    J_1ATXREL,       -- Tax Rel. Class. [J_1ATXREL_]
    ABTNR,           -- Department [ABTNR]
    EMPST,           -- Recv. Point [EMPST]
    BSTKD,           -- Cust. Reference [BSTKD]
    BSTDK,           -- Cust. Ref. Date [BSTDK]
    BSARK,           -- Pur. Ord. Type [BSARK]
    IHREZ,           -- Your Reference [IHREZ]
    BSTKD_E,         -- Cust. Reference [BSTKD_E]
    BSTDK_E,         -- Cust. Ref. Date [BSTDK_E]
    BSARK_E,         -- Pur. Ord. Type [BSARK_E]
    IHREZ_E,         -- Your Reference [IHREZ_E]
    POSEX_E,         -- PO Item [POSEX_E]
    KURSK_DAT,       -- Translatn Date [WWERT_D]
    KURRF_DAT,       -- Translatn Date [WWERT_D]
    KDKG1,           -- Condition grp 1 [KDKG1]
    KDKG2,           -- Condition grp 2 [KDKG2]
    KDKG3,           -- Condition grp 3 [KDKG3]
    KDKG4,           -- Condition grp 4 [KDKG4]
    KDKG5,           -- Condition grp 5 [KDKG5]
    WKWAE,           -- Currency [WKWAE]
    WKKUR,           -- Exchange rate [WKKUR]
    AKWAE,           -- LettOfCredCrcy [AKWAE]
    AKKUR,           -- LettofCredRate [AKKUR]
    AKPRZ,           -- Depreciation [AKPRZ]
    J_1AINDXP,       -- Inflation index [J_1AINDXP]
    J_1AIDATEP,      -- Index base date [J_1AIDATES]
    BSTKD_M,         -- Cust. Reference [BSTKD_M]
    DELCO,           -- Delivery Time [DELCO]
    FFPRF,           -- DIP Profile [AD01PROFNR]
    BEMOT,           -- AcctIndicator [BEMOT]
    FAKTF,           -- Billing form [FAKTF]
    RRREL,           -- Rev. Recognition [RR_RELTYP]
    ACDATV,          -- Acc. Period Start [RR_ACDATV]
    VSART,           -- Shipping Type [VSARTTR]
    TRATY,           -- MnsOfTrns Type [TRATY]
    TRMTYP,          -- MeansTransp. [TRMTYP]
    SDABW,           -- Spec.Processing [SDABW]
    WMINR,           -- Catalog [WMINR]
    FKBER,           -- Functional Area [FKBER]
    PODKZ,           -- POD-relevant [PODKZ]
    CAMPAIGN,        -- CGPL_GUID [CGPL_GUID16_R3]
    VKONT,           -- Contract Acct [CORR_VKONT_KK]
    DPBP_REF_FPLNR,  -- Bill. Plan No. [FPLNR]
    DPBP_REF_FPLTR,  -- Item [FPLTR]
    REVSP,           -- Revenue Dist. [RR_REVSP]
    REVEVTYP,        -- Revenue Event [RR_REVEVTYP_CUST]
    FARR_RELTYPE,    -- Type [FARR_RELTYPE]
    VTREF,           -- Contract [CORR_VTREF_KK]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    J_1TPBUPL,       -- Branch Code [BCODE]
    INCOV,           -- Inco. Version [INCOV]
    INCO2_L,         -- Inco. Location1 [INCO2_L]
    INCO3_L,         -- Inco. Location2 [INCO3_L]
    INCO2_KEY,       -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,       -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,       -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    PACKNO,          -- Package number [PACKNO]
    PEROP_BEG,       -- Per. of Perf. Start [FM_PEROP_SD_LOW]
    PEROP_END,       -- Per. of Perf. End [FM_PEROP_SD_HIGH]
    STCODE,          -- LST-CST Code [J_1ISTCODE]
    FORMC1,          -- Form Type [J_1IFORTYP]
    FORMC2,          -- Form Type [J_1IFORTYP]
    STEUC,           -- Control Code [STEUC]
    COMPREAS,        -- Abbreviation [CMP_COMPREAS_COPY]
    MNDID,           -- Mandate Ref. [SEPA_MNDID]
    PAY_TYPE,        -- Payment Type [SEPA_PAY_TYPE]
    SEPON,           -- SEPA-Relevant [SD_SEPA_FLAG]
    MNDVG,           -- SEPA-Relevant [SD_SEPA_FLAG]
    PRIMARY KEY (MANDT, VBELN, POSNR)
);

Learn More