A_IntrstRateInstrCondition_2

DDL: A_INTRSTRATEINSTRCONDITION_2 Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_TM_FT_API
132 Fields 1 Data Sources 1 OData Services

Condition

A_IntrstRateInstrCondition_2 is a Consumption CDS View that provides data about "Condition" in SAP S/4HANA. It reads from 1 data source (R_FinTransConditionTP) and exposes 132 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It is exposed through 1 OData service (API_FINTRANSINTRSTRATEINSTR_3). Part of development package RAP_FIN_TRM_TM_FT_API.

Data Sources (1)

SourceAliasJoin Type
R_FinTransConditionTP R_FinTransConditionTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Condition view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name IntrstRateInstrCondition_Type view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_FINTRANSINTRSTRATEINSTR_3

Fields (132)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY FinancialInstrumentActivity FinancialInstrumentActivity
KEY FinancialTransactionDirection FinancialTransactionDirection
KEY FinConditionItem FinConditionItem
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate
FinConditionForm FinConditionForm
FinInstrConditionLogicGroup FinInstrConditionLogicGroup
TreasuryContractType TreasuryContractType Treasury Contract Type
FinConditionConditionCategory FinConditionConditionCategory
FinConditionConditionType FinConditionConditionType
InterestCalculationMethod InterestCalculationMethod
InterestCalculationType InterestCalculationType
FinConditionInterestCategory FinConditionInterestCategory
ConditionPercentageRate ConditionPercentageRate
FinConditionFormulaReference FinConditionFormulaReference
InterestReference InterestReference
FinConditionFixedAmount FinConditionFixedAmount
FinConditionFixedAmountCrcy FinConditionFixedAmountCrcy
FinConditionRpaytPercentRate FinConditionRpaytPercentRate
FinConditionRpaytBaseAmount FinConditionRpaytBaseAmount
FinConditionRpaytAmount FinConditionRpaytAmount
FinConditionRpaytCurrency FinConditionRpaytCurrency
CalculationDate CalculationDate
FinCndnCalcDteUpdateRule FinCndnCalcDteUpdateRule
FinCndnCalcDteFrequency FinCndnCalcDteFrequency
FinCndnCalcDteFrqcyUnit FinCndnCalcDteFrqcyUnit
CalcDateIsAsEndDateInclusive CalcDateIsAsEndDateInclusive
CalcDateIsAsEndDateMonthEnd CalcDateIsAsEndDateMonthEnd
FinCndnCalcDteWrkgDayShft FinCndnCalcDteWrkgDayShft
FinCndnCalcDteShftDrctn FinCndnCalcDteShftDrctn
FinCndnCalcDteShftNrOfDays FinCndnCalcDteShftNrOfDays
DueDate DueDate Promised For
FinCndnDueDteUpdateRule FinCndnDueDteUpdateRule
FinCndnDueDteFrequency FinCndnDueDteFrequency
FinCndnDueDteFrqcyUnit FinCndnDueDteFrqcyUnit
DueDateIsAsEndDateInclusive DueDateIsAsEndDateInclusive
DueDateIsAsEndDateMonthEnd DueDateIsAsEndDateMonthEnd
FinCndnDueDteWrkgDayShft FinCndnDueDteWrkgDayShft
FinCndnDueDteShftDrctn FinCndnDueDteShftDrctn
FinCndnDueDteShftNrOfDays FinCndnDueDteShftNrOfDays
FinConditionFactoryCalendar1 FinConditionFactoryCalendar1
FinConditionFactoryCalendar2 FinConditionFactoryCalendar2
FinConditionFactoryCalendar3 FinConditionFactoryCalendar3
FinConditionFactoryCalendar4 FinConditionFactoryCalendar4
FinConditionFactoryCalendar5 FinConditionFactoryCalendar5
ExponentialIntrstSettlmtFrqcy ExponentialIntrstSettlmtFrqcy
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar
FinancialConditionPaymentRate FinancialConditionPaymentRate
InterestMarkupMarkdownValue InterestMarkupMarkdownValue
InterestFirstPeriodRate InterestFirstPeriodRate
AverageIntrstRateWeightingCat AverageIntrstRateWeightingCat
AverageIntrstRateRndngCategory AverageIntrstRateRndngCategory
AverageIntrstRateRndngDecimals AverageIntrstRateRndngDecimals
AverageInterestRateSpreadValue AverageInterestRateSpreadValue
AvgIntrstRateHasUsedUpperLimit AvgIntrstRateHasUsedUpperLimit
AverageInterestUpperLimitRate AverageInterestUpperLimitRate
AvgIntrstRateHasUsedLowerLimit AvgIntrstRateHasUsedLowerLimit
AverageInterestLowerLimitRate AverageInterestLowerLimitRate
AverageIntrstRateResetCalcEvt AverageIntrstRateResetCalcEvt
FinCndnRateFactorRndngCategory FinCndnRateFactorRndngCategory
FinCndnRateFactorRndngDecimals FinCndnRateFactorRndngDecimals
FinCndnFactorRoundingCategory FinCndnFactorRoundingCategory
FinCndnFactorRoundingDecimals FinCndnFactorRoundingDecimals
FinCndnBaseFactorRndngCategory FinCndnBaseFactorRndngCategory
FinCndnBaseFactorRndngDecimals FinCndnBaseFactorRndngDecimals
FinCndnAmountRoundingCategory FinCndnAmountRoundingCategory
FinCndnAmountRoundingUnit FinCndnAmountRoundingUnit
RndngBaseUntAmtInCndnItmCrcy RndngBaseUntAmtInCndnItmCrcy
FinConditionIntrstBaseAmount FinConditionIntrstBaseAmount
FinCndnCalcBaseReference FinCndnCalcBaseReference
FinCndnProcessingSequenceValue FinCndnProcessingSequenceValue
FinCndnAmountTimeUnit FinCndnAmountTimeUnit
FinCndnLimitAmountCurrency FinCndnLimitAmountCurrency
FinCndnItmHasUsedLowerLimitAmt FinCndnItmHasUsedLowerLimitAmt
FinCndnItemLowerLimitAmount FinCndnItemLowerLimitAmount
FinCndnItmHasUsedUpperLimitAmt FinCndnItmHasUsedUpperLimitAmt
FinCndnItemUpperLimitAmount FinCndnItemUpperLimitAmount
FinCndnCrsRefcdAccmlnCndnGrp FinCndnCrsRefcdAccmlnCndnGrp
RefcdIntrstRateAdjmtCondition RefcdIntrstRateAdjmtCondition
RefcdPrcIdxAdjmtCondition RefcdPrcIdxAdjmtCondition
InterestCalculationDateRef InterestCalculationDateRef
InterestDueDateReference InterestDueDateReference
CalcDteIsRegularWithVarblDte CalcDteIsRegularWithVarblDte
DueDteIsRegularWithVarblDte DueDteIsRegularWithVarblDte
FinCndnFirstPeriodCalcMethod FinCndnFirstPeriodCalcMethod
FinCndnLastPeriodCalcMethod FinCndnLastPeriodCalcMethod
FinCndnDueDteShiftToTermEnd FinCndnDueDteShiftToTermEnd
FinCndnPaytDateWrkgDayShft FinCndnPaytDateWrkgDayShft
FinCndnRpaytSettlmt FinCndnRpaytSettlmt
InterestRateAdjustmentDateRule InterestRateAdjustmentDateRule
InterestRateAdjustmentFrqcy InterestRateAdjustmentFrqcy
InterestRateAdjmtFrqcyUnit InterestRateAdjmtFrqcyUnit
InterestRateAdjustmentDate InterestRateAdjustmentDate
IntrstRateAdjmtDateIsMonthEnd IntrstRateAdjmtDateIsMonthEnd
IntrstRateAdjmtDteIsExclusive IntrstRateAdjmtDteIsExclusive
IntrstRateAdjmtDateWrkgDayShft IntrstRateAdjmtDateWrkgDayShft
IntrstRateAdjmtShftNrOfDays IntrstRateAdjmtShftNrOfDays
FinCndnAdjmtDteShftDrctn FinCndnAdjmtDteShftDrctn
InterestRateFixingDateRule InterestRateFixingDateRule
InterestRateFixingFrqcy InterestRateFixingFrqcy
InterestRateFixingFrqcyUnit InterestRateFixingFrqcyUnit
InterestRateFixingDate InterestRateFixingDate
IntrstRateFixingDateIsMonthEnd IntrstRateFixingDateIsMonthEnd
FinCndnFixingDteShftDrctn FinCndnFixingDteShftDrctn
InterestRateFixingShftNrOfDays InterestRateFixingShftNrOfDays
IntrstRateFixDteShftIsModifd IntrstRateFixDteShftIsModifd
InterestRateFixingDateRef InterestRateFixingDateRef
FinCndnRateFixingLockoutPeriod FinCndnRateFixingLockoutPeriod
TreasuryPriceIndex TreasuryPriceIndex
PriceIndexInterpolationMethod PriceIndexInterpolationMethod
PriceIndexApplicationMethod PriceIndexApplicationMethod
PrcIdxFctrCalcCompoundingFrqcy PrcIdxFctrCalcCompoundingFrqcy
FinCndnDayFracRoundingCat FinCndnDayFracRoundingCat
FinCndnDayFracRoundingDcmls FinCndnDayFracRoundingDcmls
PrcIdxAdjmtDateReference PrcIdxAdjmtDateReference
PrcIdxAdjmtDateWrkgDayShift PrcIdxAdjmtDateWrkgDayShift
PrcIdxAdjmtDateShftDrctn PrcIdxAdjmtDateShftDrctn
PrcIdxAdjmtShftNrOfDays PrcIdxAdjmtShftNrOfDays
PriceIndexAdjustmentBaseDate PriceIndexAdjustmentBaseDate
PrcIdxAdjmtFixingLowDate PrcIdxAdjmtFixingLowDate
PrcIdxAdjmtFixingHighDate PrcIdxAdjmtFixingHighDate
PrcIdxAdjmtFxngDteWrkgDayShft PrcIdxAdjmtFxngDteWrkgDayShft
PrcIdxAdjmtFixingDateShftDrctn PrcIdxAdjmtFixingDateShftDrctn
PrcIdxAdjmtFxngDteShftNrOfDays PrcIdxAdjmtFxngDteShftNrOfDays
FinConditionSettlementCrcy FinConditionSettlementCrcy
ForeignExchangeFixingReference ForeignExchangeFixingReference
FXRateAdjmtFixingDateRef FXRateAdjmtFixingDateRef
FXRateAdjmtFixingDateShftDrctn FXRateAdjmtFixingDateShftDrctn
FXRateAdjmtFxngDteShftNrOfDays FXRateAdjmtFxngDteShftNrOfDays
FXRateAdjmtFxngDteShftIsModifd FXRateAdjmtFxngDteShftIsModifd
_FinTrans _FinTrans

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 A_IntrstRateInstrCondition_2.
-- 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 A_IntrstRateInstrCondition_2 AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialInstrumentActivity,
  FinancialTransactionDirection,
  FinConditionItem,
  ConditionItemValidityStartDate,
  FinConditionForm,
  FinInstrConditionLogicGroup,
  TreasuryContractType,
  FinConditionConditionCategory,
  FinConditionConditionType,
  InterestCalculationMethod,
  InterestCalculationType,
  FinConditionInterestCategory,
  ConditionPercentageRate,
  FinConditionFormulaReference,
  InterestReference,
  FinConditionFixedAmount,
  FinConditionFixedAmountCrcy,
  FinConditionRpaytPercentRate,
  FinConditionRpaytBaseAmount,
  FinConditionRpaytAmount,
  FinConditionRpaytCurrency,
  CalculationDate,
  FinCndnCalcDteUpdateRule,
  FinCndnCalcDteFrequency,
  FinCndnCalcDteFrqcyUnit,
  CalcDateIsAsEndDateInclusive,
  CalcDateIsAsEndDateMonthEnd,
  FinCndnCalcDteWrkgDayShft,
  FinCndnCalcDteShftDrctn,
  FinCndnCalcDteShftNrOfDays,
  DueDate,
  FinCndnDueDteUpdateRule,
  FinCndnDueDteFrequency,
  FinCndnDueDteFrqcyUnit,
  DueDateIsAsEndDateInclusive,
  DueDateIsAsEndDateMonthEnd,
  FinCndnDueDteWrkgDayShft,
  FinCndnDueDteShftDrctn,
  FinCndnDueDteShftNrOfDays,
  FinConditionFactoryCalendar1,
  FinConditionFactoryCalendar2,
  FinConditionFactoryCalendar3,
  FinConditionFactoryCalendar4,
  FinConditionFactoryCalendar5,
  ExponentialIntrstSettlmtFrqcy,
  IntrstCalcMethFactoryCalendar,
  FinancialConditionPaymentRate,
  InterestMarkupMarkdownValue,
  InterestFirstPeriodRate,
  AverageIntrstRateWeightingCat,
  AverageIntrstRateRndngCategory,
  AverageIntrstRateRndngDecimals,
  AverageInterestRateSpreadValue,
  AvgIntrstRateHasUsedUpperLimit,
  AverageInterestUpperLimitRate,
  AvgIntrstRateHasUsedLowerLimit,
  AverageInterestLowerLimitRate,
  AverageIntrstRateResetCalcEvt,
  FinCndnRateFactorRndngCategory,
  FinCndnRateFactorRndngDecimals,
  FinCndnFactorRoundingCategory,
  FinCndnFactorRoundingDecimals,
  FinCndnBaseFactorRndngCategory,
  FinCndnBaseFactorRndngDecimals,
  FinCndnAmountRoundingCategory,
  FinCndnAmountRoundingUnit,
  RndngBaseUntAmtInCndnItmCrcy,
  FinConditionIntrstBaseAmount,
  FinCndnCalcBaseReference,
  FinCndnProcessingSequenceValue,
  FinCndnAmountTimeUnit,
  FinCndnLimitAmountCurrency,
  FinCndnItmHasUsedLowerLimitAmt,
  FinCndnItemLowerLimitAmount,
  FinCndnItmHasUsedUpperLimitAmt,
  FinCndnItemUpperLimitAmount,
  FinCndnCrsRefcdAccmlnCndnGrp,
  RefcdIntrstRateAdjmtCondition,
  RefcdPrcIdxAdjmtCondition,
  InterestCalculationDateRef,
  InterestDueDateReference,
  CalcDteIsRegularWithVarblDte,
  DueDteIsRegularWithVarblDte,
  FinCndnFirstPeriodCalcMethod,
  FinCndnLastPeriodCalcMethod,
  FinCndnDueDteShiftToTermEnd,
  FinCndnPaytDateWrkgDayShft,
  FinCndnRpaytSettlmt,
  InterestRateAdjustmentDateRule,
  InterestRateAdjustmentFrqcy,
  InterestRateAdjmtFrqcyUnit,
  InterestRateAdjustmentDate,
  IntrstRateAdjmtDateIsMonthEnd,
  IntrstRateAdjmtDteIsExclusive,
  IntrstRateAdjmtDateWrkgDayShft,
  IntrstRateAdjmtShftNrOfDays,
  FinCndnAdjmtDteShftDrctn,
  InterestRateFixingDateRule,
  InterestRateFixingFrqcy,
  InterestRateFixingFrqcyUnit,
  InterestRateFixingDate,
  IntrstRateFixingDateIsMonthEnd,
  FinCndnFixingDteShftDrctn,
  InterestRateFixingShftNrOfDays,
  IntrstRateFixDteShftIsModifd,
  InterestRateFixingDateRef,
  FinCndnRateFixingLockoutPeriod,
  TreasuryPriceIndex,
  PriceIndexInterpolationMethod,
  PriceIndexApplicationMethod,
  PrcIdxFctrCalcCompoundingFrqcy,
  FinCndnDayFracRoundingCat,
  FinCndnDayFracRoundingDcmls,
  PrcIdxAdjmtDateReference,
  PrcIdxAdjmtDateWrkgDayShift,
  PrcIdxAdjmtDateShftDrctn,
  PrcIdxAdjmtShftNrOfDays,
  PriceIndexAdjustmentBaseDate,
  PrcIdxAdjmtFixingLowDate,
  PrcIdxAdjmtFixingHighDate,
  PrcIdxAdjmtFxngDteWrkgDayShft,
  PrcIdxAdjmtFixingDateShftDrctn,
  PrcIdxAdjmtFxngDteShftNrOfDays,
  FinConditionSettlementCrcy,
  ForeignExchangeFixingReference,
  FXRateAdjmtFixingDateRef,
  FXRateAdjmtFixingDateShftDrctn,
  FXRateAdjmtFxngDteShftNrOfDays,
  FXRateAdjmtFxngDteShftIsModifd
FROM R_FinTransConditionTP
;

Learn More