SHSM_V_NPACT

@AbapCatalog.sqlViewName: 'SHSMVNPACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'cds view for search help NPACT'
define view SHSM_V_NPACT as select from I_NetworkActivity 

 inner join afko on I_NetworkActivity.ProjectNetworkInternalID = afko.aufpl
 inner join aufk on aufk.aufnr = afko.aufnr

{
 
 afko.aufnr as aufnr,
 I_NetworkActivity.NetworkActivity as vornr,
 I_NetworkActivity.NetworkActivityDescription as ltxa1,
 I_NetworkActivity.NetworkActivityObject as objnr,
 aufk.autyp as autyp,
 
 @Consumption.hidden:true
 NetworkActivityCategory,
 @Consumption.hidden:true
 Plant,
 @Consumption.hidden:true
 WorkCenter,
 @Consumption.hidden:true
 FreeDefinedAttribute01,
 @Consumption.hidden:true
 FreeDefinedAttribute02,
 @Consumption.hidden:true
 FreeDefinedAttribute03,
 @Consumption.hidden:true
 FreeDefinedAttribute04,
 @Consumption.hidden:true
 FreeDefinedIndicator1,
 @Consumption.hidden:true
 FreeDefinedIndicator2,
 @Consumption.hidden:true
 WBSElementInternalID,
 @Consumption.hidden:true
 Supplier,
 @UI.hidden: true
 @Consumption.hidden:true
 _WBSElement,
 @UI.hidden: true
 @Consumption.hidden:true
 _Supplier
  
}
where I_NetworkActivity.SuperiorNtwkActivityInternalID = '00000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NETWORKACTIVITY",
"AFKO",
"AUFK"
],
"ASSOCIATED":
[
"I_SUPPLIER",
"I_WBSELEMENT"
],
"BASE":
[
"I_NETWORKACTIVITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/