R_IHBAcctIntrstCompnTP

DDL: R_IHBACCTINTRSTCOMPNTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources

IHB Account Interest Compensation

R_IHBAcctIntrstCompnTP is a Transactional CDS View that provides data about "IHB Account Interest Compensation" in SAP S/4HANA. It reads from 1 data source (I_IHBGroupAssignmentComposite) and exposes 15 fields with key field IHBGroupAssignmentUUID.

Data Sources (1)

SourceAliasJoin Type
I_IHBGroupAssignmentComposite I_IHBGroupAssignmentComposite from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label IHB Account Interest Compensation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey IHBGroupAssignmentUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY IHBGroupAssignmentUUID IHBGroupAssignmentUUID UUID
IHBObjectUUID IHBObjectUUID UUID
IHBGroupAssignmentRefUUID IHBGroupAssignmentRefUUID UUID
IHBObjectCategory IHBObjectCategory Object Category
IHBObjectKeyUUID IHBObjectKeyUUID UUID
IHBAccountNumber _IHBAccount IHBAccountNumber Account Number
IHBGroupAssgmtValidFromDate IHBGroupAssgmtValidFromDate Valid From Date
IHBGroupAssgmtValidToDate IHBGroupAssgmtValidToDate Valid To Date
IHBObjectTotalChangedDateTime IHBObjectTotalChangedDateTime Changed On
IHBObjectCreatedDateTime IHBObjectCreatedDateTime Created At
IHBObjectCreatedByUser IHBObjectCreatedByUser Created By
IHBObjectChangedDateTime IHBObjectChangedDateTime Changed at
IHBObjectChangedByUser IHBObjectChangedByUser Changed by
_IHBMasterDataObjectTP _IHBMasterDataObjectTP
_IHBAccount _IHBAccount

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 R_IHBAcctIntrstCompnTP.
-- 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.

CREATE VIEW R_IHBAcctIntrstCompnTP AS
SELECT
  IHBGroupAssignmentUUID,
  IHBObjectUUID,
  IHBGroupAssignmentRefUUID,
  IHBObjectCategory,
  IHBObjectKeyUUID,
  _IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  IHBGroupAssgmtValidFromDate,
  IHBGroupAssgmtValidToDate,
  IHBObjectTotalChangedDateTime,
  IHBObjectCreatedDateTime,
  IHBObjectCreatedByUser,
  IHBObjectChangedDateTime,
  IHBObjectChangedByUser
FROM I_IHBGroupAssignmentComposite
;

Learn More