DISPCASEDRA
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DisputeCaseDraft | view | from | BASIC | Dispute Case Draft |
Fields (55)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | |||||
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA