Oij05_Nominations

@AbapCatalog.sqlViewName: 'V_OIJ05_NM'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'To fetch nominations'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #CLIENT_DEPENDENT
@AccessControl.personalData.blocking: #REQUIRED

define view Oij05_Nominations
  as select distinct from v_oij05_nom  as a
    inner join   goij05_nomtk as b on a.nomtk = b.nomtk
    left outer join oijloc as c on a.locid = c.locid 
    left outer join makt as d on a.s_matnr_i = d.matnr and d.spras = $session.system_language
    left outer join makt as e on a.matnr_i = e.matnr   and e.spras = $session.system_language
    left outer join oijts as f on a.tsyst = f.tsyst 
    left outer join tvtrt as g on a.vktra = g.vktra and g.spras = $session.system_language
    left outer join lfa1  as h on a.nmcarrier = h.lifnr and h.spras = $session.system_language
    left outer join lfa1  as i on a.nmshipper = i.lifnr and i.spras = $session.system_language
    left outer join oigvt as j on a.nmvehicle = j.vehicle and j.language = $session.system_language
    left outer join ( oijpeg as k inner join 
                      oij07_pegging_ty as l on k.pegtype = l.peg_type and 
                                               l.peg_type_usage = 'TS') on a.nomtk = k.docno and a.nomit = k.item
{
  key a.mandt,
  key a.nomtk,
  key nomit,
  nomcl,
  nomtyp,
  a.bustyp,
  nomnr,
  nomst,
  nmshtype,
  nmbalch,
  stages_id,
  worklist,
  sentdat,
  senttime,
  sentnam,
  items,
  counter1,
  counter2,
  counter3,
  counter4,
  counter5,
  counter6,
  apo_shipment_id,
  apo_shipment_num,
  nmblock,
  nomtypdesc,
  a.shtyp,
  tknum,
  lov_gl,
  a.tsyst,
  f.tsnam                            as tsnam,
  nmshipper,
  i.name1                          as name1,
  nmcarrier,
  h.name1                          as CARR_NAME,
  //'' as CARR_NAME,

  cycle,
  nmwerk,
  nmlgort,
  nmvehicle,
  j.veh_text                    as veh_text,
  nmvessel,
  nmtplst,
  route,
  a.bookts,
  ev_group,
  a.vktra,
  g.bezei                     as bezei,
  qtyin,
  qtyout,
  unit,
  tst_from_min,
  tst_to_max,
  a.bloind,
  a.delind,
  shnum,
  a.erdat,
  a.erzeit,
  a.ernam,
  a.aedat,
  a.aezeit,
  a.aenam,
  sityp,
  istat,
  isubstat,
  idate,
  sched_tst_from,
  sched_tst_to,
  a.locid,
  c.locnam                       as locnam,
  s_matnr_i,
 // '' as s_matnr_i,

  d.maktx                   as  S_MAKTX,
  matnr_i,
  e.maktx                       as maktx,
  menge,
  unit_i,
  unit_i_t,
  docind,
  docnr,
  docitm,
  docschedln,
  qtyfcr,
  qtyfcr_uom,
  worklist_i,
  tank,
  cons,
  partnr,
  conpat,
  inspe,
  impoexpo,
  flag_imex,
  owner,
  charg_o,
  charg_d,
  rvp,
  valuationtype_o,
  valuationtype_d,
  shnum_i,
  shitem,
  ilock,
  prorateqty,
  assignedqty,
  actdat,
  acttime,
  actuals,
  actualqty,
  actualuom,
  itbotol,
  itbutol,
  itbotolabs,
  itbutolabs,
  ittolunit,
  a.unlimited,
  bloind_i,
  delind_i,
  updatexdok,
  incomplete_flag,
  doctyp,
  ldrate,
  ldquom,
  ldtuom,
  third_nomnr,
  upmat,
  refitem,
  stlty,
  stlkn,
  charg_d_create,
  charg_o_create,
  co_carr,
  co_ship,
  co_tsyst,
  commctl,
  soldto,
  prorate_routine,
  charg_l,
  charg_l_create,
  tcnum,
  tcitm,
  ga_nmshipper,
  ga_conf_qty,
  ga_conf_uom,
  ga_techsch_qty,
  ga_techsch_uom,
  ga_conf_qty_cal,
  ga_tsch_qty_cal,
  ga_allocated_qty,
  ga_allocated_uom,
  ga_rank,
  cycle_item,
  lesshnum,
  lestpnum,
  atl_delv_number,
  atl_delv_itm,
  atl_crdt_qty,
  atl_crdt_uom,
  atl_crdt_val,
  atl_crdt_curr,
  pre_exist_ind,
  planind,
  locpt,
  locsl,
  quickconf,
  erdat_i,
  erzeit_i,
  ernam_i,
  aedat_i,
  aezeit_i,
  aenam_i,
  actualqty_par,
  actualuom_par,
  lov_ind,
  ferryind,
  railcarqty,
  tstmp_to_tims(sched_tst_from, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as itime,
  tstmp_to_dats(sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as idate_to,
  tstmp_to_tims(sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as itime_to,
  pegid,
  pegtype
}
where
  delind_i = ''
  and a.nmselect != 'X'
  ;


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GOIJ05_NOMTK",
"LFA1",
"MAKT",
"OIGVT",
"OIJ07_PEGGING_TY",
"OIJLOC",
"OIJPEG",
"OIJTS",
"TVTRT",
"V_OIJ05_NOM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/