N_ChangeRecordObjPgDoc

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 N_ChangeRecordObjPgDoc.
-- 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: NCHGRCDOBJPGDOC

CREATE VIEW N_ChangeRecordObjPgDoc AS
SELECT
  ChangeRecordReferenceUUID,
  Document.DocumentInfoRecordDocNumber AS DocumentInfoRecord,
  Document.DocumentInfoRecordDocType AS DocumentType,
  Document.DocumentInfoRecordDocPart AS DocumentPart,
  Document.DocumentInfoRecordDocVersion AS DocumentVersion,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ChangeRecordReference,
  ParentChangeRecordRefUUID,
  IsMainReference,
  reference_DOC.CreatedByUser AS CreatedByUser,
  reference_DOC.CreationDateTime AS CreationDateTime,
  _ChangeRecordDocStatus._DocStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus AS ExternalDocumentStatus,
  _ChangeRecordDocStatus._DocStatus._Text[1:Language = $session.system_language].DocumentStatusName AS DocumentStatusName,
  _DocumentPart.DocumentDescription AS DocumentDescription
FROM I_ChgRecdRefDocBsc AS reference_DOC
LEFT OUTER JOIN I_DocumentInfoRecord AS Document ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordItemRelDocVH AS _ChangeRecordItemRelDocVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelDocVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelDocVH.ChangeRecordType AND ChangeRecordReferenceType = _ChangeRecordItemRelDocVH.ChangeRecordReferenceType  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordDocStatus AS _ChangeRecordDocStatus ON DocumentType = _ChangeRecordDocStatus.DocumentType AND DocumentInfoRecord = _ChangeRecordDocStatus.DocumentInfoRecord AND DocumentVersion = _ChangeRecordDocStatus.DocumentVersion AND DocumentPart = _ChangeRecordDocStatus.DocumentPart  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocumentType ON DocumentType = _DocumentType.DocumentInfoRecordDocType  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordDocPart AS _DocumentPart ON DocumentType = _DocumentPart.DocumentType AND DocumentPart = _DocumentPart.DocumentPart AND DocumentInfoRecord = _DocumentPart.DocumentInfoRecord AND DocumentVersion = _DocumentPart.DocumentVersion  -- association [1..1]
;