DFKKINVBILL_S

Transparent Table Application Table
31 Fields 1 CDS Views

Source Items in Billing Document

DFKKINVBILL_S is an SAP database table in S/4HANA. Source Items in Billing Document. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CABillgDocSource view_entity from BASIC Quellposition des Abrechnungsbelegs

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY billdocno BILLDOCNO_KK Billing Doc.
KEY billdocsrcitem BILLDOCSRCITEM_KK Source Item
src_group SRC_GROUP_KK Source Item Grp
billdocrectype BILLDOCRECTYPE_KK Record Type
simulated SIMULATED_KK Simulation Doc.
crdate BILLCRDATE_KK Billed On
citcat CITCAT_KK Class
bitcat BITCAT_KK Class
bitstatus BITSTATUS_KK Status
bitrectype BITRECTYPE_KK Record Type
bit_dbtab BIT_DBTAB_KK BIT DB Table
bit_grpno BIT_GRPNO_KK Bill.Items Grp
subprocess SUB_PROCESS_KK Subprocess
bittype BITTYPE_KK Bill.Item Type
srctatype SRCTATYPE_KK SrcTransType
srcreftype BILL_SRCREFTYPE_KK Reference Type
srcref BILL_SRCREF_KK Reference
altmd_orig ALTMD_ORIG_KK OriglMasterData
gpart_orig GPART_ORIG_KK Orig. BPartner
vkont_orig VKONT_ORIG_KK Orig. Cont.Acct
xprimary XPRIMARY_KK Primary Item
reltype_primary RELTYPE_PRIMARY_KK Rel. Type
bitmonth BITMONTH_KK Month of Origin
bitcrmonth BITCRMONTH_KK Creation Month
bit_amount BIT_AMOUNT_KK Amount
bit_curr BIT_CURR_KK Currency
bit_quantity BIT_QUANTITY_KK Billing Quantity
bit_qty_unit BIT_QTY_UNIT_KK Unit of Measure
bit_number BIT_NUMBER_KK Number of Items
billac_type BILLAC_TYPE_KK A/D PostingType

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.

-- Source Items in Billing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVBILL_S (
    MANDT,            -- Client [MANDT]
    BILLDOCNO,        -- Billing Doc. [BILLDOCNO_KK]
    BILLDOCSRCITEM,   -- Source Item [BILLDOCSRCITEM_KK]
    SRC_GROUP,        -- Source Item Grp [SRC_GROUP_KK]
    BILLDOCRECTYPE,   -- Record Type [BILLDOCRECTYPE_KK]
    SIMULATED,        -- Simulation Doc. [SIMULATED_KK]
    CRDATE,           -- Billed On [BILLCRDATE_KK]
    CITCAT,           -- Class [CITCAT_KK]
    BITCAT,           -- Class [BITCAT_KK]
    BITSTATUS,        -- Status [BITSTATUS_KK]
    BITRECTYPE,       -- Record Type [BITRECTYPE_KK]
    BIT_DBTAB,        -- BIT DB Table [BIT_DBTAB_KK]
    BIT_GRPNO,        -- Bill.Items Grp [BIT_GRPNO_KK]
    SUBPROCESS,       -- Subprocess [SUB_PROCESS_KK]
    BITTYPE,          -- Bill.Item Type [BITTYPE_KK]
    SRCTATYPE,        -- SrcTransType [SRCTATYPE_KK]
    SRCREFTYPE,       -- Reference Type [BILL_SRCREFTYPE_KK]
    SRCREF,           -- Reference [BILL_SRCREF_KK]
    ALTMD_ORIG,       -- OriglMasterData [ALTMD_ORIG_KK]
    GPART_ORIG,       -- Orig. BPartner [GPART_ORIG_KK]
    VKONT_ORIG,       -- Orig. Cont.Acct [VKONT_ORIG_KK]
    XPRIMARY,         -- Primary Item [XPRIMARY_KK]
    RELTYPE_PRIMARY,  -- Rel. Type [RELTYPE_PRIMARY_KK]
    BITMONTH,         -- Month of Origin [BITMONTH_KK]
    BITCRMONTH,       -- Creation Month [BITCRMONTH_KK]
    BIT_AMOUNT,       -- Amount [BIT_AMOUNT_KK]
    BIT_CURR,         -- Currency [BIT_CURR_KK]
    BIT_QUANTITY,     -- Billing Quantity [BIT_QUANTITY_KK]
    BIT_QTY_UNIT,     -- Unit of Measure [BIT_QTY_UNIT_KK]
    BIT_NUMBER,       -- Number of Items [BIT_NUMBER_KK]
    BILLAC_TYPE,      -- A/D PostingType [BILLAC_TYPE_KK]
    PRIMARY KEY (MANDT, BILLDOCNO, BILLDOCSRCITEM)
);

Learn More