Aps_Com_Cs_D2_Root

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.
-- 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_2

CREATE VIEW Aps_Com_Cs_D2_Root AS
SELECT
  Document.db_key AS db_key,
  Document.commsyst AS CommSyst,
  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,
  cast( Document.creationdatetime as timestamp ) AS CreationDateTime,
  Document.createdbyuser AS CreatedByUser,
  cast( Document.lastchangedatetime as timestamp ) 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.ishubsystem AS IsHubSystem,
  Document.inboundonly AS InboundOnly,
  Document.usedefaultdestservice AS UseDefaultDestService,
  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_cs_d_root AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Inbound AS _Inbound ON _Inbound.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN Aps_Com_Cs_D2_Outbound AS _Outbound ON _Outbound.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_PARTNER AS _Partner ON _Partner.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_OIDC AS _Oidc ON _Oidc.parent_key = db_key  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_D2_EVENT AS _Event ON _Event.parent_key = db_key  -- association [0..*]
;