P_DISPUTECASEDRAFT
P_DISPUTECASEDRAFT is a CDS View in S/4HANA. It contains 61 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_CollsHeadOfficeDisputeCase | view | inner | COMPOSITE | Head Office Dispute Case |
| R_DisputeCaseDraftCollsSgmtTP | view | inner | TRANSACTIONAL | Dispute Case TP |
| R_DisputeCaseDraftTP | view | from | TRANSACTIONAL | Dispute Case with Draft |
Fields (61)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DisputeCaseUUID | DisputeCaseUUID | 1 |
| _AuthLevel | _AuthLevel | 1 | |
| _CaseCategory | _CaseCategory | 1 | |
| _CaseSystemStatus | _CaseSystemStatus | 1 | |
| _CaseTypes | _CaseTypes | 1 | |
| _CompanyCode | _CompanyCode | 2 | |
| _Country | _Country | 1 | |
| _Customer | _Customer | 1 | |
| _DisputeCaseExternalAppl | _DisputeCaseExternalAppl | 1 | |
| _Escalation | _Escalation | 1 | |
| _Individual | _Individual | 1 | |
| _Priority | _Priority | 1 | |
| _Reasons | _Reasons | 1 | |
| _RootCause | _RootCause | 1 | |
| _StatProfile | _StatProfile | 1 | |
| CaseAuthorizationLevel | CaseAuthorizationLevel | 1 | |
| CaseCategory | CaseCategory | 1 | |
| CaseClosedBy | CaseClosedBy | 1 | |
| CaseClosedTime | CaseClosedTime | 1 | |
| CaseCreatedBy | CaseCreatedBy | 1 | |
| CaseCreatedOn | CaseCreatedOn | 1 | |
| CaseEscalationReason | CaseEscalationReason | 1 | |
| CaseExternalReference | CaseExternalReference | 1 | |
| CaseID | CaseID | 1 | |
| CaseLastChangedBy | CaseLastChangedBy | 1 | |
| CaseLastChangedOn | CaseLastChangedOn | 1 | |
| CasePlannedCloseDate | CasePlannedCloseDate | 1 | |
| CasePriority | CasePriority | 1 | |
| CaseProcessingDeadlineDate | CaseProcessingDeadlineDate | 1 | |
| CaseProcessor | CaseProcessor | 1 | |
| CaseReason | CaseReason | 1 | |
| CaseResponsible | CaseResponsible | 1 | |
| CaseStatus | CaseStatus | 1 | |
| CaseStatusProfile | CaseStatusProfile | 1 | |
| CaseSystemStatus | CaseSystemStatus | 1 | |
| CaseTitle | CaseTitle | 1 | |
| CaseType | CaseType | 1 | |
| CompanyCode | CompanyCode | 2 | |
| ContactPersonEmailAddress | ContactPersonEmailAddress | 1 | |
| ContactPersonFaxCountry | ContactPersonFaxCountry | 1 | |
| ContactPersonFaxNumber | ContactPersonFaxNumber | 1 | |
| ContactPersonName | ContactPersonName | 1 | |
| ContactPersonPhoneNumber | ContactPersonPhoneNumber | 1 | |
| CreditedAmount | CreditedAmount | 1 | |
| Customer | Customer | 1 | |
| CustomerDisputedAmount | CustomerDisputedAmount | 1 | |
| CustomerDisputedCurrency | CustomerDisputedCurrency | 1 | |
| DisputeCaseCoordinator | DisputeCaseCoordinator | 1 | |
| DisputeCaseCurrency | DisputeCaseCurrency | 1 | |
| DisputeCaseExternalApplication | DisputeCaseExternalApplication | 1 | |
| DisputeCaseRootCause | DisputeCaseRootCause | 1 | |
| DisputedAmount | DisputedAmount | 1 | |
| DraftCreationDateTime | DraftCreationDateTime | 1 | |
| DraftLastChangedDateTime | DraftLastChangedDateTime | 1 | |
| DraftUUID | DraftUUID | 1 | |
| HasActiveEntity | HasActiveEntity | 1 | |
| IsActiveEntity | IsActiveEntity | 1 | |
| ManuallyClearedAmount | ManuallyClearedAmount | 1 | |
| OriginalAmount | OriginalAmount | 1 | |
| PaidAmount | PaidAmount | 1 | |
| WriteOffAmount | WriteOffAmount | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DISPUTECASEDRAFT (
DISPUTECASEUUID,
_AUTHLEVEL,
_CASECATEGORY,
_CASESYSTEMSTATUS,
_CASETYPES,
_COMPANYCODE,
_COUNTRY,
_CUSTOMER,
_DISPUTECASEEXTERNALAPPL,
_ESCALATION,
_INDIVIDUAL,
_PRIORITY,
_REASONS,
_ROOTCAUSE,
_STATPROFILE,
CASEAUTHORIZATIONLEVEL,
CASECATEGORY,
CASECLOSEDBY,
CASECLOSEDTIME,
CASECREATEDBY,
CASECREATEDON,
CASEESCALATIONREASON,
CASEEXTERNALREFERENCE,
CASEID,
CASELASTCHANGEDBY,
CASELASTCHANGEDON,
CASEPLANNEDCLOSEDATE,
CASEPRIORITY,
CASEPROCESSINGDEADLINEDATE,
CASEPROCESSOR,
CASEREASON,
CASERESPONSIBLE,
CASESTATUS,
CASESTATUSPROFILE,
CASESYSTEMSTATUS,
CASETITLE,
CASETYPE,
COMPANYCODE,
CONTACTPERSONEMAILADDRESS,
CONTACTPERSONFAXCOUNTRY,
CONTACTPERSONFAXNUMBER,
CONTACTPERSONNAME,
CONTACTPERSONPHONENUMBER,
CREDITEDAMOUNT,
CUSTOMER,
CUSTOMERDISPUTEDAMOUNT,
CUSTOMERDISPUTEDCURRENCY,
DISPUTECASECOORDINATOR,
DISPUTECASECURRENCY,
DISPUTECASEEXTERNALAPPLICATION,
DISPUTECASEROOTCAUSE,
DISPUTEDAMOUNT,
DRAFTCREATIONDATETIME,
DRAFTLASTCHANGEDDATETIME,
DRAFTUUID,
HASACTIVEENTITY,
ISACTIVEENTITY,
MANUALLYCLEAREDAMOUNT,
ORIGINALAMOUNT,
PAIDAMOUNT,
WRITEOFFAMOUNT,
PRIMARY KEY (DISPUTECASEUUID)
);
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