P_SolvedDisputeStatusDuration5

DDL: P_SOLVEDDISPUTESTATUSDURATION5 SQL: PSLVDDSPSTSDURN5 Type: view COMPOSITE

P_SolvedDisputeStatusDuration5 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SolvedDisputeStatusDuration4) and exposes 6 fields.

Data Sources (1)

SourceAliasJoin Type
P_SolvedDisputeStatusDuration4 _main from

Annotations (7)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
CaseID P_SolvedDisputeStatusDuration4 CaseID Case ID
LastChangeDateTime P_SolvedDisputeStatusDuration4 LastChangeDateTime Timestamp
StatusBeginDateTime
ChangeDocOldFieldValueText P_SolvedDisputeStatusDuration4 ChangeDocOldFieldValueText
ChangeDocNewFieldValueText P_SolvedDisputeStatusDuration4 ChangeDocNewFieldValueText
CaseCreationDate P_SolvedDisputeStatusDuration4 CaseCreationDate

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_SolvedDisputeStatusDuration5.
-- 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: PSLVDDSPSTSDURN5

CREATE VIEW P_SolvedDisputeStatusDuration5 AS
SELECT
  _main.CaseID AS CaseID,
  _main.LastChangeDateTime AS LastChangeDateTime,
  max( _dur4.LastChangeDateTime ) AS StatusBeginDateTime,
  _main.ChangeDocOldFieldValueText AS ChangeDocOldFieldValueText,
  _main.ChangeDocNewFieldValueText AS ChangeDocNewFieldValueText,
  _main.CaseCreationDate AS CaseCreationDate
FROM P_SolvedDisputeStatusDuration4 AS _main
;