P_RSHWCNightSplit

@AbapCatalog.sqlViewName: 'PRSHWCNIGHTSPLIT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

/*
CONTRACT**********************************************************************************************************************

Name:                       Work Center Night Split
Specification:              This view provides two fixed lines so that we can split the night shifts
                            select from any view since we are not actually taking any values
Requires:                   NA
Ensures:                    NA
Owners:                     CK
Contributors:               AN, PRP
Unit Test required Y/N:     Yes

END OF CONTRACT***************************************************************************************************************
*/

define view P_RSHWCNightSplit

  //  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":""
}
}*/