@AbapCatalog.sqlViewName: 'PPLANTCRCY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PLANTCURRENCY
as select from t001w
inner join t001k on t001w.bwkey = t001k.bwkey
inner join t001 on t001.bukrs = t001k.bukrs
{
key t001w.werks as Plant,
t001w.bwkey as ValuationArea,
t001.bukrs as CompanyCode,
t001.waers as CompanyCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/