OIJ05_GSCHED

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_GSCHED.
-- 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: OIJ05_V_GSCHED

CREATE VIEW OIJ05_GSCHED AS
SELECT
  b.mandt AS mandt,
  ( case when ( b.nomtk is null or b.nomtk = '' ) then concat( '$', substring(b.sim_sched_id,2,19) ) else b.nomtk end ) AS nomtk,
  ( case when b.nomit = '0000000000' then b.sim_sched_ln else b.nomit end ) AS nomit,
  b.nomcl AS nomcl,
  b.nomtyp AS nomtyp,
  b.bustyp AS bustyp,
  b.nomnr AS nomnr,
  b.nomst AS nomst,
  b.nmshtype AS nmshtype,
  b.nmbalch AS nmbalch,
  b.stages_id AS stages_id,
  b.worklist AS worklist,
  b.sentdat AS sentdat,
  b.senttime AS senttime,
  b.sentnam AS sentnam,
  b.items AS items,
  b.counter1 AS counter1,
  b.counter2 AS counter2,
  b.counter3 AS counter3,
  b.counter4 AS counter4,
  b.counter5 AS counter5,
  b.counter6 AS counter6,
  b.nmblock AS nmblock,
  b.nomtypdesc AS nomtypdesc,
  b.shtyp AS shtyp,
  b.tknum AS tknum,
  b.lov_gl AS lov_gl,
  b.tsyst AS tsyst,
  g.tsnam AS tsnam,
  b.nmshipper AS nmshipper,
  j.name1 AS name1,
  b.nmcarrier AS nmcarrier,
  i.name1 AS CARR_NAME,
  b.cycle AS cycle,
  b.nmwerk AS nmwerk,
  b.nmlgort AS nmlgort,
  b.nmvehicle AS nmvehicle,
  k.veh_text AS veh_text,
  b.nmvessel AS nmvessel,
  b.nmtplst AS nmtplst,
  b.route AS route,
  b.bookts AS bookts,
  b.ev_group AS ev_group,
  b.vktra AS vktra,
  h.bezei AS bezei,
  b.qtyin AS qtyin,
  b.qtyout AS qtyout,
  b.unit AS unit,
  b.tst_from_min AS tst_from_min,
  b.tst_to_max AS tst_to_max,
  b.bloind AS bloind_i,
  b.delind AS delind_i,
  b.shnum AS shnum,
  b.shnum AS shnum_i,
  b.erdat AS erdat,
  b.erzeit AS erzeit,
  b.ernam AS ernam,
  b.aedat AS aedat,
  b.aezeit AS aezeit,
  b.aenam AS aenam,
  b.sityp AS sityp,
  b.istat AS istat,
  b.isubstat AS isubstat,
  b.idate AS idate,
  b.sched_tst_to AS sched_tst_to,
  b.locid AS locid,
  d.locnam AS locnam,
  b.s_matnr_i AS s_matnr_i,
  e.maktx AS S_MAKTX,
  b.matnr_i AS matnr_i,
  f.maktx AS maktx,
  b.menge AS menge,
  b.unit_i AS unit_i,
  b.unit_i_t AS unit_i_t,
  b.docind AS docind,
  b.docnr AS docnr,
  b.docitm AS docitm,
  b.docschedln AS docschedln,
  b.qtyfcr AS qtyfcr,
  b.qtyfcr_uom AS qtyfcr_uom,
  b.worklist_i AS worklist_i,
  b.tank AS tank,
  b.cons AS cons,
  b.partnr AS partnr,
  b.conpat AS conpat,
  b.inspe AS inspe,
  b.impoexpo AS impoexpo,
  b.flag_imex AS flag_imex,
  b.owner AS owner,
  b.charg_o AS charg_o,
  b.charg_d AS charg_d,
  b.rvp AS rvp,
  b.shitem AS shitem,
  b.ilock AS ilock,
  b.prorateqty AS prorateqty,
  b.assignedqty AS assignedqty,
  b.actdat AS actdat,
  b.acttime AS acttime,
  b.actuals AS actuals,
  b.actualqty AS actualqty,
  b.actualuom AS actualuom,
  b.itbotol AS itbotol,
  b.itbutol AS itbutol,
  b.itbotolabs AS itbotolabs,
  b.itbutolabs AS itbutolabs,
  b.ittolunit AS ittolunit,
  b.unlimited AS unlimited,
  '' AS BLOIND,
  '' AS DELIND,
  b.updatexdok AS updatexdok,
  b.doctyp AS doctyp,
  b.ldrate AS ldrate,
  b.ldquom AS ldquom,
  b.ldtuom AS ldtuom,
  b.third_nomnr AS third_nomnr,
  b.upmat AS upmat,
  b.refitem AS refitem,
  b.stlty AS stlty,
  b.stlkn AS stlkn,
  b.co_carr AS co_carr,
  b.co_ship AS co_ship,
  b.co_tsyst AS co_tsyst,
  b.commctl AS commctl,
  b.soldto AS soldto,
  b.charg_l AS charg_l,
  b.tcnum AS tcnum,
  b.tcitm AS tcitm,
  b.ga_nmshipper AS ga_nmshipper,
  b.ga_conf_qty AS ga_conf_qty,
  b.ga_conf_uom AS ga_conf_uom,
  b.ga_rank AS ga_rank,
  b.cycle_item AS cycle_item,
  b.lesshnum AS lesshnum,
  b.lestpnum AS lestpnum,
  b.atl_delv_itm AS atl_delv_itm,
  b.atl_crdt_qty AS atl_crdt_qty,
  b.atl_crdt_uom AS atl_crdt_uom,
  b.atl_crdt_val AS atl_crdt_val,
  '' AS PLANIND,
  b.loc_pt AS locpt,
  b.loc_sl AS locsl,
  '' 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 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 AS sim_sched_id,
  b.sim_sched_ln AS sim_sched_ln,
  ( case when ( b.updkz is null or b.updkz = '' ) then 'I' else b.updkz end ) AS updkz,
  b.user_id AS user_id,
  b.sim_version AS sim_version,
  b.sched_comm AS sched_comm,
  b.ipw_txt AS ipw_txt,
  b.sched_stat AS sched_stat,
  '2' AS nom_sim,
  l.pegid AS pegid,
  l.pegtype AS pegtype,
  '23' AS CD_NOMTK,
  '23' AS CD_NOMIT,
  '23' AS CD_NOMCL,
  '23' AS CD_NOMTYP,
  '23' AS CD_BUSTYP,
  '23' AS CD_NOMNR,
  '23' AS CD_NOMST,
  '23' AS CD_NMSHTYPE,
  '23' AS CD_NMBALCH,
  '23' AS CD_STAGES_ID,
  '23' AS CD_WORKLIST,
  '23' AS CD_SENTDAT,
  '23' AS CD_SENTTIME,
  '23' AS CD_SENTNAM,
  '23' AS CD_ITEMS,
  '23' AS CD_COUNTER1,
  '23' AS CD_COUNTER2,
  '23' AS CD_COUNTER3,
  '23' AS CD_COUNTER4,
  '23' AS CD_COUNTER5,
  '23' AS CD_COUNTER6,
  '23' AS CD_APO_SHIPMENT_ID,
  '23' AS CD_APO_SHIPMENT_NUM,
  '23' AS CD_NMBLOCK,
  '23' AS CD_NOMTYPDESC,
  '23' AS CD_SHTYP,
  '23' AS CD_TKNUM,
  '23' AS CD_LOV_GL,
  '23' AS CD_TSYST,
  '23' AS CD_TSNAM,
  '23' AS CD_NMSHIPPER,
  '23' AS CD_NAME1,
  '23' AS CD_NMCARRIER,
  '23' AS CD_CARR_NAME,
  '23' AS CD_CYCLE,
  '23' AS CD_NMWERK,
  '23' AS CD_NMLGORT,
  '23' AS CD_NMVEHICLE,
  '23' AS CD_VEH_TEXT,
  '23' AS CD_NMVESSEL,
  '23' AS CD_NMTPLST,
  '23' AS CD_ROUTE,
  '23' AS CD_BOOKTS,
  '23' AS CD_EV_GROUP,
  '23' AS CD_VKTRA,
  '23' AS CD_BEZEI,
  '23' AS CD_QTYIN,
  '23' AS CD_QTYOUT,
  '23' AS CD_UNIT,
  '23' AS CD_TST_FROM_MIN,
  '23' AS CD_TST_TO_MAX,
  '23' AS CD_BLOIND_I,
  '23' AS CD_DELIND_I,
  '23' AS CD_SHNUM,
  '23' AS CD_SHNUM_I,
  '23' AS CD_ERDAT,
  '23' AS CD_ERZEIT,
  '23' AS CD_ERNAM,
  '23' AS CD_AEDAT,
  '23' AS CD_AEZEIT,
  '23' AS CD_AENAM,
  '23' AS CD_SITYP,
  '23' AS CD_ISTAT,
  '23' AS CD_ISUBSTAT,
  '23' AS CD_IDATE,
  '23' AS CD_SCHED_TST_FROM,
  '23' AS CD_SCHED_TST_TO,
  '23' AS CD_LOCID,
  '23' AS CD_LOCNAM,
  '23' AS CD_S_MATNR_I,
  '23' AS CD_S_MAKTX,
  '23' AS CD_MATNR_I,
  '23' AS CD_MAKTX,
  '23' AS CD_MENGE,
  '23' AS CD_UNIT_I,
  '23' AS CD_UNIT_I_T,
  '23' AS CD_DOCIND,
  '23' AS CD_DOCNR,
  '23' AS CD_DOCITM,
  '23' AS CD_DOCSCHEDLN,
  '23' AS CD_QTYFCR,
  '23' AS CD_QTYFCR_UOM,
  '23' AS CD_WORKLIST_I,
  '23' AS CD_TANK,
  '23' AS CD_CONS,
  '23' AS CD_PARTNR,
  '23' AS CD_CONPAT,
  '23' AS CD_INSPE,
  '23' AS CD_IMPOEXPO,
  '23' AS CD_FLAG_IMEX,
  '23' AS CD_OWNER,
  '23' AS CD_CHARG_O,
  '23' AS CD_CHARG_D,
  '23' AS CD_RVP,
  '23' AS CD_VALUATIONTYPE_O,
  '23' AS CD_VALUATIONTYPE_D,
  '23' AS CD_SHITEM,
  '23' AS CD_ILOCK,
  '23' AS CD_PRORATEQTY,
  '23' AS CD_ASSIGNEDQTY,
  '23' AS CD_ACTDAT,
  '23' AS CD_ACTTIME,
  '23' AS CD_ACTUALS,
  '23' AS CD_ACTUALQTY,
  '23' AS CD_ACTUALUOM,
  '23' AS CD_ITBOTOL,
  '23' AS CD_ITBUTOL,
  '23' AS CD_ITBOTOLABS,
  '23' AS CD_ITBUTOLABS,
  '23' AS CD_ITTOLUNIT,
  '23' AS CD_UNLIMITED,
  '23' AS CD_BLOIND,
  '23' AS CD_DELIND,
  '23' AS CD_UPDATEXDOK,
  '23' AS CD_INCOMPLETE_FLAG,
  '23' AS CD_DOCTYP,
  '23' AS CD_LDRATE,
  '23' AS CD_LDQUOM,
  '23' AS CD_LDTUOM,
  '23' AS CD_THIRD_NOMNR,
  '23' AS CD_UPMAT,
  '23' AS CD_REFITEM,
  '23' AS CD_STLTY,
  '23' AS CD_STLKN,
  '23' AS CD_CHARG_D_CREATE,
  '23' AS CD_CHARG_O_CREATE,
  '23' AS CD_CO_CARR,
  '23' AS CD_CO_SHIP,
  '23' AS CD_CO_TSYST,
  '23' AS CD_COMMCTL,
  '23' AS CD_SOLDTO,
  '23' AS CD_PRORATE_ROUTINE,
  '23' AS CD_CHARG_L,
  '23' AS CD_CHARG_L_CREATE,
  '23' AS CD_TCNUM,
  '23' AS CD_TCITM,
  '23' AS CD_GA_NMSHIPPER,
  '23' AS CD_GA_CONF_QTY,
  '23' AS CD_GA_CONF_UOM,
  '23' AS CD_GA_TECHSCH_QTY,
  '23' AS CD_GA_TECHSCH_UOM,
  '23' AS CD_GA_CONF_QTY_CAL,
  '23' AS CD_GA_TSCH_QTY_CAL,
  '23' AS CD_GA_ALLOCATED_QTY,
  '23' AS CD_GA_ALLOCATED_UOM,
  '23' AS CD_GA_RANK,
  '23' AS CD_CYCLE_ITEM,
  '23' AS CD_LESSHNUM,
  '23' AS CD_LESTPNUM,
  '23' AS CD_ATL_DELV_NUMBER,
  '23' AS CD_ATL_DELV_ITM,
  '23' AS CD_ATL_CRDT_QTY,
  '23' AS CD_ATL_CRDT_UOM,
  '23' AS CD_ATL_CRDT_VAL,
  '23' AS CD_ATL_CRDT_CURR,
  '23' AS CD_PRE_EXIST_IND,
  '23' AS CD_PLANIND,
  '23' AS CD_LOCPT,
  '23' AS CD_LOCSL,
  '23' AS CD_QUICKCONF,
  '23' AS CD_ERDAT_I,
  '23' AS CD_ERZEIT_I,
  '23' AS CD_ERNAM_I,
  '23' AS CD_AEDAT_I,
  '23' AS CD_AEZEIT_I,
  '23' AS CD_AENAM_I,
  '23' AS CD_ACTUALQTY_PAR,
  '23' AS CD_ACTUALUOM_PAR,
  '23' AS CD_LOV_IND,
  '23' AS CD_FERRYIND,
  '23' AS CD_RAILCARQTY,
  '23' AS CD_IPW_TXT,
  '23' AS CD_ITIME,
  '23' AS CD_IDATE_TO,
  '23' AS CD_ITIME_TO,
  '23' AS CD_SIM_SCHED_TYP,
  'X' AS CE_NOMTYP,
  'X' AS CE_QUICKCONF,
  'X' AS CE_EXTAPPSIM,
  'X' AS CE_NMSHTYPE
INNER JOIN goij05_simschkey AS a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oijloc AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt 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 oijts AS g ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvtrt AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 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 oigvt AS k ON /* join condition not captured in parsed metadata */
INNER JOIN oij07_pegging_ty AS m ON /* join condition not captured in parsed metadata */
;