A_SecurityClassCondition_2

DDL: A_SECURITYCLASSCONDITION_2 Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_SEC_SC_API

Security Class Condition

A_SecurityClassCondition_2 is a Consumption CDS View that provides data about "Security Class Condition" in SAP S/4HANA. It reads from 1 data source (R_SecurityClassConditionTP_2) and exposes 95 fields with key fields SecurityClass, FinConditionConditionType, ConditionItemValidityStartDate, FinConditionSubItem. It is exposed through 2 OData services (API_SECURITYCLASS_2, ASQL_F7824). Part of development package RAP_FIN_TRM_SEC_SC_API.

Data Sources (1)

SourceAliasJoin Type
R_SecurityClassConditionTP_2 R_SecurityClassConditionTP_2 projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
EndUserText.label Security Class Condition view
OData.entityType.name SecurityClassCondition_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (2)

ServiceBindingVersionContractRelease
API_SECURITYCLASS_2
ASQL_F7824 ASQL_F7824 C2 NOT_RELEASED

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass SecurityClass
KEY FinConditionConditionType FinConditionConditionType
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate
KEY FinConditionSubItem FinConditionSubItem
CndnItmValdtyStrtDtIsInclusive CndnItmValdtyStrtDtIsInclusive
FinConditionForm FinConditionForm
FinCndnReferenceConditionType FinCndnReferenceConditionType
FinCndnRefAccumulatingCndnType FinCndnRefAccumulatingCndnType
InterestCalculationMethod InterestCalculationMethod
InterestCalculationType InterestCalculationType
ExponentialIntrstSettlmtFrqcy ExponentialIntrstSettlmtFrqcy
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar
InterestFirstPeriodRate InterestFirstPeriodRate
InterestRefRateOptrSign InterestRefRateOptrSign
InterestReference InterestReference
ConditionPercentageRate ConditionPercentageRate
FinancialConditionPaymentRate FinancialConditionPaymentRate
DividendFactorType DividendFactorType
FinCndnRateFactorRndngCategory FinCndnRateFactorRndngCategory
FinCndnRateFactorRndngDecimals FinCndnRateFactorRndngDecimals
FinCndnFactorRoundingCategory FinCndnFactorRoundingCategory
FinCndnFactorRoundingDecimals FinCndnFactorRoundingDecimals
FinCndnBaseFactorRndngCategory FinCndnBaseFactorRndngCategory
FinCndnBaseFactorRndngDecimals FinCndnBaseFactorRndngDecimals
FinCndnAmountRoundingCategory FinCndnAmountRoundingCategory
FinCndnAmountRoundingUnit FinCndnAmountRoundingUnit
RndngBaseUntAmtInCndnItmCrcy RndngBaseUntAmtInCndnItmCrcy
FinConditionIntrstBaseAmount FinConditionIntrstBaseAmount
FinCndnCalcBaseReference FinCndnCalcBaseReference
FinancialConditionItemAmount FinancialConditionItemAmount
FinancialConditionItemCurrency FinancialConditionItemCurrency
FinCndnAmountTimeUnit FinCndnAmountTimeUnit
ScrtyClCndnDrctExchRate ScrtyClCndnDrctExchRate
ScrtyClCndnIndrctExchRate ScrtyClCndnIndrctExchRate
FinConditionFactoryCalendar1 FinConditionFactoryCalendar1
FinConditionFactoryCalendar2 FinConditionFactoryCalendar2
FinConditionFactoryCalendar3 FinConditionFactoryCalendar3
FinConditionFactoryCalendar4 FinConditionFactoryCalendar4
FinConditionFactoryCalendar5 FinConditionFactoryCalendar5
AverageIntrstRateWeightingCat AverageIntrstRateWeightingCat
AverageIntrstRateRndngCategory AverageIntrstRateRndngCategory
AverageIntrstRateRndngDecimals AverageIntrstRateRndngDecimals
AverageInterestRateSpreadValue AverageInterestRateSpreadValue
AvgIntrstRateHasUsedUpperLimit AvgIntrstRateHasUsedUpperLimit
AverageInterestUpperLimitRate AverageInterestUpperLimitRate
AvgIntrstRateHasUsedLowerLimit AvgIntrstRateHasUsedLowerLimit
AverageInterestLowerLimitRate AverageInterestLowerLimitRate
AverageIntrstRateResetCalcEvt AverageIntrstRateResetCalcEvt
FinCndnUpdateRuleEntryType FinCndnUpdateRuleEntryType
FinCndnCalcDteUpdateRule FinCndnCalcDteUpdateRule
CalculationDate CalculationDate
FinCndnCalcDteFrequency FinCndnCalcDteFrequency
FinCndnCalcDteFrqcyUnit FinCndnCalcDteFrqcyUnit
CalcDateIsAsEndDateInclusive CalcDateIsAsEndDateInclusive
CalcDateIsAsEndDateMonthEnd CalcDateIsAsEndDateMonthEnd
FinCndnCalcDteWrkgDayShft FinCndnCalcDteWrkgDayShft
FinCndnCalcDteShftDrctn FinCndnCalcDteShftDrctn
ScrtyClCndnCalcDteShftNrOfDays ScrtyClCndnCalcDteShftNrOfDays
CalcDteIsRegularWithVarblDte CalcDteIsRegularWithVarblDte
InterestCalculationDateRef InterestCalculationDateRef
FinCndnDueDteUpdateRule FinCndnDueDteUpdateRule
DueDate DueDate Promised For
FinCndnDueDteFrequency FinCndnDueDteFrequency
FinCndnDueDteFrqcyUnit FinCndnDueDteFrqcyUnit
DueDateIsAsEndDateInclusive DueDateIsAsEndDateInclusive
DueDateIsAsEndDateMonthEnd DueDateIsAsEndDateMonthEnd
FinCndnDueDteWrkgDayShft FinCndnDueDteWrkgDayShft
FinCndnDueDteShftDrctn FinCndnDueDteShftDrctn
ScrtyClCndnDueDteShftNrOfDays ScrtyClCndnDueDteShftNrOfDays
DueDteIsRegularWithVarblDte DueDteIsRegularWithVarblDte
InterestDueDateReference InterestDueDateReference
FinCndnPaytDateWrkgDayShft FinCndnPaytDateWrkgDayShft
FinCndnDueDteShiftToTermEnd FinCndnDueDteShiftToTermEnd
FinCndnDuDteIsFinMathCalcReltd FinCndnDuDteIsFinMathCalcReltd
FinCndnRpaytSettlmt FinCndnRpaytSettlmt
FinCndnFirstPeriodCalcMethod FinCndnFirstPeriodCalcMethod
FinCndnLastPeriodCalcMethod FinCndnLastPeriodCalcMethod
InterestRateAdjustmentDateRule InterestRateAdjustmentDateRule
InterestRateAdjustmentDate InterestRateAdjustmentDate
IntrstRateAdjmtDateIsMonthEnd IntrstRateAdjmtDateIsMonthEnd
InterestRateAdjustmentFrqcy InterestRateAdjustmentFrqcy
InterestRateAdjmtFrqcyUnit InterestRateAdjmtFrqcyUnit
IntrstRateAdjmtDateWrkgDayShft IntrstRateAdjmtDateWrkgDayShft
FinCndnAdjmtDteShftDrctn FinCndnAdjmtDteShftDrctn
ScrtyClIntrstRateAdjmtShftDays ScrtyClIntrstRateAdjmtShftDays
InterestRateFixingDateRule InterestRateFixingDateRule
InterestRateFixingDate InterestRateFixingDate
IntrstRateFixingDateIsMonthEnd IntrstRateFixingDateIsMonthEnd
InterestRateFixingFrqcy InterestRateFixingFrqcy
InterestRateFixingFrqcyUnit InterestRateFixingFrqcyUnit
FinCndnFixingDteShftDrctn FinCndnFixingDteShftDrctn
ScrtyClIntrstRateFixShftDays ScrtyClIntrstRateFixShftDays
FinCndnRateFixingLockoutPeriod FinCndnRateFixingLockoutPeriod
IntrstRateFixDteShftIsModifd IntrstRateFixDteShftIsModifd
InterestRateFixingDateRef InterestRateFixingDateRef

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_SecurityClassCondition_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_SecurityClassCondition_2 AS
SELECT
  SecurityClass,
  FinConditionConditionType,
  ConditionItemValidityStartDate,
  FinConditionSubItem,
  CndnItmValdtyStrtDtIsInclusive,
  FinConditionForm,
  FinCndnReferenceConditionType,
  FinCndnRefAccumulatingCndnType,
  InterestCalculationMethod,
  InterestCalculationType,
  ExponentialIntrstSettlmtFrqcy,
  IntrstCalcMethFactoryCalendar,
  InterestFirstPeriodRate,
  InterestRefRateOptrSign,
  InterestReference,
  ConditionPercentageRate,
  FinancialConditionPaymentRate,
  DividendFactorType,
  FinCndnRateFactorRndngCategory,
  FinCndnRateFactorRndngDecimals,
  FinCndnFactorRoundingCategory,
  FinCndnFactorRoundingDecimals,
  FinCndnBaseFactorRndngCategory,
  FinCndnBaseFactorRndngDecimals,
  FinCndnAmountRoundingCategory,
  FinCndnAmountRoundingUnit,
  RndngBaseUntAmtInCndnItmCrcy,
  FinConditionIntrstBaseAmount,
  FinCndnCalcBaseReference,
  FinancialConditionItemAmount,
  FinancialConditionItemCurrency,
  FinCndnAmountTimeUnit,
  ScrtyClCndnDrctExchRate,
  ScrtyClCndnIndrctExchRate,
  FinConditionFactoryCalendar1,
  FinConditionFactoryCalendar2,
  FinConditionFactoryCalendar3,
  FinConditionFactoryCalendar4,
  FinConditionFactoryCalendar5,
  AverageIntrstRateWeightingCat,
  AverageIntrstRateRndngCategory,
  AverageIntrstRateRndngDecimals,
  AverageInterestRateSpreadValue,
  AvgIntrstRateHasUsedUpperLimit,
  AverageInterestUpperLimitRate,
  AvgIntrstRateHasUsedLowerLimit,
  AverageInterestLowerLimitRate,
  AverageIntrstRateResetCalcEvt,
  FinCndnUpdateRuleEntryType,
  FinCndnCalcDteUpdateRule,
  CalculationDate,
  FinCndnCalcDteFrequency,
  FinCndnCalcDteFrqcyUnit,
  CalcDateIsAsEndDateInclusive,
  CalcDateIsAsEndDateMonthEnd,
  FinCndnCalcDteWrkgDayShft,
  FinCndnCalcDteShftDrctn,
  ScrtyClCndnCalcDteShftNrOfDays,
  CalcDteIsRegularWithVarblDte,
  InterestCalculationDateRef,
  FinCndnDueDteUpdateRule,
  DueDate,
  FinCndnDueDteFrequency,
  FinCndnDueDteFrqcyUnit,
  DueDateIsAsEndDateInclusive,
  DueDateIsAsEndDateMonthEnd,
  FinCndnDueDteWrkgDayShft,
  FinCndnDueDteShftDrctn,
  ScrtyClCndnDueDteShftNrOfDays,
  DueDteIsRegularWithVarblDte,
  InterestDueDateReference,
  FinCndnPaytDateWrkgDayShft,
  FinCndnDueDteShiftToTermEnd,
  FinCndnDuDteIsFinMathCalcReltd,
  FinCndnRpaytSettlmt,
  FinCndnFirstPeriodCalcMethod,
  FinCndnLastPeriodCalcMethod,
  InterestRateAdjustmentDateRule,
  InterestRateAdjustmentDate,
  IntrstRateAdjmtDateIsMonthEnd,
  InterestRateAdjustmentFrqcy,
  InterestRateAdjmtFrqcyUnit,
  IntrstRateAdjmtDateWrkgDayShft,
  FinCndnAdjmtDteShftDrctn,
  ScrtyClIntrstRateAdjmtShftDays,
  InterestRateFixingDateRule,
  InterestRateFixingDate,
  IntrstRateFixingDateIsMonthEnd,
  InterestRateFixingFrqcy,
  InterestRateFixingFrqcyUnit,
  FinCndnFixingDteShftDrctn,
  ScrtyClIntrstRateFixShftDays,
  FinCndnRateFixingLockoutPeriod,
  IntrstRateFixDteShftIsModifd,
  InterestRateFixingDateRef
FROM R_SecurityClassConditionTP_2
;