I_IHBAccountCondition

DDL: I_IHBACCOUNTCONDITION Type: view_entity COMPOSITE Package: IHB_FICO
58 Fields 3 Data Sources

IHB Account Condition

I_IHBAccountCondition is a Composite CDS View that provides data about "IHB Account Condition" in SAP S/4HANA. It reads from 3 data sources (R_IHBMasterDataObjectTP, R_IHBMasterDataObjectTP, R_IHBMasterDataObjectTP) and exposes 58 fields with key field IHBConditionUUID. Part of development package IHB_FICO.

Data Sources (3)

SourceAliasJoin Type
R_IHBMasterDataObjectTP MDObject from
R_IHBMasterDataObjectTP MDObject union
R_IHBMasterDataObjectTP MDObject union

Parameters (1)

NameTypeDefault
P_IHBObjectKeyUUID uuid

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label IHB Account Condition view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY IHBConditionUUID Condition IHBConditionUUID UUID
IHBObjectUUID R_IHBMasterDataObjectTP IHBObjectUUID UUID
IHBObjectLevel R_IHBMasterDataObjectTP IHBObjectLevel Level
IHBObjectKeyUUID R_IHBMasterDataObjectTP IHBObjectKeyUUID UUID
IHBConditionInterestType Condition IHBConditionInterestType Interest Type
IHBConditionInterestCurrency Condition IHBConditionInterestCurrency Currency
IHBConditionInterestCalcMethod Condition IHBConditionInterestCalcMethod Int.calc.method
IHBConditionInterestCalcType Condition IHBConditionInterestCalcType Interest Calc. Type
IHBConditionFixedRate Condition IHBConditionFixedRate Percentage rate
IHBConditionRefRateCode Condition IHBConditionRefRateCode Ref. Int. Rate
IHBConditionInterestMinRate Condition IHBConditionInterestMinRate Minimum Per. Rate
IHBConditionInterestMaxRate Condition IHBConditionInterestMaxRate Maximum Per. Rate
IHBCndnIntrstMarkUpDownRate Condition IHBCndnIntrstMarkUpDownRate Markup/Markdown
IHBConditionFactoryCalendarID Condition IHBConditionFactoryCalendarID Calendar
IHBCndnIntrstAdjmtPerdInDays Condition IHBCndnIntrstAdjmtPerdInDays Lookback Period
IHBCndnIntrstLockoutPerdInDays Condition IHBCndnIntrstLockoutPerdInDays Interest Lockout Per
IHBConditionInterestWeightCode Condition IHBConditionInterestWeightCode Interest Weight
IHBConditionValidFromDate Condition IHBConditionValidFromDate Valid From Date
P_IHBObjectKeyUUID
P_IHBConditionValidFromDate
IHBConditionUUID UUID
IHBObjectUUID R_IHBMasterDataObjectTP IHBObjectUUID UUID
IHBObjectLevel R_IHBMasterDataObjectTP IHBObjectLevel Level
IHBObjectKeyUUID R_IHBMasterDataObjectTP IHBObjectKeyUUID UUID
IHBConditionInterestType Condition IHBConditionInterestType Interest Type
IHBConditionInterestCurrency Condition IHBConditionInterestCurrency Currency
IHBConditionInterestCalcMethod Condition IHBConditionInterestCalcMethod Int.calc.method
IHBConditionInterestCalcType Condition IHBConditionInterestCalcType Interest Calc. Type
IHBConditionFixedRate Condition IHBConditionFixedRate Percentage rate
IHBConditionRefRateCode Condition IHBConditionRefRateCode Ref. Int. Rate
IHBConditionInterestMinRate Condition IHBConditionInterestMinRate Minimum Per. Rate
IHBConditionInterestMaxRate Condition IHBConditionInterestMaxRate Maximum Per. Rate
IHBCndnIntrstMarkUpDownRate Condition IHBCndnIntrstMarkUpDownRate Markup/Markdown
IHBConditionFactoryCalendarID Condition IHBConditionFactoryCalendarID Calendar
IHBCndnIntrstAdjmtPerdInDays Condition IHBCndnIntrstAdjmtPerdInDays Lookback Period
IHBCndnIntrstLockoutPerdInDays Condition IHBCndnIntrstLockoutPerdInDays Interest Lockout Per
IHBConditionInterestWeightCode Condition IHBConditionInterestWeightCode Interest Weight
IHBConditionValidFromDate Condition IHBConditionValidFromDate Valid From Date
P_IHBConditionValidFromDate
IHBConditionUUID UUID
IHBObjectUUID R_IHBMasterDataObjectTP IHBObjectUUID UUID
IHBObjectLevel R_IHBMasterDataObjectTP IHBObjectLevel Level
IHBObjectKeyUUID R_IHBMasterDataObjectTP IHBObjectKeyUUID UUID
IHBConditionInterestType Condition IHBConditionInterestType Interest Type
IHBConditionInterestCurrency Condition IHBConditionInterestCurrency Currency
IHBConditionInterestCalcMethod Condition IHBConditionInterestCalcMethod Int.calc.method
IHBConditionInterestCalcType Condition IHBConditionInterestCalcType Interest Calc. Type
IHBConditionFixedRate Condition IHBConditionFixedRate Percentage rate
IHBConditionRefRateCode Condition IHBConditionRefRateCode Ref. Int. Rate
IHBConditionInterestMinRate Condition IHBConditionInterestMinRate Minimum Per. Rate
IHBConditionInterestMaxRate Condition IHBConditionInterestMaxRate Maximum Per. Rate
IHBCndnIntrstMarkUpDownRate Condition IHBCndnIntrstMarkUpDownRate Markup/Markdown
IHBConditionFactoryCalendarID Condition IHBConditionFactoryCalendarID Calendar
IHBCndnIntrstAdjmtPerdInDays Condition IHBCndnIntrstAdjmtPerdInDays Lookback Period
IHBCndnIntrstLockoutPerdInDays Condition IHBCndnIntrstLockoutPerdInDays Interest Lockout Per
IHBConditionInterestWeightCode Condition IHBConditionInterestWeightCode Interest Weight
IHBConditionValidFromDate Condition IHBConditionValidFromDate Valid From Date
IHBConditionValidToDate Condition IHBConditionValidToDate Valid To Date

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 I_IHBAccountCondition.
-- 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.
-- Parameters: P_IHBObjectKeyUUID : uuid

