I_BerthScheduling

@AbapCatalog.sqlViewName: 'IBERTHSCHEDULING'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Berth Scheduling Information'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BerthScheduling
  as select from    I_NominationAnalysisPath as nom
    left outer join v_oij_pegtyp             as peg on peg.peg_type_usage = 'BS'
    left outer join v_oijpeg                 as b   on  b.docno   = nom.NominationDoc
                                                    and b.item    = nom.NominationDocItem
                                                    and b.doctype = 'n'
                                                    and b.pegtype = peg.peg_type //'MS'

    left outer join v_oijnomi_lds_bs         as c   on  c.pegid = b.pegid
                                                    and c.nomtk = b.docno
    left outer join v_oijberloc              as d   on d.berid = c.berid
    left outer join v_oij_nomlt              as dem on dem.pegid = b.pegid
    left outer join v_oigvt                  as g   on  g.vehicle = nom.VehicleId
                                                    and g.lang    = $session.system_language
    left outer join v_mara_makt              as m   on  m.matnr = nom.ScheduledMaterial
                                                    and m.spras = $session.system_language

{
  nom.NominationDoc                    as NominationKey,
  nom.NominationDocItem                as NominationItem,
  @Search.ranking : #HIGH
  nom.NominationExtNumber              as NominationExtNumber,
  nom.NominationScheduleType           as NominationScheduleType,
  // Nomination Schedule Start DateTime (Timestamp)

  nom.ScheduledBatchStartDateTime      as ScheduledBatchStartDateTime,
  //  tstmp_to_dats( nom.ScheduledBatchStartDateTime,

  //               abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' )

  //                                       as PlannedStartDate,

  //  tstmp_to_tims( nom.ScheduledBatchStartDateTime,

  //                 abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' )

  //                                       as PlannedStartTime,

  // Nomination Schedule Start Date

  cast( '00000000' as abap.dats )      as PlannedStartDate,
  // Nomination Schedule Start Time

  cast( '000000' as abap.tims )        as PlannedStartTime,

  //  // Nomination Schedule End DateTime (Timestamp)

  nom.ScheduledBatchEndDateTime        as ScheduledBatchEndDateTime,
  //  tstmp_to_dats( nom.ScheduledBatchEndDateTime,

  //               abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' )

  //                                       as PlannedDischargeDate,

  //  tstmp_to_tims( nom.ScheduledBatchEndDateTime,

  //               abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' )

  //                                       as NominationDischargeTime,

  // Nomination Schedule End Date

  cast( '00000000' as abap.dats )      as PlannedDischargeDate,
  // Nomination Schedule End Time

  cast( '000000' as abap.tims )        as NominationDischargeTime,
  nom.LocationId                       as LocationDischargeId,
  d.bernr                              as BerthNumber,
  d.pblnr                              as LocationId,
  b.pegid                              as NominationPegID,
  b.pegtype                            as NominationPegType,
  peg.peg_type_usage                   as NominationPeggingTypeUsage,
  dem.lt_act                           as ActualLayTime,
  cast( '' as abap.char( 10 ) )        as TripLayTimeUoM, // lay_uom

  dem.lt_allowed                       as PlannedLayTimeDuration,
  dem.dm_pot                           as DemurrageAmount,  
  dem.dm_curr                          as AlternativeCurrencyKey,
  cast( '' as abap.char( 15 ) )        as DemurrageAmountCrcy, // dm_curr  

  m.matnr                              as ScheduledMaterial,
  m.maktx                              as MaterialDesc,
  g.vehicle                            as TransportationVehicle,
  cast( '' as abap.char( 40 ) )        as VehicleDescription,
  nom.NominationModeOfTransport        as NominationModeOfTransport,
  nom.ScheduledQuantity                as NominationTicketQuantity,
  nom.ScheduledQuantityUnit            as NominationHeaderUom,
  c.ldfrdate                           as NominationBerthStartDate,
  c.ldfrtime                           as NominationBerthStartTime,
  c.ldtodate                           as NominationBerthEndDate,
  c.ldtotime                           as NominationBerthEndTime,
  cast( '' as abap.char( 4 ) )         as NominationTicketEventType,
  cast( '' as abap.char( 40 ) )        as TripEventDescription,
  cast( '00000000' as abap.dats )      as NominationEventChangedDate,
  cast( '000000' as abap.tims )        as NominationEventChangedTime,
  cast(dats_tims_to_tstmp( cast( '00000000' as abap.dats ),
                       cast( '000000' as abap.tims ),
                       abap_system_timezone($session.client, 'NULL'),
                       $session.client,
                       'NULL' )  as timestamp)                                                           as NominationEventChangedDateTime,
      
  cast( '00000000' as abap.dats )      as NominationEvtPlndEndDateFrom,
  cast( '000000' as abap.tims )        as NominationEvtPlndEndTimeFrom,
  cast( '' as abap.char( 2 ) )         as NomEventPhaseType,
  cast( '' as abap.char( 40 ) )        as NomEventPhaseDesc,
  cast( '' as abap.char( 7 ) )         as TicketStatusColorCode,
  cast( '' as abap.char( 7 ) )         as WeatherRedGradientColor
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NOMINATIONANALYSISPATH",
"V_MARA_MAKT",
"V_OIGVT",
"V_OIJBERLOC",
"V_OIJNOMI_LDS_BS",
"V_OIJPEG",
"V_OIJ_NOMLT",
"V_OIJ_PEGTYP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/