E_ARBankStatement

//Extension include view

//Used to wrap the extension include in the persistency 

//Target for extension associations

//An extend view will be generated on the basis of this view

//which will add the extensiuon fields

@AbapCatalog.sqlViewName: 'EARBANKSTMTEXT'
//@ClientDependent: true

@AbapCatalog.compiler.compareFilter: true    
@VDM.viewType: #EXTENSION 
//as per guideline in Wiki https://wiki.wdf.sap.corp/wiki/display/SuiteCDS/VDM+CDS+ATC+Checks+-+VDMCDSSEC-PRIV the @AccessControl.authorizationCheck shall not 

//have the value #NOT_ALLOWED but #PRIVILEGED_ONLY

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Extension View for Bank Statement Header'
//  remove session variable annotation as it will prevent the HANA self-join optimization and lead to performance issues

//     see https://wiki.wdf.sap.corp/wiki/display/SuiteCDS/VDM+CDS+Extension+Include+View

//@ClientHandling.algorithm: #SESSION_VARIABLE 

@ObjectModel.usageType.sizeCategory: #XL 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view E_ARBankStatement
//'Persistence' is a mandatory naming convention

as select from febko as Persistence 
{
  key Persistence.anwnd                        as BankStatementShortID,
  key Persistence.absnd                        as SendingBank,
  key Persistence.azidt                        as BankStatementInternalID,
  key Persistence.emkey                        as BankStatementRecipientRefID
}

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