C_IHBAcctLimitExpand

DDL: C_IHBACCTLIMITEXPAND Type: view_entity CONSUMPTION
22 Fields 2 Data Sources 2 OData Services

IHB Account Limit List With Expanded Groups

C_IHBAcctLimitExpand is a Consumption CDS View that provides data about "IHB Account Limit List With Expanded Groups" in SAP S/4HANA. It reads from 2 data sources (I_IHBAcctLimitAccount, I_IHBAcctLimitAccountFilter) and exposes 22 fields with key fields IHBObjectUUID, IHBLimitUUID, IHBAccountUUID. It is exposed through 2 OData services (UI_IHBACCOUNTBALANCETP, UI_IHBACCOUNTTP).

Data Sources (2)

SourceAliasJoin Type
I_IHBAcctLimitAccount _IHBAcctLimitAccount from
I_IHBAcctLimitAccountFilter _IHBAcctLimitAccountFilter inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label IHB Account Limit List With Expanded Groups view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_IHBACCOUNTBALANCETP UI_IHBACCOUNTBALANCETP_02 V2 C1 NOT_RELEASED
UI_IHBACCOUNTTP UI_IHBACCOUNTTP_02 V2 C1 NOT_RELEASED

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY IHBObjectUUID I_IHBAcctLimitAccount IHBObjectUUID UUID
KEY IHBLimitUUID I_IHBAcctLimitAccount IHBLimitUUID UUID
KEY IHBAccountUUID I_IHBAcctLimitAccount IHBAccountUUID Account ID
IHBObjectReferenceUUID I_IHBAcctLimitAccount IHBObjectReferenceUUID UUID
IHBObjectType I_IHBAcctLimitAccount IHBObjectType Object Type
IHBObjectCategory I_IHBAcctLimitAccount IHBObjectCategory Object Category
IHBObjectLevel I_IHBAcctLimitAccount IHBObjectLevel Level
IHBObjectLevelText
IHBObjectKeyUUID I_IHBAcctLimitAccount IHBObjectKeyUUID UUID
IHBReleaseStatus I_IHBAcctLimitAccount IHBReleaseStatus Release Status
IHBObjectApprovalActivity I_IHBAcctLimitAccount IHBObjectApprovalActivity IHB Object Activity
IHBAccountNumber I_IHBAcctLimitAccount IHBAccountNumber Account Number
InhouseBankGroupID I_IHBAcctLimitAccount InhouseBankGroupID Group
IHBLimitAmount I_IHBAcctLimitAccount IHBLimitAmount Limit Amount
IHBLimitCurrency I_IHBAcctLimitAccount IHBLimitCurrency Limit Currency
IHBLimitValidFromDate I_IHBAcctLimitAccount IHBLimitValidFromDate Valid From Date
IHBLimitValidToDate I_IHBAcctLimitAccount IHBLimitValidToDate Valid To Date
IHBBankArea I_IHBAcctLimitAccount IHBBankArea Bank Area
_IHBAccount I_IHBAcctLimitAccount _IHBAccount
_IHBGroupAssignment I_IHBAcctLimitAccount _IHBGroupAssignment
_IHBGroupType I_IHBAcctLimitAccount _IHBGroupType
_IHBObjectLevel I_IHBAcctLimitAccount _IHBObjectLevel

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_IHBAcctLimitExpand.
-- 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 C_IHBAcctLimitExpand AS
SELECT
  _IHBAcctLimitAccount.IHBObjectUUID AS IHBObjectUUID,
  _IHBAcctLimitAccount.IHBLimitUUID AS IHBLimitUUID,
  _IHBAcctLimitAccount.IHBAccountUUID AS IHBAccountUUID,
  _IHBAcctLimitAccount.IHBObjectReferenceUUID AS IHBObjectReferenceUUID,
  _IHBAcctLimitAccount.IHBObjectType AS IHBObjectType,
  _IHBAcctLimitAccount.IHBObjectCategory AS IHBObjectCategory,
  _IHBAcctLimitAccount.IHBObjectLevel AS IHBObjectLevel,
  _IHBAcctLimitAccount._IHBObjectLevel._IHBObjectLevelT[1:Language = $session.system_language ].IHBObjectLevelText AS IHBObjectLevelText,
  _IHBAcctLimitAccount.IHBObjectKeyUUID AS IHBObjectKeyUUID,
  _IHBAcctLimitAccount.IHBReleaseStatus AS IHBReleaseStatus,
  _IHBAcctLimitAccount.IHBObjectApprovalActivity AS IHBObjectApprovalActivity,
  _IHBAcctLimitAccount.IHBAccountNumber AS IHBAccountNumber,
  _IHBAcctLimitAccount.InhouseBankGroupID AS InhouseBankGroupID,
  _IHBAcctLimitAccount.IHBLimitAmount AS IHBLimitAmount,
  _IHBAcctLimitAccount.IHBLimitCurrency AS IHBLimitCurrency,
  _IHBAcctLimitAccount.IHBLimitValidFromDate AS IHBLimitValidFromDate,
  _IHBAcctLimitAccount.IHBLimitValidToDate AS IHBLimitValidToDate,
  _IHBAcctLimitAccount.IHBBankArea AS IHBBankArea,
  _IHBAcctLimitAccount._IHBAccount AS _IHBAccount,
  _IHBAcctLimitAccount._IHBGroupAssignment AS _IHBGroupAssignment,
  _IHBAcctLimitAccount._IHBGroupType AS _IHBGroupType,
  _IHBAcctLimitAccount._IHBObjectLevel AS _IHBObjectLevel
FROM I_IHBAcctLimitAccount AS _IHBAcctLimitAccount
INNER JOIN I_IHBAcctLimitAccountFilter AS _IHBAcctLimitAccountFilter ON /* join condition not captured in parsed metadata */
;

Learn More