DFKKINVBILL_I_D

Transparent Table Application Table
80 Fields 2 CDS Views

Draft table for entity R_CABILLGDOCITEMTP

DFKKINVBILL_I_D is an SAP database table in S/4HANA. Draft table for entity R_CABILLGDOCITEMTP. It contains 80 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CABillgDocItemDraft view_entity from EXTENSION Billing Document Item Drft - Extension
R_CABillgDocItemDraft view_entity from BASIC Billing Document Item Draft

Fields (80)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cabillgdocument BILLDOCNO_KK Billing Doc.
KEY cabillgdocitem BILLDOCITEM_KK Item
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
caisdocitemsimulated ITEM_SIMULATED_KK Item Simulated
cabillgdocumentitemtype BILL_ITEMTYPE_KK Item Type
cacontract VTREF_KK Contract
companycode BUKRS Company Code
camaintransaction HVORG_KK Main Trans.
casubtransaction TVORG_KK Subtransaction
cainvcgisitempostingrelevant POSTREL_KK Posting-Relevt
cainvcgisitemprintingrelevant PRINTREL_KK Print-Relevnt
cabillgdocitemamount BILL_AMOUNT_KK Amount
cabillgcurrency BILL_CURR_KK Currency
cataxisincluded TAX_INCLUDED_KK Gross
taxcode MWSKZ Tax Code
unitofmeasure MEINS Base Unit
cabillgdocitemexternalnumber REFITEM_KK External Item
cabillgdocitemisreversal REVERSALITEM_KK Reversal Item
cainvcgcorrectioncategory CORRCAT_GFN_KK Invcg Correction Category
cainvcgisnotbprelevant NOT_BPREL_KK No BP Item
cainvcgsubstitutegroupprinting PRINT_SUBSTITUTE_KK Substitute Group
caitemperiodstartdate ITEMPERIOD_FROM_KK Start Item Per.
caitemperiodenddate ITEMPERIOD_TO_KK End of Item Per
canetduedate FAEDN_KK Net Due Date
division SPART_KK Division
businessarea GSBER Business Area
businessplace FARP_BUPLA Business Place
segment SEGMT_KK Segment
profitcenter PRCTR Profit Center
caaccountdeterminationcode KOFIZ_KK Acct Determ. ID
cataxdetntype TAX_DET_TYPE_KK Tax Calculation
cataxcountry TAX_COUNTRY_KK Country/Region
cataxdatetype TAX_DATE_TYPE_KK Tax Date
cabillgtaxgroup TAX_GROUP_KK Tax Grouping
caexternaltaxdate EXT_TAX_DATE_KK Ext. Tax Date
cataxdeterminationcode ERMWSKZ Tax Determination
caaltvtaxdeterminationcode ERMWSKZ_B2B_GFN_KK Altv Tax Detn Code
caaltvtaxcode MWSKZ_B2B_KK Altern.Tax Code
caothertaxcode STRKZ_KK TxCde:Oth.Taxes
taxjurisdiction TXJCD Tax Jur.
withholdingtaxcode QSSKZ WTax Code
caisdownpaymentrequest XANZA_KK Down Payment
castatisticalitemcode STAKZ_KK Statistical key
cabillgdeferredrevenuecategory DEFREV_CAT_GFN_KK Deferred Revenue Category
cabillgdeferredrevenuedate DATE_KK Transfer date
cainvcgdfrrdrevenuestatus DEFREV_STAT_GFN_KK Deferred Revenues Status
caisrevenueaccountingrelevant RAREL_KK Rev. Acctg Relevant
carevenueaccountingservicetype RAI_SERVICE_TYPE_KK Service Type
cainvcgaccrualpostingtype BILLAC_TYPE_GFN_KK Accr/Defrl Postg Type
cabillgdocitemisbirelevant QTY_BW_REL_KK BI-Relevant
cabillgdocitemisficorelevant QTY_FI_CO_REL_KK FI/CO-Relevant
caprovidercontractitemnumber VTPOS_KK Contract Item
casubapplication SUBAP_KK Subapplication
caisprepaid PREPAID_KK Prepaid
cabillgisprepaidbalancechg PPREFILL_KK Prepaid Refill
cabillgpartnersettlementcat PSCAT_GFN_KK Partner Settlement Category
cabillgdocitemcrtnmethod BILLITEM_CRMET_KK Creation Method
cabillgfunction BILL_FUNCTION_KK Billing Funct.
cabillggrpgofadditionalitems ADD_GROUP_GFN_KK Additional Item Grouping
cabillggrpgofpaymentdata PY_GROUP_KK Pmt Data Group
cabillggroupingsourceitems SRC_GROUP_KK Source Item Grp
cabllbleitmnumber BIT_NUMBER_GFN_KK Number of Billable Items
cadiscbaseitmgroup DISC_GROUP_KK Base Item Group
careasonsecuritydeposit REASON_KK Request Reason
cabillgreqreason BILLREQRSN_GFN_KK Billing Request Reason
cabllbleitmdiscountkey DISCKEY_GFN_KK Disc Key
cabllbleitmdiscountversion DISCKEY_VERSNO_KK Version No.
cabillingquantity QUANTITY_KK Billing Quantity
cadependentitemtype DITTYPE_GFN_KK Dependent Item Type
conditiontype COND_TYPE_KK Condition Type
caaltvmdoriginalisenbld ALTMD_ORIG_KK OriglMasterData
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_invbill_i_incl_eew_ps CFD_DUMMY Dummy

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.

