DFKKINVBILL_I_D

Transparent Table Application Table
96 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 96 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 (96)

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 Relevant
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
cainvcgoffsettingreferencekey inv_offset_refid_kk Offsetting Ref.
cainvcgoffsettingcategory inv_offset_cat_kk Offsetting Cat.
cainvcgoffsettingprocedure inv_offset_proc_kk Offsett. Proc.
cainvcgoffsettingaction inv_offset_action_kk Action Offsett.
cainvcgoffsettinggroup inv_offset_group_kk Offsetting Grp
cainvcgoffsettingrefkeylong inv_offset_refid_long_kk Offst.Ref(Long)
raoriginaldocitemtype rai_ority_kk OrigItemType
raoriginaldocitemid rai_oriid_kk OriginalItemID
caamountperunitamount amount_per_unit_amnt_kk Amount per Quantity
caamountperunitcurrency amount_per_unit_cuky_kk Crcy Amt per Qty
caamountperunitquantityunit amount_per_unit_qtyu_kk UoM Amount
caamountperunitquantity amount_per_unit_quan_kk Qty Amt per Qty
caintcocompanycoderequesting ico_bukrs_req_kk ReqCCode
caintcocompanycodesupplying ico_bukrs_sup_kk Supplying CCode
caintcotype ico_type_kk IntSettlmntType
caintcoprocedure ico_proc_kk IntSettlmntProc
cabilltoparty fica_bill_to_party Bill-To Party
cabilltoregion fica_bill_to_region Bill-To Region
cabillfromregion fica_bill_from_region Region Dlv.Plnt
cacontrolcode fica_steuc Control Code
casupplyregion fica_supply_region Supply Regi
cabilltocountry fica_bill_to_country Bill-To Country
wbselementinternalid ps_psp_pnr WBS Element

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 Relevant [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]
    CAINVCGOFFSETTINGREFERENCEKEY,   -- Offsetting Ref. [inv_offset_refid_kk]
    CAINVCGOFFSETTINGCATEGORY,       -- Offsetting Cat. [inv_offset_cat_kk]
    CAINVCGOFFSETTINGPROCEDURE,      -- Offsett. Proc. [inv_offset_proc_kk]
    CAINVCGOFFSETTINGACTION,         -- Action Offsett. [inv_offset_action_kk]
    CAINVCGOFFSETTINGGROUP,          -- Offsetting Grp [inv_offset_group_kk]
    CAINVCGOFFSETTINGREFKEYLONG,     -- Offst.Ref(Long) [inv_offset_refid_long_kk]
    RAORIGINALDOCITEMTYPE,           -- OrigItemType [rai_ority_kk]
    RAORIGINALDOCITEMID,             -- OriginalItemID [rai_oriid_kk]
    CAAMOUNTPERUNITAMOUNT,           -- Amount per Quantity [amount_per_unit_amnt_kk]
    CAAMOUNTPERUNITCURRENCY,         -- Crcy Amt per Qty [amount_per_unit_cuky_kk]
    CAAMOUNTPERUNITQUANTITYUNIT,     -- UoM Amount [amount_per_unit_qtyu_kk]
    CAAMOUNTPERUNITQUANTITY,         -- Qty Amt per Qty [amount_per_unit_quan_kk]
    CAINTCOCOMPANYCODEREQUESTING,    -- ReqCCode [ico_bukrs_req_kk]
    CAINTCOCOMPANYCODESUPPLYING,     -- Supplying CCode [ico_bukrs_sup_kk]
    CAINTCOTYPE,                     -- IntSettlmntType [ico_type_kk]
    CAINTCOPROCEDURE,                -- IntSettlmntProc [ico_proc_kk]
    CABILLTOPARTY,                   -- Bill-To Party [fica_bill_to_party]
    CABILLTOREGION,                  -- Bill-To Region [fica_bill_to_region]
    CABILLFROMREGION,                -- Region Dlv.Plnt [fica_bill_from_region]
    CACONTROLCODE,                   -- Control Code [fica_steuc]
    CASUPPLYREGION,                  -- Supply Regi [fica_supply_region]
    CABILLTOCOUNTRY,                 -- Bill-To Country [fica_bill_to_country]
    WBSELEMENTINTERNALID,            -- WBS Element [ps_psp_pnr]
    PRIMARY KEY (MANDT, CABILLGDOCUMENT, CABILLGDOCITEM, DRAFTUUID)
);

Learn More