P_NUMBEROFSOS

DDL: P_NUMBEROFSOS Type: view_entity COMPOSITE Package: PPH_VDM_CAP_EVAL

Number of Source Of Supply

P_NUMBEROFSOS is a Composite CDS View that provides data about "Number of Source Of Supply" in SAP S/4HANA. It reads from 3 data sources (I_Capacity, I_SchedProdnPlngDets, I_WorkCenter) and exposes 3 fields with key fields Product, Plant. Part of development package PPH_VDM_CAP_EVAL.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
I_Capacity _Capacity inner
I_SchedProdnPlngDets _plngdets left_outer
I_WorkCenter _WorkCenter inner

Annotations (2)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Product _prodvers Material
KEY Plant _prodvers Plant
NumberOfSOS 
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_NUMBEROFSOS
  as select distinct from I_ProductionVersion as _prodvers
    left outer join I_SchedProdnPlngDets as _plngdets on _plngdets.UserName = $session.user
                                                      and _plngdets.SchedProdnAppName = 'SCH_PROD'
    inner join            I_WorkCenter        as _WorkCenter on  _WorkCenter.WorkCenter              = _prodvers.ProductionLine
                                                             and _WorkCenter.Plant                   = _prodvers.Plant
                                                             and _WorkCenter.WorkCenterTypeCode      = 'A'
                                                             and _WorkCenter.WorkCenterIsToBeDeleted = ''
    inner join            I_Capacity          as _Capacity   on  _WorkCenter.CapacityInternalID = _Capacity.CapacityInternalID
                                                             and _Capacity.CapacityIsFinite     = 'X'
{

  key _prodvers.Material as Product,
  key _prodvers.Plant,
      cast (count(*) as pph_cfs_sch_number_of_sos) as NumberOfSOS
}
where
  _prodvers.ProductionLine != '' and (_plngdets.IndustryType is null or _prodvers._BillOfOperationsType.BillOfOperationsApplication = _plngdets.IndustryType)
group by
  _prodvers.Material,
  _prodvers.Plant

Learn More