P_BSBW

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Parallel Valuation Views of Operational AccDocument Items'

@AbapCatalog.sqlViewName: 'PFIBSBW'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
define view P_BSBW as select from bsbw inner join t001 on bsbw.bukrs = t001.bukrs
{
key cast( bsbw.bukrs as fis_bukrs preserving type )    as bukrs, 
key cast( belnr as farp_belnr_d preserving type )      as belnr, 
key cast( gjahr as fis_gjahr_no_conv preserving type ) as gjahr, 
key cast( buzei as fis_buzei preserving type )         as buzei, 
key cast( curtp as fins_curtype preserving type )      as curtp, 
key cast( bwber as fis_bwber preserving type )         as bwber, 
key methd, 

cast( datum as fis_valdate preserving type )           as datum, 

@Semantics.currencyCode:true
cast( t001.waers as fis_hwaer preserving type )        as waers,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 't001.waers'} } 
bwshb, 

cast( kunnr as fis_kunnr preserving type )             as kunnr, 
cast( koart as fis_koart preserving type )             as koart 
}

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