I_SecurityClass

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true // only if required by ATC check 

@AbapCatalog.sqlViewName: 'ISECURITYCLASS' 
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION 
@Analytics.dataExtraction.enabled : true
@Analytics.internalName: #LOCAL 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Security Class'
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'SecurityClass'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D 
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:true   
@Metadata.ignorePropagatedAnnotations: true // For C1-Release 

@VDM.viewType: #BASIC

// Do not use I_SecurityClassN anymore!!!


define view I_SecurityClass

   as select from vwpanla as SecurityClass

   association [0..1] to I_SecurityClassBond as _SecurityClassBond on $projection.SecurityClass = _SecurityClassBond.SecurityClass
   association [0..1] to I_SecurityClassStock as _SecurityClassStock on $projection.SecurityClass = _SecurityClassStock.SecurityClass
   association [0..1] to I_SecurityClassLstdDerivative as _SecurityClassLstdDerivative on $projection.SecurityClass = _SecurityClassLstdDerivative.SecurityClass
 
   association [0..1]  to I_BusinessPartner           as _SecurityClassIssuer           on  $projection.Issuer                      = _SecurityClassIssuer.BusinessPartner
   association [0..1]  to I_SecurityClassQuotation    as _SecurityClassQuotation        on  $projection.SecurityClassQuotation      = _SecurityClassQuotation.SecurityClassQuotation
   association [0..1]  to I_SecurityClassTransferType as _SecurityClassTransferType     on  $projection.SecurityClassTransferType   = _SecurityClassTransferType.SecurityClassTransferType
   association [0..1]  to I_SecurityClassGenClassfctn as _SecurityClassGenClassfctn     on  $projection.ScrtyClassGenClassification = _SecurityClassGenClassfctn.ScrtyClassGenClassification
                                                                                     
   association        to I_FinancialinstrProductType  as _FinancialInstrProductType  on $projection.FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType
   association        to I_FinancialInstrProdCat      as _FinancialInstrProdCat      on $projection.FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory 
            
                                                                                     
{
       @ObjectModel.text.element:  [ 'SecurityClassName' ]
  key  cast(ranl as ftr_gen_security_class preserving type )                          as SecurityClass,
       cast(sanlf as ftr_gen_fin_instr_prod_categ preserving type)                    as FinancialInstrProductCategory,  
       SecurityClass.gsart                                                            as FinancialInstrumentProductType,
       @Semantics.text: true
       cast(SecurityClass.xalkz as ftr_gen_security_class_name preserving type)       as SecurityClassName,
       @Semantics.text: true
       cast(SecurityClass.xallb as ftr_gen_security_class_lname preserving type)      as SecurityClassDescription,
       cast(SecurityClass.repke as repke_new preserving type)                         as Issuer,
       SecurityClass.sboernot                                                         as SecurityClassIsListed,
       SecurityClass.snoti                                                            as SecurityClassQuotation,
       //Additional table fields for TPM12

       SecurityClass.rewhr                                                            as IssueCurrency,
       SecurityClass.wpfan                                                            as SecurityClassIsPledgeable,
       SecurityClass.srolext                                                          as ScrtyClassGenClassification,
       SecurityClass.swerttyp                                                         as SecurityClassTransferType,       

//       _SecurityClassStock.SecurityClassStockCategory,

//       _SecurityClassStockCategory._Text[1: Language=$session.system_language].SecurityClassStockCategoryName,

//   

//       SecurityClassQuotation,

//       _SecurityClassQuotation._Text[1: Language=$session.system_language].SecurityClassQuotationName,

//

//       //Additional table fields for TPM12

//       IssueCurrency,

//       SecurityClassIsPledgeable,

//       ScrtyClassGenClassification,

//       SecurityClassTransferType,

//       _SecurityClassBond.BondClassification,

//       ListedDerivativeCategory,

//       OptionPutCallCode,

//       _ListedDerivativeCategory._Text[1: Language=$session.system_language].ListedDerivativeCategoryName,

//       _OptionPutCallCode._Text[1: Language=$session.system_language].OptionPutCallCodeName,

//

//       _BondClassificationText.BondClassificationName, 

//       _SecurityClassTransferTypeText.SecurityClassTransferTypeName, 

//       _ScrtyClassGenClassfctnText.ScrtyClassGenClassfctnName,

       
       _SecurityClassBond,
       _SecurityClassStock,
       _SecurityClassLstdDerivative,
       _SecurityClassIssuer,
       _FinancialInstrProductType,
       _FinancialInstrProdCat,
       _SecurityClassQuotation,
       _SecurityClassTransferType,
       _SecurityClassGenClassfctn      
       
}