What is I_SecurityClassConditionItem in SAP S/4HANA?

I_SecurityClassConditionItem is a basic CDS view in SAP S/4HANA. Security Class Condition Item It contains 54 fields.

Which tables does I_SecurityClassConditionItem read from?

I_SecurityClassConditionItem reads data from: vzzkopo, tzk01.

What VDM layer is I_SecurityClassConditionItem?

I_SecurityClassConditionItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SecurityClassConditionItem

DDL: I_SECURITYCLASSCONDITIONITEM Type: view_entity BASIC Package: FTR_SECURITIES_CORE

54 Fields 2 Data Sources 1 Associations

Security Class Condition Item

I_SecurityClassConditionItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

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. Part of development package FTR_SECURITIES_CORE.

SAP Help Documentation

Category	Security 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 →

SAP API Hub

Category	Basic
State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-TRM-2CL
Capabilities	Data Source for Defining CDS Entities,Data Source for Search,Association Target for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Financial Operations for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
vzzkopo	ConditionItem	from
tzk01	ConditionType	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_SecurityClassBasic	_SecurityClassBasic	`$projection.SecurityClass = _SecurityClassBasic.SecurityClass`

Annotations (8)

Name	Value	Level
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)

Key	Field	Source Table	Source Field	Description
KEY	SecurityClass			Security Class
KEY	FinConditionConditionType	vzzkopo	skoart	Condition Type (Smallest Subdivision of Condition Records)
KEY	FinConditionSubItem	vzzkopo	nstufe	Level Number of Condition Item for Recurring Payments
	FinancialInstrProductCategory			Financial Instrument Product Category
	FinConditionForm	vzzkopo	jnullkon	Condition Form
	FinCndnReferenceConditionType	tzk01	skoaref	Reference Cond. Type on Which Current Cond. Type Is Based
	FinCndnRefAccumulatingCndnType	tzk01	sum_skoaref	Reference to accumulating condition type
	InterestCalculationMethod	vzzkopo	szbmeth	Interest Calculation Method
	ExponentialIntrstSettlmtFrqcy	vzzkopo	ammrhyzv	Interest Settlement Frequency for Exponential Interest Calc.
	IntrstCalcMethFactoryCalendar	vzzkopo	skalidwt	Interest Calendar
	InterestFirstPeriodRate	vzzkopo	pkond1stper	Interest Rate for the First Period
	InterestRefRateOptrSign	vzzkopo	szsrefvz	+/- Sign / Reference Interest Rate Operator
	InterestReference	vzzkopo	szsref	Reference Interest Rate
	ConditionPercentageRate	vzzkopo	pkond	Percentage rate for condition items
	FinCndnFluctuationMarginRate	vzzkopo	pfluct	Fluctuation Margin
	FinancialConditionPaymentRate	vzzkopo	ppayment	Payment Rate
	FinConditionFormulaReference	vzzkopo	sformref	Formula reference for the cash flow calculator
	FinCndnFormulaVariable	vzzkopo	svarname	Description of variables in cash flow calculator
	DividendFactorType	vzzkopo	factor_type	Factor Type
	FinCndnRateFactorRndngCategory	vzzkopo	sroundratefactor	Rounding Category of Interest Factor
	FinCndnRateFactorRndngDecimals	vzzkopo	rounddecratefactor	Number of Rounding Decimal Places for Interest Factor
	FinCndnFactorRoundingCategory	vzzkopo	sroundfactor	Rounding Category of a Factor
	FinCndnFactorRoundingDecimals	vzzkopo	rounddecfactor	Number of Rounding Decimal Places for a Factor
	FinCndnBaseFactorRndngCategory	vzzkopo	sroundbasefactor	Rounding Category of a Base Factor
	FinCndnBaseFactorRndngDecimals	vzzkopo	rounddecbasefactor	Number of Rounding Decimal Places for a Base Factor
	FinCndnAmountRoundingCategory	vzzkopo	sround	Rounding Category
	FinCndnAmountRoundingUnit	vzzkopo	broundunit	Rounding Unit for Amounts
	RndngBaseUntAmtInCndnItmCrcy	vzzkopo	bbasisunit	Base Unit for Rounding
	FinConditionIntrstBaseAmount			Calculation Base Amount for Financial Condition Interest
	FinCndnCalcBaseReference	vzzkopo	sbasis	Calculation base reference
	FinancialConditionItemAmount	vzzkopo	kbkond	Condition amount independent of currency
	FinancialConditionItemCurrency	vzzkopo	swhrkond	Currency of Condition Item
	FinCndnAmountTimeUnit	vzzkopo	jbmonat	Indicator for Calculating Amount per Month
	FinConditionFactoryCalendar1	vzzkopo	skalid	Factory calendar
	FinConditionFactoryCalendar2	vzzkopo	skalid2	Calendar ID 2 (valid in connection with calendar ID 1)
	FinConditionFactoryCalendar3	vzzkopo	skalid3	Calendar ID 3 (valid in connection with calendar ID 1)
	FinConditionFactoryCalendar4	vzzkopo	skalid4	Calendar ID 4 (valid in connection with calendar ID 1)
	FinConditionFactoryCalendar5	vzzkopo	skalid5	Calendar ID 5 (valid in connection with calendar ID 1)
	AverageIntrstRateWeightingCat	vzzkopo	savgweight	Weighting Category of Interest Rate
	AverageIntrstRateRndngCategory	vzzkopo	sroundavginterest	Rounding Category of Average Interest Rate
	AverageIntrstRateRndngDecimals	vzzkopo	rounddecavginterest	Number of Rounding Decimal Places for Average Interest Rate
	AverageInterestRateSpreadValue	vzzkopo	pavgspread	Average Interest Rate Spread
	AvgIntrstRateHasUsedUpperLimit	vzzkopo	javgcap	Use Upper Limit of Average Interest Rate
	AverageInterestUpperLimitRate	vzzkopo	pavgcap	Upper Limit of Average Interest Rate
	AvgIntrstRateHasUsedLowerLimit	vzzkopo	javgfloor	Use Lower Limit of Average Interest Rate
	AverageInterestLowerLimitRate	vzzkopo	pavgfloor	Lower Limit of Average Interest Rate
	AverageIntrstRateResetCalcEvt	vzzkopo	sfactorreset	Event for Resetting Factor Calculation
	dvalutelsenullendasCalculationDate
	dfaellelsenullendasDueDate
	FinCndnPaytDateWrkgDayShft	vzzkopo	sdwerk	Working Day Shift for Payment Date
	FinCndnDueDteShiftToTermEnd			Shift Due Date Back to End of Term
	FinCndnRpaytSettlmt	vzzkopo	jsofverr	Immediate settlement
	FinCndnRateFixingLockoutPeriod	vzzkopo	adgstage	Number of Days for Relative Payment Date Calculation
	_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]
;

Depth:

I_SecurityClassConditionItem view_entity

I_SecurityClassCondition view_entity
P_ScrtyClConditionSubItem view_entity