Oij05_Cds_Nom_Gsim

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_Cds_Nom_Gsim.
-- 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_NOMGSIM

CREATE VIEW Oij05_Cds_Nom_Gsim AS
SELECT
  a.nomtk AS NOMTK,
  a.nomit AS NOMIT,
  (case when c.nomcl is null or c.nomcl = '' then a.nomcl else b.nomcl end) AS NOMCL,
  (case when c.nomtyp is null or c.nomtyp = '' then a.nomtyp else b.nomtyp end) AS NOMTYP,
  (case when c.bustyp is null or c.bustyp = '' then a.bustyp else b.bustyp end) AS BUSTYP,
  (case when c.nomnr is null or c.nomnr = '' then a.nomnr else b.nomnr end) AS NOMNR,
  (case when c.nomst is null or c.nomst = '' then a.nomst else b.nomst end) AS NOMST,
  (case when c.nmshtype is null or c.nmshtype = '' then a.nmshtype else b.nmshtype end) AS NMSHTYPE,
  (case when c.nmbalch is null or c.nmbalch = '' then a.nmbalch else b.nmbalch end) AS NMBALCH,
  (case when c.stages_id is null or c.stages_id = '' then a.stages_id else b.stages_id end) AS STAGES_ID,
  (case when c.worklist is null or c.worklist = '' then a.worklist else b.worklist end) AS WORKLIST,
  (case when c.sentdat is null or c.sentdat = '' then a.sentdat else b.sentdat end) AS SENTDAT,
  (case when c.senttime is null or c.senttime = '' then a.senttime else b.senttime end) AS SENTTIME,
  (case when c.sentnam is null or c.sentnam = '' then a.sentnam else b.sentnam end) AS SENTNAM,
  (case when c.items is null or c.items = '' then a.items else b.items end) AS ITEMS,
  (case when c.counter1 is null or c.counter1 = '' then a.counter1 else b.counter1 end) AS COUNTER1,
  (case when c.counter2 is null or c.counter2 = '' then a.counter2 else b.counter2 end) AS COUNTER2,
  (case when c.counter3 is null or c.counter3 = '' then a.counter3 else b.counter3 end) AS COUNTER3,
  (case when c.counter4 is null or c.counter4 = '' then a.counter4 else b.counter4 end) AS COUNTER4,
  (case when c.counter5 is null or c.counter5 = '' then a.counter5 else b.counter5 end) AS COUNTER5,
  (case when c.counter6 is null or c.counter6 = '' then a.counter6 else b.counter6 end) AS COUNTER6,
  (case when c.apo_shipment_id is null or c.apo_shipment_id = '' then a.apo_shipment_id else b.apo_shipment_id end) AS APO_SHIPMENT_ID,
  (case when c.apo_shipment_num is null or c.apo_shipment_num = '' then a.apo_shipment_num else b.apo_shipment_num end) AS APO_SHIPMENT_NUM,
  (case when c.nmblock is null or c.nmblock = '' then a.nmblock else b.nmblock end) AS NMBLOCK,
  (case when c.nomtypdesc is null or c.nomtypdesc = '' then a.nomtypdesc else b.nomtypdesc end) AS NOMTYPDESC,
  (case when c.shtyp is null or c.shtyp = '' then a.shtyp else b.shtyp end) AS SHTYP,
  (case when c.tknum is null or c.tknum = '' then a.tknum else b.tknum end) AS TKNUM,
  (case when c.lov_gl is null or c.lov_gl = '' then a.lov_gl else b.lov_gl end) AS LOV_GL,
  (case when c.tsyst is null or c.tsyst = '' then a.tsyst else b.tsyst end) AS TSYST,
  (case when c.tsnam is null or c.tsnam = '' then a.tsnam else b.tsnam end) AS TSNAM,
  (case when c.nmshipper is null or c.nmshipper = '' then a.nmshipper else b.nmshipper end) AS NMSHIPPER,
  (case when c.name1 is null or c.name1 = '' then a.name1 else b.name1 end) AS NAME1,
  (case when c.nmcarrier is null or c.nmcarrier = '' then a.nmcarrier else b.nmcarrier end) AS NMCARRIER,
  (case when c.CARR_NAME is null or c.CARR_NAME = '' then a.CARR_NAME else b.CARR_NAME end) AS CARR_NAME,
  (case when c.cycle is null or c.cycle = '' then a.cycle else b.cycle end) AS CYCLE,
  (case when c.nmwerk is null or c.nmwerk = '' then a.nmwerk else b.nmwerk end) AS NMWERK,
  (case when c.nmlgort is null or c.nmlgort = '' then a.nmlgort else b.nmlgort end) AS NMLGORT,
  (case when c.nmvehicle is null or c.nmvehicle = '' then a.nmvehicle else b.nmvehicle end ) AS NMVEHICLE,
  (case when c.veh_text is null or c.veh_text = '' then a.veh_text else b.veh_text end) AS VEH_TEXT,
  (case when c.nmvessel is null or c.nmvessel = '' then a.nmvessel else b.nmvessel end) AS NMVESSEL,
  (case when c.nmtplst is null or c.nmtplst = '' then a.nmtplst else b.nmtplst end) AS NMTPLST,
  (case when c.route is null or c.route = '' then a.route else b.route end) AS ROUTE,
  (case when c.bookts is null or c.bookts = '' then a.bookts else b.bookts end) AS BOOKTS,
  (case when c.ev_group is null or c.ev_group ='' then a.ev_group else b.ev_group end) AS EV_GROUP,
  (case when c.vktra is null or c.vktra = '' then a.vktra else b.vktra end) AS VKTRA,
  (case when c.bezei is null or c.bezei = '' then a.bezei else b.bezei end) AS BEZEI,
  (case when c.qtyin is null or c.qtyin = '' then a.qtyin else b.qtyin end) AS QTYIN,
  (case when c.qtyout is null or c.qtyout = '' then a.qtyout else b.qtyout end) AS QTYOUT,
  (case when c.unit is null or c.unit = '' then a.unit else b.unit end) AS UNIT,
  (case when c.tst_from_min is null or c.tst_from_min = '' then a.tst_from_min else b.tst_from_min end) AS TST_FROM_MIN,
  (case when c.tst_to_max is null or c.tst_to_max = '' then a.tst_to_max else b.tst_to_max end) AS TST_TO_MAX,
  (case when c.bloind is null or c.bloind = '' then a.bloind else b.bloind end) AS BLOIND_I,
  (case when c.delind is null or c.delind = '' then a.delind else b.delind end) AS DELIND_I,
  a.shnum AS SHNUM,
  (case when c.shnum_i is null or c.shnum_i = '' then a.shnum_i else b.shnum end) AS SHNUM_I,
  (case when c.erdat is null or c.erdat = '00000000' then a.erdat else b.erdat end) AS ERDAT,
  (case when c.erzeit is null or c.erzeit = '000000' then a.erzeit else b.erzeit end) AS ERZEIT,
  (case when c.ernam is null or c.ernam = '' then a.ernam else b.ernam end) AS ERNAM,
  (case when c.aedat is null or c.aedat = '00000000' then a.aedat else b.aedat end) AS AEDAT,
  (case when c.aezeit is null or c.aezeit = '000000' then a.aezeit else b.aezeit end) AS AEZEIT,
  (case when c.aenam is null or c.aenam = '' then a.aenam else b.aenam end) AS AENAM,
  (case when c.sityp is null or c.sityp = '' then a.sityp else b.sityp end) AS SITYP,
  (case when c.istat is null or c.istat = '' then a.istat else b.istat end) AS ISTAT,
  (case when c.isubstat is null or c.isubstat = '' then a.isubstat else b.isubstat end) AS ISUBSTAT,
  (case when c.idate is null or c.idate = '' then a.idate else b.idate end) AS IDATE,
  (case when c.sched_tst_from is null or c.sched_tst_from = '' then a.sched_tst_from else b.sched_tst_from end) AS SCHED_TST_FROM,
  (case when c.sched_tst_to is null or c.sched_tst_to = '' then a.sched_tst_to else b.sched_tst_to end) AS SCHED_TST_TO,
  (case when c.locid is null or c.locid = '' then a.locid else b.locid end) AS LOCID,
  (case when c.locnam is null or c.locnam = '' then a.locnam else b.locnam end) AS LOCNAM,
  (case when c.s_matnr_i is null or c.s_matnr_i = '' then a.s_matnr_i else b.s_matnr_i end) AS S_MATNR_I,
  (case when c.S_MAKTX is null or c.S_MAKTX = '' then a.S_MAKTX else b.S_MAKTX end) AS S_MAKTX,
  (case when c.matnr_i is null or c.matnr_i = '' then a.matnr_i else b.matnr_i end) AS MATNR_I,
  (case when c.maktx is null or c.maktx = '' then a.maktx else b.maktx end) AS MAKTX,
  (case when c.menge is null or c.menge = '' then a.menge else b.menge end) AS MENGE,
  (case when c.unit_i is null or c.unit_i = '' then a.unit_i else b.unit_i end) AS UNIT_I,
  (case when c.unit_i_t is null or c.unit_i_t = '' then a.unit_i_t else b.unit_i_t end) AS UNIT_I_T,
  (case when c.docind is null or c.docind = '' then a.docind else b.docind end) AS DOCIND,
  (case when c.docnr is null or c.docnr = '' then a.docnr else b.docnr end) AS DOCNR,
  (case when c.docitm is null or c.docitm = '' then a.docitm else b.docitm end) AS DOCITM,
  (case when c.docschedln is null or c.docschedln = '' then a.docschedln else b.docschedln end) AS DOCSCHEDLN,
  (case when c.qtyfcr is null or c.qtyfcr = '' then a.qtyfcr else b.qtyfcr end) AS QTYFCR,
  (case when c.qtyfcr_uom is null or c.qtyfcr_uom = '' then a.qtyfcr_uom else b.qtyfcr_uom end) AS QTYFCR_UOM,
  (case when c.worklist_i is null or c.worklist_i= '' then a.worklist_i else b.worklist_i end) AS WORKLIST_I,
  (case when c.tank is null or c.tank = '' then a.tank else b.tank end) AS TANK,
  (case when c.cons is null or c.cons = '' then a.cons else b.cons end) AS CONS,
  (case when c.partnr is null or c.partnr = '' then a.partnr else b.partnr end) AS PARTNR,
  (case when c.conpat is null or c.conpat = '' then a.conpat else b.conpat end) AS CONPAT,
  (case when c.inspe is null or c.inspe = '' then a.inspe else b.inspe end) AS INSPE,
  (case when c.impoexpo is null or c.impoexpo = '' then a.impoexpo else b.impoexpo end) AS IMPOEXPO,
  (case when c.flag_imex is null or c.flag_imex = '' then a.flag_imex else b.flag_imex end) AS FLAG_IMEX,
  (case when c.owner is null or c.owner = '' then a.owner else b.owner end) AS OWNER,
  (case when c.charg_o is null or c.charg_o = '' then a.charg_o else b.charg_o end) AS CHARG_O,
  (case when c.charg_d is null or c.charg_d = '' then a.charg_d else b.charg_d end) AS CHARG_D,
  (case when c.rvp is null or c.rvp = '' then a.rvp else b.rvp end) AS RVP,
  (case when c.valuationtype_o is null or c.valuationtype_o = '' then a.valuationtype_o else b.valuationtype_o end) AS VALUATIONTYPE_O,
  (case when c.valuationtype_d is null or c.valuationtype_d = '' then a.valuationtype_d else b.valuationtype_d end) AS VALUATIONTYPE_D,
  (case when c.shitem is null or c.shitem = '' then a.shitem else b.shitem end) AS SHITEM,
  (case when c.ilock is null or c.ilock = '' then a.ilock else b.ilock end) AS ILOCK,
  (case when c.prorateqty is null or c.prorateqty = '' then a.prorateqty else b.prorateqty end) AS PRORATEQTY,
  (case when c.assignedqty is null or c.assignedqty = '' then a.assignedqty else b.assignedqty end) AS ASSIGNEDQTY,
  (case when c.actdat is null or c.actdat = '' then a.actdat else b.actdat end) AS ACTDAT,
  (case when c.acttime is null or c.acttime = '' then a.acttime else b.acttime end) AS ACTTIME,
  (case when c.actuals is null or c.actuals = '' then a.actuals else b.actuals end) AS ACTUALS,
  (case when c.actualqty is null or c.actualqty = '' then a.actualqty else b.actualqty end) AS ACTUALQTY,
  (case when c.actualuom is null or c.actualuom = '' then a.actualuom else b.actualuom end) AS ACTUALUOM,
  (case when c.itbotol is null or c.itbotol = '' then a.itbotol else b.itbotol end) AS ITBOTOL,
  (case when c.itbutol is null or c.itbutol = '' then a.itbutol else b.itbutol end) AS ITBUTOL,
  (case when c.itbotolabs is null or c.itbotolabs = '' then a.itbotolabs else b.itbotolabs end) AS ITBOTOLABS,
  (case when c.itbutolabs is null or c.itbutolabs = '' then a.itbutolabs else b.itbutolabs end) AS ITBUTOLABS,
  (case when c.ittolunit is null or c.ittolunit = '' then a.ittolunit else b.ittolunit end) AS ITTOLUNIT,
  (case when c.unlimited is null or c.unlimited = '' then a.unlimited else b.unlimited end) AS UNLIMITED,
  a.bloind AS bloind,
  a.delind AS delind,
  (case when c.updatexdok is null or c.updatexdok = '' then a.updatexdok else b.updatexdok end) AS UPDATEXDOK,
  (case when c.incomplete_flag is null or c.incomplete_flag = '' then a.incomplete_flag else b.incomplete_flag end) AS INCOMPLETE_FLAG,
  (case when c.doctyp is null or c.doctyp = '' then a.doctyp else b.doctyp end) AS DOCTYP,
  (case when c.ldrate is null or c.ldrate = '' then a.ldrate else b.ldrate end) AS LDRATE,
  (case when c.ldquom is null or c.ldquom = '' then a.ldquom else b.ldquom end) AS LDQUOM,
  (case when c.ldtuom is null or c.ldtuom = '' then a.ldtuom else b.ldtuom end) AS LDTUOM,
  (case when c.third_nomnr is null or c.third_nomnr = '' then a.third_nomnr else b.third_nomnr end) AS THIRD_NOMNR,
  (case when c.upmat is null or c.upmat = '' then a.upmat else b.upmat end) AS UPMAT,
  (case when c.refitem is null or c.refitem = '' then a.refitem else b.refitem end) AS REFITEM,
  (case when c.stlty is null or c.stlty = '' then a.stlty else b.stlty end) AS STLTY,
  (case when c.stlkn is null or c.stlkn = '' then a.stlkn else b.stlkn end) AS STLKN,
  (case when c.charg_d_create is null or c.charg_d_create = '' then a.charg_d_create else b.charg_d_create end) AS CHARG_D_CREATE,
  (case when c.charg_o_create is null or c.charg_o_create = '' then a.charg_o_create else b.charg_o_create end) AS CHARG_O_CREATE,
  (case when c.co_carr is null or c.co_carr = '' then a.co_carr else b.co_carr end) AS CO_CARR,
  (case when c.co_ship is null or c.co_ship = '' then a.co_ship else b.co_ship end) AS CO_SHIP,
  (case when c.co_tsyst is null or c.co_tsyst = '' then a.co_tsyst else b.co_tsyst end) AS CO_TSYST,
  (case when c.commctl is null or c.commctl = '' then a.commctl else b.commctl end) AS COMMCTL,
  (case when c.soldto is null or c.soldto = '' then a.soldto else b.soldto end) AS SOLDTO,
  (case when c.prorate_routine is null or c.prorate_routine = '' then a.prorate_routine else b.prorate_routine end) AS PRORATE_ROUTINE,
  (case when c.charg_l is null or c.charg_l = '' then a.charg_l else b.charg_l end) AS CHARG_L,
  (case when c.charg_l_create is null or c.charg_l_create = '' then a.charg_l_create else b.charg_l_create end) AS CHARG_L_CREATE,
  (case when c.tcnum is null or c.tcnum = '' then a.tcnum else b.tcnum end) AS TCNUM,
  (case when c.tcitm is null or c.tcitm = '' then a.tcitm else b.tcitm end) AS TCITM,
  (case when c.ga_nmshipper is null or c.ga_nmshipper = '' then a.ga_nmshipper else b.ga_nmshipper end) AS GA_NMSHIPPER,
  (case when c.ga_conf_qty is null or c.ga_conf_qty = '' then a.ga_conf_qty else b.ga_conf_qty end) AS GA_CONF_QTY,
  (case when c.ga_conf_uom is null or c.ga_conf_uom = '' then a.ga_conf_uom else b.ga_conf_uom end) AS GA_CONF_UOM,
  (case when c.ga_techsch_qty is null or c.ga_techsch_qty = '' then a.ga_techsch_qty else b.ga_techsch_qty end) AS GA_TECHSCH_QTY,
  (case when c.ga_techsch_uom is null or c.ga_techsch_uom = '' then a.ga_techsch_uom else b.ga_techsch_uom end) AS GA_TECHSCH_UOM,
  (case when c.ga_conf_qty_cal is null or c.ga_conf_qty_cal = '' then a.ga_conf_qty_cal else b.ga_conf_qty_cal end) AS GA_CONF_QTY_CAL,
  (case when c.ga_tsch_qty_cal is null or c.ga_tsch_qty_cal = '' then a.ga_tsch_qty_cal else b.ga_tsch_qty_cal end) AS GA_TSCH_QTY_CAL,
  (case when c.ga_allocated_qty is null or c.ga_allocated_qty = '' then a.ga_allocated_qty else b.ga_allocated_qty end) AS GA_ALLOCATED_QTY,
  (case when c.ga_allocated_uom is null or c.ga_allocated_uom = '' then a.ga_allocated_uom else b.ga_allocated_uom end) AS GA_ALLOCATED_UOM,
  (case when c.ga_rank is null or c.ga_rank = '' then a.ga_rank else b.ga_rank end) AS GA_RANK,
  (case when c.cycle_item is null or c.cycle_item = '' then a.cycle_item else b.cycle_item end) AS CYCLE_ITEM,
  (case when c.lesshnum is null or c.lesshnum = '' then a.lesshnum else b.lesshnum end) AS LESSHNUM,
  (case when c.lestpnum is null or c.lestpnum = '' then a.lestpnum else b.lestpnum end) AS LESTPNUM,
  (case when c.atl_delv_number is null or c.atl_delv_number = '' then a.atl_delv_number else b.atl_delv_number end) AS ATL_DELV_NUMBER,
  (case when c.atl_delv_itm is null or c.atl_delv_itm = '' then a.atl_delv_itm else b.atl_delv_itm end) AS ATL_DELV_ITM,
  (case when c.atl_crdt_qty is null or c.atl_crdt_qty ='' then a.atl_crdt_qty else b.atl_crdt_qty end) AS ATL_CRDT_QTY,
  (case when c.atl_crdt_uom is null or c.atl_crdt_uom = '' then a.atl_crdt_uom else b.atl_crdt_uom end) AS ATL_CRDT_UOM,
  (case when c.atl_crdt_val is null or c.atl_crdt_val = '' then a.atl_crdt_val else b.atl_crdt_val end) AS ATL_CRDT_VAL,
  (case when c.atl_crdt_curr is null or c.atl_crdt_curr = '' then a.atl_crdt_curr else b.atl_crdt_curr end) AS ATL_CRDT_CURR,
  (case when c.pre_exist_ind is null or c.pre_exist_ind = '' then a.pre_exist_ind else b.pre_exist_ind end) AS PRE_EXIST_IND,
  a.planind AS planind,
  (case when c.locpt is null or c.locpt = '' then a.locpt else b.locpt end) AS locpt,
  (case when c.locsl is null or c.locsl = '' then a.locsl else b.locsl end) AS locsl,
  (case when c.quickconf is null or c.quickconf = '' then a.quickconf else b.quickconf end) AS quickconf,
  (case when b.erdat is null then a.erdat_i else b.erdat end) AS ERDAT_I,
  (case when b.erzeit is null then a.erzeit_i else b.erzeit end) AS ERZEIT_I,
  (case when b.ernam is null then a.ernam_i else b.ernam end) AS ERNAM_I,
  (case when b.aedat is null then a.aedat_i else b.aedat end) AS AEDAT_I,
  (case when b.aezeit is null then a.aezeit_i else b.aezeit end) AS AEZEIT_I,
  (case when b.aenam is null then a.aenam_i else b.aenam end) AS AENAM_I,
  a.lov_ind AS lov_ind,
  a.ferryind AS ferryind,
  a.railcarqty AS railcarqty,
  (case when c.itime is null or c.itime = '' then tstmp_to_tims(a.sched_tst_from, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') else tstmp_to_tims(b.sched_tst_from, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') end) as itime AS clientNULLendasitime,
  (case when c.idate_to is null or c.idate_to = '' then tstmp_to_dats(a.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') else tstmp_to_dats(b.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') end) as idate_to AS clientNULLendasidate_to,
  (case when c.itime_to is null or c.itime_to = '' then tstmp_to_tims(a.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') else tstmp_to_tims(b.sched_tst_to, abap_system_timezone( $session.client, 'NULL'),$session.client,'NULL') end) as itime_to AS clientNULLendasitime_to,
  ( case when b.sim_sched_id is null then '' else b.sim_sched_id end) AS sim_sched_id,
  ( case when b.sim_sched_ln is null then '0000000000' else b.sim_sched_ln end) AS sim_sched_ln,
  ( case when b.updkz is null then ' ' else b.updkz end) AS updkz,
  ( case when b.user_id is null then ' ' else b.user_id end) AS user_id,
  ( case when b.sim_version is null then '000' else b.sim_version end) AS sim_version,
  ( case when c.sched_comm is null or c.sched_comm = '' then ' ' else b.sched_comm end) AS sched_comm,
  ( case when c.ipw_txt is null or c.ipw_txt = '' then ' ' else b.ipw_txt end) AS ipw_txt,
  ( case when b.sched_stat is null then '' else b.sched_stat end) AS sched_stat,
  ( case when b.nomtk is null then '' else '1' end) AS nom_sim,
  (case when c.pegid is null or c.pegid = '' then a.pegid else b.pegid end) AS pegid,
  (case when c.pegtype is null or c.pegtype = '' then a.pegtype else b.pegtype end) AS pegtype,
  (case when b.nomtk is null or b.nomtk = '' or b.nomtk = a.nomtk then '00' else '23' end) AS CD_NOMTK,
  (case when b.nomit is null or b.nomit = '' or b.nomit = a.nomit then '00' else '23' end) AS CD_NOMIT,
  (case when c.nomcl = 'X' then '23' else '00' end) AS CD_NOMCL,
  (case when c.nomtyp = 'X' then '23' else '00' end) AS CD_NOMTYP,
  (case when c.bustyp = 'X' then '23' else '00' end) AS CD_BUSTYP,
  (case when c.nomnr = 'X' then '23' else '00' end) AS CD_NOMNR,
  (case when c.nomst = 'X' then '23' else '00' end) AS CD_NOMST,
  (case when c.nmshtype = 'X' then '23' else '00' end) AS CD_NMSHTYPE,
  (case when c.nmbalch = 'X' then '23' else '00' end) AS CD_NMBALCH,
  (case when c.stages_id = 'X' then '23' else '00' end) AS CD_STAGES_ID,
  (case when c.worklist = 'X' then '23' else '00' end) AS CD_WORKLIST,
  (case when c.sentdat = 'X' then '23' else '00' end) AS CD_SENTDAT,
  (case when c.senttime = 'X' then '23' else '00' end) AS CD_SENTTIME,
  (case when c.sentnam = 'X' then '23' else '00' end) AS CD_SENTNAM,
  (case when c.items = 'X' then '23' else '00' end) AS CD_ITEMS,
  (case when c.counter1 = 'X' then '23' else '00' end) AS CD_COUNTER1,
  (case when c.counter2 = 'X' then '23' else '00' end) AS CD_COUNTER2,
  (case when c.counter3 = 'X' then '23' else '00' end) AS CD_COUNTER3,
  (case when c.counter4 = 'X' then '23' else '00' end) AS CD_COUNTER4,
  (case when c.counter5 = 'X' then '23' else '00' end) AS CD_COUNTER5,
  (case when c.counter6 = 'X' then '23' else '00' end) AS CD_COUNTER6,
  (case when c.apo_shipment_id = 'X' then '23' else '00' end) AS CD_APO_SHIPMENT_ID,
  (case when c.apo_shipment_num = 'X' then '23' else '00' end) AS CD_APO_SHIPMENT_NUM,
  (case when c.nmblock = 'X' then '23' else '00' end) AS CD_NMBLOCK,
  (case when c.nomtypdesc = 'X' then '23' else '00' end) AS CD_NOMTYPDESC,
  (case when c.shtyp = 'X' then '23' else '00' end) AS CD_SHTYP,
  (case when c.tknum = 'X' then '23' else '00' end) AS CD_TKNUM,
  (case when c.lov_gl = 'X' then '23' else '00' end) AS CD_LOV_GL,
  (case when c.tsyst = 'X' then '23' else '00' end) AS CD_TSYST,
  (case when c.tsnam = 'X' then '23' else '00' end) AS CD_TSNAM,
  (case when c.nmshipper = 'X' then '23' else '00' end) AS CD_NMSHIPPER,
  (case when c.name1 = 'X' then '23' else '00' end) AS CD_NAME1,
  (case when c.nmcarrier = 'X' then '23' else '00' end) AS CD_NMCARRIER,
  (case when c.CARR_NAME = 'X' then '23' else '00' end) AS CD_CARR_NAME,
  (case when c.cycle = 'X' then '23' else '00' end) AS CD_CYCLE,
  (case when c.nmwerk = 'X' then '23' else '00' end) AS CD_NMWERK,
  (case when c.nmlgort = 'X' then '23' else '00' end) AS CD_NMLGORT,
  (case when c.nmvehicle = 'X' then '23' else '00' end ) AS CD_NMVEHICLE,
  (case when c.veh_text = 'X' then '23' else '00' end) AS CD_VEH_TEXT,
  (case when c.nmvessel = 'X' then '23' else '00' end) AS CD_NMVESSEL,
  (case when c.nmtplst = 'X' then '23' else '00' end) AS CD_NMTPLST,
  (case when c.route = 'X' then '23' else '00' end) AS CD_ROUTE,
  (case when c.bookts = 'X' then '23' else '00' end) AS CD_BOOKTS,
  (case when c.ev_group = 'X' then '23' else '00' end) AS CD_EV_GROUP,
  (case when c.vktra = 'X' then '23' else '00' end) AS CD_VKTRA,
  (case when c.bezei = 'X' then '23' else '00' end) AS CD_BEZEI,
  (case when c.qtyin = 'X' then '23' else '00' end) AS CD_QTYIN,
  (case when c.qtyout = 'X' then '23' else '00' end) AS CD_QTYOUT,
  (case when c.unit = 'X' then '23' else '00' end) AS CD_UNIT,
  (case when c.tst_from_min = 'X' then '23' else '00' end) AS CD_TST_FROM_MIN,
  (case when c.tst_to_max = 'X' then '23' else '00' end) AS CD_TST_TO_MAX,
  (case when c.bloind = 'X' then '23' else '00' end) AS CD_BLOIND_I,
  (case when c.delind = 'X' then '23' else '00' end) AS CD_DELIND_I,
  (case when c.shnum = 'X' then '23' else '00' end) AS CD_SHNUM,
  (case when c.shnum_i = 'X' then '23' else '00' end) AS CD_SHNUM_I,
  (case when b.erdat is null or b.erdat = '00000000' or b.erdat = a.erdat then '00' else '23' end) AS CD_ERDAT,
  (case when b.erzeit is null or b.erzeit = '000000' or b.erzeit = a.erzeit then '00' else '23' end) AS CD_ERZEIT,
  (case when b.ernam is null or b.ernam = '' or b.ernam = a.ernam then '00' else '23' end) AS CD_ERNAM,
  (case when b.aedat is null or b.aedat = '00000000' or b.aedat = a.aedat then '00' else '23' end) AS CD_AEDAT,
  (case when b.aezeit is null or b.aezeit = '000000' or b.aezeit = a.aezeit then '00' else '23' end) AS CD_AEZEIT,
  (case when b.aenam is null or b.aenam = '' or b.aenam = a.aenam then '00' else '23' end) AS CD_AENAM,
  (case when c.sityp = 'X' then '23' else '00' end) AS CD_SITYP,
  (case when c.istat = 'X' then '23' else '00' end) AS CD_ISTAT,
  (case when c.isubstat = 'X' then '23' else '00' end) AS CD_ISUBSTAT,
  (case when c.idate = 'X' then '23' else '00' end) AS CD_IDATE,
  '00' AS CD_SCHED_TST_FROM,
  '00' AS CD_SCHED_TST_TO,
  (case when c.locid = 'X' then '23' else '00' end) AS CD_LOCID,
  (case when c.locnam = 'X' then '23' else '00' end) AS CD_LOCNAM,
  (case when c.s_matnr_i = 'X' then '23' else '00' end) AS CD_S_MATNR_I,
  (case when c.S_MAKTX = 'X' then '23' else '00' end) AS CD_S_MAKTX,
  (case when c.matnr_i = 'X' then '23' else '00' end) AS CD_MATNR_I,
  (case when c.maktx = 'X' then '23' else '00' end) AS CD_MAKTX,
  (case when c.menge = 'X' then '23' else '00' end) AS CD_MENGE,
  (case when c.unit_i = 'X' then '23' else '00' end) AS CD_UNIT_I,
  (case when c.unit_i_t = 'X' then '23' else '00' end) AS CD_UNIT_I_T,
  (case when c.docind = 'X' then '23' else '00' end) AS CD_DOCIND,
  (case when c.docnr = 'X' then '23' else '00' end) AS CD_DOCNR,
  (case when c.docitm = 'X' then '23' else '00' end) AS CD_DOCITM,
  (case when c.docschedln = 'X' then '23' else '00' end) AS CD_DOCSCHEDLN,
  (case when c.qtyfcr = 'X' then '23' else '00' end) AS CD_QTYFCR,
  (case when c.qtyfcr_uom = 'X' then '23' else '00' end) AS CD_QTYFCR_UOM,
  (case when c.worklist_i = 'X' then '23' else '00' end) AS CD_WORKLIST_I,
  (case when c.tank = 'X' then '23' else '00' end) AS CD_TANK,
  (case when c.cons = 'X' then '23' else '00' end) AS CD_CONS,
  (case when c.partnr = 'X' then '23' else '00' end) AS CD_PARTNR,
  (case when c.conpat = 'X' then '23' else '00' end) AS CD_CONPAT,
  (case when c.inspe = 'X' then '23' else '00' end) AS CD_INSPE,
  (case when c.impoexpo = 'X' then '23' else '00' end) AS CD_IMPOEXPO,
  (case when c.flag_imex = 'X' then '23' else '00' end) AS CD_FLAG_IMEX,
  (case when c.owner = 'X' then '23' else '00' end) AS CD_OWNER,
  (case when c.charg_o = 'X' then '23' else '00' end) AS CD_CHARG_O,
  (case when c.charg_d = 'X' then '23' else '00' end) AS CD_CHARG_D,
  (case when c.rvp = 'X' then '23' else '00' end) AS CD_RVP,
  (case when c.valuationtype_o = 'X' then '23' else '00' end) AS CD_VALUATIONTYPE_O,
  (case when c.valuationtype_d = 'X' then '23' else '00' end) AS CD_VALUATIONTYPE_D,
  (case when c.shitem = 'X' then '23' else '00' end) AS CD_SHITEM,
  (case when c.ilock = 'X' then '23' else '00' end) AS CD_ILOCK,
  (case when c.prorateqty = 'X' then '23' else '00' end) AS CD_PRORATEQTY,
  (case when c.assignedqty = 'X' then '23' else '00' end) AS CD_ASSIGNEDQTY,
  (case when c.actdat = 'X' then '23' else '00' end) AS CD_ACTDAT,
  (case when c.acttime = 'X' then '23' else '00' end) AS CD_ACTTIME,
  (case when c.actuals = 'X' then '23' else '00' end) AS CD_ACTUALS,
  (case when c.actualqty = 'X' then '23' else '00' end) AS CD_ACTUALQTY,
  (case when c.actualuom = 'X' then '23' else '00' end) AS CD_ACTUALUOM,
  (case when c.itbotol = 'X' then '23' else '00' end) AS CD_ITBOTOL,
  (case when c.itbutol = 'X' then '23' else '00' end) AS CD_ITBUTOL,
  (case when c.itbotolabs = 'X' then '23' else '00' end) AS CD_ITBOTOLABS,
  (case when c.itbutolabs = 'X' then '23' else '00' end) AS CD_ITBUTOLABS,
  (case when c.ittolunit = 'X' then '23' else '00' end) AS CD_ITTOLUNIT,
  (case when c.unlimited = 'X' then '23' else '00' end) AS CD_UNLIMITED,
  '00' AS CD_BLOIND,
  '00' AS CD_DELIND,
  (case when c.updatexdok = 'X' then '23' else '00' end) AS CD_UPDATEXDOK,
  (case when c.incomplete_flag = 'X' then '23' else '00' end) AS CD_INCOMPLETE_FLAG,
  (case when c.doctyp = 'X' then '23' else '00' end) AS CD_DOCTYP,
  (case when c.ldrate = 'X' then '23' else '00' end) AS CD_LDRATE,
  (case when c.ldquom = 'X' then '23' else '00' end) AS CD_LDQUOM,
  (case when c.ldtuom = 'X' then '23' else '00' end) AS CD_LDTUOM,
  (case when c.third_nomnr = 'X' then '23' else '00' end) AS CD_THIRD_NOMNR,
  (case when c.upmat = 'X' then '23' else '00' end) AS CD_UPMAT,
  (case when c.refitem = 'X' then '23' else '00' end) AS CD_REFITEM,
  (case when c.stlty = 'X' then '23' else '00' end) AS CD_STLTY,
  (case when c.stlkn = 'X' then '23' else '00' end) AS CD_STLKN,
  (case when c.charg_d_create = 'X' then '23' else '00' end) AS CD_CHARG_D_CREATE,
  (case when c.charg_o_create = 'X' then '23' else '00' end) AS CD_CHARG_O_CREATE,
  (case when c.co_carr = 'X' then '23' else '00' end) AS CD_CO_CARR,
  (case when c.co_ship = 'X' then '23' else '00' end) AS CD_CO_SHIP,
  (case when c.co_tsyst = 'X' then '23' else '00' end) AS CD_CO_TSYST,
  (case when c.commctl = 'X' then '23' else '00' end) AS CD_COMMCTL,
  (case when c.soldto = 'X' then '23' else '00' end) AS CD_SOLDTO,
  (case when c.prorate_routine = 'X' then '23' else '00' end) AS CD_PRORATE_ROUTINE,
  (case when c.charg_l = 'X' then '23' else '00' end) AS CD_CHARG_L,
  (case when c.charg_l_create = 'X' then '23' else '00' end) AS CD_CHARG_L_CREATE,
  (case when c.tcnum = 'X' then '23' else '00' end) AS CD_TCNUM,
  (case when c.tcitm = 'X' then '23' else '00' end) AS CD_TCITM,
  (case when c.ga_nmshipper = 'X' then '23' else '00' end) AS CD_GA_NMSHIPPER,
  (case when c.ga_conf_qty = 'X' then '23' else '00' end) AS CD_GA_CONF_QTY,
  (case when c.ga_conf_uom = 'X' then '23' else '00' end) AS CD_GA_CONF_UOM,
  (case when c.ga_techsch_qty = 'X' then '23' else '00' end) AS CD_GA_TECHSCH_QTY,
  (case when c.ga_techsch_uom = 'X' then '23' else '00' end) AS CD_GA_TECHSCH_UOM,
  (case when c.ga_conf_qty_cal = 'X' then '23' else '00' end) AS CD_GA_CONF_QTY_CAL,
  (case when c.ga_tsch_qty_cal = 'X' then '23' else '00' end) AS CD_GA_TSCH_QTY_CAL,
  (case when c.ga_allocated_qty = 'X' then '23' else '00' end) AS CD_GA_ALLOCATED_QTY,
  (case when c.ga_allocated_uom = 'X' then '23' else '00' end) AS CD_GA_ALLOCATED_UOM,
  (case when c.ga_rank = 'X' then '23' else '00' end) AS CD_GA_RANK,
  (case when c.cycle_item = 'X' then '23' else '00' end) AS CD_CYCLE_ITEM,
  (case when c.lesshnum = 'X' then '23' else '00' end) AS CD_LESSHNUM,
  (case when c.lestpnum = 'X' then '23' else '00' end) AS CD_LESTPNUM,
  (case when c.atl_delv_number = 'X' then '23' else '00' end) AS CD_ATL_DELV_NUMBER,
  (case when c.atl_delv_itm = 'X' then '23' else '00' end) AS CD_ATL_DELV_ITM,
  (case when c.atl_crdt_qty = 'X' then '23' else '00' end) AS CD_ATL_CRDT_QTY,
  (case when c.atl_crdt_uom = 'X' then '23' else '00' end) AS CD_ATL_CRDT_UOM,
  (case when c.atl_crdt_val = 'X' then '23' else '00' end) AS CD_ATL_CRDT_VAL,
  (case when c.atl_crdt_curr = 'X' then '23' else '00' end) AS CD_ATL_CRDT_CURR,
  (case when c.pre_exist_ind = 'X' then '23' else '00' end) AS CD_PRE_EXIST_IND,
  '00' AS CD_PLANIND,
  (case when c.locpt = 'X' then '23' else '00' end) AS CD_LOCPT,
  (case when c.locsl = 'X' then '23' else '00' end) AS CD_LOCSL,
  (case when c.quickconf = 'X' then '23' else '00' end) AS CD_QUICKCONF,
  '00' AS CD_ERDAT_I,
  '00' AS CD_ERZEIT_I,
  '00' AS CD_ERNAM_I,
  '00' AS CD_AEDAT_I,
  '00' AS CD_AEZEIT_I,
  '00' AS CD_AENAM_I,
  '00' AS CD_ACTUALQTY_PAR,
  '00' AS CD_ACTUALUOM_PAR,
  '00' AS CD_LOV_IND,
  '00' AS CD_FERRYIND,
  '00' AS CD_RAILCARQTY,
  ( case when c.ipw_txt = 'X' then '23' else '00' end) AS CD_IPW_TXT,
  (case when c.itime = 'X' then '23' else '00' end) AS CD_ITIME,
  (case when c.idate_to = 'X' then '23' else '00' end) AS CD_IDATE_TO,
  (case when c.itime_to = 'X' then '23' else '00' end) AS CD_ITIME_TO,
  '00' AS CD_SIM_SCHED_TYP,
  'X' AS CE_NOMTYP,
  ' ' AS CE_QUICKCONF,
  ' ' AS CE_EXTAPPSIM,
  ' ' AS CE_NMSHTYPE
FROM Oij05_GNominations AS a
INNER JOIN Oij05_Oijgsched_Sim AS c ON /* join condition not captured in parsed metadata */
;