Oij05_Oijsched_Sim

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view Oij05_Oijsched_Sim.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: V_OIJ05_SCHD_SIM
-- Parameters: p_userid : oij05_userid, p_version : oij_simvers

CREATE VIEW Oij05_Oijsched_Sim AS
SELECT
  b.mandt AS mandt,
  sim_sched_id,
  sim_sched_ln,
  b.sim_version AS sim_version,
  sched_stat,
  sched_acf,
  b.nomtk AS nomtk,
  nomit,
  sched_comm,
  nomcl,
  nomtyp,
  b.bustyp AS bustyp,
  nomnr,
  nomst,
  nmshtype,
  nmbalch,
  stages_id,
  worklist,
  sentdat,
  senttime,
  sentnam,
  items,
  counter1,
  counter2,
  counter3,
  counter4,
  counter5,
  counter6,
  nmblock,
  nomtypdesc,
  b.shtyp AS shtyp,
  tknum,
  lov_gl,
  b.tsyst AS tsyst,
  h.tsnam AS tsnam,
  nmshipper,
  k.name1 AS name1,
  nmcarrier,
  j.name1 AS CARR_NAME,
  cycle,
  nmwerk,
  nmlgort,
  nmvehicle,
  l.veh_text AS veh_text,
  nmvessel,
  nmtplst,
  route,
  b.bookts AS bookts,
  ev_group,
  b.vktra AS vktra,
  i.bezei AS bezei,
  qtyin,
  qtyout,
  unit,
  tst_from_min,
  tst_to_max,
  sityp,
  istat,
  isubstat,
  idate,
  sched_tst_to,
  b.locid AS locid,
  e.locnam AS locnam,
  s_matnr_i,
  f.maktx AS S_MAKTX,
  matnr_i,
  g.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,
  '' AS shnum,
  shnum AS shnum_i,
  shitem,
  ilock,
  prorateqty,
  assignedqty,
  actdat,
  acttime,
  actuals,
  actualqty,
  actualuom,
  itbotol,
  itbutol,
  itbotolabs,
  itbutolabs,
  ittolunit,
  b.unlimited AS unlimited,
  b.bloind AS bloind,
  b.delind AS delind,
  updatexdok,
  doctyp,
  ldrate,
  ldquom,
  ldtuom,
  third_nomnr,
  upmat,
  refitem,
  stlty,
  stlkn,
  co_carr,
  co_ship,
  co_tsyst,
  commctl,
  soldto,
  charg_l,
  tcnum,
  tcitm,
  ga_nmshipper,
  ga_conf_qty,
  ga_conf_uom,
  ga_rank,
  cycle_item,
  lesshnum,
  lestpnum,
  atl_delv_itm,
  atl_crdt_qty,
  atl_crdt_uom,
  atl_crdt_val,
  b.erdat AS erdat,
  b.erzeit AS erzeit,
  b.ernam AS ernam,
  b.aedat AS aedat,
  b.aezeit AS aezeit,
  b.aenam AS aenam,
  flttnomtk,
  updkz,
  user_id,
  scenario_id,
  ipw_txt,
  locpt,
  locsl,
  quickconf,
  '' AS bloind_i,
  '' AS delind_i,
  itime,
  idate_to,
  itime_to,
  c.pegid AS pegid,
  c.pegtype AS pegtype
FROM oij05_sched_sim AS b
INNER JOIN goij05_nomtk AS a ON /* join condition not captured in parsed metadata */
INNER JOIN oij07_pegging_ty AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oijloc AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt AS g ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oijts AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvtrt AS i ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS j ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS k ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oigvt AS l ON /* join condition not captured in parsed metadata */
;