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]
    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)
);