R_IHBAcctLimitTP

DDL: R_IHBACCTLIMITTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources

IHB Account Limit

R_IHBAcctLimitTP is a Transactional CDS View that provides data about "IHB Account Limit" in SAP S/4HANA. It reads from 1 data source (I_IHBAcctLimitComposite) and exposes 13 fields with key field IHBLimitUUID.

Data Sources (1)

SourceAliasJoin Type
I_IHBAcctLimitComposite I_IHBAcctLimitComposite from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label IHB Account Limit view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey IHBLimitUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY IHBLimitUUID IHBLimitUUID UUID
IHBObjectUUID IHBObjectUUID UUID
IHBLimitRefUUID IHBLimitRefUUID UUID
IHBLimitAmount IHBLimitAmount Limit Amount
IHBLimitCurrency IHBLimitCurrency Limit Currency
IHBLimitValidFromDate IHBLimitValidFromDate Valid From Date
IHBLimitValidToDate IHBLimitValidToDate 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

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_IHBAcctLimitTP.
-- 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_IHBAcctLimitTP AS
SELECT
  IHBLimitUUID,
  IHBObjectUUID,
  IHBLimitRefUUID,
  IHBLimitAmount,
  IHBLimitCurrency,
  IHBLimitValidFromDate,
  IHBLimitValidToDate,
  IHBObjectTotalChangedDateTime,
  IHBObjectCreatedDateTime,
  IHBObjectCreatedByUser,
  IHBObjectChangedDateTime,
  IHBObjectChangedByUser
FROM I_IHBAcctLimitComposite
;

Learn More