VKDFS

Transparent Table Application Table
30 Fields 3 CDS Views

SD Index: Billing Initiator

VKDFS is an SAP database table in S/4HANA. SD Index: Billing Initiator. It contains 30 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_BillingDueListItem view from EXTENSION Extension Include View for VKDFS
I_BillingDueListItem view from BASIC Billing Due List Item
SHSM_VF_D view from CDS view replacing SHVF_D

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fktyp FKTYP BillingCategory
KEY vkorg VKORG Sales Org.
KEY fkdat FKDAT Billing Date
KEY kunnr KUNAG Sold-to Party
KEY fkart FKART Billing Type
KEY lland LLAND Dest. Ctry/Reg
KEY vbeln VBELN SD Document
vbtyp VBTYPL Document Cat.
adrnr ADRNR_AG Sold-To Address
sortkri SORTKRI Sort Term
faksk FAKSK Billing Block
vtweg VTWEG Distr. Channel
spart SPART Division
vstel VSTEL Shipping Point
pdstk PDSTK POD Status
netwr NETWR Net Value
waerk WAERK Doc. Currency
bdr_ref BDR_REF BDR Source Document
bdr_ref_logsys BDR_REF_LOGSYS BDR Source System
draft_type DRAFT_MODE Draft mode
dbd_ref DBD_REF Draft Bill.Doc.Ref.
vbart VBART SD Doc. Type
solution_order_id CRMS4_SOLO_OBJECT_ID Solution Order
ernam ERNAM Created By
erdat ERDAT Created On
erzet ERZET Time
adrnp AD_PERSNUM Person Number
addr_type AD_ADRTYPE Address Type
dummy_sdbillindex_incl_eew_ps DUMMY Dummy function in length 1

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.

-- SD Index: Billing Initiator
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VKDFS (
    MANDT,                          -- Client [MANDT]
    FKTYP,                          -- BillingCategory [FKTYP]
    VKORG,                          -- Sales Org. [VKORG]
    FKDAT,                          -- Billing Date [FKDAT]
    KUNNR,                          -- Sold-to Party [KUNAG]
    FKART,                          -- Billing Type [FKART]
    LLAND,                          -- Dest. Ctry/Reg [LLAND]
    VBELN,                          -- SD Document [VBELN]
    VBTYP,                          -- Document Cat. [VBTYPL]
    ADRNR,                          -- Sold-To Address [ADRNR_AG]
    SORTKRI,                        -- Sort Term [SORTKRI]
    FAKSK,                          -- Billing Block [FAKSK]
    VTWEG,                          -- Distr. Channel [VTWEG]
    SPART,                          -- Division [SPART]
    VSTEL,                          -- Shipping Point [VSTEL]
    PDSTK,                          -- POD Status [PDSTK]
    NETWR,                          -- Net Value [NETWR]
    WAERK,                          -- Doc. Currency [WAERK]
    BDR_REF,                        -- BDR Source Document [BDR_REF]
    BDR_REF_LOGSYS,                 -- BDR Source System [BDR_REF_LOGSYS]
    DRAFT_TYPE,                     -- Draft mode [DRAFT_MODE]
    DBD_REF,                        -- Draft Bill.Doc.Ref. [DBD_REF]
    VBART,                          -- SD Doc. Type [VBART]
    SOLUTION_ORDER_ID,              -- Solution Order [CRMS4_SOLO_OBJECT_ID]
    ERNAM,                          -- Created By [ERNAM]
    ERDAT,                          -- Created On [ERDAT]
    ERZET,                          -- Time [ERZET]
    ADRNP,                          -- Person Number [AD_PERSNUM]
    ADDR_TYPE,                      -- Address Type [AD_ADRTYPE]
    DUMMY_SDBILLINDEX_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, FKTYP, VKORG, FKDAT, KUNNR, FKART, LLAND, VBELN)
);

Learn More