C_IHBAcctApprvlRsltRjctdEml

DDL: C_IHBACCTAPPRVLRSLTRJCTDEML SQL: CIHBARRPEML3 Type: view CONSUMPTION Package: IHB_ACCOUNT

IHB Account Email Template Provider

C_IHBAcctApprvlRsltRjctdEml is a Consumption CDS View that provides data about "IHB Account Email Template Provider" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 16 fields with key field WorkflowTaskInternalID. It has 1 association to related views. Part of development package IHB_ACCOUNT.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_IHBBankArea _IHBBankArea $projection.IHBBankArea = _IHBBankArea.IHBBankArea

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CIHBARRPEML3 view
EndUserText.label IHB Account Email Template Provider view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
IHBAccountUUID _IHBAccountTP IHBAccountUUID
IHBBankArea _IHBAccountTP IHBBankArea
IHBBankKey _IHBBankArea IHBBankKey
IHBBankAreaCountry _IHBBankArea IHBBankAreaCountry
IHBAccountNumber _IHBAccountTP IHBAccountNumber
IHBAccountCurrency _IHBAccountTP IHBAccountCurrency
IHBAccountHolder _IHBAccountTP IHBAccountHolder
IHBAccountAliasName _IHBAccountTP IHBAccountAliasName
IHBAccountGroupName _IHBAccountTP IHBAccountGroupName
IHBAccountReleasedByUser _IHBAccountTP IHBAccountReleasedByUser
IHBAccountChangedDate
IHBAccountChangedTime
IHBAccountReleasedDate
IHBAccountReleasedTime
WorkflowTaskResultComment 
@AbapCatalog.sqlViewName: 'CIHBARRPEML3'
@EndUserText.label: 'IHB Account Email Template Provider'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType : #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType : {
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@ObjectModel.supportedCapabilities:[ #OUTPUT_EMAIL_DATA_PROVIDER ]
@Metadata.ignorePropagatedAnnotations:true
define view C_IHBAcctApprvlRsltRjctdEml
  as select from           I_WorkflowTask           as _Workflowtask
    join                   I_WorkflowTaskApplObject as _WorkflowTaskApplObject    on  _WorkflowTaskApplObject.WorkflowTaskInternalID        = _Workflowtask.WorkflowTaskInternalID
                                                                                  and _WorkflowTaskApplObject.WorkflowObjectRole            = '01'
                                                                                  and _WorkflowTaskApplObject.TechnicalWrkflwObjectType     = '/PF1/CL_IHBACC_REL_WORKFLOW'
                                                                                  and _WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'
  //    to get approver's comments from workitem log

    left outer to one join I_WorkflowTaskApplObject as _WorkflowTaskApplObject_WI on  _WorkflowTaskApplObject_WI.WorkflowTaskInternalID        = _Workflowtask.WorkflowTaskInternalID
                                                                                  and _WorkflowTaskApplObject_WI.WorkflowObjectRole            = '99'
                                                                                  and _WorkflowTaskApplObject_WI.TechnicalWrkflwObjectType     = 'WORKINGWI'
                                                                                  and _WorkflowTaskApplObject_WI.TechnicalWrkflwObjectCategory = 'BO'
    left outer to one join I_WorkflowTask           as _WorkflowTask_WI           on _WorkflowTask_WI.WorkflowTaskInternalID = _WorkflowTaskApplObject_WI.TechnicalWrkflwObject
    join                   R_IHBAccountTP           as _IHBAccountTP              on  _WorkflowTaskApplObject.TechnicalWrkflwObject =  bintohex(
      _IHBAccountTP.IHBAccountReferenceUUID
    )
                                                                                  and _IHBAccountTP.IHBAccountStatus                <> '02'
  association [0..1] to I_IHBBankArea as _IHBBankArea on $projection.IHBBankArea = _IHBBankArea.IHBBankArea

{
  key _Workflowtask.WorkflowTaskInternalID,
      _IHBAccountTP.IHBAccountUUID,
      _IHBAccountTP.IHBBankArea,
      _IHBBankArea.IHBBankKey,
      _IHBBankArea.IHBBankAreaCountry,
      _IHBAccountTP.IHBAccountNumber,
      _IHBAccountTP.IHBAccountCurrency,
      _IHBAccountTP.IHBAccountHolder,
      _IHBAccountTP.IHBAccountAliasName,
      _IHBAccountTP.IHBAccountGroupName,

      _IHBAccountTP.IHBAccountReleasedByUser,
      case _IHBAccountTP.IHBAccountReleasedByUser
        when '' then _IHBAccountTP.IHBAccountReleasedByUser
        else _IHBAccountTP._ReleasedBy.UserDescription
       end                                                                                                        as IHBAccountReleasedByUserText,

      cast(tstmp_to_dats( _IHBAccountTP.IHBAccountChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd )  as IHBAccountChangedDate,
      cast(tstmp_to_tims( _IHBAccountTP.IHBAccountChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst )  as IHBAccountChangedTime,
      cast(tstmp_to_dats( _IHBAccountTP.IHBAccountReleasedDateTime, 'UTC', $session.client, 'NULL' ) as sww_led ) as IHBAccountReleasedDate,
      cast(tstmp_to_tims( _IHBAccountTP.IHBAccountReleasedDateTime, 'UTC', $session.client, 'NULL' ) as sww_let ) as IHBAccountReleasedTime,

      _WorkflowTask_WI._WorkflowTaskResult.WorkflowTaskResultComment
}

Learn More