I_SecurityClassStock

DDL: I_SECURITYCLASSSTOCK SQL: ISECSTOCK Type: view BASIC
9 Fields 1 Data Sources 3 Associations

Security Class Stock

I_SecurityClassStock (Basic)

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

SecurityClassStock · Financial Operations

I_SecurityClassStock is a Basic CDS View (Dimension) that provides data about "Security Class Stock" in SAP S/4HANA. It reads from 1 data source (vwpakti) and exposes 9 fields with key field SecurityClass. It has 3 associations to related views.

SAP Help Documentation

CategorySecurity Class
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Corresponding DataSourceISECSTOCK
Purpose
This CDS view provides access to stock-specific and fund-specific security class master data. This CDS view provides the prerequisites for answering the following business questions: To which stock category does a stock belong? To which fund type does an investment certificate/fund belong?

Prerequisites
The role must grant display authorization for the following authorization objects and fields: Authorization object: Master Data: Class Category ( T_STAM_GAT ) Field: Product Type ( GSART )

Structure
Main CDS parameters and filters The main filters are: Security class ID number Measures and attributes Some important attributes are: Security class ID number Stock category Fund type

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to stock-specific and fund-specific security class master data.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>To which stock category does a stock belong?</p></li> <li><p>To which fund type does an investment certificate/fund belong?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
vwpakti vwpakti from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SecurityClass _SecurityClass $projection.SecurityClass = _SecurityClass.SecurityClass
[0..1] I_SecurityClassFundType _SecurityClassFundType $projection.SecurityClassFundType = _SecurityClassFundType.SecurityClassFundType
[0..1] I_SecurityClassStockCategory _SecurityClassStockCategory $projection.SecurityClassStockCategory = _SecurityClassStockCategory.SecurityClassStockCategory

Annotations (19)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISECSTOCK view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Security Class Stock view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey SecurityClass view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name SecurityClassStock view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass Treasury ID No.
SecurityClassStockCategory sakar Stock Category
SecurityClassFundType sfoty Fund Type Indicator
SecurityClNmbrOfIssuedStocks aaaaktie Number of Stocks Issued
SecurityClassNomPerStockValue kbnewe Nominal Value per Stock (Independent of Currency)
SecurityClassIssueStartDate debeg Issue Start Date
_SecurityClass _SecurityClass
_SecurityClassFundType _SecurityClassFundType
_SecurityClassStockCategory _SecurityClassStockCategory

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_SecurityClassStock.
-- 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.
-- SQL view name: ISECSTOCK

CREATE VIEW I_SecurityClassStock AS
SELECT
  cast(ranl as ftr_gen_security_class preserving type) AS SecurityClass,
  sakar AS SecurityClassStockCategory,
  sfoty AS SecurityClassFundType,
  aaaaktie AS SecurityClNmbrOfIssuedStocks,
  kbnewe AS SecurityClassNomPerStockValue,
  debeg AS SecurityClassIssueStartDate
FROM vwpakti
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_SecurityClassFundType AS _SecurityClassFundType ON SecurityClassFundType = _SecurityClassFundType.SecurityClassFundType  -- association [0..1]
LEFT OUTER JOIN I_SecurityClassStockCategory AS _SecurityClassStockCategory ON SecurityClassStockCategory = _SecurityClassStockCategory.SecurityClassStockCategory  -- association [0..1]
;

Learn More