P_SolvedDisputeStatusDuration2

DDL: P_SOLVEDDISPUTESTATUSDURATION2 SQL: PSLVDDSPSTSDURN2 Type: view COMPOSITE
8 Fields 2 Data Sources

P_SolvedDisputeStatusDuration2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_DisputeCaseProtocol, P_DisputeCase_SUBSTR_TF) and exposes 8 fields with key fields mandt, DisputeCasePersistentObject, LastChangeDateTime, TableChangeLogUser.

Data Sources (2)

SourceAliasJoin Type
I_DisputeCaseProtocol _prot from
P_DisputeCase_SUBSTR_TF P_DisputeCase_SUBSTR_TF inner

Annotations (7)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY mandt I_DisputeCaseProtocol mandt Editing Client
KEY DisputeCasePersistentObject I_DisputeCaseProtocol DisputeCasePersistentObject POID ID
KEY LastChangeDateTime I_DisputeCaseProtocol LastChangeDateTime Timestamp
KEY TableChangeLogUser I_DisputeCaseProtocol TableChangeLogUser User Name
ChangeDocOldFieldValueText I_DisputeCaseProtocol ChangeDocOldFieldValueText 3-Byte field
ChangeDocNewFieldValueText I_DisputeCaseProtocol ChangeDocNewFieldValueText 3-Byte field
ObjectName I_DisputeCaseProtocol ObjectName Object name
CaseID _amdp caseid Case ID

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_SolvedDisputeStatusDuration2.
-- 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: PSLVDDSPSTSDURN2

CREATE VIEW P_SolvedDisputeStatusDuration2 AS
SELECT
  _prot.mandt AS mandt,
  _prot.DisputeCasePersistentObject AS DisputeCasePersistentObject,
  _prot.LastChangeDateTime AS LastChangeDateTime,
  _prot.TableChangeLogUser AS TableChangeLogUser,
  _prot.ChangeDocOldFieldValueText AS ChangeDocOldFieldValueText,
  _prot.ChangeDocNewFieldValueText AS ChangeDocNewFieldValueText,
  _prot.ObjectName AS ObjectName,
  _amdp.caseid AS CaseID
FROM I_DisputeCaseProtocol AS _prot
INNER JOIN P_DisputeCase_SUBSTR_TF ON /* join condition not captured in parsed metadata */
;

Learn More