P_DGR_Ctr_Status

DDL: P_DGR_CTR_STATUS SQL: PDGRCNTSTATUS Type: view COMPOSITE
7 Fields 2 Data Sources

P_DGR_Ctr_Status is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_TrdgContractSnapshotData, I_ContractStatus) and exposes 7 fields with key fields ContractNumber, ApplicationId, ActionDateTime.

Data Sources (2)

SourceAliasJoin Type
I_TrdgContractSnapshotData ContSnapshotData from
I_ContractStatus ContStatus left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDGRCNTSTATUS view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ContractNumber
KEY ApplicationId ACMSnapshotAppl UI Application
KEY ActionDateTime TradeContractSnapshotDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ContractStatus I_TrdgContractSnapshotData ContractStatus Paper Contr Status
ContractType Contract Type
ContractType ACMTradingContractType Contract Type
ContractIsConfirmationRelevant ContractIsConfirmationRelevant Conf. Relevant

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_DGR_Ctr_Status.
-- 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: PDGRCNTSTATUS

CREATE VIEW P_DGR_Ctr_Status AS
SELECT
  left(ACMSnapshotID, 10) AS ContractNumber,
  ACMSnapshotAppl AS ApplicationId,
  TradeContractSnapshotDateTime AS ActionDateTime,
  ContSnapshotData.ContractStatus AS ContractStatus,
  ACMTradingContractType AS ContractType,
  ContractIsConfirmationRelevant
FROM I_TrdgContractSnapshotData AS ContSnapshotData
LEFT OUTER JOIN I_ContractStatus AS ContStatus ON /* join condition not captured in parsed metadata */
;

Learn More