Aps_Com_Cs_D2_Root_Tp

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 Aps_Com_Cs_D2_Root_Tp.
-- 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: APS_COM_CS_R_T_2

CREATE VIEW Aps_Com_Cs_D2_Root_Tp AS
SELECT
  Document.db_key AS db_key,
  Document.CommSyst AS CommSyst,
  cast (Document.IsManagedBySAP as boole_d ) AS IsManagedBySAP,
  Document.CommSystName AS CommSystName,
  Document.CommSystPort AS CommSystPort,
  Document.CommSystDescription AS CommSystDescription,
  Document.CommunicationProtocol AS CommunicationProtocol,
  Document.IntermediateDocLogicalSystem AS IntermediateDocLogicalSystem,
  Document.CommSystSAPClient AS CommSystSAPClient,
  Document.CommSystHostName AS CommSystHostName,
  Document.CommSystUIHostName AS CommSystUIHostName,
  Document.CommSystOwnrCntCtPersnName AS CommSystOwnrCntCtPersnName,
  Document.CommSystOwnrCntCtPersnPhnmbr AS CommSystOwnrCntCtPersnPhnmbr,
  Document.CommSystOwnrCntCtPersnEmlAddr AS CommSystOwnrCntCtPersnEmlAddr,
  Document.CommSystEditStatus AS CommSystEditStatus,
  Document.CommSystType AS CommSystType,
  Document.BusinessSystemName AS BusinessSystemName,
  Document.IsOwnSystem AS IsOwnSystem,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.OAuth2IDPEnabled AS OAuth2IDPEnabled,
  Document.OAuth2IDPCertificate AS OAuth2IDPCertificate,
  Document.OAuth2IDPCertificateUUID AS OAuth2IDPCertificateUUID,
  Document.OAuth2IDPName AS OAuth2IDPName,
  Document.OAuth2IDPCTFSubject AS OAuth2IDPCTFSubject,
  Document.OAuth2IDPCTFIssuer AS OAuth2IDPCTFIssuer,
  Document.OAuth2IDPUserLogonType AS OAuth2IDPUserLogonType,
  Document.OAuth2RedirectUri AS OAuth2RedirectUri,
  Document.OAuth2RedirectUriIsLoopback AS OAuth2RedirectUriIsLoopback,
  Document.OAuth2AuthEndpoint AS OAuth2AuthEndpoint,
  Document.OAuth2TokenEndpoint AS OAuth2TokenEndpoint,
  Document.OAuth2Audience AS OAuth2Audience,
  Document.OAuth2mTLSEndpoint AS OAuth2mTLSEndpoint,
  Document.CipherSuiteCode AS CipherSuiteCode,
  Document.IsABAPSystem AS IsABAPSystem,
  Document.SccLocationID AS SccLocationID,
  Document.TechnicalUserPropagation AS TechnicalUserPropagation,
  Document.IsLoadBalancing AS IsLoadBalancing,
  Document.SAPSystemID AS SAPSystemID,
  Document.SAPSystemNumber AS SAPSystemNumber,
  Document.LogonGroup AS LogonGroup,
  Document.MessageServerTargetHost AS MessageServerTargetHost,
  Document.FastSerializer AS FastSerializer,
  Document.RFCNonUnicodeSystem AS RFCNonUnicodeSystem,
  Document.DestinationService AS DestinationService,
  Document.DestinationServiceName AS DestinationServiceName,
  Document.UseDefaultDestService AS UseDefaultDestService,
  Document.IsHubSystem AS IsHubSystem,
  Document.InboundOnly AS InboundOnly,
  Document.SAMLBAPEnabled AS SAMLBAPEnabled,
  Document.SAMLBAPName AS SAMLBAPName,
  Document.SAMLBAPUserLogonType AS SAMLBAPUserLogonType,
  Document.SAMLBAPCertUUID AS SAMLBAPCertUUID,
  Document.RemoteSqlEnabled AS RemoteSqlEnabled,
  Document.RemoteSqlAdapterName AS RemoteSqlAdapterName,
  Document.RemoteSqlAdapterConfig AS RemoteSqlAdapterConfig
FROM Aps_Com_Cs_D2_Root AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Inbound_Tp AS _Inbound ON _Inbound.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN Aps_Com_Cs_D2_Outbound_Tp AS _Outbound ON _Outbound.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_PARTNER_TP AS _Partner ON _Partner.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC_TP AS _Oidc ON _Oidc.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_EVENT_TP AS _Event ON _Event.parent_key = db_key  -- association [0..*]
;