I_DocInfoRecdDocumentPart

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_DocInfoRecdDocumentPart.
-- 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: ICVDOCUMENTPART

CREATE VIEW I_DocInfoRecdDocumentPart AS
SELECT
  document.dokar AS DocumentType,
  document.doknr AS DocumentInfoRecord,
  document.dokvr AS DocumentVersion,
  document.doktl AS DocumentPart,
  _DocumentDescription[1:Language = $session.system_language].DocumentDescription AS DocumentDescription
FROM draw AS document
LEFT OUTER JOIN I_DocInfoRecdDocumentType AS _DocumentType ON DocumentType = _DocumentType.DocumentType  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdNumber AS _DocumentNumber ON DocumentType = _DocumentNumber.DocumentType AND DocumentInfoRecord = _DocumentNumber.DocumentInfoRecord  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentVersion AS _DocumentVersion ON DocumentType = _DocumentVersion.DocumentType AND DocumentInfoRecord = _DocumentVersion.DocumentInfoRecord AND DocumentVersion = _DocumentVersion.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDescription AS _DocumentDescription ON DocumentPart = _DocumentDescription.DocumentPart AND DocumentType = _DocumentDescription.DocumentType AND DocumentVersion = _DocumentDescription.DocumentVersion AND DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord  -- association [0..*]
;