P_SecurityClassAll

DDL: P_SECURITYCLASSALL Type: view_entity BASIC Package: FTR_SECURITIES_CORE
45 Fields 1 Data Sources

All Security Classes

P_SecurityClassAll is a Basic CDS View that provides data about "All Security Classes" in SAP S/4HANA. It reads from 1 data source (I_SecurityClassBasic) and exposes 45 fields with key field SecurityClass. Part of development package FTR_SECURITIES_CORE.

Data Sources (1)

SourceAliasJoin Type
I_SecurityClassBasic SecurityClassBasic from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label All Security Classes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #BASIC view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass I_SecurityClassBasic SecurityClass
SecurityClassStatus I_SecurityClassBasic SecurityClassStatus Status
SecurityClassName I_SecurityClassBasic SecurityClassName
SecurityClassDescription I_SecurityClassBasic SecurityClassDescription
FinancialInstrumentProductType I_SecurityClassBasic FinancialInstrumentProductType Product Type
ScrtyClassGenClassification I_SecurityClassBasic ScrtyClassGenClassification Sec. Classific.
Issuer I_SecurityClassBasic Issuer User Name
IssueCurrency I_SecurityClassBasic IssueCurrency Issue Currency
SecurityClassIssuePriceValue I_SecurityClassBasic SecurityClassIssuePriceValue
IssueRateInPercent I_SecurityClassBasic IssueRateInPercent Issue rate
SecurityClassTransferType I_SecurityClassBasic SecurityClassTransferType Security Type
SecurityClassQuotation I_SecurityClassBasic SecurityClassQuotation Quotation
ScrtyClMinimalNumberOfUnits I_SecurityClassBasic ScrtyClMinimalNumberOfUnits
SecurityClassIsListed I_SecurityClassBasic SecurityClassIsListed Listed
SecurityClassTaxClassification I_SecurityClassBasic SecurityClassTaxClassification Tax Classif.
SecurityClassCreatedByUser I_SecurityClassBasic SecurityClassCreatedByUser
SecurityClassCreationDate I_SecurityClassBasic SecurityClassCreationDate
SecurityClassCreationTime I_SecurityClassBasic SecurityClassCreationTime
SecurityClassCreationSource I_SecurityClassBasic SecurityClassCreationSource
SecurityClassLastChangedByUser I_SecurityClassBasic SecurityClassLastChangedByUser
SecurityClassLastChangedDate I_SecurityClassBasic SecurityClassLastChangedDate
SecurityClassLastChangedTime I_SecurityClassBasic SecurityClassLastChangedTime
SecurityClassLastChangedSource I_SecurityClassBasic SecurityClassLastChangedSource
FinancialInstrProductCategory I_SecurityClassBasic FinancialInstrProductCategory
SecurityClassIsPledgeable I_SecurityClassBasic SecurityClassIsPledgeable Pledgeable
SecurityClassNomPerStockValue StockSubscrpnRghtInvmtCert SecurityClassNomPerStockValue
SecurityClassStockCategory StockSubscrpnRghtInvmtCert SecurityClassStockCategory
SecurityClassStockForm StockSubscrpnRghtInvmtCert SecurityClassStockForm
SecurityClassFundType StockSubscrpnRghtInvmtCert SecurityClassFundType
SecurityClassFundCategory StockSubscrpnRghtInvmtCert SecurityClassFundCategory
SecurityClassFundVolumeAmount StockSubscrpnRghtInvmtCert SecurityClassFundVolumeAmount
ScrtyClIssuePremiumInPercent StockSubscrpnRghtInvmtCert ScrtyClIssuePremiumInPercent
SecurityClassShareholdingType StockSubscrpnRghtInvmtCert SecurityClassShareholdingType
ScrtyClShareholdingStructure StockSubscrpnRghtInvmtCert ScrtyClShareholdingStructure
BondClassification SecurityClassBond BondClassification
BondCertificateNominalAmount SecurityClassBond BondCertificateNominalAmount
BondCertPerTrdgUnitNominalAmt SecurityClassBond BondCertPerTrdgUnitNominalAmt
SecurityClassFinalDueDate SecurityClassBond SecurityClassFinalDueDate
ScrtyClCalcPeriodStartDate SecurityClassBond ScrtyClCalcPeriodStartDate
ScrtyClCompatibleTermEndDate SecurityClassBond ScrtyClCompatibleTermEndDate
ScrtyClExpectedTermEndDate SecurityClassBond ScrtyClExpectedTermEndDate
ScrtyClIsCalcdWthNomPerTrdgUnt SecurityClassBond ScrtyClIsCalcdWthNomPerTrdgUnt
ScrtyClTrancheClassification SecurityClassBond ScrtyClTrancheClassification
SecurityClassAssetPool SecurityClassBond SecurityClassAssetPool
IntrstCalcFnlDuDteIsIncld BondConditionHeader IntrstCalcFnlDuDteIsIncld

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 P_SecurityClassAll.
-- 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 P_SecurityClassAll AS
SELECT
  SecurityClassBasic.SecurityClass AS SecurityClass,
  SecurityClassBasic.SecurityClassStatus AS SecurityClassStatus,
  SecurityClassBasic.SecurityClassName AS SecurityClassName,
  SecurityClassBasic.SecurityClassDescription AS SecurityClassDescription,
  SecurityClassBasic.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  SecurityClassBasic.ScrtyClassGenClassification AS ScrtyClassGenClassification,
  SecurityClassBasic.Issuer AS Issuer,
  SecurityClassBasic.IssueCurrency AS IssueCurrency,
  SecurityClassBasic.SecurityClassIssuePriceValue AS SecurityClassIssuePriceValue,
  SecurityClassBasic.IssueRateInPercent AS IssueRateInPercent,
  SecurityClassBasic.SecurityClassTransferType AS SecurityClassTransferType,
  SecurityClassBasic.SecurityClassQuotation AS SecurityClassQuotation,
  SecurityClassBasic.ScrtyClMinimalNumberOfUnits AS ScrtyClMinimalNumberOfUnits,
  SecurityClassBasic.SecurityClassIsListed AS SecurityClassIsListed,
  SecurityClassBasic.SecurityClassTaxClassification AS SecurityClassTaxClassification,
  SecurityClassBasic.SecurityClassCreatedByUser AS SecurityClassCreatedByUser,
  SecurityClassBasic.SecurityClassCreationDate AS SecurityClassCreationDate,
  SecurityClassBasic.SecurityClassCreationTime AS SecurityClassCreationTime,
  SecurityClassBasic.SecurityClassCreationSource AS SecurityClassCreationSource,
  SecurityClassBasic.SecurityClassLastChangedByUser AS SecurityClassLastChangedByUser,
  SecurityClassBasic.SecurityClassLastChangedDate AS SecurityClassLastChangedDate,
  SecurityClassBasic.SecurityClassLastChangedTime AS SecurityClassLastChangedTime,
  SecurityClassBasic.SecurityClassLastChangedSource AS SecurityClassLastChangedSource,
  SecurityClassBasic.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  SecurityClassBasic.SecurityClassIsPledgeable AS SecurityClassIsPledgeable,
  StockSubscrpnRghtInvmtCert.SecurityClassNomPerStockValue AS SecurityClassNomPerStockValue,
  StockSubscrpnRghtInvmtCert.SecurityClassStockCategory AS SecurityClassStockCategory,
  StockSubscrpnRghtInvmtCert.SecurityClassStockForm AS SecurityClassStockForm,
  StockSubscrpnRghtInvmtCert.SecurityClassFundType AS SecurityClassFundType,
  StockSubscrpnRghtInvmtCert.SecurityClassFundCategory AS SecurityClassFundCategory,
  StockSubscrpnRghtInvmtCert.SecurityClassFundVolumeAmount AS SecurityClassFundVolumeAmount,
  StockSubscrpnRghtInvmtCert.ScrtyClIssuePremiumInPercent AS ScrtyClIssuePremiumInPercent,
  StockSubscrpnRghtInvmtCert.SecurityClassShareholdingType AS SecurityClassShareholdingType,
  StockSubscrpnRghtInvmtCert.ScrtyClShareholdingStructure AS ScrtyClShareholdingStructure,
  SecurityClassBond.BondClassification AS BondClassification,
  SecurityClassBond.BondCertificateNominalAmount AS BondCertificateNominalAmount,
  SecurityClassBond.BondCertPerTrdgUnitNominalAmt AS BondCertPerTrdgUnitNominalAmt,
  SecurityClassBond.SecurityClassFinalDueDate AS SecurityClassFinalDueDate,
  SecurityClassBond.ScrtyClCalcPeriodStartDate AS ScrtyClCalcPeriodStartDate,
  SecurityClassBond.ScrtyClCompatibleTermEndDate AS ScrtyClCompatibleTermEndDate,
  SecurityClassBond.ScrtyClExpectedTermEndDate AS ScrtyClExpectedTermEndDate,
  SecurityClassBond.ScrtyClIsCalcdWthNomPerTrdgUnt AS ScrtyClIsCalcdWthNomPerTrdgUnt,
  SecurityClassBond.ScrtyClTrancheClassification AS ScrtyClTrancheClassification,
  SecurityClassBond.SecurityClassAssetPool AS SecurityClassAssetPool,
  BondConditionHeader.IntrstCalcFnlDuDteIsIncld AS IntrstCalcFnlDuDteIsIncld
FROM I_SecurityClassBasic AS SecurityClassBasic
;

Learn More