DISPCASEDRA

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_DISPUTECASETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DISPCASEDRA (
    MANDT,                           -- Client [mandt]
    DISPUTECASEUUID,                 -- UUID [sysuuid_c]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    DISPUTECASECOORDINATOR,          -- Coordinator [udm_coordinator]
    DISPUTECASEROOTCAUSE,            -- Root Cause Code [udm_root_ccode]
    CASEPROCESSINGDEADLINEDATE,      -- Process. Deadline [udm_due_date]
    ORIGINALAMOUNT,                  -- Original Disputed Amount [dispute_original_disp_amt]
    DISPUTEDAMOUNT,                  -- Disputed Amount [udm_disputed_amt]
    PAIDAMOUNT,                      -- Paid [udm_paid_amt]
    CREDITEDAMOUNT,                  -- Credited [udm_credited_amt]
    WRITEOFFAMOUNT,                  -- Cleared Manually [udm_write_off_amt]
    MANUALLYCLEAREDAMOUNT,           -- Automatically Written Off [dispute_auto_write_off_amt]
    DISPUTECASECURRENCY,             -- Currency [udm_dispute_curr]
    CUSTOMERDISPUTEDAMOUNT,          -- Customer Disputed Amount [dispute_cust_disp_amt]
    CUSTOMERDISPUTEDCURRENCY,        -- Currency [udm_custdisp_curr]
    CONTACTPERSONNAME,               -- Contact Person [udm_contact_name]
    CONTACTPERSONEMAILADDRESS,       -- Email [udm_contact_email]
    CONTACTPERSONPHONENUMBER,        -- Telephone No. [udm_contact_phone]
    CONTACTPERSONFAXNUMBER,          -- Fax Number [udm_contact_fax]
    CONTACTPERSONFAXCOUNTRY,         -- C/R of Fax No. [udm_contact_faxc]
    CONTACTPERSON,                   -- Contact Person Key [udm_contact_key]
    CUSTOMER,                        -- Customer [udm_kunnr]
    COMPANYCODE,                     -- Company Code [bukrs]
    DISPUTECASEEXTERNALAPPLICATION,  -- External Appl. [udm_extappl_pro]
    CASETYPE,                        -- Case Type [scmgcase_type]
    CASEID,                          -- Case ID [scmg_ext_key]
    CASEEXTERNALREFERENCE,           -- External Reference [dispute_external_reference]
    CASECREATEDBY,                   -- Created By [scmg_create_user]
    CASECREATEDON,                   -- Created At [coll_pr_creation_date_time]
    CASELASTCHANGEDBY,               -- Changed By [scmg_change_user]
    CASELASTCHANGEDON,               -- Last Changed At [coll_pr_changed_at]
    CASECLOSEDBY,                    -- Closed By [scmg_closed_by]
    CASECLOSEDTIME,                  -- Closed At [coll_pr_closed_at]
    CASEPLANNEDCLOSEDATE,            -- Planned Close Date [scmg_plan_end_date]
    CASEPROCESSOR,                   -- Processor [scmg_processor]
    CASERESPONSIBLE,                 -- Person Responsible [dispute_person_responisble]
    CASETITLE,                       -- Case Title [dispute_title]
    CASEESCALATIONREASON,            -- Escalation Reason [scmg_escal_reason]
    CASECATEGORY,                    -- Category [scmg_category]
    CASEPRIORITY,                    -- Priority [scmg_priority]
    CASEAUTHORIZATIONLEVEL,          -- Auth. Level [scmg_secure_level]
    CASESTATUSPROFILE,               -- Status Profile [scmgstatusprofid]
    CASESTATUS,                      -- Status [scmgstatusonr]
    CASESYSTEMSTATUS,                -- System Status [scmgstatpara]
    CASEREASON,                      -- Reason [scmg_reason_code]
    CASEUSERSTATUSNAME,              -- User Status [scmgstatuserline]
    BOPFUUID,                        -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, DISPUTECASEUUID, DRAFTUUID)
);