CREATE VIEW I_IHBAccountCondition AS
SELECT
  Condition.IHBConditionUUID AS IHBConditionUUID,
  MDObject.IHBObjectUUID AS IHBObjectUUID,
  MDObject.IHBObjectLevel AS IHBObjectLevel,
  MDObject.IHBObjectKeyUUID AS IHBObjectKeyUUID,
  Condition.IHBConditionInterestType AS IHBConditionInterestType,
  Condition.IHBConditionInterestCurrency AS IHBConditionInterestCurrency,
  Condition.IHBConditionInterestCalcMethod AS IHBConditionInterestCalcMethod,
  Condition.IHBConditionInterestCalcType AS IHBConditionInterestCalcType,
  Condition.IHBConditionFixedRate AS IHBConditionFixedRate,
  Condition.IHBConditionRefRateCode AS IHBConditionRefRateCode,
  Condition.IHBConditionInterestMinRate AS IHBConditionInterestMinRate,
  Condition.IHBConditionInterestMaxRate AS IHBConditionInterestMaxRate,
  Condition.IHBCndnIntrstMarkUpDownRate AS IHBCndnIntrstMarkUpDownRate,
  Condition.IHBConditionFactoryCalendarID AS IHBConditionFactoryCalendarID,
  Condition.IHBCndnIntrstAdjmtPerdInDays AS IHBCndnIntrstAdjmtPerdInDays,
  Condition.IHBCndnIntrstLockoutPerdInDays AS IHBCndnIntrstLockoutPerdInDays,
  Condition.IHBConditionInterestWeightCode AS IHBConditionInterestWeightCode,
  Condition.IHBConditionValidFromDate AS IHBConditionValidFromDate,
  Condition.IHBConditionValidToDate AS P_IHBObjectKeyUUID,
  P_IHBConditionValidFromDate : $parameters.P_IHBConditionValidFromDate AS P_IHBConditionValidFromDate,
  Condition.IHBConditionValidToDate AS IHBConditionValidToDate
FROM R_IHBMasterDataObjectTP AS MDObject
-- UNION with additional select branch(es): R_IHBMasterDataObjectTP
;

Learn More