P_BOOPlantControllingArea

DDL: P_BOOPLANTCONTROLLINGAREA SQL: PPPBOOPLNTCOAREA Type: view_entity COMPOSITE

P_BOOPlantControllingArea is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Plant) and exposes 3 fields with key field Plant.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_Plant I_Plant from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant
ControllingArea I_CompanyCode ControllingArea
_ControllingArea I_CompanyCode _ControllingArea 
//@AbapCatalog.sqlViewName: 'PPPBOOPLNTCOAREA'

//@AbapCatalog.compiler.compareFilter:true 

//@AbapCatalog.preserveKey:true 

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER}
@VDM.viewType: #COMPOSITE
@VDM.private: true

// The ControllingArea is not known but can be derived this way:

// I_PLANT(valuation area)->I_PURREQVALUATIONAREA(company code)->I_COMPANYCODE(controlling area)


//define view P_BOOPlantControllingArea

define view entity P_BOOPlantControllingArea
  as select from I_Plant
    join         I_Purreqvaluationarea on I_Purreqvaluationarea.ValuationArea = I_Plant.ValuationArea
    join         I_CompanyCode         on I_CompanyCode.CompanyCode = I_Purreqvaluationarea.CompanyCode

{
  key I_Plant.Plant,
      I_CompanyCode.ControllingArea,
      I_CompanyCode._ControllingArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_PLANT",
"I_PURREQVALUATIONAREA"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA"
],
"BASE":
[
"I_COMPANYCODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More