R_DrftRptDocumentDataTP

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 R_DrftRptDocumentDataTP.
-- 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.

CREATE VIEW R_DrftRptDocumentDataTP AS
SELECT
  StatryRptActivityUUID,
  StatryRptDocumentID,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptTaskPeriodStartDate,
  StatryRptTaskPeriodEndDate,
  StatryRptActivityStatus,
  DrftRptRecnclnRunUUID,
  DrftRptRecnclnSubmsnRunUUID,
  DrftRptCommFileID,
  DraftReportComparisonStatus,
  DrftRptComprnRunDteTme,
  DraftReportGeneratedByUserID,
  _DrftRptGeneratedBy.UserDescription AS DraftReportGeneratedBy,
  DrftRptRecnclnLgHandle,
  Country,
  _DrftRptCommunicationDataTP.DrftRptCommProcessID AS DrftRptCommProcessID,
  _DrftRptCommunicationDataTP.DrftRptRecnclnDocName AS DrftRptRecnclnDocName,
  _DrftRptCommunicationDataTP.DrftRptRecnclnFetchDteTme AS DrftRptRecnclnFetchDteTme,
  _DrftRptCommunicationDataTP.DrftRptRecnclnExtFileReqSts AS DrftRptRecnclnExtFileReqSts,
  _DrftRptCommunicationDataTP.DrftRptExtFileReqStsCritlty AS DrftRptExtFileReqStsCritlty,
  PhysDocFileName,
  CreatedOnDateTime,
  DraftReportRequestedByUserID,
  _DrftRptRequestedBy.UserDescription AS DraftReportRequestedBy,
  StatryRptRunStatus
FROM I_DraftReportDocumentData
LEFT OUTER JOIN R_DrftRptCommunicationDataTP AS _DrftRptCommunicationDataTP ON _DrftRptCommunicationDataTP.StatryRptActivityUUID = StatryRptActivityUUID AND _DrftRptCommunicationDataTP.StatryRptDocumentID = StatryRptDocumentID  -- association [0..1]
LEFT OUTER JOIN R_DrftRptAuthorityFileDwnldTP AS _DrftRptAuthorityFileDownload ON _DrftRptAuthorityFileDownload.StatryRptActivityUUID = StatryRptActivityUUID AND _DrftRptAuthorityFileDownload.StatryRptDocumentID = StatryRptDocumentID  -- association [0..1]
LEFT OUTER JOIN R_DrftRptSourceFileDownloadTP AS _DrftRptSourceFileDownload ON _DrftRptSourceFileDownload.StatryRptActivityUUID = StatryRptActivityUUID AND _DrftRptSourceFileDownload.StatryRptDocumentID = StatryRptDocumentID  -- association [0..1]
LEFT OUTER JOIN I_User AS _DrftRptGeneratedBy ON _DrftRptGeneratedBy.UserID = DraftReportGeneratedByUserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _DrftRptRequestedBy ON _DrftRptRequestedBy.UserID = DraftReportRequestedByUserID  -- association [0..1]
LEFT OUTER JOIN I_StRpEntityText AS _StRpEntityText ON _StRpEntityText.StatryRptgEntity = StatryRptgEntity  -- association [0..*]
LEFT OUTER JOIN I_StRpCategoryText AS _StRpCategoryText ON _StRpCategoryText.StatryRptCategory = StatryRptCategory AND _StRpCategoryText.StatryRptCatVersion = 'ACT'  -- association [0..*]
LEFT OUTER JOIN I_StRpActivityStatusText AS _ActivityStatusText ON _ActivityStatusText.StatryRptActivityStatus = StatryRptActivityStatus  -- association [0..*]
LEFT OUTER JOIN I_DrftRptComprnStsTxt AS _ComparisonStatusText ON _ComparisonStatusText.DraftReportComparisonStatus = DraftReportComparisonStatus  -- association [0..*]
LEFT OUTER JOIN I_DrftRptExtFileReqStsTxt AS _ExtFileReqStsTxt ON _ExtFileReqStsTxt.DrftRptRecnclnExtFileReqSts = drftrptrecnclnextfilereqsts  -- association [0..*]
LEFT OUTER JOIN I_StRpRepRunStatusText AS _GeneratedRunStatusText ON _GeneratedRunStatusText.StatryRptRunStatus = StatryRptRunStatus  -- association [0..*]
LEFT OUTER JOIN R_DrftRptDetComprnDocDataTP AS _DetComparisonDocumentData ON /* condition not available in parsed metadata */  -- association [1..*]
;