I_StockSubscrpnRghtInvmtCert

DDL: I_STOCKSUBSCRPNRGHTINVMTCERT Type: view_entity BASIC
14 Fields 1 Data Sources 1 Associations

Stock Subscription Rights Invmt Cert

I_StockSubscrpnRghtInvmtCert is a Basic CDS View that provides data about "Stock Subscription Rights Invmt Cert" in SAP S/4HANA. It reads from 1 data source (vwpakti) and exposes 14 fields with key field SecurityClass. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
vwpakti StockSubscrpnRghtInvmtCert from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Stock Subscription Rights Invmt Cert view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass Treasury ID No.
SecurityClassIssueStartDate vwpakti debeg Issue Start
SecurityClassNomPerStockValue vwpakti kbnewe Nominal val.
SecurityClassStockCategory vwpakti sakar Stock Category
SecurityClassStockForm vwpakti svbre Stock form
SecurityClassFundType vwpakti sfoty Fund Type
SecurityClassFundCategory vwpakti sfoart Fund cat.
SecurityClassFundVolumeAmount
ScrtyClIssuePremiumInPercent vwpakti pausg % issue prem.
ScrtyClDvdndRightsPerUnitInPct vwpakti pdivber Dividend rights
SecurityClassShareholdingType vwpakti sartbet Sharehold.type
ScrtyClShareholdingStructure vwpakti skonbet Share.structure
IssueCurrency _SecurityClassBasic IssueCurrency
_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_StockSubscrpnRghtInvmtCert.
-- 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_StockSubscrpnRghtInvmtCert AS
SELECT
  cast(ranl as ftr_gen_security_class preserving type) AS SecurityClass,
  StockSubscrpnRghtInvmtCert.debeg AS SecurityClassIssueStartDate,
  StockSubscrpnRghtInvmtCert.kbnewe AS SecurityClassNomPerStockValue,
  StockSubscrpnRghtInvmtCert.sakar AS SecurityClassStockCategory,
  StockSubscrpnRghtInvmtCert.svbre AS SecurityClassStockForm,
  StockSubscrpnRghtInvmtCert.sfoty AS SecurityClassFundType,
  StockSubscrpnRghtInvmtCert.sfoart AS SecurityClassFundCategory,
  cast(StockSubscrpnRghtInvmtCert.bfonvol as ftr_sc_bfonvol) AS SecurityClassFundVolumeAmount,
  StockSubscrpnRghtInvmtCert.pausg AS ScrtyClIssuePremiumInPercent,
  StockSubscrpnRghtInvmtCert.pdivber AS ScrtyClDvdndRightsPerUnitInPct,
  StockSubscrpnRghtInvmtCert.sartbet AS SecurityClassShareholdingType,
  StockSubscrpnRghtInvmtCert.skonbet AS ScrtyClShareholdingStructure,
  _SecurityClassBasic.IssueCurrency AS IssueCurrency
FROM vwpakti AS StockSubscrpnRghtInvmtCert
LEFT OUTER JOIN I_SecurityClassBasic AS _SecurityClassBasic ON SecurityClass = _SecurityClassBasic.SecurityClass  -- association [1..1]
;

Learn More