P_SECURITYCLASSALL

CDS View

All Security Classes

P_SECURITYCLASSALL is a CDS View in S/4HANA. All Security Classes. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SecurityClass view from BASIC Security Class 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'All Security Classes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.private: true
@VDM.viewType: #BASIC
define view entity P_SecurityClassAll
  as select from    I_SecurityClassBasic         as SecurityClassBasic
    left outer to one join I_StockSubscrpnRghtInvmtCert as StockSubscrpnRghtInvmtCert on SecurityClassBasic.SecurityClass = StockSubscrpnRghtInvmtCert.SecurityClass
    left outer to one join I_SecurityClassBond          as SecurityClassBond          on SecurityClassBasic.SecurityClass = SecurityClassBond.SecurityClass
    left outer to one join I_BondConditionHeader        as BondConditionHeader        on SecurityClassBasic.SecurityClass = BondConditionHeader.SecurityClass
{
  key SecurityClassBasic.SecurityClass,
      SecurityClassBasic.SecurityClassStatus,
      SecurityClassBasic.SecurityClassName,
      SecurityClassBasic.SecurityClassDescription,
      SecurityClassBasic.FinancialInstrumentProductType,
      SecurityClassBasic.ScrtyClassGenClassification,
      SecurityClassBasic.Issuer,
      SecurityClassBasic.IssueCurrency,
      SecurityClassBasic.SecurityClassIssuePriceValue,
      SecurityClassBasic.IssueRateInPercent,
      SecurityClassBasic.SecurityClassTransferType,
      SecurityClassBasic.SecurityClassQuotation,
      SecurityClassBasic.ScrtyClMinimalNumberOfUnits,
      SecurityClassBasic.SecurityClassIsListed,
      SecurityClassBasic.SecurityClassTaxClassification,
      SecurityClassBasic.SecurityClassCreatedByUser,
      SecurityClassBasic.SecurityClassCreationDate,
      SecurityClassBasic.SecurityClassCreationTime,
      SecurityClassBasic.SecurityClassCreationSource,
      SecurityClassBasic.SecurityClassLastChangedByUser,
      SecurityClassBasic.SecurityClassLastChangedDate,
      SecurityClassBasic.SecurityClassLastChangedTime,
      SecurityClassBasic.SecurityClassLastChangedSource,
      
      SecurityClassBasic.FinancialInstrProductCategory,
      SecurityClassBasic.SecurityClassIsPledgeable,

      case
        when SecurityClassBasic.FinancialInstrProductCategory = '010'
        or SecurityClassBasic.FinancialInstrProductCategory = '020'
        or SecurityClassBasic.FinancialInstrProductCategory = '160'
          then StockSubscrpnRghtInvmtCert.SecurityClassIssueStartDate
        when SecurityClassBasic.FinancialInstrProductCategory = '040'
        or SecurityClassBasic.FinancialInstrProductCategory = '042'
          then SecurityClassBond.SecurityClassIssueStartDate
        else null  
      end as SecurityClassIssueStartDate,       

      StockSubscrpnRghtInvmtCert.SecurityClassNomPerStockValue,
      StockSubscrpnRghtInvmtCert.SecurityClassStockCategory,
      StockSubscrpnRghtInvmtCert.SecurityClassStockForm,
      StockSubscrpnRghtInvmtCert.SecurityClassFundType,
      StockSubscrpnRghtInvmtCert.SecurityClassFundCategory,
      @Semantics.amount.currencyCode: 'IssueCurrency'
      StockSubscrpnRghtInvmtCert.SecurityClassFundVolumeAmount,
      StockSubscrpnRghtInvmtCert.ScrtyClIssuePremiumInPercent,
      StockSubscrpnRghtInvmtCert.SecurityClassShareholdingType,
      StockSubscrpnRghtInvmtCert.ScrtyClShareholdingStructure,
      
      SecurityClassBond.BondClassification,
      @Semantics.amount.currencyCode: 'IssueCurrency'
      SecurityClassBond.BondCertificateNominalAmount,
      @Semantics.amount.currencyCode: 'IssueCurrency'
      SecurityClassBond.BondCertPerTrdgUnitNominalAmt,
      SecurityClassBond.SecurityClassFinalDueDate,
      SecurityClassBond.ScrtyClCalcPeriodStartDate,
      SecurityClassBond.ScrtyClCompatibleTermEndDate,
      SecurityClassBond.ScrtyClExpectedTermEndDate,
      SecurityClassBond.ScrtyClIsCalcdWthNomPerTrdgUnt,
      SecurityClassBond.ScrtyClTrancheClassification,
      SecurityClassBond.SecurityClassAssetPool,
      
      BondConditionHeader.IntrstCalcFnlDuDteIsIncld

}

Learn More