C_IHBIntrstCompnApprvlStrtEml

DDL: C_IHBINTRSTCOMPNAPPRVLSTRTEML SQL: CIHBINTCOMPNEML2 Type: view CONSUMPTION Package: IHB_INTEREST_COMPENSATION
21 Fields 1 Data Sources 2 Associations

IHB Interest Compensation Email Template Data Provider

C_IHBIntrstCompnApprvlStrtEml 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 21 fields with key field WorkflowTaskInternalID. It has 2 associations to related views. Part of development package IHB_INTEREST_COMPENSATION.

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.IHBObjectChangedByUser = _User.UserID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CIHBINTCOMPNEML2 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 (21)

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
IHBObjectApprovalActivity _IHBMasterDataObjectTP IHBObjectApprovalActivity IHB Object Activity
IHBObjectChangedDateTime _IHBMasterDataObjectTP IHBObjectChangedDateTime Changed at
IHBObjectChangedDate
IHBObjectChangedTime
IHBObjectDeadlineDateTime _IHBMasterDataObjectTP IHBObjectDeadlineDateTime Time Stamp
IHBObjectDeadlineDate
IHBObjectDeadlineTime
IHBObjectChangedByUser _IHBMasterDataObjectTP IHBObjectChangedByUser Changed by
IHBObjectChangedByUserText _User UserDescription Full Name
WorkflowTaskResultReasonText
WorkflowTaskResultComment
WrkflwTskCreationUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime Created On
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL

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_IHBIntrstCompnApprvlStrtEml.
-- 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: CIHBINTCOMPNEML2

CREATE VIEW C_IHBIntrstCompnApprvlStrtEml 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.IHBObjectApprovalActivity AS IHBObjectApprovalActivity,
  _IHBMasterDataObjectTP.IHBObjectChangedDateTime AS IHBObjectChangedDateTime,
  cast(tstmp_to_dats( IHBObjectChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS IHBObjectChangedDate,
  cast(tstmp_to_tims( IHBObjectChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS IHBObjectChangedTime,
  _IHBMasterDataObjectTP.IHBObjectDeadlineDateTime AS IHBObjectDeadlineDateTime,
  cast(tstmp_to_dats( IHBObjectDeadlineDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS IHBObjectDeadlineDate,
  cast(tstmp_to_tims( IHBObjectDeadlineDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS IHBObjectDeadlineTime,
  _IHBMasterDataObjectTP.IHBObjectChangedByUser AS IHBObjectChangedByUser,
  _User.UserDescription AS IHBObjectChangedByUserText,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReasonText AS WorkflowTaskResultReasonText,
  _Workflowtask._WorkflowTaskResult.WorkflowTaskResultComment AS WorkflowTaskResultComment,
  _Workflowtask.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  _WorkflowTaskURL.WorkflowTaskURL AS WorkflowTaskURL
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 IHBObjectChangedByUser = _User.UserID  -- association [0..1]
;

Learn More