C_IHBAcctApprvlRsltRjctdEml

DDL: C_IHBACCTAPPRVLRSLTRJCTDEML SQL: CIHBARRPEML3 Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

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.

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 Work Item ID
IHBAccountUUID _IHBAccountTP IHBAccountUUID Account ID
IHBBankArea _IHBAccountTP IHBBankArea Bank Area
IHBBankKey _IHBBankArea IHBBankKey IHB Bank Key
IHBBankAreaCountry _IHBBankArea IHBBankAreaCountry Bank Ctry/Rgn. Key
IHBAccountNumber _IHBAccountTP IHBAccountNumber Account Number
IHBAccountCurrency _IHBAccountTP IHBAccountCurrency Currency
IHBAccountHolder _IHBAccountTP IHBAccountHolder Busn. Partner
IHBAccountAliasName _IHBAccountTP IHBAccountAliasName Alias
IHBAccountGroupName _IHBAccountTP IHBAccountGroupName Account Group
IHBAccountReleasedByUser _IHBAccountTP IHBAccountReleasedByUser Released By
IHBAccountChangedDate
IHBAccountChangedTime
IHBAccountReleasedDate
IHBAccountReleasedTime
WorkflowTaskResultComment

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 C_IHBAcctApprvlRsltRjctdEml.
-- 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: CIHBARRPEML3

CREATE VIEW C_IHBAcctApprvlRsltRjctdEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _IHBAccountTP.IHBAccountUUID AS IHBAccountUUID,
  _IHBAccountTP.IHBBankArea AS IHBBankArea,
  _IHBBankArea.IHBBankKey AS IHBBankKey,
  _IHBBankArea.IHBBankAreaCountry AS IHBBankAreaCountry,
  _IHBAccountTP.IHBAccountNumber AS IHBAccountNumber,
  _IHBAccountTP.IHBAccountCurrency AS IHBAccountCurrency,
  _IHBAccountTP.IHBAccountHolder AS IHBAccountHolder,
  _IHBAccountTP.IHBAccountAliasName AS IHBAccountAliasName,
  _IHBAccountTP.IHBAccountGroupName AS IHBAccountGroupName,
  _IHBAccountTP.IHBAccountReleasedByUser AS IHBAccountReleasedByUser,
  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 AS WorkflowTaskResultComment
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_IHBBankArea AS _IHBBankArea ON IHBBankArea = _IHBBankArea.IHBBankArea  -- association [0..1]
;

Learn More