Oij05_Sched

@AbapCatalog.sqlViewName: 'V_OIJ05_SCHED'
@EndUserText.label: 'CDS for OIJ_SCHED'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED

define view Oij05_Sched
  with parameters
    p_userid :oij05_userid,
    p_version : oij_simvers
  as select distinct from oij_sched    as b
    inner join   goij05_nomtk as a on b.nomtk = a.nomtk
    left outer join oijloc as c on b.locid = c.locid
    left outer join makt as d on b.s_matnr_i = d.matnr and d.spras = $session.system_language
    left outer join makt as e on b.matnr_i = e.matnr and e.spras = $session.system_language
    left outer join oijts as f on b.tsyst = f.tsyst
    left outer join tvtrt as g on b.vktra = g.vktra and g.spras = $session.system_language
    left outer join lfa1  as h on b.nmcarrier = h.lifnr and h.spras = $session.system_language
    left outer join lfa1  as i on b.nmshipper = i.lifnr and i.spras = $session.system_language
    left outer join oigvt as j on b.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 b.sim_sched_id = k.docno and b.sim_sched_ln = k.item
{
  b.mandt,
  b.nomtk,
  b.nomit,
  b.nomcl, 
  b.nomtyp,
  b.bustyp,
  b.nomnr,
  b.nomst,
  b.nmshtype,
  b.nmbalch,
  b.stages_id,
  b.worklist,
  b.sentdat,
  b.senttime,
  b.sentnam,
  b.items,
  b.counter1,
  b.counter2,
  b.counter3,
  b.counter4,
  b.counter5,
  b.counter6,
  b.apo_shipment_id,
  b.apo_shipment_num,
  b.nmblock,
  b.nomtypdesc,
  b.shtyp,
  b.tknum,
  b.lov_gl,
  b.tsyst,
  f.tsnam,
  b.nmshipper,
  i.name1,
  b.nmcarrier,
  h.name1             as      CARR_NAME,
  b.cycle,
  b.nmwerk,
  b.nmlgort,
  b.nmvehicle,
  j.veh_text,
  b.nmvessel,
  b.nmtplst,
  b.route,
  b.bookts,
  b.ev_group,
  b.vktra,
  g.bezei,
  b.qtyin,
  b.qtyout,
  b.unit,
  b.tst_from_min,
  b.tst_to_max,
  b.bloind  as   bloind_i,
  b.delind  as   delind_i,
  b.shnum   as   shnum,
  b.shnum   as   shnum_i,
  b.erdat,
  b.erzeit,
  b.ernam,
  b.aedat,
  b.aezeit,
  b.aenam,
  b.sityp,
  b.istat,
  b.isubstat,
  b.idate,
  b.sched_tst_from,
  b.sched_tst_to,
  b.locid,
  c.locnam,
  b.s_matnr_i,
  d.maktx                    as  S_MAKTX,
  b.matnr_i,
  e.maktx,
  b.menge,
  b.unit_i,
  b.unit_i_t,
  b.docind,
  b.docnr,
  b.docitm,
  b.docschedln,
  b.qtyfcr,
  b.qtyfcr_uom,
  b.worklist_i,
  b.tank,
  b.cons,
  b.partnr,
  b.conpat,
  b.inspe,
  b.impoexpo,
  b.flag_imex,
  b.owner,
  b.charg_o,
  b.charg_d,
  b.rvp,
  b.valuationtype_o,
  b.valuationtype_d,
  b.shitem,
  b.ilock,
  b.prorateqty,
  b.assignedqty,
  b.actdat,
  b.acttime,
  b.actuals,
  b.actualqty,
  b.actualuom,
  b.itbotol,
  b.itbutol,
  b.itbotolabs,
  b.itbutolabs,
  b.ittolunit,
  b.unlimited,
  ''        as   BLOIND,
  ''        as   DELIND,
  b.updatexdok,
  b.incomplete_flag,
  b.doctyp,
  b.ldrate,
  b.ldquom,
  b.ldtuom,
  b.third_nomnr,
  b.upmat,
  b.refitem,
  b.stlty,
  b.stlkn,
  b.charg_d_create,
  b.charg_o_create,
  b.co_carr,
  b.co_ship,
  b.co_tsyst,
  b.commctl,
  b.soldto,
  b.prorate_routine,
  b.charg_l,
  b.charg_l_create,
  b.tcnum,
  b.tcitm,
  b.ga_nmshipper,
  b.ga_conf_qty,
  b.ga_conf_uom,
  b.ga_techsch_qty,
  b.ga_techsch_uom,
  b.ga_conf_qty_cal,
  b.ga_tsch_qty_cal,
  b.ga_allocated_qty,
  b.ga_allocated_uom,
  b.ga_rank,
  b.cycle_item,
  b.lesshnum,
  b.lestpnum,
  b.atl_delv_number,
  b.atl_delv_itm,
  b.atl_crdt_qty,
  b.atl_crdt_uom,
  b.atl_crdt_val,
  b.atl_crdt_curr,
  b.pre_exist_ind,
  ''        as   PLANIND,
  b.loc_pt  as   locpt,
  b.loc_sl  as   locsl,
  //''  as LOCPT,

  //''  as LOCSL,

  b.quickconf as   QUICKCONF,
  b.erdat   as   ERDAT_I,
  b.erzeit  as   ERZEIT_I,
  b.ernam   as   ERNAM_I,
  b.aedat   as   AEDAT_I,
  b.aezeit  as   AEZEIT_I,
  b.aenam   as   AENAM_I,
  0         as   ACTUALQTY_PAR,
  '   '     as   actualuom_par,
  ''        as   LOV_IND,
  ''        as   FERRYIND,
  0         as   RAILCARQTY,
  tstmp_to_tims(b.sched_tst_from, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as itime,
  tstmp_to_dats(b.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as idate_to,
  tstmp_to_tims(b.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') as itime_to, 
  b.sim_sched_id,
  b.sim_sched_ln,
  b.updkz,
  b.user_id,
  b.sim_version,
  b.sched_comm,
  b.ipw_txt,
  b.sim_sched_typ,
  b.sched_stat,
  '2'       as   nom_sim,
  k.pegid,
  k.pegtype,
  '83'      as   CD_NOMTK,
  '83'      as   CD_NOMIT,
  '83'      as   CD_NOMCL,
  '83'      as   CD_NOMTYP,
  '83'      as   CD_BUSTYP,
  '83'      as   CD_NOMNR,
  '83'      as   CD_NOMST,
  '83'      as   CD_NMSHTYPE,
  '83'      as   CD_NMBALCH,
  '83'      as   CD_STAGES_ID,
  '83'      as   CD_WORKLIST,
  '83'      as   CD_SENTDAT,
  '83'      as   CD_SENTTIME,
  '83'      as   CD_SENTNAM,
  '83'      as   CD_ITEMS,
  '83'      as   CD_COUNTER1,
  '83'      as   CD_COUNTER2,
  '83'      as   CD_COUNTER3,
  '83'      as   CD_COUNTER4,
  '83'      as   CD_COUNTER5,
  '83'      as   CD_COUNTER6,
  '83'      as   CD_APO_SHIPMENT_ID,
  '83'      as   CD_APO_SHIPMENT_NUM,
  '83'      as   CD_NMBLOCK,
  '83'      as   CD_NOMTYPDESC,
  '83'      as   CD_SHTYP,
  '83'      as   CD_TKNUM,
  '83'      as   CD_LOV_GL,
  '83'      as   CD_TSYST,
  '83'      as   CD_TSNAM,
  '83'      as   CD_NMSHIPPER,
  '83'      as   CD_NAME1,
  '83'      as   CD_NMCARRIER,
  '83'      as   CD_CARR_NAME,
  '83'      as   CD_CYCLE,
  '83'      as   CD_NMWERK,
  '83'      as   CD_NMLGORT,
  '83'      as   CD_NMVEHICLE,
  '83'      as   CD_VEH_TEXT,
  '83'      as   CD_NMVESSEL,
  '83'      as   CD_NMTPLST,
  '83'      as   CD_ROUTE,
  '83'      as   CD_BOOKTS,
  '83'      as   CD_EV_GROUP,
  '83'      as   CD_VKTRA,
  '83'      as   CD_BEZEI,
  '83'      as   CD_QTYIN,
  '83'      as   CD_QTYOUT,
  '83'      as   CD_UNIT,
  '83'      as   CD_TST_FROM_MIN,
  '83'      as   CD_TST_TO_MAX,
  '83'      as   CD_BLOIND_I,
  '83'      as   CD_DELIND_I,
  '83'      as   CD_SHNUM,
  '83'      as   CD_SHNUM_I,
  '83'      as   CD_ERDAT,
  '83'      as   CD_ERZEIT,
  '83'      as   CD_ERNAM,
  '83'      as   CD_AEDAT,
  '83'      as   CD_AEZEIT,
  '83'      as   CD_AENAM,
  '83'      as   CD_SITYP,
  '83'      as   CD_ISTAT,
  '83'      as   CD_ISUBSTAT,
  '83'      as   CD_IDATE,
  '83'      as   CD_SCHED_TST_FROM,
  '83'      as   CD_SCHED_TST_TO,
  '83'      as   CD_LOCID,
  '83'      as   CD_LOCNAM,
  '83'      as   CD_S_MATNR_I,
  '83'      as   CD_S_MAKTX,
  '83'      as   CD_MATNR_I,
  '83'      as   CD_MAKTX,
  '83'      as   CD_MENGE,
  '83'      as   CD_UNIT_I,
  '83'      as   CD_UNIT_I_T,
  '83'      as   CD_DOCIND,
  '83'      as   CD_DOCNR,
  '83'      as   CD_DOCITM,
  '83'      as   CD_DOCSCHEDLN,
  '83'      as   CD_QTYFCR,
  '83'      as   CD_QTYFCR_UOM,
  '83'      as   CD_WORKLIST_I,
  '83'      as   CD_TANK,
  '83'      as   CD_CONS,
  '83'      as   CD_PARTNR,
  '83'      as   CD_CONPAT,
  '83'      as   CD_INSPE,
  '83'      as   CD_IMPOEXPO,
  '83'      as   CD_FLAG_IMEX,
  '83'      as   CD_OWNER,
  '83'      as   CD_CHARG_O,
  '83'      as   CD_CHARG_D,
  '83'      as   CD_RVP,
  '83'      as   CD_VALUATIONTYPE_O,
  '83'      as   CD_VALUATIONTYPE_D,
  '83'      as   CD_SHITEM,
  '83'      as   CD_ILOCK,
  '83'      as   CD_PRORATEQTY,
  '83'      as   CD_ASSIGNEDQTY,
  '83'      as   CD_ACTDAT,
  '83'      as   CD_ACTTIME,
  '83'      as   CD_ACTUALS,
  '83'      as   CD_ACTUALQTY,
  '83'      as   CD_ACTUALUOM,
  '83'      as   CD_ITBOTOL,
  '83'      as   CD_ITBUTOL,
  '83'      as   CD_ITBOTOLABS,
  '83'      as   CD_ITBUTOLABS,
  '83'      as   CD_ITTOLUNIT,
  '83'      as   CD_UNLIMITED,
  '83'      as   CD_BLOIND,
  '83'      as   CD_DELIND,
  '83'      as   CD_UPDATEXDOK,
  '83'      as   CD_INCOMPLETE_FLAG,
  '83'      as   CD_DOCTYP,
  '83'      as   CD_LDRATE,
  '83'      as   CD_LDQUOM,
  '83'      as   CD_LDTUOM,
  '83'      as   CD_THIRD_NOMNR,
  '83'      as   CD_UPMAT,
  '83'      as   CD_REFITEM,
  '83'      as   CD_STLTY,
  '83'      as   CD_STLKN,
  '83'      as   CD_CHARG_D_CREATE,
  '83'      as   CD_CHARG_O_CREATE,
  '83'      as   CD_CO_CARR,
  '83'      as   CD_CO_SHIP,
  '83'      as   CD_CO_TSYST,
  '83'      as   CD_COMMCTL,
  '83'      as   CD_SOLDTO,
  '83'      as   CD_PRORATE_ROUTINE,
  '83'      as   CD_CHARG_L,
  '83'      as   CD_CHARG_L_CREATE,
  '83'      as   CD_TCNUM,
  '83'      as   CD_TCITM,
  '83'      as   CD_GA_NMSHIPPER,
  '83'      as   CD_GA_CONF_QTY,
  '83'      as   CD_GA_CONF_UOM,
  '83'      as   CD_GA_TECHSCH_QTY,
  '83'      as   CD_GA_TECHSCH_UOM,
  '83'      as   CD_GA_CONF_QTY_CAL,
  '83'      as   CD_GA_TSCH_QTY_CAL,
  '83'      as   CD_GA_ALLOCATED_QTY,
  '83'      as   CD_GA_ALLOCATED_UOM,
  '83'      as   CD_GA_RANK,
  '83'      as   CD_CYCLE_ITEM,
  '83'      as   CD_LESSHNUM,
  '83'      as   CD_LESTPNUM,
  '83'      as   CD_ATL_DELV_NUMBER,
  '83'      as   CD_ATL_DELV_ITM,
  '83'      as   CD_ATL_CRDT_QTY,
  '83'      as   CD_ATL_CRDT_UOM,
  '83'      as   CD_ATL_CRDT_VAL,
  '83'      as   CD_ATL_CRDT_CURR,
  '83'      as   CD_PRE_EXIST_IND,
  '83'      as   CD_PLANIND,
  '83'      as   CD_LOCPT,
  '83'      as   CD_LOCSL,
  '83'      as   CD_QUICKCONF,
  '83'      as   CD_ERDAT_I,
  '83'      as   CD_ERZEIT_I,
  '83'      as   CD_ERNAM_I,
  '83'      as   CD_AEDAT_I,
  '83'      as   CD_AEZEIT_I,
  '83'      as   CD_AENAM_I,
  '83'      as   CD_ACTUALQTY_PAR,
  '83'      as   CD_ACTUALUOM_PAR,
  '83'      as   CD_LOV_IND,
  '83'      as   CD_FERRYIND,
  '83'      as   CD_RAILCARQTY,
  '83'      as   CD_IPW_TXT,
  '83'      as   CD_ITIME,
  '83'      as   CD_IDATE_TO,
  '83'      as   CD_ITIME_TO,
  '83'      as   CD_SIM_SCHED_TYP,
  ' '       as   CE_NOMTYP,
  ' '       as   CE_QUICKCONF,
  ' '       as   CE_EXTAPPSIM,
  ' '       as   CE_NMSHTYPE
}
where
  b.user_id = $parameters.p_userid
  and b.sim_version = $parameters.p_version 
  and b.nmselect != 'X';
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GOIJ05_NOMTK",
"LFA1",
"MAKT",
"OIGVT",
"OIJ07_PEGGING_TY",
"OIJLOC",
"OIJPEG",
"OIJTS",
"OIJ_SCHED",
"TVTRT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/