Aps_Com_Cs_D2_Root

@AbapCatalog.sqlViewName: 'APS_COM_CS_R_2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Communication System Draft 2.0 root view'
@ObjectModel.compositionRoot: true

define view Aps_Com_Cs_D2_Root
  as select from aps_cs_d_root as Document
  association [0..*] to Aps_Com_Cs_D2_Inbound  as _Inbound  on _Inbound.parent_key = $projection.db_key
  association [0..*] to Aps_Com_Cs_D2_Outbound as _Outbound on _Outbound.parent_key = $projection.db_key
  association [0..*] to APS_COM_CS_D2_PARTNER  as _Partner  on _Partner.parent_key = $projection.db_key
  association [0..*] to APS_COM_CS_D2_OIDC     as _Oidc     on _Oidc.parent_key = $projection.db_key
  association [0..*] to APS_COM_CS_D2_EVENT    as _Event    on _Event.parent_key = $projection.db_key
{
  key Document.db_key,
      Document.commsyst                                as CommSyst,
      case
       when Document.commsyst like 'SAP_%' then 'X'
       else ''
       end                                             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,
//      case 

//        when Document.commsysttype = '' and Document.commsyst like 'SAP_%' then '2'

//        when Document.commsysttype = '' and Document.commsyst not like 'SAP_%' then '1'

//        else Document.commsysttype  

//        end                                            as CommSystType,

      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,
      
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Inbound,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Outbound,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Partner,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Oidc,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Event      
}