I_DocumentPRTByInternalKey

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 I_DocumentPRTByInternalKey.
-- 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: IPPDOCUMENTPRTIK

CREATE VIEW I_DocumentPRTByInternalKey AS
SELECT
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  crvd_a.dokar AS DocumentType,
  crvd_a.doknr AS DocumentInfoRecord,
  crvd_a.dokvr AS DocumentVersion,
  crvd_a.doktl AS DocumentPart,
  draw.begru AS AuthorizationGroup,
  draw.dokst AS InternalDocumentStatus,
  PRT.CreationDate AS CreationDate,
  PRT.CreatedByUser AS CreatedByUser,
  PRT.LastChangeDate AS LastChangeDate,
  PRT.LastChangedByUser AS LastChangedByUser,
  PRT._ProductionResourceType AS _ProductionResourceType,
  PRT._CreatedByUser AS _CreatedByUser,
  PRT._LastChangedByUser AS _LastChangedByUser
FROM I_ProdnRsceToolMasterData AS PRT
INNER JOIN crvd_a ON /* join condition not captured in parsed metadata */
INNER JOIN draw ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocumentType ON DocumentType = _DocumentType.DocumentInfoRecordDocType  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocNumber AS _DocumentNumber ON DocumentType = _DocumentNumber.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentNumber.DocumentInfoRecordDocNumber  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocVersion AS _DocumentVersion ON DocumentType = _DocumentVersion.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentVersion.DocumentInfoRecordDocNumber AND DocumentVersion = _DocumentVersion.DocumentInfoRecordDocVersion  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecord AS _DocumentInfoRecord ON DocumentType = _DocumentInfoRecord.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentInfoRecord.DocumentInfoRecordDocNumber AND DocumentVersion = _DocumentInfoRecord.DocumentInfoRecordDocVersion AND DocumentPart = _DocumentInfoRecord.DocumentInfoRecordDocPart  -- association [1..1]
LEFT OUTER JOIN I_DocumentProdnRsceTool AS _DocumentProdnRsceTool ON DocumentType = _DocumentProdnRsceTool.DocumentType AND DocumentInfoRecord = _DocumentProdnRsceTool.DocumentInfoRecord AND DocumentVersion = _DocumentProdnRsceTool.DocumentVersion AND DocumentPart = _DocumentProdnRsceTool.DocumentPart  -- association [1..1]
;