I_SecurityClassConditionItem

DDL: I_SECURITYCLASSCONDITIONITEM Type: view_entity BASIC
54 Fields 2 Data Sources 1 Associations

Security Class Condition Item

I_SecurityClassConditionItem is a Basic CDS View that provides data about "Security Class Condition Item" in SAP S/4HANA. It reads from 2 data sources (vzzkopo, tzk01) and exposes 54 fields with key fields SecurityClass, FinConditionConditionType, FinConditionSubItem. It has 1 association to related views.

SAP Help Documentation

CategorySecurity Class
Purpose
This CDS view provides the data to answer the following business questions: What are the condition items for a security class? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: Field Name Description SCRTYCLCNDNDUEDTESHFTNROFDAYS Shifting Days FINCNDNDUEDTESHFTDRCTN Shift Direction FINCNDNDUEDTEWRKGDAYSHFT Working Day Shift DUEDATEISASENDDATEMONTHEND Month End Indicator DUEDATEISASENDDATEINCLUSIVE Date is inclusive FINCNDNDUEDTEFRQCYUNIT Frequency Unit FINCNDNDUEDTEFREQUENCY Frequency DUEDATE Due date FINCNDNDUEDTEUPDATERULE Due Date Update Rule INTERESTCALCULATIONDATEREF reference CALCDTEISREGULARWITHVARBLDTE Variable date SCRTYCLCNDNCALCDTESHFTNROFDAYS Shifting Days FINCNDNCALCDTESHFTDRCTN Shift Direction FINCNDNCALCDTEWRKGDAYSHFT Working Day Shift CALCDATEISASENDDATEMONTHEND Month End Indicator CALCDATEISASENDDATEINCLUSIVE Date is inclusive FINCNDNCALCDTEFRQCYUNIT Calculation Unit FINCNDNCALCDTEFREQUENCY Calc Date Frequency CALCULATIONDATE Calculation Date FINCNDNCALCDTEUPDATERULE Calculation Date Update Rule FINCNDNUPDTRULEDATEWRKGDAYSHFT Working Day Shift UPDATERULEDATEISMONTHEND Month End Indicator FINCNDNUPDATERULEDATEFRQCYUNIT Calculation Unit FINCNDNUPDATERULEDATEFREQUENCY Calc Date Frequency FINCNDNUPDATERULEFIRSTDATE Due date FINCNDNUPDATERULEENTRYTYPE Update Rule INTERESTRATEFIXINGDATEREF INTRSTRATEFIXDTESHFTISMODIFD Modified FINCNDNRATEFIXINGLOCKOUTPERIOD No. of Working Days SCRTYCLINTRSTRATEFIXSHFTDAYS Shifting Days FINCNDNFIXINGDTESHFTDRCTN Shift Direction INTERESTRATEFIXINGFRQCYUNIT Frequency Unit INTERESTRATEFIXINGFRQCY Frequency INTRSTRATEFIXINGDATEISMONTHEND Month End Indicator INTERESTRATEFIXINGDATE Int.rate fixing date INTERESTRATEFIXINGDATERULE SCRTYCLINTRSTRATEADJMTSHFTDAYS Shifting Days FINCNDNADJMTDTESHFTDRCTN Shift Direction INTRSTRATEADJMTDATEWRKGDAYSHFT Working Day Shift INTERESTRATEADJMTFRQCYUNIT Frequency Unit INTERESTRATEADJUSTMENTFRQCY Frequency INTRSTRATEADJMTDATEISMONTHEND Month End Indicator INTERESTRATEADJUSTMENTDATE Int. Rate Adj. Date INTERESTRATEADJUSTMENTDATERULE Upd. Rule IRA FINCNDNLASTPERIODCALCMETHOD Last period FINCNDNFIRSTPERIODCALCMETHOD First period FINCNDNRPAYTSETTLMT Immediate settlement FINCNDNDUDTEISFINMATHCALCRELTD Due Date-Related FINCNDNDUEDTESHIFTTOTERMEND DueDate TermEnd FINCNDNPAYTDATEWRKGDAYSHFT WorkingDayShift INTERESTDUEDATEREFERENCE reference DUEDTEISREGULARWITHVARBLDTE Variable date FINCNDNFACTORROUNDINGDECIMALS Dec. Fac. Round FINCNDNFACTORROUNDINGCATEGORY Factor RC FINCNDNRATEFACTORRNDNGDECIMALS Dec. Int. Fac. FINCNDNRATEFACTORRNDNGCATEGORY Int. Factor RC DIVIDENDFACTORTYPE Factor Type FINCNDNFORMULAVARIABLE Variable FINCONDITIONFORMULAREFERENCE Formula FINANCIALCONDITIONPAYMENTRATE Payment Rate FINCNDNFLUCTUATIONMARGINRATE Fluctuation margin CONDITIONPERCENTAGERATE Percentage Rate INTERESTREFERENCE Ref. Interest Rate INTERESTREFRATEOPTRSIGN +/- sign INTERESTFIRSTPERIODRATE First Interest Rate INTRSTCALCMETHFACTORYCALENDAR Interest Calendar EXPONENTIALINTRSTSETTLMTFRQCY Int. Sttlmnt Freq. INTERESTCALCULATIONTYPE Int. Calc. Type INTERESTCALCULATIONMETHOD Int. Calc. Method FINCNDNREFACCUMULATINGCNDNTYPE Ref. Accu. Cond. FINCNDNREFERENCECONDITIONTYPE Reference Cond. Type FINCONDITIONFORM Condition Form CNDNITMVALDTYSTRTDTISINCLUSIVE Inclusive indicator FINANCIALINSTRPRODUCTCATEGORY Product Category FINCONDITIONSUBITEM Level number CONDITIONITEMVALIDITYSTARTDATE Item Effective From FINCONDITIONCONDITIONTYPE Condition Type SECURITYCLASS Security Class AVERAGEINTRSTRATERESETCALCEVT Reset AVERAG

