CADISPINVITMDRA

Transparent Table Application Table
105 Fields 1 CDS Views

Draft table for entity R_CADISPUTEDINVCGDOCITEMTP

CADISPINVITMDRA is an SAP database table in S/4HANA. Draft table for entity R_CADISPUTEDINVCGDOCITEMTP. It contains 105 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CADisputedInvcgDocItemDraft view_entity from BASIC Not disputed invoicing item draft

Fields (105)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY caseuuid sysuuid_c UUID
KEY cainvoicingdocument invdocno_kk Invoic. Doc.
KEY cainvcgdocitem invdocitem_kk Item
caisdocitemsimulated item_simulated_kk Item Simulated
cainvcgdocumentitemtype inv_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
cainvcgisinfinalamt totalrel_gfn_kk Rlvt for Invoice Total
transactioncurrency blwae_kk Currency
caamountintransactioncurrency betrw_kk Amount
cataxisincluded tax_included_kk Gross
cainvcgtaxgroupingkey taxgr_kk Tax Grpng Key
taxcode mwskz Tax Code
cataxrateinpercent tax_perc_kk Tax Percentage
taxcountry fot_tax_country Tax Ctry/Reg.
quantity menge_d Quantity
canetduedate faedn_kk Net Due Date
division spart_kk Division
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
cainvcgdocitemisreversal reversalitem_kk Reversal Item
cainvcgisnotbprelevant not_bprel_kk No BP Item
cainvcgsubstitutegroupprinting print_substitute_kk Substitute Group
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
cataxdetntype tax_det_type_kk Tax Calculation
caothertaxcode strkz_kk TxCde:Oth.Taxes
cataxdeterminationcode ermwskz Tax Determination
taxjurisdiction txjcd Tax Jur.
catransactionkeyaccountdetn ktosl_kk Autom. Posting
caconditiontype kschl Condition Type
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
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
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.
caapplicationarea applk_kk ApplicationArea
companycodecountry land1 Country/Reg.
cainvcgcorrectioncategory corrcat_gfn_kk Invcg Correction Category
companycodename butxt Company Name
camaintransactionname hvorg_txt Main Transactn
casubtransactionname tvorg_txt Subtransaction
cainvcgdocitemtypetext inv_itemtype_txt_kk ItmTypText
casubapplicationtext subap_text_kk Subapplication
divisionname divisionname Division Description
cainvcgdocitmaltvmdcattext description_kk Description
businessareaname farp_gtext BA Description
taxcountryname landx50 Country/Region
cataxdetntypetext description_kk Description
caothertaxcodename strkz_txt_kk Name
taxcodename fis_mwskz_name Tax Code Name
taxjurisdictionname text1_txjt Description
conditiontypename vtxtm Description
catransactionkeyacctdetntext description_kk Description
cadeferredrevenuestatustext description_kk Description
cainvcgdocitmdefstatustext description_kk Description
carevnacctgservicetypetext rai_service_type_txt_kk Service Type
cainvcgaccrualpostingtypetxt billac_type_txt_kk A/D Type Text
cainvcgrefpostgdoctypetxt cadoctype_txt_kk RefDocTypeText
cainvcgdocitmcrtnmethodtext description_kk Description
cainvcgfunctiontext inv_function_txt_kk Function Text
cainvcgsourcedoccattext text50 Explanation
cainvcgdocitmsrceitmcattext description_kk Description
cabllbleitmdiscountkeytext disckey_txt_kk Name
unitofmeasurename mseht Meas. Unit Text

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_CADISPUTEDINVCGDOCITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CADISPINVITMDRA (
    MANDT,                           -- Client [mandt]
    CASEUUID,                        -- UUID [sysuuid_c]
    CAINVOICINGDOCUMENT,             -- Invoic. Doc. [invdocno_kk]
    CAINVCGDOCITEM,                  -- Item [invdocitem_kk]
    CAISDOCITEMSIMULATED,            -- Item Simulated [item_simulated_kk]
    CAINVCGDOCUMENTITEMTYPE,         -- Item Type [inv_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]
    CAINVCGISINFINALAMT,             -- Rlvt for Invoice Total [totalrel_gfn_kk]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    CATAXISINCLUDED,                 -- Gross [tax_included_kk]
    CAINVCGTAXGROUPINGKEY,           -- Tax Grpng Key [taxgr_kk]
    TAXCODE,                         -- Tax Code [mwskz]
    CATAXRATEINPERCENT,              -- Tax Percentage [tax_perc_kk]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    QUANTITY,                        -- Quantity [menge_d]
    CANETDUEDATE,                    -- Net Due Date [faedn_kk]
    DIVISION,                        -- Division [spart_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]
    CAINVCGDOCITEMISREVERSAL,        -- Reversal Item [reversalitem_kk]
    CAINVCGISNOTBPRELEVANT,          -- No BP Item [not_bprel_kk]
    CAINVCGSUBSTITUTEGROUPPRINTING,  -- Substitute Group [print_substitute_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]
    CATAXDETNTYPE,                   -- Tax Calculation [tax_det_type_kk]
    CAOTHERTAXCODE,                  -- TxCde:Oth.Taxes [strkz_kk]
    CATAXDETERMINATIONCODE,          -- Tax Determination [ermwskz]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    CATRANSACTIONKEYACCOUNTDETN,     -- Autom. Posting [ktosl_kk]
    CACONDITIONTYPE,                 -- Condition Type [kschl]
    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]
    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]
    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]
    CAAPPLICATIONAREA,               -- ApplicationArea [applk_kk]
    COMPANYCODECOUNTRY,              -- Country/Reg. [land1]
    CAINVCGCORRECTIONCATEGORY,       -- Invcg Correction Category [corrcat_gfn_kk]
    COMPANYCODENAME,                 -- Company Name [butxt]
    CAMAINTRANSACTIONNAME,           -- Main Transactn [hvorg_txt]
    CASUBTRANSACTIONNAME,            -- Subtransaction [tvorg_txt]
    CAINVCGDOCITEMTYPETEXT,          -- ItmTypText [inv_itemtype_txt_kk]
    CASUBAPPLICATIONTEXT,            -- Subapplication [subap_text_kk]
    DIVISIONNAME,                    -- Division Description [divisionname]
    CAINVCGDOCITMALTVMDCATTEXT,      -- Description [description_kk]
    BUSINESSAREANAME,                -- BA Description [farp_gtext]
    TAXCOUNTRYNAME,                  -- Country/Region [landx50]
    CATAXDETNTYPETEXT,               -- Description [description_kk]
    CAOTHERTAXCODENAME,              -- Name [strkz_txt_kk]
    TAXCODENAME,                     -- Tax Code Name [fis_mwskz_name]
    TAXJURISDICTIONNAME,             -- Description [text1_txjt]
    CONDITIONTYPENAME,               -- Description [vtxtm]
    CATRANSACTIONKEYACCTDETNTEXT,    -- Description [description_kk]
    CADEFERREDREVENUESTATUSTEXT,     -- Description [description_kk]
    CAINVCGDOCITMDEFSTATUSTEXT,      -- Description [description_kk]
    CAREVNACCTGSERVICETYPETEXT,      -- Service Type [rai_service_type_txt_kk]
    CAINVCGACCRUALPOSTINGTYPETXT,    -- A/D Type Text [billac_type_txt_kk]
    CAINVCGREFPOSTGDOCTYPETXT,       -- RefDocTypeText [cadoctype_txt_kk]
    CAINVCGDOCITMCRTNMETHODTEXT,     -- Description [description_kk]
    CAINVCGFUNCTIONTEXT,             -- Function Text [inv_function_txt_kk]
    CAINVCGSOURCEDOCCATTEXT,         -- Explanation [text50]
    CAINVCGDOCITMSRCEITMCATTEXT,     -- Description [description_kk]
    CABLLBLEITMDISCOUNTKEYTEXT,      -- Name [disckey_txt_kk]
    UNITOFMEASURENAME,               -- Meas. Unit Text [mseht]
    PRIMARY KEY (MANDT, CASEUUID, CAINVOICINGDOCUMENT, CAINVCGDOCITEM)
);

Learn More