P_SolvedDisputeStatusDuration3

DDL: P_SOLVEDDISPUTESTATUSDURATION3 SQL: PSLVDDSPSTSDURN3 Type: view COMPOSITE Package: UDM_DM_CDS
10 Fields 1 Data Sources 1 Associations

Solved Dispute Status Duration 3

P_SolvedDisputeStatusDuration3 is a Composite CDS View that provides data about "Solved Dispute Status Duration 3" in SAP S/4HANA. It reads from 1 data source (P_SolvedDisputeStatusDuration1) and exposes 10 fields. It has 1 association to related views. Part of development package UDM_DM_CDS.

Data Sources (1)

SourceAliasJoin Type
P_SolvedDisputeStatusDuration1 _dur1 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_SolvedDisputeStatusDuration2 _dur2 _dur1.CaseID = _dur2.CaseID

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSLVDDSPSTSDURN3 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
CaseID P_SolvedDisputeStatusDuration1 CaseID Case ID
DisputeCaseUUID P_SolvedDisputeStatusDuration1 DisputeCaseUUID UUID
CreationDateTime P_SolvedDisputeStatusDuration1 CreationDateTime Timestamp
StatusProfile P_SolvedDisputeStatusDuration1 StatusProfile Status Profile
CaseCreationDate P_SolvedDisputeStatusDuration1 CaseCreationDate
LastChangeDateTime _dur2 LastChangeDateTime Timestamp
TableChangeLogUser _dur2 TableChangeLogUser
ChangeDocOldFieldValueText _dur2 ChangeDocOldFieldValueText
ChangeDocNewFieldValueText _dur2 ChangeDocNewFieldValueText
ObjectName _dur2 ObjectName Object name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SolvedDisputeStatusDuration3.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSLVDDSPSTSDURN3

CREATE VIEW P_SolvedDisputeStatusDuration3 AS
SELECT
  _dur1.CaseID AS CaseID,
  _dur1.DisputeCaseUUID AS DisputeCaseUUID,
  _dur1.CreationDateTime AS CreationDateTime,
  _dur1.StatusProfile AS StatusProfile,
  _dur1.CaseCreationDate AS CaseCreationDate,
  _dur2.LastChangeDateTime AS LastChangeDateTime,
  _dur2.TableChangeLogUser AS TableChangeLogUser,
  _dur2.ChangeDocOldFieldValueText AS ChangeDocOldFieldValueText,
  _dur2.ChangeDocNewFieldValueText AS ChangeDocNewFieldValueText,
  _dur2.ObjectName AS ObjectName
FROM P_SolvedDisputeStatusDuration1 AS _dur1
LEFT OUTER JOIN P_SolvedDisputeStatusDuration2 AS _dur2 ON _dur1.CaseID = _dur2.CaseID  -- association [0..*]
;

Learn More