I_PPAREAOFRESPONSIBILITY

CDS View

PP Area of Responsibility

I_PPAREAOFRESPONSIBILITY is a CDS View in S/4HANA. PP Area of Responsibility. 8 CDS views read from this table.

Used by 8 CDS view(s)

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_AreaOfResponsibilityFilter view_entity from CONSUMPTION Area Of Responsibility Filter
P_MfgOperationsList view_entity from COMPOSITE Operations matching the assigned AORs
P_MfgOperationsList view_entity union COMPOSITE Operations matching the assigned AORs
P_MfgOrderAORList view_entity from COMPOSITE Orders matching the assigned _AORs
P_MfgOrderAORList view_entity union COMPOSITE Orders matching the assigned _AORs
P_ProcOrdAORList view_entity from COMPOSITE Process Orders for AOR
P_ProcOrdAORList view_entity union_all COMPOSITE Process Orders for AOR
R_PPAreaOfResponsibilityTP view_entity from TRANSACTIONAL PP Area of Responsibility - TP 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PP Area of Responsibility'
@ObjectModel: { 
    usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #CUSTOMIZING }
}

@VDM.viewType: #BASIC
define root view entity I_PPAreaOfResponsibility as select from sdm_aor as aor
association [1..1] to I_Plant                       as _Plant                       on  $projection.Plant = _Plant.Plant
association [1..1] to I_ProductionSupervisor as _ProductionSupervisor    on  $projection.Plant         = _ProductionSupervisor.Plant
                                                                        and $projection.ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor
association [1..1] to I_WorkCenterBySemanticKey as _WorkCenter          on $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                        and $projection.Plant = _WorkCenter.Plant
{
  key aor.werks as Plant,
  key aor.fevor as ProductionSupervisor,
  key aor.uname as UserID,
  key aor.objid as WorkCenterInternalID,
  
 
  _ProductionSupervisor,
  _WorkCenter,
  _Plant
}  
where aor.dispo = '' and aor.uname = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDM_AOR"
],
"ASSOCIATED":
[
"I_PLANT",
"I_PRODUCTIONSUPERVISOR",
"I_WORKCENTERBYSEMANTICKEY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More