CADISPINVCGDRA

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_CADISPUTEDINVCGDOCTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CADISPINVCGDRA (
    MANDT,                           -- Client [mandt]
    CASEUUID,                        -- UUID [sysuuid_c]
    CAINVOICINGDOCUMENT,             -- Invoic. Doc. [invdocno_kk]
    CAOFFICIALDOCUMENTNUMBER,        -- Offic. Doc. No. [exbel_no_conv_kk]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    CONTRACTACCOUNT,                 -- Contract Acct [vkont_kk]
    CAINVCGTYPE,                     -- Invoicing Type [inv_type_kk]
    CAINVCGDOCPERIODDATE,            -- Invoicing Per. [invperiod_kk]
    DOCUMENTDATE,                    -- Document Date [bldat]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    CAINVCGPROCESS,                  -- Invoicing Proc. [inv_process_kk]
    CAINVCGDOCUMENTTYPE,             -- Document Type [doctype_kk]
    CADUNNINGCOUNTER,                -- Dunning counter [mazae_kk]
    CAINVCGDOCHASCONTROLDOC,         -- Clrfctn Case Control Doc [inv_cfcsimulated_gfn_kk]
    APPLICATIONFORM,                 -- Forms [formname_kk]
    CAINVCGDOCUMENTPRINTDATE,        -- Print Date [printdat_kk]
    CAINVCGDOCISLOCKEDFORPRINTING,   -- Printing Lock [printlock_kk]
    CANETDUEDATE,                    -- Net Due Date [faedn_kk]
    CAINVCGDOCUMENTREVERSALREASON,   -- Reversal Reason [revreason_kk]
    CAINVCGISDOCUMENTPOSTED,         -- Document Posted [inv_posted_kk]
    CAINVCGISDOCUMENTPRELIMINARY,    -- Preliminary Invoice [inv_preliminary_gfn_kk]
    CAINVCGISDOCUMENTSIMULATED,      -- Doc. Simulated [inv_simulated_kk]
    CAPOSTINGDATE,                   -- Posting Date [budat_kk]
    CAAPPLICATIONAREA,               -- ApplicationArea [applk_kk]
    CAINVCGTECHNICALDOCUMENTTYPE,    -- Technical Document Type [techdoctype_gfn_kk]
    CAINVCGTARGETPROCESS,            -- Target Process [targprocess_kk]
    CAINVCGMASTERDATATYPE,           -- MasterData Type [mdcat_ci_kk]
    ALTVCONTRACTACCTFORCOLLVBILLS,   -- Coll. Bill Acct [abwvk_kk]
    CASUBSTITUTEDOCUMENTNUMBER,      -- Sub. Doc. [abwbl_kk]
    CREATEDBYUSER,                   -- Created By [crnam]
    CAINVCGCREATIONDATE,             -- Invoiced On [invdoc_crdat_kk]
    CAINVCGCREATIONTIME,             -- Invoiced At [invdoc_crtim_kk]
    CAINVCGCREATIONDATETIME,         -- Invoiced On [invdoc_crtsmp_kk]
    CAINVCGDOCCREATIONMODE,          -- CreatnMode [inv_crmode_kk]
    CAINVCGNMBROFINVOICINGDOCITEMS,  -- Number of Items [invdoc_recnum_kk]
    CAINVCGDOCINTERNALNUMBER,        -- Invoicg Run No. [invrunno_kk]
    CARECONCILIATIONKEY,             -- Reconcil. Key [fikey_kk]
    CACASHDISCOUNTDUEDATE,           -- Disct Due Date [faeds_kk]
    CACASHDISCOUNTRATE,              -- Discount rate [sktpz_kk]
    CAINVCGPRELIMINARYCATEGORY,      -- Category Prlm Invoice [prlinv_cat_gfn_kk]
    CAPRELIMINVCGDOCVALUE,           -- Counter PrlmInv [prlinv_cnt_kk]
    CAPRELIMINARYINVCGDOCSTATUS,     -- Status Prlm Invoice [prlinv_status_gfn_kk]
    CAINVCGCATEGORY,                 -- Invoicing Cat. [inv_category_kk]
    CAINVCGREVERSALDOCUMENT,         -- Reversal Doc. [inv_reversaldoc_kk]
    CAINVCGREVERSEDDOCUMENT,         -- Reversed Invoicing Doc [inv_reverseddoc_gfn_kk]
    CAINVCGCORRECTIONCATEGORY,       -- Invcg Correction Category [corrcat_gfn_kk]
    CAPAYMENTMETHOD,                 -- Payment Method [pymet_kk]
    CAPAYMENTFORMNUMBER,             -- Payment Form [nrzas_kk]
    FORMIDFORATTACHEDPAYMENTMEDIUM,  -- Form ID [fidzt]
    CAKEYIDENTIFICATION,             -- Key ID [exkid_kk]
    CAPARTNERSETTLEMENTRULE,         -- Settlement Rule [ptsrl_kk]
    COMPANYCODE,                     -- Company Code [bukrs]
    BUSINESSPLACE,                   -- Business place [bupla]
    CACONTRACT,                      -- Contract [vtref_kk]
    CASUBAPPLICATION,                -- Subapplication [subap_kk]
    CAINVCGBASEDATE,                 -- Baseline Date [invoice_basedate_kk]
    CAINVCGDOCPERIODCATEGORY,        -- Period Category [invpercat_kk]
    CAINVCGDOCPERIODSTARTDATE,       -- Inv. Period Frm [invperiod_from_kk]
    CAINVCGDOCHASCHARGEORDISCITEMS,  -- Charge/Discount Exists [chgdoc_ex_gfn_kk]
    CAINVCGBOLLOTAXPOSTSTATUS,       -- Bollo Posted [inv_bollotax_kk]
    CAINVCGDOCISPARTOFLIST,          -- Inv. Subdoc. [xsubinv_kk]
    CAINVCGDOCHASOBJECTRELATION,     -- ObjRel. Exist [xinvdoc_x_kk]
    CAINVCGDOCHASSEPAPRENOTIF,       -- Pre-Notif. [inv_sepa_prenot_kk]
    CAINVCGDOCEXTERNAL,              -- External Invoicing Doc [ext_invdocno_gfn_kk]
    CAINVCGDOCUMENTTYPETEXT,         -- Doc. Type Text [doctype_txt_kk]
    CAINVCGPROCESSTEXT,              -- Process Text [inv_process_txt_kk]
    CAINVCGTYPETEXT,                 -- Inv. Type Text [inv_type_txt_kk]
    CAINVCGCATEGORYTEXT,             -- Inv. Cat. Text [inv_category_txt_kk]
    CAINVCGDOCTECHDOCTYPETEXT,       -- Description [description_kk]
    CAINVCGTARGETPROCTEXT,           -- Explanation [text50]
    CAINVCGMASTERDATATYPETEXT,       -- Description [description_kk]
    CAINVCGDOCCREATIONMODETEXT,      -- Description [description_kk]
    CAINVCGPRELIMINARYCATEGORYTXT,   -- Explanation [prlinv_cat_txt_kk]
    CAPRELIMINARYINVCGDOCSTATUSTXT,  -- Description [descr_60_kk]
    CAINVCGDOCREVERSALREASONTEXT,    -- Reversal Reason [revreason_txt_kk]
    CAINVCGCORRECTIONCATTEXT,        -- Description [description_kk]
    CAINVCGDOCLOCKEDFORPRINTTEXT,    -- Description [description_kk]
    CAINVCGPERIODCATTEXT,            -- Text [txt40]
    CAINVCGDOCCHRGDISCITEMSTEXT,     -- Description [description_kk]
    CAINVCGBOLLOTAXPOSTSTATTEXT,     -- Description [description_kk]
    CAINVCGDOCPARTOFLISTTEXT,        -- Description [description_kk]
    COMPANYCODENAME,                 -- Company Name [butxt]
    PRIMARY KEY (MANDT, CASEUUID, CAINVOICINGDOCUMENT)
);