P_ProccatalogcalldetailsWD

@AbapCatalog.sqlViewName: 'PPROCCATCAL000WD'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientDependent: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING

define view P_ProccatalogcalldetailsWD
  as select from    I_Proccatalogcalldetails as ActiveDocument
    left outer join proccatcalldet_d         as DraftDocument on DraftDocument.activeopnctlgwebserviceid = ActiveDocument.OpnCtlgWebServiceID
{
  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) as OpnCtlgWebServiceDraftUUID,
  key ActiveDocument.OpnCtlgWebServiceID                                                 as ActiveOpnCtlgWebServiceID,
      ActiveDocument.OpnCtlgWebServiceID,
      ActiveDocument.OpnCtlgWebServiceName,
      ActiveDocument.IsDefaultCatalog,
      ActiveDocument.OpnCtlgIsProdDspAllwd,
      ActiveDocument.OpnCtlgIsProdUpdtAllwd,
      ActiveDocument.OpnCtlgIsSrcgAllwd,
      ActiveDocument.OpnCtlgHasCrsCtlgSrch,
      ActiveDocument.OpnCtlgHasPartDets,
      ActiveDocument.OpnCtlgHasHttpGet,
      ActiveDocument.OpnCtlgIconPath,
      ActiveDocument.IsOpnCtlgPunchoutDisabled,
      ActiveDocument.IsOpnCtlgExtractionEnabled,
      ActiveDocument.IsErrorMsgNotToBeLogged,
      ActiveDocument.IsSuccessMsgNotToBeLogged,
      ActiveDocument.IsWarningMsgNotToBeLogged,
      DraftDocument.opnctlgwebservicedraftuuid                                           as DraftAdministrativeDataUUID,
      cast( 'X' as sdraft_is_active preserving type )                                    as IsActiveEntity,
      cast( ' ' as sdraft_has_active preserving type )                                   as HasActiveEntity,
      cast(
      case
      when DraftDocument.opnctlgwebservicedraftuuid is null then ' '
      else 'X'
      end  as sdraft_has_draft preserving type )                                         as HasDraftEntity
}
union all select from proccatcalldet_d          as DraftDocument
  inner join          I_DraftAdministrativeData as I_DraftAdministrativeData on I_DraftAdministrativeData.DraftUUID = DraftDocument.opnctlgwebservicedraftuuid
{
  key DraftDocument.opnctlgwebservicedraftuuid,
  key DraftDocument.activeopnctlgwebserviceid,
      DraftDocument.opnctlgwebserviceid,
      DraftDocument.opnctlgwebservicename,
      DraftDocument.isdefaultcatalog,
      DraftDocument.opnctlgisproddspallwd,
      DraftDocument.opnctlgisprodupdtallwd,
      DraftDocument.opnctlgissrcgallwd,
      DraftDocument.opnctlghascrsctlgsrch,
      DraftDocument.opnctlghaspartdets,
      DraftDocument.opnctlghashttpget,
      DraftDocument.opnctlgiconpath,
      DraftDocument.isopnctlgpunchoutdisabled,
      DraftDocument.isopnctlgextractionenabled,
      DraftDocument.iserrormsgnottobelogged,
      DraftDocument.issuccessmsgnottobelogged,
      DraftDocument.iswarningmsgnottobelogged,
      DraftDocument.opnctlgwebservicedraftuuid         as DraftAdministrativeDataUUID,
      cast( ' '  as sdraft_is_active preserving type ) as IsActiveEntity,
      DraftDocument.hasactiveentity,
      cast( ' '  as sdraft_has_draft preserving type ) as HasDraftEntity
}
where
     I_DraftAdministrativeData.CreatedByUser   = $session.user
  or I_DraftAdministrativeData.InProcessByUser = $session.user     
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DRAFTADMINISTRATIVEDATA",
"I_PROCCATALOGCALLDETAILS",
"PROCCATCALLDET_D"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/