P_NightSplitForShift

DDL: P_NIGHTSPLITFORSHIFT SQL: PWRKCTRNIGHTSPLT Type: view COMPOSITE

P_NightSplitForShift is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_Plant).

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More