I_SecurityAccount

// harmonized annotations

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ISECACCOUNT'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Security Account'
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'SecurityAccount'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@Metadata.allowExtensions:true  
@Metadata.ignorePropagatedAnnotations: true // For C1-Release 

@VDM.viewType: #BASIC

define view I_SecurityAccount
  as select from twd01 as SecurityAccount

  association to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_SecurityAccountType as _SecurityAccountType on $projection.SecurityAccountType = _SecurityAccountType.SecurityAccountType
  
  association [0..1] to I_SecurityAccountGroup as _SecurityAccountGroup on $projection.SecurityAccountGroup = _SecurityAccountGroup.SecurityAccountGroup
                                                                        and $projection.CompanyCode         = _SecurityAccountGroup.CompanyCode

{
      //--[ GENERATED:012:GlBfhyJl7kY4pGd}um{aL0

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key SecurityAccount.bukrs                                              as CompanyCode,
      @ObjectModel.text.element: 'SecurityAccountName'
  key cast(SecurityAccount.rldepo      as ftr_gen_security_account preserving type)      as SecurityAccount,
      @Semantics.text: true
      cast(SecurityAccount.xldepo      as ftr_gen_security_account_name preserving type) as SecurityAccountName,
      cast(SecurityAccount.sec_acc_grp as ftr_gen_sec_account_group preserving type)     as SecurityAccountGroup,

      cast(SecurityAccount.secacc_type as ftr_gen_security_account_type preserving type ) as SecurityAccountType,
      cast(SecurityAccount.rdpbank     as ftr_gen_partnr_depository_bank preserving type ) as DepositoryBank,  
          
      _CompanyCode,
      _SecurityAccountType,
      _SecurityAccountGroup
      //      SecurityAccount.verkonto,

      //      SecurityAccount.rdepotnr,

      //      SecurityAccount.rertrk,

      //      SecurityAccount.rdpbank,

      //      SecurityAccount.rbgue,

      //      SecurityAccount.ssperrv,

      //      SecurityAccount.dsperr,

      //      SecurityAccount.rgsber,

      //      SecurityAccount.sskzb,

      //      SecurityAccount.jvermst,

      //      SecurityAccount.sudec,

      //      SecurityAccount.dedec,

      //      SecurityAccount.rfgeb,

      //      SecurityAccount.dfrei,

      //      SecurityAccount.tfrei,

      //      SecurityAccount.rerf,

      //      SecurityAccount.derf,

      //      SecurityAccount.terf,

      //      SecurityAccount.reher,

      //      SecurityAccount.rbear,

      //      SecurityAccount.dbear,

      //      SecurityAccount.tbear,

      //      SecurityAccount.rbher,

      //      SecurityAccount.rportb,

      //      SecurityAccount.sobjekt,

      //      SecurityAccount.srolextdep,

      //      SecurityAccount.srolextbeg,

      //      SecurityAccount.vvsloekz,

      //      SecurityAccount.ssperr,

      //      SecurityAccount.rahabki,

      //      SecurityAccount.rahktid,

      //      SecurityAccount.status,

      //      SecurityAccount.status_rbear,

      //      SecurityAccount.status_dbear,

      //      SecurityAccount.status_tbear,

      //      SecurityAccount.ext_sec_acc_no,

      //      SecurityAccount.flg_no_tax_map,

      //      SecurityAccount.budat                 as PostingDate

      //      SecurityAccount.country_var,

      //      SecurityAccount.sparte,

      //      SecurityAccount.stockbav

}      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TWD01"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_SECURITYACCOUNTGROUP",
"I_SECURITYACCOUNTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/