/APE/C_TransferDocBOHeader_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_TransferDocBOHeader_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_TransferDocBOHeader_UI AS
SELECT
  BusinessObject.db_key AS BusinessObjectDocumentKey,
  BusinessObject.parent_key AS TransferDocumentKey,
  BusinessObject.bo_ext_uuid AS BOExternalUUID,
  BusinessObject.bo_ext_uuid_prev AS BOExternalUUIDPrev,
  BusinessObject.bo_status AS BOStatus,
  BusinessObject.operation AS Operation,
  BusinessObject.com_acc_uuid AS CommonAccessUUID,
  BusinessObject.bu_partner_uuid AS BusinessPartnerUUID,
  BusinessObject.proc_cluster AS ProcessCluster,
  BusinessObject.tech_msg_id AS TechnicalMessage,
  BusinessObject.tech_msg_version AS TechnicalMessageVersion,
  BusinessObject.bus_msg_id AS BusinessMessageID,
  BusinessObject.response_cat AS MessageCategory,
  BusinessObject.user_uuid AS InitiatingBackendUser,
  BusinessObject.blocked AS BusinessPartnerBlocked,
  BusinessObject.person_data_ind AS PersonalData,
  BusinessObject.client_uuid AS client_uuid,
  BusinessObject.trans_direct AS trans_direct,
  BusinessObject.sender_id AS sender_id,
  BusinessObject.receiver_id AS receiver_id,
  BusinessObject.auth_grp AS auth_grp
FROM /APE/I_TransBOHeader_TP AS BusinessObject
LEFT OUTER JOIN /APE/C_TransferDoc_UI AS _trans_header ON _trans_header.TransferDocumentKey = TransferDocumentKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_TransBOID_UI AS _BOIdentification ON _BOIdentification.BusinessObjectDocumentKey = BusinessObjectDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_TransBORelation_UI AS _BORelation ON _BORelation.BusinessObjectDocumentKey = BusinessObjectDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_TransBOData_UI AS _BOData ON _BOData.BusinessObjectDocumentKey = BusinessObjectDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_BOSTA_VH AS _BOStatus ON _BOStatus.BOStatus = BOStatus  -- association [0..1]
LEFT OUTER JOIN /APE/C_BusinessMessageID_VH AS _BusinessMessageID ON _BusinessMessageID.BusinessMessageID = BusinessMessageID  -- association [0..1]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _MessageCategory ON _MessageCategory.Domname = '/APE/D_RESPONSE_CATEGORY' AND _MessageCategory.Domvalue = MessageCategory  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessCluster ON _ProcessCluster.ProcessCluster = ProcessCluster  -- association [0..1]
LEFT OUTER JOIN /APE/C_BusinessMessageID_VH AS _TechnicalMessage ON _TechnicalMessage.BusinessMessageID = TechnicalMessage  -- association [0..1]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _Operation ON _Operation.Domname = '/APE/D_BO_OPERATION' AND _Operation.Domvalue = Operation  -- association [0..1]
;