P_DocInfoRecdOriginal

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_DocInfoRecdOriginal.
-- 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: PCVORIGINAL

CREATE VIEW P_DocInfoRecdOriginal AS
SELECT
  Dir_Loio.dokar AS DocumentType,
  Dir_Loio.doknr AS DocumentInfoRecord,
  Dir_Loio.dokvr AS DocumentVersion,
  Dir_Loio.doktl AS DocumentPart,
  Dir_Loio.lo_index AS DocumentIndex,
  Phio_Filename.file_id AS FileUUID,
  Doc_Files.filename AS FileName,
  Original_Phio.prop01 AS IsOriginalVersionActive,
  Doc_Files.dappl AS WorkstationApplication,
  Original_fileSizeData.mimetype AS MimeType,
  Original_Phio.stor_cat AS StorageCategory,
  Original_CheckOutData.chko_user AS OriginalCheckedOutUser,
  cast ( Original_CheckOutData.chko_time as tzntstmps) AS OriginalCheckedOutTime,
  Original_CheckOutData.chko_commt AS InternalComment,
  cast ( Original_Phio.crea_time as tzntstmps) AS CreationDateTime,
  Original_Phio.crea_user AS CreatedByUser,
  cast ( Original_Phio.chng_time as tzntstmps) AS ChangedDateTime,
  Original_Phio.chng_user AS LastChangedByUser,
  Original_Phio.phio_id AS PhysicalDocument,
  Original_fileSizeData.file_size AS FileSize,
  Dir_Loio.lo_type AS OriginalType,
  Dir_Loio.lo_objid AS LogicalDocument,
  Dir_Loio.lo_is_ref AS LogicalDocumentIsReference,
  Original_Phio.lo_class AS LogicalDocumentClass,
  Original_Phio.state AS PhysicalDocTechnicalStatus,
  Original_Phio.descript AS DocumentTitle,
  Original_Phio.doc_format AS DocumentFormat,
  Phio_Filename.protected AS OriginalIsProtected
FROM dms_doc2loio AS Dir_Loio
LEFT OUTER JOIN dms_ph_cd1 AS Original_Phio ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dms_phio2file AS Phio_Filename ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dms_ph_chko_cd1 AS Original_CheckOutData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dms_phf_cd1 AS Original_fileSizeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dms_doc_files AS Doc_Files ON /* join condition not captured in parsed metadata */
;