C_IHBIntrstCompnRjctdEml

DDL: C_IHBINTRSTCOMPNRJCTDEML SQL: CIHBINTCOMPNEML4 Type: view CONSUMPTION
13 Fields 1 Data Sources 2 Associations

IHB Interest Compensation Email Template Data Provider

C_IHBIntrstCompnRjctdEml 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 13 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 CIHBINTCOMPNEML4 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 (13)

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
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_IHBIntrstCompnRjctdEml.
-- 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: CIHBINTCOMPNEML4

CREATE VIEW C_IHBIntrstCompnRjctdEml 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,
  _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