Cds_Oijne

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_Oijne.
-- 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_OIJNE
-- Parameters: p_userid : oij05_userid, p_version : oij_simvers

CREATE VIEW Cds_Oijne AS
SELECT
  (case when c.ev_seq = 'X' then b.ev_seq else a.ev_seq end) AS EV_SEQ,
  (case when c.doc_number = 'X' then b.doc_number else a.doc_number end) AS DOC_NUMBER,
  (case when c.shitem = 'X' then b.shitem else a.shitem end) AS SHITEM,
  (case when c.status = 'X' then b.status else a.status end) AS STATUS,
  (case when c.pstdtf = 'X' then b.pstdtf else a.pstdtf end) AS PSTDTF,
  (case when c.psttmf = 'X' then b.psttmf else a.psttmf end) AS PSTTMF,
  (case when c.pstdtt = 'X' then b.pstdtt else a.pstdtt end) AS PSTDTT,
  (case when c.psttmt = 'X' then b.psttmt else a.psttmt end) AS PSTTMT,
  (case when c.peddtf = 'X' then b.peddtf else a.peddtf end) AS PEDDTF,
  (case when c.pedtmf = 'X' then b.pedtmf else a.pedtmf end) AS PEDTMF,
  (case when c.peddtt = 'X' then b.peddtt else a.peddtt end) AS PEDDTT,
  (case when c.pedtmt = 'X' then b.pedtmt else a.pedtmt end) AS PEDTMT,
  (case when b.cre_name is null then a.cre_name else b.cre_name end) AS CRE_NAME,
  (case when b.cre_date is null then a.cre_date else b.cre_date end) AS CRE_DATE,
  (case when b.cre_time is null then a.cre_time else b.cre_time end) AS CRE_TIME,
  (case when b.cha_name is null then a.cha_name else b.cha_name end) AS CHA_NAME,
  (case when b.cha_date is null then a.cha_date else b.cha_date end) AS CHA_DATE,
  (case when b.cha_time is null then a.cha_time else b.cha_time end) AS CHA_TIME,
  (case when c.astdtf = 'X' then b.astdtf else a.astdtf end) AS ASTDTF,
  (case when c.asttmf = 'X' then b.asttmf else a.asttmf end) AS ASTTMF,
  (case when c.astdtt = 'X' then b.astdtt else a.astdtt end) AS ASTDTT,
  (case when c.asttmt = 'X' then b.asttmt else a.asttmt end) AS ASTTMT,
  (case when c.aeddtf = 'X' then b.aeddtf else a.aeddtf end) AS AEDDTF,
  (case when c.aedtmf = 'X' then b.aedtmf else a.aedtmf end) AS AEDTMF,
  (case when c.aeddtt = 'X' then b.aeddtt else a.aeddtt end) AS AEDDTT,
  (case when c.aedtmt = 'X' then b.aedtmt else a.aedtmt end) AS AEDTMT,
  (case when c.defaulted = 'X' then b.defaulted else a.defaulted end) AS DEFAULTED,
  (case when c.veh_nr = 'X' then b.veh_nr else a.veh_nr end) AS VEH_NR,
  (case when c.tsrfo = 'X' then b.tsrfo else a.tsrfo end) AS TSRFO,
  (case when c.ticket_key = 'X' then b.ticket_key else a.ticket_key end) AS TICKET_KEY,
  (case when c.ticket_item = 'X' then b.ticket_item else a.ticket_item end) AS TICKET_ITEM,
  (case when c.ticket_ev_nr = 'X' then b.ticket_ev_nr else a.ticket_ev_nr end) AS TICKET_EV_NR,
  (case when c.tpnum = 'X' then b.tpnum else a.tpnum end) AS TPNUM,
  (case when c.delind = 'X' then b.delind else a.delind end) AS DELIND,
  (case when c.driver = 'X' then b.driver else a.driver end) AS DRIVER,
  (case when c.cparid = 'X' then b.cparid else a.cparid end) AS CPARID,
  (case when c.add_qty = 'X' then b.add_qty else a.add_qty end) AS ADD_QTY,
  (case when c.adq_uom = 'X' then b.adq_uom else a.adq_uom end) AS ADQ_UOM,
  (case when c.matnr = 'X' then b.matnr else a.matnr end) AS MATNR,
  (case when c.lt_evoppoint = 'X' then b.lt_evoppoint else a.lt_evoppoint end) AS LT_EVOPPOINT,
  (case when c.bernr = 'X' then b.bernr else a.bernr end) AS BERNR,
  (case when c.berid = 'X' then b.berid else a.berid end) AS BERID,
  (case when b.user_id is null then ' ' else b.user_id end) AS USER_ID,
  (case when b.updkz is null then ' ' else b.updkz end) AS UPDKZ,
  ( case when b.nomtk is null then '' else '1' end) AS EVENT_SIM,
  '00' AS CD_EVENT_NR,
  '00' AS CD_NOMNR,
  '00' AS CD_TYPE,
  '00' AS CD_DOC_TYPE,
  '00' AS CD_UPDFLAG,
  (case when c.ev_seq = 'X' then '83' else '00' end) AS CD_EV_SEQ,
  (case when c.doc_number = 'X' then '83' else '00' end) AS CD_DOC_NUMBER,
  (case when c.shitem = 'X' then '83' else '00' end) AS CD_SHITEM,
  (case when c.status = 'X' then '83' else '00' end) AS CD_STATUS,
  (case when c.cre_name is null then '00' else '83' end) AS CD_CRE_NAME,
  (case when c.cre_date is null then '00' else '83' end) AS CD_CRE_DATE,
  (case when c.cre_time is null then '00' else '83' end) AS CD_CRE_TIME,
  (case when c.cha_name is null then '00' else '83' end) AS CD_CHA_NAME,
  (case when c.cha_date is null then '00' else '83' end) AS CD_CHA_DATE,
  (case when c.cha_time is null then '00' else '83' end) AS CD_CHA_TIME,
  (case when c.defaulted = 'X' then '83' else '00' end) AS CD_DEFAULTED,
  (case when c.veh_nr = 'X' then '83' else '00' end) AS CD_VEH_NR,
  (case when c.tsrfo = 'X' then '83' else '00' end) AS CD_TSRFO,
  (case when c.ticket_key = 'X' then '83' else '00' end) AS CD_TICKET_KEY,
  (case when c.ticket_item = 'X' then '83' else '00' end) AS CD_TICKET_ITEM,
  (case when c.ticket_ev_nr = 'X' then '83' else '00' end) AS CD_TICKET_EV_NR,
  (case when c.tpnum = 'X' then '83' else '00' end) AS CD_TPNUM,
  (case when c.delind = 'X' then '83' else '00' end) AS CD_DELIND,
  (case when c.driver = 'X' then '83' else '00' end) AS CD_DRIVER,
  (case when c.cparid = 'X' then '83' else '00' end) AS CD_CPARID,
  (case when c.add_qty = 'X' then '83' else '00' end) AS CD_ADD_QTY,
  (case when c.adq_uom = 'X' then '83' else '00' end) AS CD_ADQ_UOM,
  (case when c.matnr = 'X' then '83' else '00' end) AS CD_MATNR,
  (case when c.lt_evoppoint = 'X' then '83' else '00' end) AS CD_LT_EVOPPOINT,
  (case when c.bernr = 'X' then '83' else '00' end) AS CD_BERNR,
  (case when c.berid = 'X' then '83' else '00' end) AS CD_BERID,
  (case when c.pstdtf = 'X' then '83' else '00' end) AS CD_PSTDTF,
  (case when c.psttmf = 'X' then '83' else '00' end) AS CD_PSTTMF,
  (case when c.pstdtt = 'X' then '83' else '00' end) AS CD_PSTDTT,
  (case when c.psttmt = 'X' then '83' else '00' end) AS CD_PSTTMT,
  (case when c.peddtf = 'X' then '83' else '00' end) AS CD_PEDDTF,
  (case when c.pedtmf = 'X' then '83' else '00' end) AS CD_PEDTMF,
  (case when c.peddtt = 'X' then '83' else '00' end) AS CD_PEDDTT,
  (case when c.pedtmt = 'X' then '83' else '00' end) AS CD_PEDTMT,
  (case when c.astdtf = 'X' then '83' else '00' end) AS CD_ASTDTF,
  (case when c.asttmf = 'X' then '83' else '00' end) AS CD_ASTTMF,
  (case when c.astdtt = 'X' then '83' else '00' end) AS CD_ASTDTT,
  (case when c.asttmt = 'X' then '83' else '00' end) AS CD_ASTTMT,
  (case when c.aeddtf = 'X' then '83' else '00' end) AS CD_AEDDTF,
  (case when c.aedtmf = 'X' then '83' else '00' end) AS CD_AEDTMF,
  (case when c.aeddtt = 'X' then '83' else '00' end) AS CD_AEDDTT,
  (case when c.aedtmt = 'X' then '83' else '00' end) as CD_AEDTMT AS clientasMANDT,
  (case when b.aedtmt = '000000' then '00' else '23' end ) AS CD_AEDTMT,
  a.client AS MANDT,
  a.nomtk AS NOMTK,
  a.nomit AS NOMIT,
  a.event_nr AS EVENT_NR,
  a.nomnr AS NOMNR,
  a.type AS TYPE,
  a.doc_type AS DOC_TYPE,
  a.updflag AS UPDFLAG,
  b.sched_stat AS SCHED_STAT
FROM oijne_sim AS b
INNER JOIN goij05_nomtk AS d ON /* join condition not captured in parsed metadata */
INNER JOIN goij05_nomtk AS e ON /* join condition not captured in parsed metadata */
INNER JOIN oijne_sim_mk AS c ON /* join condition not captured in parsed metadata */
INNER JOIN goij05_nomtk AS b1 ON /* join condition not captured in parsed metadata */
INNER JOIN goij05_gnomtk AS g ON /* join condition not captured in parsed metadata */
INNER JOIN goij05_gnomtk AS b1 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): oijne_sim
;