P_WrkCtrPersnRespAORList

DDL: P_WRKCTRPERSNRESPAORLIST Type: view_entity COMPOSITE Package: VDM_PP_MD_WKC

Work Center Person Responsible AOR List

P_WrkCtrPersnRespAORList is a Composite CDS View that provides data about "Work Center Person Responsible AOR List" in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_WorkCenterResponsible) and exposes 9 fields with key fields Plant, WorkCenterResponsible, WorkCenterResponsible. It has 3 associations to related views. Part of development package VDM_PP_MD_WKC.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Plant plant union
I_WorkCenterResponsible wrkctrresp from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_WrkCtrPersnRespAreaOfRespy _WrkCtrPersnRespAOR wrkctrresp.Plant = _WrkCtrPersnRespAOR.Plant and _WrkCtrPersnRespAOR.UserID = $session.user and wrkctrresp.WorkCenterResponsible = _WrkCtrPersnRespAOR.WorkCenterResponsible
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_WrkCtrPersnRespAreaOfRespy _WrkCtrPersnRespAOR_2 plant.Plant = _WrkCtrPersnRespAOR_2.Plant and _WrkCtrPersnRespAOR_2.UserID = $session.user and _WrkCtrPersnRespAOR_2.WorkCenterResponsible is initial

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Center Person Responsible AOR List view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant
KEY WorkCenterResponsible WorkCenterResponsible
WorkCenterResponsibleName WorkCenterResponsibleName
PlantName _Plant PlantName
WorkCenterResponsibleisinitialkeyPlant
KEY WorkCenterResponsible
WorkCenterResponsibleName
PlantName PlantName
_Plant _Plant 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work Center Person Responsible AOR List'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
//@Search.searchable: true

define view entity P_WrkCtrPersnRespAORList as 

select from I_WorkCenterResponsible as wrkctrresp
association [0..1] to I_WrkCtrPersnRespAreaOfRespy as _WrkCtrPersnRespAOR     on  wrkctrresp.Plant            = _WrkCtrPersnRespAOR.Plant
                                                                              and _WrkCtrPersnRespAOR.UserID          = $session.user
                                                                              and wrkctrresp.WorkCenterResponsible  = _WrkCtrPersnRespAOR.WorkCenterResponsible
{
  key Plant,
  key WorkCenterResponsible,
  WorkCenterResponsibleName,
  _Plant.PlantName as PlantName,
  case
      when _WrkCtrPersnRespAOR.UserID is not null then 1 
      else 0 end as PersnRespAORIsAssigned, 
  _Plant
}

union

select  from I_Plant as plant
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_WrkCtrPersnRespAreaOfRespy as _WrkCtrPersnRespAOR_2     on  plant.Plant            = _WrkCtrPersnRespAOR_2.Plant
                                                                                and _WrkCtrPersnRespAOR_2.UserID          = $session.user
                                                                                and _WrkCtrPersnRespAOR_2.WorkCenterResponsible is initial                                                                           
{
  key Plant,
  key cast( '' as ap_veran )  as WorkCenterResponsible,
  cast( '' as  pph_veranname ) as  WorkCenterResponsibleName,
  PlantName,
  case
      when _WrkCtrPersnRespAOR_2.UserID is not null then 1 
      else 0 end as PersnRespAORIsAssigned,
  _Plant
}

Learn More