P_DGR_StatusCD_ValidStatus

DDL: P_DGR_STATUSCD_VALIDSTATUS SQL: PSCDVALIDSTATUS Type: view COMPOSITE
9 Fields 2 Data Sources

P_DGR_StatusCD_ValidStatus is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_DGR_StatusCD_MaxChangeNumber, I_SystemUserChangeDocuments) and exposes 9 fields with key fields ApplicationStatusObject, ApplicationStatus, ChangeNumber.

Data Sources (2)

SourceAliasJoin Type
P_DGR_StatusCD_MaxChangeNumber MaxChgnr inner
I_SystemUserChangeDocuments validstat from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSCDVALIDSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ApplicationStatusObject I_SystemUserChangeDocuments ApplicationStatusObject Val. Obj. No.
KEY ApplicationStatus I_SystemUserChangeDocuments ApplicationStatus Status of Time-Dependent Document Linkage
KEY ChangeNumber I_SystemUserChangeDocuments ChangeNumber Change Number
StatusDate I_SystemUserChangeDocuments ChangeDocumentStatusDate Update Date
StatusTime I_SystemUserChangeDocuments ChangeDocumentStatusTime Time
StatusTmstp I_SystemUserChangeDocuments ChangeDocumentStatusDateTime
TransactionCode I_SystemUserChangeDocuments TransactionCode Transaction Code
ChangeTransactionCode I_SystemUserChangeDocuments ChangeTransactionCode Change Tcode
StatusInactive I_SystemUserChangeDocuments ChangeDocumentStatusIsInactive TRUE

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_StatusCD_ValidStatus.
-- 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: PSCDVALIDSTATUS

CREATE VIEW P_DGR_StatusCD_ValidStatus AS
SELECT
  validstat.ApplicationStatusObject AS ApplicationStatusObject,
  validstat.ApplicationStatus AS ApplicationStatus,
  validstat.ChangeNumber AS ChangeNumber,
  validstat.ChangeDocumentStatusDate AS StatusDate,
  validstat.ChangeDocumentStatusTime AS StatusTime,
  validstat.ChangeDocumentStatusDateTime AS StatusTmstp,
  validstat.TransactionCode AS TransactionCode,
  validstat.ChangeTransactionCode AS ChangeTransactionCode,
  validstat.ChangeDocumentStatusIsInactive AS StatusInactive
FROM I_SystemUserChangeDocuments AS validstat
INNER JOIN P_DGR_StatusCD_MaxChangeNumber AS MaxChgnr ON /* join condition not captured in parsed metadata */
;

Learn More