Cds_Oijsched

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 Cds_Oijsched.
-- 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_oijsched
-- Parameters: p_mandt : mandt, p_start_date : dats, p_end_date : dats, p_tsyst : oij_tsyst, p_locid : oij_locid, p_matnr : oij_smatnr, p_valtype : oij_bwtar_o, p_userid : oij05_userid

CREATE VIEW Cds_Oijsched AS
SELECT
  b.mandt AS mandt,
  b.nomtk AS nomtk,
  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,
  b.nmshipper AS nmshipper,
  b.nmcarrier AS nmcarrier,
  b.cycle AS cycle,
  b.nmwerk AS nmwerk,
  b.nmlgort AS nmlgort,
  b.nmvehicle AS nmvehicle,
  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,
  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,
  b.delind AS delind,
  b.shnum AS shnum,
  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.nomit AS nomit,
  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,
  b.s_matnr_i AS s_matnr_i,
  b.matnr_i AS matnr_i,
  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_I,
  '' AS DELIND_I,
  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,
  '' AS LOCPT,
  '' AS LOCSL,
  '' AS QUICKCONF,
  0 AS ACTUALQTY_PAR,
  '' AS LOV_IND,
  '' AS FERRYIND,
  0 AS RAILCARQTY,
  b.sim_sched_id AS sim_sched_id,
  b.sim_sched_ln AS sim_sched_ln,
  b.updkz AS updkz,
  b.user_id AS user_id,
  b.sched_comm AS sched_comm,
  b.ipw_txt AS ipw_txt
FROM oij_sched AS b
INNER JOIN Cdsv_Nomtk ON /* join condition not captured in parsed metadata */
;