C_IHBIntrstCompnAprvdEml

DDL: C_IHBINTRSTCOMPNAPRVDEML SQL: CIHBINTCOMPNEML3 Type: view CONSUMPTION
14 Fields 1 Data Sources 2 Associations

IHB Interest Compensation Email Template Data Provider

C_IHBIntrstCompnAprvdEml is a Consumption CDS View that provides data about "IHB Interest Compensation Email Template Data Provider" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 14 fields with key field WorkflowTaskInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskURL _WorkflowTaskURL $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID
[0..1] I_User _User $projection.IHBObjectReleasedByUser = _User.UserID

Annotations (12)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
IHBBankArea _IHBMasterDataObjectTP IHBBankArea Bank Area
IHBObjectLevel _IHBMasterDataObjectTP IHBObjectLevel Level
IHBObjectLevelText
IHBAccountNumber
IHBAccountDescription
InhouseBankGroupID
IHBGroupDescription
IHBObjectReleaseDateTime _IHBMasterDataObjectTP IHBObjectReleaseDateTime Released At
IHBObjectReleaseDate
IHBObjectReleaseTime
IHBObjectReleasedByUser _IHBMasterDataObjectTP IHBObjectReleasedByUser Released By
IHBObjectReleasedByUserText
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_IHBIntrstCompnAprvdEml.
-- 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: CIHBINTCOMPNEML3

CREATE VIEW C_IHBIntrstCompnAprvdEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _IHBMasterDataObjectTP.IHBBankArea AS IHBBankArea,
  _IHBMasterDataObjectTP.IHBObjectLevel AS IHBObjectLevel,
  _IHBMasterDataObjectTP._IHBObjectLevel._IHBObjectLevelT[1:Language = $session.system_language ].IHBObjectLevelText AS IHBObjectLevelText,
  _IHBMasterDataObjectTP._IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  _IHBMasterDataObjectTP._IHBAccount._IHBAccountText[1:IHBAccountLanguage = $session.system_language ].IHBAccountDescription AS IHBAccountDescription,
  _IHBMasterDataObjectTP._IHBGroupType.InhouseBankGroupID AS InhouseBankGroupID,
  _IHBMasterDataObjectTP._IHBGroupType._IHBGroupTypeText[1:IHBGroupLanguage = $session.system_language ].IHBGroupDescription AS IHBGroupDescription,
  _IHBMasterDataObjectTP.IHBObjectReleaseDateTime AS IHBObjectReleaseDateTime,
  cast(tstmp_to_dats( IHBObjectReleaseDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS IHBObjectReleaseDate,
  cast(tstmp_to_tims( IHBObjectReleaseDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS IHBObjectReleaseTime,
  _IHBMasterDataObjectTP.IHBObjectReleasedByUser AS IHBObjectReleasedByUser,
  _IHBMasterDataObjectTP._ReleasedBy.UserDescription AS IHBObjectReleasedByUserText,
  _WorkflowTask_WI._WorkflowTaskResult.WorkflowTaskResultComment AS WorkflowTaskResultComment
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON IHBObjectReleasedByUser = _User.UserID  -- association [0..1]
;

Learn More