/APE/C_ArchivePDoc_UI

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 /APE/C_ArchivePDoc_UI.
-- 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: /APE/C_ARPDOCUI

CREATE VIEW /APE/C_ArchivePDoc_UI AS
SELECT
  doc_uuid AS DocumentKey,
  doc_no AS DocumentNumberFlt,
  cast(doc_no as /ape/de_doc_no) AS DocumentNumber,
  doc_type AS DocumentType,
  cast('' as /ape/de_config_db_key) AS ProcessDescriptionKey,
  cast('' as /ape/de_description) AS ProcessDescription,
  _BOType.BusinessObjectTypeDescription AS DocumentTypeDescription,
  doc_status AS DocumentStatus,
  _DocStatus.Description AS DocumentStatusDescription,
  cast( doc_key_date as timestampl ) AS DocumentKeyDateTS,
  tstmp_to_dats( doc_key_date, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as DocumentKeyDate AS clientNULLasDocumentKeyDate,
  tstmp_to_dats( doc_key_date, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as ProcessKeyDate AS clientNULLasProcessKeyDate,
  com_acc_uuid AS CommonAccessUUID,
  bus_status AS BusinessStatus,
  cast('' as /ape/de_description) AS BusinessStatusDescription,
  cast('' as /ape/de_config_db_key) AS ProcessClusterKey,
  cast('' as /ape/de_proc_cluster) AS ProcessCluster,
  cast('' as /ape/de_description) AS ProcessClusterDescription,
  cast('' as /ape/de_config_db_key) AS VersionKey,
  cast('' as /ape/de_version) AS Version,
  cast('' as /ape/de_description) AS VersionDescription,
  cast('' as /ape/de_config_db_key) AS ProcessIdKey,
  proc_id_uuid AS ProcessIDKeyFt,
  _ProcessIDConf.semantic_value AS ProcessID,
  cast('' as /ape/de_description) AS ProcessIDDescription,
  cast( doc_status_tstmp as timestampl ) AS StatusTimestamp,
  bu_partner_uuid AS BusinessPartner,
  bo_uuid AS BusinessObjectUUID,
  bo_type_uuid AS BusinessObjectTypeUUID,
  cast('' as /ape/de_bo_type) AS BusinessObjectType,
  cast('' as /ape/de_description) AS BusinessObjectTypeDescription,
  cast('' as /ape/de_owner_uuid) AS OwnerUUID,
  person_data_ind AS PersonalDataIndicator,
  _PersonalDataInd.Description AS PersonalDataIndicatorDescr,
  Blocked,
  Test,
  _TestInd.Description AS TestDescription,
  cast( created_at as timestampl ) AS CreatedAt,
  created_by AS CreatedBy,
  cast( changed_at as timestampl ) AS ChangedAt,
  changed_by AS ChangedBy,
  tstmp_to_dats( created_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate,
  doc_tags AS Tags,
  tech_msg_id AS TechnicalMessageID,
  tech_msg_version AS TechnicalMessageVersion,
  com_partner_id AS CommunicationPartnerID,
  cast( doc_created_at as timestampl ) AS DocCreatedAt,
  cast( doc_changed_at as timestampl ) AS DocChangedAt,
  doc_created_at AS DocCreatedAtTMP,
  client_uuid,
  auth_grp,
  doc_type,
  cast('' as /ape/de_description) AS ProcessConfiguration,
  cast('' as /ape/de_tech_msg_id_ext) AS ExternalTransferReference,
  cast('' as /ape/de_bus_msg_id_ext) AS TDocBusinessMessageID,
  cast('' as /ape/de_bus_status) AS TDocBusinessStatus,
  cast( '' as abap.char( 70 ) ) AS AddBusObjKey,
  cast( '' as abap.char( 40 ) ) AS AddBusObjType,
  cast( 0 as abap.int2 ) AS AddBusObjCount
FROM /APE/I_ArchiveDoc
LEFT OUTER JOIN /APE/C_BusObjTypeOfEExDoc_VH AS _BOType ON _BOType.BusinessObjectType = DocumentType  -- association [0..1]
LEFT OUTER JOIN /APE/C_ArchivedDocStatus_VH AS _DocStatus ON _DocStatus.Value = DocumentStatus AND _DocStatus.DocumentType = 'PDoc'  -- association [0..1]
LEFT OUTER JOIN /APE/C_Process_VH AS _Process ON _Process.ProcessKey = proc_config_uuid  -- association [0..1]
LEFT OUTER JOIN /APE/C_PersonalDataInd_VH AS _PersonalDataInd ON _PersonalDataInd.Value = PersonalDataIndicator  -- association [0..1]
LEFT OUTER JOIN /APE/C_TestInd_VH AS _TestInd ON _TestInd.Value = Test AND _TestInd.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /APE/C_HistoricalData_VH AS _HistoricalData ON _HistoricalData.Value = HistoricalData AND _HistoricalData.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /APE/C_ArchiveLinkedDoc_UI AS _LinkedDocs ON _LinkedDocs.DocumentKey = DocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ArchiveLinkedTDoc AS _LinkedTDoc ON _LinkedTDoc.ArchivedPDocKey = DocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_RemoteArchConfigure AS _ProcessIDConf ON _ProcessIDConf.config_key = ProcessIDKeyFt AND _ProcessIDConf.config_type = 'PROCID'  -- association [1..1]
LEFT OUTER JOIN /APE/C_RemoteArchConfigureText AS _ProcessIDText ON _ProcessIDText.arch_config_key = _ProcessIDConf.arch_config_key AND _ProcessIDText.language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN /ape/C_ProcDataObjectAdd_UI AS _PdocBOAdd ON _PdocBOAdd.proc_uuid = DocumentKey  -- association [0..*]
;