View on SAP Help Portal →

Data Sources (2)

SourceAliasJoin Type
vzzkopo ConditionItem from
tzk01 ConditionType inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SecurityClassBasic _SecurityClassBasic $projection.SecurityClass = _SecurityClassBasic.SecurityClass

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Security Class Condition Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass
KEY FinConditionConditionType vzzkopo skoart Condition Type
KEY FinConditionSubItem vzzkopo nstufe Level Number
FinancialInstrProductCategory
FinConditionForm vzzkopo jnullkon Condition Form
FinCndnReferenceConditionType tzk01 skoaref Ref. Cond. Type
FinCndnRefAccumulatingCndnType tzk01 sum_skoaref Ref. Accu. Cond.
InterestCalculationMethod vzzkopo szbmeth Int.calc.method
ExponentialIntrstSettlmtFrqcy vzzkopo ammrhyzv Int.sttlm.freq
IntrstCalcMethFactoryCalendar vzzkopo skalidwt Int. Calendar
InterestFirstPeriodRate vzzkopo pkond1stper First Int Rate
InterestRefRateOptrSign vzzkopo szsrefvz +/- Sign
InterestReference vzzkopo szsref Ref.int.rate
ConditionPercentageRate vzzkopo pkond Percentage Rate
FinCndnFluctuationMarginRate vzzkopo pfluct Fluct. Margin
FinancialConditionPaymentRate vzzkopo ppayment Payment Rate
FinConditionFormulaReference vzzkopo sformref Formula Ref.
FinCndnFormulaVariable vzzkopo svarname Variable
DividendFactorType vzzkopo factor_type Factor Type
FinCndnRateFactorRndngCategory vzzkopo sroundratefactor Int. Factor RC
FinCndnRateFactorRndngDecimals vzzkopo rounddecratefactor Dec. Int. Fac.
FinCndnFactorRoundingCategory vzzkopo sroundfactor Factor RC
FinCndnFactorRoundingDecimals vzzkopo rounddecfactor Dec. Fac. Round
FinCndnBaseFactorRndngCategory vzzkopo sroundbasefactor Factor RC
FinCndnBaseFactorRndngDecimals vzzkopo rounddecbasefactor Dec. Fac. Round
FinCndnAmountRoundingCategory vzzkopo sround Rounding Type
FinCndnAmountRoundingUnit vzzkopo broundunit Rounding Unit
RndngBaseUntAmtInCndnItmCrcy vzzkopo bbasisunit Base Unit
FinConditionIntrstBaseAmount
FinCndnCalcBaseReference vzzkopo sbasis Calculat. Base
FinancialConditionItemAmount vzzkopo kbkond Crcy-Indp. Cond. Amt
FinancialConditionItemCurrency vzzkopo swhrkond Currency
FinCndnAmountTimeUnit vzzkopo jbmonat Unit for Amount
FinConditionFactoryCalendar1 vzzkopo skalid Calendar
FinConditionFactoryCalendar2 vzzkopo skalid2 Calendar ID 2
FinConditionFactoryCalendar3 vzzkopo skalid3 Calendar ID 3
FinConditionFactoryCalendar4 vzzkopo skalid4 Calendar ID 4
FinConditionFactoryCalendar5 vzzkopo skalid5 Calendar ID 5
AverageIntrstRateWeightingCat vzzkopo savgweight Weighting Cat.
AverageIntrstRateRndngCategory vzzkopo sroundavginterest RC of AIR
AverageIntrstRateRndngDecimals vzzkopo rounddecavginterest AIR Round. Dec.
AverageInterestRateSpreadValue vzzkopo pavgspread Spread
AvgIntrstRateHasUsedUpperLimit vzzkopo javgcap Upper Limit
AverageInterestUpperLimitRate vzzkopo pavgcap Upper Limit
AvgIntrstRateHasUsedLowerLimit vzzkopo javgfloor Lower Limit
AverageInterestLowerLimitRate vzzkopo pavgfloor Lower Limit
AverageIntrstRateResetCalcEvt vzzkopo sfactorreset Reset
dvalutelsenullendasCalculationDate
dfaellelsenullendasDueDate
FinCndnPaytDateWrkgDayShft vzzkopo sdwerk WorkingDayShift
FinCndnDueDteShiftToTermEnd
FinCndnRpaytSettlmt vzzkopo jsofverr Immed.Settlemnt
FinCndnRateFixingLockoutPeriod vzzkopo adgstage No.Working Days
_SecurityClassBasic _SecurityClassBasic

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_SecurityClassConditionItem.
-- 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 I_SecurityClassConditionItem AS
SELECT
  cast(ConditionItem.rkey1 as ftr_gen_security_class preserving type) AS SecurityClass,
  ConditionItem.skoart AS FinConditionConditionType,
  ConditionItem.nstufe AS FinConditionSubItem,
  cast(ConditionItem.sanlf as ftr_gen_fin_instr_prod_categ preserving type) AS FinancialInstrProductCategory,
  ConditionItem.jnullkon AS FinConditionForm,
  ConditionType.skoaref AS FinCndnReferenceConditionType,
  ConditionType.sum_skoaref AS FinCndnRefAccumulatingCndnType,
  ConditionItem.szbmeth AS InterestCalculationMethod,
  ConditionItem.ammrhyzv AS ExponentialIntrstSettlmtFrqcy,
  ConditionItem.skalidwt AS IntrstCalcMethFactoryCalendar,
  ConditionItem.pkond1stper AS InterestFirstPeriodRate,
  ConditionItem.szsrefvz AS InterestRefRateOptrSign,
  ConditionItem.szsref AS InterestReference,
  ConditionItem.pkond AS ConditionPercentageRate,
  ConditionItem.pfluct AS FinCndnFluctuationMarginRate,
  ConditionItem.ppayment AS FinancialConditionPaymentRate,
  ConditionItem.sformref AS FinConditionFormulaReference,
  ConditionItem.svarname AS FinCndnFormulaVariable,
  ConditionItem.factor_type AS DividendFactorType,
  ConditionItem.sroundratefactor AS FinCndnRateFactorRndngCategory,
  ConditionItem.rounddecratefactor AS FinCndnRateFactorRndngDecimals,
  ConditionItem.sroundfactor AS FinCndnFactorRoundingCategory,
  ConditionItem.rounddecfactor AS FinCndnFactorRoundingDecimals,
  ConditionItem.sroundbasefactor AS FinCndnBaseFactorRndngCategory,
  ConditionItem.rounddecbasefactor AS FinCndnBaseFactorRndngDecimals,
  ConditionItem.sround AS FinCndnAmountRoundingCategory,
  ConditionItem.broundunit AS FinCndnAmountRoundingUnit,
  ConditionItem.bbasisunit AS RndngBaseUntAmtInCndnItmCrcy,
  cast(ConditionItem.bbasis as ftr_cndn_intrst_base_amount) AS FinConditionIntrstBaseAmount,
  ConditionItem.sbasis AS FinCndnCalcBaseReference,
  ConditionItem.kbkond AS FinancialConditionItemAmount,
  ConditionItem.swhrkond AS FinancialConditionItemCurrency,
  ConditionItem.jbmonat AS FinCndnAmountTimeUnit,
  ConditionItem.skalid AS FinConditionFactoryCalendar1,
  ConditionItem.skalid2 AS FinConditionFactoryCalendar2,
  ConditionItem.skalid3 AS FinConditionFactoryCalendar3,
  ConditionItem.skalid4 AS FinConditionFactoryCalendar4,
  ConditionItem.skalid5 AS FinConditionFactoryCalendar5,
  ConditionItem.savgweight AS AverageIntrstRateWeightingCat,
  ConditionItem.sroundavginterest AS AverageIntrstRateRndngCategory,
  ConditionItem.rounddecavginterest AS AverageIntrstRateRndngDecimals,
  ConditionItem.pavgspread AS AverageInterestRateSpreadValue,
  ConditionItem.javgcap AS AvgIntrstRateHasUsedUpperLimit,
  ConditionItem.pavgcap AS AverageInterestUpperLimitRate,
  ConditionItem.javgfloor AS AvgIntrstRateHasUsedLowerLimit,
  ConditionItem.pavgfloor AS AverageInterestLowerLimitRate,
  ConditionItem.sfactorreset AS AverageIntrstRateResetCalcEvt,
  case when ConditionType.sberfima <> 'ZA' then ConditionItem.dvalut else null end as CalculationDate AS dvalutelsenullendasCalculationDate,
  case when ConditionType.sberfima <> 'ZA' then ConditionItem.dfaell else null end as DueDate AS dfaellelsenullendasDueDate,
  ConditionItem.sdwerk AS FinCndnPaytDateWrkgDayShft,
  cast( ConditionItem.sfranz as tb_sfranze_new ) AS FinCndnDueDteShiftToTermEnd,
  ConditionItem.jsofverr AS FinCndnRpaytSettlmt,
  ConditionItem.adgstage AS FinCndnRateFixingLockoutPeriod
FROM vzzkopo AS ConditionItem
INNER JOIN tzk01 AS ConditionType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SecurityClassBasic AS _SecurityClassBasic ON SecurityClass = _SecurityClassBasic.SecurityClass  -- association [1..1]
;

Learn More