P_NightSplitForShift

DDL: P_NIGHTSPLITFORSHIFT SQL: PWRKCTRNIGHTSPLT Type: view COMPOSITE Package: PPH_VDM_CAP_EVAL

Work Center Night Split

P_NightSplitForShift is a Composite CDS View that provides data about "Work Center Night Split" in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_Plant). Part of development package PPH_VDM_CAP_EVAL.

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
I_Plant I_Plant from
I_Plant I_Plant union

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PWRKCTRNIGHTSPLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view 
@AbapCatalog.sqlViewName: 'PWRKCTRNIGHTSPLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
  private: true
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Work Center Night Split'

define view P_NightSplitForShift

  //  the job of this view is to provide two fixed lines so that we can split the night shifts

  //  select from any view since we are not actually taking any values

  as select from I_Plant
{
      // first row to join the part of the night shift that is before midnight

  key 1 as NightSplitDate
}

union

select from I_Plant
{
      // second row to join the part of the night shift that is after midnight

  key 2 as NightSplitDate
}

Learn More