P_DocInfoRecd

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_DocInfoRecd.
-- 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: PCVDOCINFORECD

CREATE VIEW P_DocInfoRecd AS
SELECT
  doc_info.dokar AS DocumentType,
  doc_info.doknr AS DocumentInfoRecord,
  doc_info.dokvr AS DocumentVersion,
  doc_info.doktl AS DocumentPart,
  doc_info.dwnam AS ResponsiblePersonName,
  doc_info.dokst AS InternalDocumentStatus,
  doc_info.labor AS LaboratoryOrDesignOffice,
  doc_info.aennr AS ChangeNumber,
  doc_info.werka AS Plant,
  doc_info.prenr AS SuperiorDocumentInfoRecord,
  doc_info.prevr AS SuperiorDocumentVersion,
  doc_info.pretl AS SuperiorDocumentPart,
  doc_info.prear AS SuperiorDocumentType,
  doc_info.begru AS AuthorizationGroup,
  doc_info.vrldat AS DueDate,
  doc_info.vprior AS ProcessingPriority,
  doc_info.adatum AS DocInfoRecdOutputDate,
  doc_info.doknr_vl AS SourceDocInfoRecd,
  doc_info.doktl_vl AS DocInfoRecdSourceDocPart,
  doc_info.dokvr_vl AS DocInfoRecdSourceDocVersion,
  doc_info.cm_fixed AS DocInfoRecdConfignMgmtFixed,
  case when DocumentStructureBOM.doknr is not null then cast('X' as abap.char(1)) when DocumentStructureBOM.doknr is null then cast(' ' as abap.char(1)) end as IsDocInfoRecdStructure AS char1endasIsDocInfoRecdStructure,
  doc_info.loedk AS DocInfoRecdIsMarkedForDeletion,
  doc_info.cadkz AS DocumentIsCreatedByCAD,
  Last_Change.created_at AS CreationDateTime,
  Last_Change.created_by AS CreatedByUser,
  Last_Change.changed_at AS ChangedDateTime,
  Last_Change.changed_by AS LastChangedByUser
LEFT OUTER JOIN draw_last_change AS Last_Change ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dost AS DocumentStructureBOM ON /* join condition not captured in parsed metadata */
;