CADISPINVITMDRA

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

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CASEUUID, CAINVOICINGDOCUMENT, CAINVCGDOCITEM)
);

Learn More