DISPCASEDRA

Transparent Table Application Table

Draft table for entity R_DISPUTECASETP

DISPCASEDRA is an SAP database table in S/4HANA. Draft table for entity R_DISPUTECASETP. It contains 55 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DisputeCaseDraft view from BASIC Dispute Case Draft

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY disputecaseuuid SYSUUID_C UUID
KEY draftuuid SDRAFT_UUID Draft Document ID
disputecasecoordinator UDM_COORDINATOR Coordinator
disputecaserootcause UDM_ROOT_CCODE Root Cause Code
caseprocessingdeadlinedate UDM_DUE_DATE Process. Deadline
originalamount DISPUTE_ORIGINAL_DISP_AMT Original Disputed Amount
disputedamount UDM_DISPUTED_AMT Disputed Amount
paidamount UDM_PAID_AMT Paid
creditedamount UDM_CREDITED_AMT Credited
writeoffamount UDM_WRITE_OFF_AMT Cleared Manually
manuallyclearedamount DISPUTE_AUTO_WRITE_OFF_AMT Automatically Written Off
disputecasecurrency UDM_DISPUTE_CURR Currency
customerdisputedamount DISPUTE_CUST_DISP_AMT Customer Disputed Amount
customerdisputedcurrency UDM_CUSTDISP_CURR Currency
contactpersonname UDM_CONTACT_NAME Contact Person
contactpersonemailaddress UDM_CONTACT_EMAIL Email
contactpersonphonenumber UDM_CONTACT_PHONE Telephone No.
contactpersonfaxnumber UDM_CONTACT_FAX Fax Number
contactpersonfaxcountry UDM_CONTACT_FAXC C/R of Fax No.
contactperson UDM_CONTACT_KEY Contact Person Key
customer UDM_KUNNR Customer
companycode BUKRS Company Code
disputecaseexternalapplication UDM_EXTAPPL_PRO External Appl.
casetype SCMGCASE_TYPE Case Type
caseid SCMG_EXT_KEY Case ID
caseexternalreference DISPUTE_EXTERNAL_REFERENCE External Reference
casecreatedby SCMG_CREATE_USER Created By
casecreatedon COLL_PR_CREATION_DATE_TIME Created At
caselastchangedby SCMG_CHANGE_USER Changed By
caselastchangedon COLL_PR_CHANGED_AT Last Changed At
caseclosedby SCMG_CLOSED_BY Closed By
caseclosedtime COLL_PR_CLOSED_AT Closed At
caseplannedclosedate SCMG_PLAN_END_DATE Planned Close Date
caseprocessor SCMG_PROCESSOR Processor
caseresponsible DISPUTE_PERSON_RESPONISBLE Person Responsible
casetitle DISPUTE_TITLE Case Title
caseescalationreason SCMG_ESCAL_REASON Escalation Reason
casecategory SCMG_CATEGORY Category
casepriority SCMG_PRIORITY Priority
caseauthorizationlevel SCMG_SECURE_LEVEL Auth. Level
casestatusprofile SCMGSTATUSPROFID Status Profile
casestatus SCMGSTATUSONR Status
casesystemstatus SCMGSTATPARA System Status
casereason SCMG_REASON_CODE Reason
caseuserstatusname SCMGSTATUSERLINE User Status
bopfuuid SDRAFT_UUID Draft Document ID
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_dispute_incl_eew_ps CFD_DUMMY Dummy

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]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_DISPUTE_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, DISPUTECASEUUID, DRAFTUUID)
);