-- Draft table for entity R_CABILLGDOCITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVBILL_I_D (
    MANDT,                           -- Client [MANDT]
    CABILLGDOCUMENT,                 -- Billing Doc. [BILLDOCNO_KK]
    CABILLGDOCITEM,                  -- Item [BILLDOCITEM_KK]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    CAISDOCITEMSIMULATED,            -- Item Simulated [ITEM_SIMULATED_KK]
    CABILLGDOCUMENTITEMTYPE,         -- Item Type [BILL_ITEMTYPE_KK]
    CACONTRACT,                      -- Contract [VTREF_KK]
    COMPANYCODE,                     -- Company Code [BUKRS]
    CAMAINTRANSACTION,               -- Main Trans. [HVORG_KK]
    CASUBTRANSACTION,                -- Subtransaction [TVORG_KK]
    CAINVCGISITEMPOSTINGRELEVANT,    -- Posting-Relevt [POSTREL_KK]
    CAINVCGISITEMPRINTINGRELEVANT,   -- Print-Relevnt [PRINTREL_KK]
    CABILLGDOCITEMAMOUNT,            -- Amount [BILL_AMOUNT_KK]
    CABILLGCURRENCY,                 -- Currency [BILL_CURR_KK]
    CATAXISINCLUDED,                 -- Gross [TAX_INCLUDED_KK]
    TAXCODE,                         -- Tax Code [MWSKZ]
    UNITOFMEASURE,                   -- Base Unit [MEINS]
    CABILLGDOCITEMEXTERNALNUMBER,    -- External Item [REFITEM_KK]
    CABILLGDOCITEMISREVERSAL,        -- Reversal Item [REVERSALITEM_KK]
    CAINVCGCORRECTIONCATEGORY,       -- Invcg Correction Category [CORRCAT_GFN_KK]
    CAINVCGISNOTBPRELEVANT,          -- No BP Item [NOT_BPREL_KK]
    CAINVCGSUBSTITUTEGROUPPRINTING,  -- Substitute Group [PRINT_SUBSTITUTE_KK]
    CAITEMPERIODSTARTDATE,           -- Start Item Per. [ITEMPERIOD_FROM_KK]
    CAITEMPERIODENDDATE,             -- End of Item Per [ITEMPERIOD_TO_KK]
    CANETDUEDATE,                    -- Net Due Date [FAEDN_KK]
    DIVISION,                        -- Division [SPART_KK]
    BUSINESSAREA,                    -- Business Area [GSBER]
    BUSINESSPLACE,                   -- Business Place [FARP_BUPLA]
    SEGMENT,                         -- Segment [SEGMT_KK]
    PROFITCENTER,                    -- Profit Center [PRCTR]
    CAACCOUNTDETERMINATIONCODE,      -- Acct Determ. ID [KOFIZ_KK]
    CATAXDETNTYPE,                   -- Tax Calculation [TAX_DET_TYPE_KK]
    CATAXCOUNTRY,                    -- Country/Region [TAX_COUNTRY_KK]
    CATAXDATETYPE,                   -- Tax Date [TAX_DATE_TYPE_KK]
    CABILLGTAXGROUP,                 -- Tax Grouping [TAX_GROUP_KK]
    CAEXTERNALTAXDATE,               -- Ext. Tax Date [EXT_TAX_DATE_KK]
    CATAXDETERMINATIONCODE,          -- Tax Determination [ERMWSKZ]
    CAALTVTAXDETERMINATIONCODE,      -- Altv Tax Detn Code [ERMWSKZ_B2B_GFN_KK]
    CAALTVTAXCODE,                   -- Altern.Tax Code [MWSKZ_B2B_KK]
    CAOTHERTAXCODE,                  -- TxCde:Oth.Taxes [STRKZ_KK]
    TAXJURISDICTION,                 -- Tax Jur. [TXJCD]
    WITHHOLDINGTAXCODE,              -- WTax Code [QSSKZ]
    CAISDOWNPAYMENTREQUEST,          -- Down Payment [XANZA_KK]
    CASTATISTICALITEMCODE,           -- Statistical key [STAKZ_KK]
    CABILLGDEFERREDREVENUECATEGORY,  -- Deferred Revenue Category [DEFREV_CAT_GFN_KK]
    CABILLGDEFERREDREVENUEDATE,      -- Transfer date [DATE_KK]
    CAINVCGDFRRDREVENUESTATUS,       -- Deferred Revenues Status [DEFREV_STAT_GFN_KK]
    CAISREVENUEACCOUNTINGRELEVANT,   -- Rev. Acctg Relevant [RAREL_KK]
    CAREVENUEACCOUNTINGSERVICETYPE,  -- Service Type [RAI_SERVICE_TYPE_KK]
    CAINVCGACCRUALPOSTINGTYPE,       -- Accr/Defrl Postg Type [BILLAC_TYPE_GFN_KK]
    CABILLGDOCITEMISBIRELEVANT,      -- BI-Relevant [QTY_BW_REL_KK]
    CABILLGDOCITEMISFICORELEVANT,    -- FI/CO-Relevant [QTY_FI_CO_REL_KK]
    CAPROVIDERCONTRACTITEMNUMBER,    -- Contract Item [VTPOS_KK]
    CASUBAPPLICATION,                -- Subapplication [SUBAP_KK]
    CAISPREPAID,                     -- Prepaid [PREPAID_KK]
    CABILLGISPREPAIDBALANCECHG,      -- Prepaid Refill [PPREFILL_KK]
    CABILLGPARTNERSETTLEMENTCAT,     -- Partner Settlement Category [PSCAT_GFN_KK]
    CABILLGDOCITEMCRTNMETHOD,        -- Creation Method [BILLITEM_CRMET_KK]
    CABILLGFUNCTION,                 -- Billing Funct. [BILL_FUNCTION_KK]
    CABILLGGRPGOFADDITIONALITEMS,    -- Additional Item Grouping [ADD_GROUP_GFN_KK]
    CABILLGGRPGOFPAYMENTDATA,        -- Pmt Data Group [PY_GROUP_KK]
    CABILLGGROUPINGSOURCEITEMS,      -- Source Item Grp [SRC_GROUP_KK]
    CABLLBLEITMNUMBER,               -- Number of Billable Items [BIT_NUMBER_GFN_KK]
    CADISCBASEITMGROUP,              -- Base Item Group [DISC_GROUP_KK]
    CAREASONSECURITYDEPOSIT,         -- Request Reason [REASON_KK]
    CABILLGREQREASON,                -- Billing Request Reason [BILLREQRSN_GFN_KK]
    CABLLBLEITMDISCOUNTKEY,          -- Disc Key [DISCKEY_GFN_KK]
    CABLLBLEITMDISCOUNTVERSION,      -- Version No. [DISCKEY_VERSNO_KK]
    CABILLINGQUANTITY,               -- Billing Quantity [QUANTITY_KK]
    CADEPENDENTITEMTYPE,             -- Dependent Item Type [DITTYPE_GFN_KK]
    CONDITIONTYPE,                   -- Condition Type [COND_TYPE_KK]
    CAALTVMDORIGINALISENBLD,         -- OriglMasterData [ALTMD_ORIG_KK]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_INVBILL_I_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CABILLGDOCUMENT, CABILLGDOCITEM, DRAFTUUID)
);

Learn More