/APE/C_ExceptionHeader_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_ExceptionHeader_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.

CREATE VIEW /APE/C_ExceptionHeader_UI AS
SELECT
  ExceptionDocument.db_key AS ExceptionDocumentKey,
  ExceptionDocument.excp_doc_no AS ExceptionDocumentNumber,
  ExceptionDocument.client_uuid AS ClientUUID,
  ExceptionDocument.com_acc_uuid AS CommonAccessUUID,
  ExceptionDocument.proc_cluster AS ProcessCluster,
  cast( '' as abap.char( 15 ) ) AS Overdue,
  1 AS OverdueCriticality,
  ExceptionDocument.excp_code AS ExceptionCode,
  ExceptionDocument.bu_partner_uuid AS BusinessPartner,
  tstmp_to_dats( ExceptionDocument.due_timestamp, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as DueDate AS clientNULLasDueDate,
  ExceptionDocument.excp_status AS ExceptionStatus,
  tstmp_to_dats( ExceptionDocument.due_timestamp, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as StatusDate AS clientNULLasStatusDate,
  ExceptionDocument.bus_status_uuid AS BusinessStatusKey,
  ExceptionDocument.bus_status AS BusinessStatus,
  _BusStatus.BusStatusDescriptionISL AS BusinessStatusDescription,
  _BusStatusCC.color_code AS BusinessStatusCriticality,
  ExceptionDocument.bo_type AS BusinessObjectType,
  ExceptionDocument.bo_uuid AS BusinessObjectUUID,
  cast('' as /ape/de_bo_uuid_ext) AS BusinessObjectNumber,
  ExceptionDocument.bo_character AS BusinessObjectCharacteristic,
  _ProcessID.ProcessIDDescription AS ProcessIDDescription,
  ExceptionDocument.priority AS Priority,
  ExceptionDocument.processor AS Processor,
  ExceptionDocument.note AS Note,
  ExceptionDocument.remote AS Remote,
  ExceptionDocument.origin_syst_uuid AS OriginSystemUUID,
  ExceptionDocument.origin_syst_type AS OriginSystemType,
  ExceptionDocument.test AS Test,
  ExceptionDocument.person_data_ind AS PersonalDataIndicator,
  _PersonalDataInd.Description AS PersonalDataIndicatorDescr,
  ExceptionDocument.blocked AS Blocked,
  ExceptionDocument.auth_grp AS AuthorizationGroup,
  case ExceptionDocument._dataaging when '00000000' then ExceptionDocument.archived else 'E' end as Archived AS archivedelseEendasArchived,
  ExceptionDocument.log_level AS LogLevel,
  tstmp_to_dats( ExceptionDocument.created_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as CreatedAtBf AS clientNULLasCreatedAtBf,
  ExceptionDocument.created_by AS CreatedBy,
  tstmp_to_dats( ExceptionDocument.changed_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as ChangedAtBf AS clientNULLasChangedAtBf,
  ExceptionDocument.changed_by AS ChangedBy,
  _Client.name AS ClientName,
  ExceptionDocument.client_uuid AS client_uuid,
  ExceptionDocument.bo_type AS bo_type,
  ExceptionDocument.bo_character AS bo_character,
  ExceptionDocument.auth_grp AS auth_grp,
  ExceptionDocument._ExcpCode AS _ExcpCode,
  ExcpType,
  _ExceptionTypeVH.Description AS ExceptionTypeDescription,
  ExceptionDocument.changed_at AS changed_at,
  cast( '' as /ape/de_bo_type ) AS ReferenceType,
  cast( '' as /ape/de_bo_uuid_ext ) AS ReferenceID,
  _TRHD.tech_msg_id AS TechnicalMessageID,
  _TRHD.tech_msg_version AS TechnicalMessageVersion,
  _TRHD.bus_msg_id AS BusinessMessageID,
  cast('true' as /ape/de_boolean_flag ) AS Editable_mc,
  cast('true' as /ape/de_boolean_flag ) AS Addrefrence_mc,
  ExceptionDocument.retry_counter AS RetryCounter,
  ExceptionDocument.owner_uuid AS OwnerMarketPartner,
  cast( '' as /ape/de_description ) AS OwnerMarketPartnerName,
  cast( '' as /ape/de_bo_uuid_ext ) AS CommunicationPartner,
  cast( '' as /ape/de_description ) AS CommunicationPartnerName,
  cast('' as /ape/de_service_type) AS TransferDocumentServiceType,
  _BOType.SemanticAction AS SemanticAction,
  _BOType.SemanticObject AS SemanticObject,
  _BOType.KeyFieldName AS KeyFieldName,
  _BOType.BusinessObjectTypeDescription AS BusinessObjectTypeDescription
FROM /APE/I_ExceptionHeader_TP AS ExceptionDocument
LEFT OUTER JOIN /APE/C_ExceptionParameter_UI AS _ExcpPara ON _ExcpPara.ExcepionDocumentKey = ExceptionDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionSolution_UI AS _ExcpSolv ON _ExcpSolv.ExceptionDocumentKey = ExceptionDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionLinkBO_UI AS _ExcpLinkBO ON _ExcpLinkBO.ExceptionDocumentKey = ExceptionDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionPriority_VH AS _ExceptionPriority ON _ExceptionPriority.Value = Priority  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionStatus_VH AS _ExceptionStatus ON _ExceptionStatus.Value = ExceptionStatus  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionID_VH AS _ExceptionCode ON _ExceptionCode.ExceptionID = ExceptionCode  -- association [0..1]
LEFT OUTER JOIN /APE/C_BusObjTypeOfEExDoc_VH AS _BOType ON _BOType.BusinessObjectType = BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN /APE/C_Client AS _Client ON _Client.client_uuid = ClientUUID  -- association [0..*]
LEFT OUTER JOIN /APE/C_BusinessPartner AS _BP ON _BP.BusinessPartnerNumber = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessCluster ON _ProcessCluster.proc_cluster = ProcessCluster  -- association [0..1]
LEFT OUTER JOIN /APE/C_PersonalData_VH AS _PersonalDataInd ON _PersonalDataInd.Value = PersonalDataIndicator  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _Remote ON _Remote.Domname = '/APE/D_REMOTE_RAISE' AND _Remote.Domvalue = Remote  -- association [0..1]
LEFT OUTER JOIN /APE/C_LogLevel_VH AS _LogLevel ON _LogLevel.Value = LogLevel  -- association [0..1]
LEFT OUTER JOIN /APE/C_TestInd_VH AS _TestInd ON _TestInd.Value = Test  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionPDocTDoc_UI AS _PDocTDoc ON _PDocTDoc.ExceptionDocumentKey = ExceptionDocumentKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _Archived ON _Archived.Domname = '/APE/D_ARCHIVE_INDICATOR' AND _Archived.Domvalue = Archived  -- association [0..*]
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_EXCPHDRTRBO AS _TRBO ON _TRBO.excp_uuid = ExceptionDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessID_VH AS _ProcessID ON _ProcessID.ProcessID = BusinessObjectCharacteristic  -- association [0..1]
LEFT OUTER JOIN /APE/I_BusStatus AS _BusStatusCC ON _BusStatusCC.config_key = BusinessStatusKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BusStatus_Excp_VH AS _BusStatus ON _BusStatus.BusinessStatusKey = BusinessStatusKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_EXCPHDTRHD AS _TRHD ON _TRHD.excp_uuid = ExceptionDocumentKey  -- association [1..*]
LEFT OUTER JOIN /APE/C_ExceptionType_VH AS _ExceptionTypeVH ON _ExceptionTypeVH.Value = ExcpType  -- association [0..1]
LEFT OUTER JOIN /APE/C_PDoc_CONV AS _PDocBOUUID ON _PDocBOUUID.ProcessDocumentBOUUID = BusinessObjectUUID  -- association [0..1]
LEFT OUTER JOIN /APE/C_TDoc_CONV AS _TDocBOUUID ON _TDocBOUUID.TransferDocumentBOUUID = BusinessObjectUUID  -- association [0..1]
;