DFKKINVDOC_I_D

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

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-Relevnt
cainvcgsubstitutegroupprinting PRINT_SUBSTITUTE_KK Substitute Group
transactioncurrency BLWAE_KK Currency
caamountintransactioncurrency BETRW_KK Amount
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
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_invdoc_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_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-Relevnt [PRINTREL_KK]
    CAINVCGSUBSTITUTEGROUPPRINTING,  -- Substitute Group [PRINT_SUBSTITUTE_KK]
    TRANSACTIONCURRENCY,             -- Currency [BLWAE_KK]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [BETRW_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]
    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_INVDOC_I_INCL_EEW_PS,      -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CAINVOICINGDOCUMENT, CAINVCGDOCITEM, DRAFTUUID)
);

Learn More