P_ProdnSupvrPlantList

DDL: P_PRODNSUPVRPLANTLIST Type: view_entity COMPOSITE

Prodn Supvr Plant List

P_ProdnSupvrPlantList is a Composite CDS View that provides data about "Prodn Supvr Plant List" in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_ProductionSupervisorAOR) and exposes 11 fields with key fields Plant, ProductionSupervisor, ProductionSupervisor. It has 1 association to related views.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_Plant plant union
I_ProductionSupervisorAOR supervisor from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPAreaOfResponsibility _SDMAOR $projection.Plant = _SDMAOR.Plant and _SDMAOR.UserID = $session.user and _SDMAOR.ProductionSupervisor is initial and _SDMAOR.WorkCenterInternalID is initial

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Prodn Supvr Plant List view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Plant I_ProductionSupervisorAOR Plant
KEY ProductionSupervisor I_ProductionSupervisorAOR ProductionSupervisor
ProductionSupervisorName I_ProductionSupervisorAOR ProductionSupervisorName
UserID I_ProductionSupervisorAOR UserID
UserName I_ProductionSupervisorAOR UserName
WorkCenterInternalIDisinitialkeyPlant
KEY ProductionSupervisor
ProductionSupervisorName
UserID _SDMAOR UserID
UserName
PlantName PlantName 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@EndUserText.label: 'Prodn Supvr Plant List'
@Metadata.ignorePropagatedAnnotations: true
define root view entity P_ProdnSupvrPlantList
  as select from I_ProductionSupervisorAOR as supervisor
  
{
      // Key

      @ObjectModel.text.element: ['PlantName']
  key supervisor.Plant,
      @ObjectModel.text.element: ['ProductionSupervisorName']
  key supervisor.ProductionSupervisor,

      // Attributes

      @Semantics.text: true
      supervisor.ProductionSupervisorName,
      
      supervisor.UserID,
      supervisor.UserName,
      @Semantics.text: true
      supervisor.PlantName
      


}

union

select  from I_Plant as plant
association [0..1] to I_PPAreaOfResponsibility     as _SDMAOR                      on $projection.Plant           = _SDMAOR.Plant 
                                                                                      and  _SDMAOR.UserID = $session.user
                                                                                      and  _SDMAOR.ProductionSupervisor is initial
                                                                                      and  _SDMAOR.WorkCenterInternalID is initial                                                                           
{
  key Plant,
  key cast( '' as pph_fevor )  as ProductionSupervisor,
  cast( '' as txt_fevor ) as  ProductionSupervisorName,
  _SDMAOR.UserID,
  $session.user  as UserName,
  PlantName
};

Learn More