@AbapCatalog.sqlViewName: 'PDGRPLNTCCDEMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D -- View will be consumed for Analytical Reporting
@ObjectModel.usageType.sizeCategory: #XXL -- No. of Records > 100,000
//@EndUserText.label: 'Get Plant Company Code Material'
define view P_DGR_Gen_PlantCCode_Material
as select from t001k as T001K
inner join marc as Material on t001k.bwkey = Material.werks
{
t001k.bukrs as CompanyCode,
t001k.bwkey as Plant,
Material.matnr as Material
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARC",
"T001K"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/