PPH_MRP_CTRLR

DDL: PPH_MRP_CTRLR SQL: PPH_MRPCTRLR Type: view

MRP Controller

PPH_MRP_CTRLR is a CDS View that provides data about "MRP Controller" in SAP S/4HANA. It reads from 3 data sources (marc, t001w, t024d) and exposes 4 fields with key fields MRPPLANT, MRPCONTROLLERID.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
marc marc left_outer
t001w T001W inner
t024d T024D from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPH_MRPCTRLR view
EndUserText.label MRP Controller view
ClientDependent true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MRPPLANT t024d werks
KEY MRPCONTROLLERID t024d dispo
MRPPLANTNAME t001w name1
MRPCONTROLLERNAME t024d dsnam 
@AbapCatalog.sqlViewName: 'PPH_MRPCTRLR'
@EndUserText.label: 'MRP Controller'
@ClientDependent: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED}
define view PPH_MRP_CTRLR as select from 
t024d as T024D
inner join t001w as T001W
on T024D.werks = T001W.werks
left outer join marc as marc
on T024D.werks = marc.werks and T024D.dispo = marc.dispo
{
  key T024D.werks as MRPPLANT,
  key T024D.dispo as MRPCONTROLLERID,
  T001W.name1 as MRPPLANTNAME,
  T024D.dsnam as MRPCONTROLLERNAME,
  case coalesce( marc.werks, '' )
    when '' then 0
    else count( * )
  end as  NUMBER_OF_MATERIALS
}
group by T024D.werks, T024D.dispo, T001W.name1, T024D.dsnam, marc.werks

Learn More