DFKKINVDOC_I_D

Transparent Table Application Table
93 Fields 2 CDS Views

Draft table for entity R_CAINVCGDOCITEMTP

DFKKINVDOC_I_D is an SAP database table in S/4HANA. Draft table for entity R_CAINVCGDOCITEMTP. It contains 93 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CAInvcgDocItemDraft view_entity from EXTENSION Invoicing Document Item Drft - Extension
R_CAInvcgDocItemDraft view_entity from BASIC Invoicing Document Item Draft

Fields (93)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cainvoicingdocument invdocno_kk Invoic. Doc.
KEY cainvcgdocitem invdocitem_kk Item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
cainvcgdocumentitemtype inv_itemtype_kk Item Type
companycode bukrs Company Code
division spart_kk Division
cacontract vtref_kk Contract
caprovidercontractitemnumber vtpos_kk Contract Item
casubapplication subap_kk Subapplication
cainvcgitmaltvbusinesspartner inv_gpart_a_gfn_kk Altv Business Partner
cainvcgitmaltvcontractaccount inv_vkont_a_gfn_kk Altv Contract Account
cainvcgdocitmaltvmdcat inv_gpvkt_a_cat_gfn_kk Cat Altv Master Data
camaintransaction hvorg_kk Main Trans.
casubtransaction tvorg_kk Subtransaction
caisdocitemsimulated item_simulated_kk Item Simulated
cainvcgdocitemisreversal reversalitem_kk Reversal Item
cainvcgisinfinalamt totalrel_gfn_kk Rlvt for Invoice Total
cainvcgisitempostingrelevant postrel_kk Posting-Relevt
cainvcgisnotbprelevant not_bprel_kk No BP Item
cainvcgisitemprintingrelevant printrel_kk Print Relevant
cainvcgsubstitutegroupprinting print_substitute_kk Substitute Group
transactioncurrency blwae_kk Currency
caamountintransactioncurrency betrw_kk Amount
cainvcgdocitmloclcurrency invwaerh_kk
cainvcgdocitmamtinloclcurrency invbetrh_kk
cainvcgdocitmtaxbaseamtinlcrcy invsbash_kk
cacurrencysourcedocument srcdoc_curr_gfn_kk Source Document Currency
cainvcgsourcedocumentamount srcdoc_amt_gfn_kk Amount in SrcDoc Crcy
cagroupingcurrencytranslation currc_group_gfn_kk Crcy Translation Group
caaccountdeterminationcode kofiz_kk Acct Determ. ID
businessplace farp_bupla Business Place
businessarea fis_rbusa Business Area
cataxisincluded tax_included_kk Gross
cataxdetntype tax_det_type_kk Tax Calculation
cainvcgtaxgroupingkey taxgr_kk Tax Grpng Key
caothertaxcode strkz_kk TxCde:Oth.Taxes
taxcode mwskz Tax Code
cataxdeterminationcode ermwskz Tax Determination
taxjurisdiction txjcd Tax Jur.
catransactionkeyaccountdetn ktosl_kk Autom. Posting
caconditiontype kschl Condition Type
cataxrateinpercent tax_perc_kk Tax Percentage
taxcountry fot_tax_country Tax Ctry/Reg.
transtotaxcntrycrcycnvrsnfctr taxc_factor_kk Tax Factor C/R
cainvcgoffsettingcategory inv_offset_cat_kk Offsetting Cat.
cainvcgoffsettingprocedure inv_offset_proc_kk Offsett. Proc.
cainvcgoffsettingaction inv_offset_action_kk Action Offsett.
cataxdate txdat_kk Tax Date
cataxbaseamount sbasw_kk Tax Base Amount
cataxamountintranscurrency sbetrw_kk Tax Amount
cataxportionintranscurrency sttax_kk Tax Portion
withholdingtaxcode qsskz WTax Code
caisdownpaymentrequest xanza_kk Down Payment
castatisticalitemcode stakz_kk Statistical key
cainvcgoffsettinggroup inv_offset_group_kk Offsetting Grp
cainvcgdfrrdrevenuestatus defrev_stat_gfn_kk Deferred Revenues Status
caisrevenueaccountingrelevant rarel_kk Rev. Acctg Relevant
cainvcgrevenuegrouping rai_invgr_kk Revenue Group
carevenueaccountingservicetype rai_service_type_kk Service Type
cainvcgaccrualpostingtype billac_type_gfn_kk Accr/Defrl Postg Type
caisprepaid prepaid_kk Prepaid
unitofmeasure meins Base Unit
quantity menge_d Quantity
canetduedate faedn_kk Net Due Date
cacashdiscountduedate faeds_kk Disct Due Date
cacashdiscountrate sktpz_kk Discount rate
cainvcgdocitemdefstatus inv_xstund_kk Item(s) Deferrd
caitemperiodstartdate itemperiod_from_kk Start Item Per.
caitemperiodenddate itemperiod_to_kk End of Item Per
cainvcgrefpostingdoctype cadoctype_kk Ref. Doc. Type
cadocumentnumber opbel_gfn_kk Document
cagroupingkeydocumentitems psgrp_kk Item Grouping
cainvcggroupingkey invgr_kk Inv. Grouping
caclearingdocumentnumber augbl_kk Clearing Doc.
caclearingamountintranscrcy augbw_kk TC Clearing Amt
cainvcgdocitemcrtnmethod invitem_crmet_kk Creation Method
cainvcgfunction inv_function_kk Function
cainvcgsourcedocumentcat srcdoccat_gfn_kk Source Document Category
cainvcgsourcedocumentnumber srcdocno_gfn_kk Source Document Number
cainvcgdocitemsourceitmcat srcitemcat_kk Srce Itm Categy
cainvcgsourcedocumentitem srcdocitem_kk Source Doc.Item
cabllbleitmdiscountkey disckey_gfn_kk Disc Key
cabllbleitmdiscountversion disckey_versno_kk Version No.
cainvcgcorrectioncategory corrcat_gfn_kk Invcg Correction Category
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_CAINVCGDOCITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVDOC_I_D (
    MANDT,                           -- Client [mandt]
    CAINVOICINGDOCUMENT,             -- Invoic. Doc. [invdocno_kk]
    CAINVCGDOCITEM,                  -- Item [invdocitem_kk]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    CAINVCGDOCUMENTITEMTYPE,         -- Item Type [inv_itemtype_kk]
    COMPANYCODE,                     -- Company Code [bukrs]
    DIVISION,                        -- Division [spart_kk]
    CACONTRACT,                      -- Contract [vtref_kk]
    CAPROVIDERCONTRACTITEMNUMBER,    -- Contract Item [vtpos_kk]
    CASUBAPPLICATION,                -- Subapplication [subap_kk]
    CAINVCGITMALTVBUSINESSPARTNER,   -- Altv Business Partner [inv_gpart_a_gfn_kk]
    CAINVCGITMALTVCONTRACTACCOUNT,   -- Altv Contract Account [inv_vkont_a_gfn_kk]
    CAINVCGDOCITMALTVMDCAT,          -- Cat Altv Master Data [inv_gpvkt_a_cat_gfn_kk]
    CAMAINTRANSACTION,               -- Main Trans. [hvorg_kk]
    CASUBTRANSACTION,                -- Subtransaction [tvorg_kk]
    CAISDOCITEMSIMULATED,            -- Item Simulated [item_simulated_kk]
    CAINVCGDOCITEMISREVERSAL,        -- Reversal Item [reversalitem_kk]
    CAINVCGISINFINALAMT,             -- Rlvt for Invoice Total [totalrel_gfn_kk]
    CAINVCGISITEMPOSTINGRELEVANT,    -- Posting-Relevt [postrel_kk]
    CAINVCGISNOTBPRELEVANT,          -- No BP Item [not_bprel_kk]
    CAINVCGISITEMPRINTINGRELEVANT,   -- Print Relevant [printrel_kk]
    CAINVCGSUBSTITUTEGROUPPRINTING,  -- Substitute Group [print_substitute_kk]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    CAINVCGDOCITMLOCLCURRENCY,       -- invwaerh_kk
    CAINVCGDOCITMAMTINLOCLCURRENCY,  -- invbetrh_kk
    CAINVCGDOCITMTAXBASEAMTINLCRCY,  -- invsbash_kk
    CACURRENCYSOURCEDOCUMENT,        -- Source Document Currency [srcdoc_curr_gfn_kk]
    CAINVCGSOURCEDOCUMENTAMOUNT,     -- Amount in SrcDoc Crcy [srcdoc_amt_gfn_kk]
    CAGROUPINGCURRENCYTRANSLATION,   -- Crcy Translation Group [currc_group_gfn_kk]
    CAACCOUNTDETERMINATIONCODE,      -- Acct Determ. ID [kofiz_kk]
    BUSINESSPLACE,                   -- Business Place [farp_bupla]
    BUSINESSAREA,                    -- Business Area [fis_rbusa]
    CATAXISINCLUDED,                 -- Gross [tax_included_kk]
    CATAXDETNTYPE,                   -- Tax Calculation [tax_det_type_kk]
    CAINVCGTAXGROUPINGKEY,           -- Tax Grpng Key [taxgr_kk]
    CAOTHERTAXCODE,                  -- TxCde:Oth.Taxes [strkz_kk]
    TAXCODE,                         -- Tax Code [mwskz]
    CATAXDETERMINATIONCODE,          -- Tax Determination [ermwskz]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    CATRANSACTIONKEYACCOUNTDETN,     -- Autom. Posting [ktosl_kk]
    CACONDITIONTYPE,                 -- Condition Type [kschl]
    CATAXRATEINPERCENT,              -- Tax Percentage [tax_perc_kk]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TRANSTOTAXCNTRYCRCYCNVRSNFCTR,   -- Tax Factor C/R [taxc_factor_kk]
    CAINVCGOFFSETTINGCATEGORY,       -- Offsetting Cat. [inv_offset_cat_kk]
    CAINVCGOFFSETTINGPROCEDURE,      -- Offsett. Proc. [inv_offset_proc_kk]
    CAINVCGOFFSETTINGACTION,         -- Action Offsett. [inv_offset_action_kk]
    CATAXDATE,                       -- Tax Date [txdat_kk]
    CATAXBASEAMOUNT,                 -- Tax Base Amount [sbasw_kk]
    CATAXAMOUNTINTRANSCURRENCY,      -- Tax Amount [sbetrw_kk]
    CATAXPORTIONINTRANSCURRENCY,     -- Tax Portion [sttax_kk]
    WITHHOLDINGTAXCODE,              -- WTax Code [qsskz]
    CAISDOWNPAYMENTREQUEST,          -- Down Payment [xanza_kk]
    CASTATISTICALITEMCODE,           -- Statistical key [stakz_kk]
    CAINVCGOFFSETTINGGROUP,          -- Offsetting Grp [inv_offset_group_kk]
    CAINVCGDFRRDREVENUESTATUS,       -- Deferred Revenues Status [defrev_stat_gfn_kk]
    CAISREVENUEACCOUNTINGRELEVANT,   -- Rev. Acctg Relevant [rarel_kk]
    CAINVCGREVENUEGROUPING,          -- Revenue Group [rai_invgr_kk]
    CAREVENUEACCOUNTINGSERVICETYPE,  -- Service Type [rai_service_type_kk]
    CAINVCGACCRUALPOSTINGTYPE,       -- Accr/Defrl Postg Type [billac_type_gfn_kk]
    CAISPREPAID,                     -- Prepaid [prepaid_kk]
    UNITOFMEASURE,                   -- Base Unit [meins]
    QUANTITY,                        -- Quantity [menge_d]
    CANETDUEDATE,                    -- Net Due Date [faedn_kk]
    CACASHDISCOUNTDUEDATE,           -- Disct Due Date [faeds_kk]
    CACASHDISCOUNTRATE,              -- Discount rate [sktpz_kk]
    CAINVCGDOCITEMDEFSTATUS,         -- Item(s) Deferrd [inv_xstund_kk]
    CAITEMPERIODSTARTDATE,           -- Start Item Per. [itemperiod_from_kk]
    CAITEMPERIODENDDATE,             -- End of Item Per [itemperiod_to_kk]
    CAINVCGREFPOSTINGDOCTYPE,        -- Ref. Doc. Type [cadoctype_kk]
    CADOCUMENTNUMBER,                -- Document [opbel_gfn_kk]
    CAGROUPINGKEYDOCUMENTITEMS,      -- Item Grouping [psgrp_kk]
    CAINVCGGROUPINGKEY,              -- Inv. Grouping [invgr_kk]
    CACLEARINGDOCUMENTNUMBER,        -- Clearing Doc. [augbl_kk]
    CACLEARINGAMOUNTINTRANSCRCY,     -- TC Clearing Amt [augbw_kk]
    CAINVCGDOCITEMCRTNMETHOD,        -- Creation Method [invitem_crmet_kk]
    CAINVCGFUNCTION,                 -- Function [inv_function_kk]
    CAINVCGSOURCEDOCUMENTCAT,        -- Source Document Category [srcdoccat_gfn_kk]
    CAINVCGSOURCEDOCUMENTNUMBER,     -- Source Document Number [srcdocno_gfn_kk]
    CAINVCGDOCITEMSOURCEITMCAT,      -- Srce Itm Categy [srcitemcat_kk]
    CAINVCGSOURCEDOCUMENTITEM,       -- Source Doc.Item [srcdocitem_kk]
    CABLLBLEITMDISCOUNTKEY,          -- Disc Key [disckey_gfn_kk]
    CABLLBLEITMDISCOUNTVERSION,      -- Version No. [disckey_versno_kk]
    CAINVCGCORRECTIONCATEGORY,       -- Invcg Correction Category [corrcat_gfn_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, CAINVOICINGDOCUMENT, CAINVCGDOCITEM, DRAFTUUID)
);

Learn More