P_Cfd_Registry_Soap

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_Cfd_Registry_Soap.
-- 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: P_CFD_RGSTRY_SOP

CREATE VIEW P_Cfd_Registry_Soap AS
SELECT
  _Registry.service_interface_name AS ServiceInterfaceName,
  _RegistryContext.business_context AS BusinessContext,
  _RegistryContext.operation AS Operation,
  _RegistryContext.message_direction AS MessageDirection,
  _Registry.service_interface_type AS ServiceInterfaceType,
  _RegistryContext.mdr_data_type_name AS MdrDataTypeName,
  _RegistryContext.release_status AS ReleaseStatus,
  _Registry.availability AS Availability
FROM cfd_w_soap_ctxt AS _RegistryContext
LEFT OUTER JOIN cfd_w_soap_t AS _ServiceInterfaceDescription ON _ServiceInterfaceDescription.service_interface_name = ServiceInterfaceName  -- association [0..*]
LEFT OUTER JOIN P_Cfd_Domain_Value_Text AS _MessageDirectionDescription ON _MessageDirectionDescription.Name = 'CFD_SOAP_MESSAGE_DIRECTION' AND _MessageDirectionDescription.Code = MessageDirection association[0..*] to P_Cfd_Domain_Value_Text as _ServiceInterfaceTypeDescr on _ServiceInterfaceTypeDescr.Name = 'CFD_SERVICE_INTERFACE_TYPE' AND _ServiceInterfaceTypeDescr.Code = ServiceInterfaceType  -- association [0..*]
;