Cds_Oijne_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 Cds_Oijne_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_OIJNOMI_OIJNE
-- Parameters: p_userid : oij05_userid, p_version : oij_simvers

CREATE VIEW Cds_Oijne_Sim AS
SELECT
  a.mandt AS mandt,
  a.nomtk AS nomtk,
  a.nomit AS nomit,
  a.locid AS locid,
  a.s_matnr_i AS s_matnr_i,
  a.idate AS idate,
  b.EVENT_NR AS EVENT_NR,
  b.NOMNR AS NOMNR,
  b.TYPE AS TYPE,
  b.DOC_TYPE AS DOC_TYPE,
  b.UPDFLAG AS UPDFLAG,
  b.EV_SEQ AS EV_SEQ,
  b.DOC_NUMBER AS DOC_NUMBER,
  b.SHITEM AS SHITEM,
  b.STATUS AS STATUS,
  b.PSTDTF AS PSTDTF,
  b.PSTTMF AS PSTTMF,
  b.PSTDTT AS PSTDTT,
  b.PSTTMT AS PSTTMT,
  b.PEDDTF AS PEDDTF,
  b.PEDTMF AS PEDTMF,
  b.PEDDTT AS PEDDTT,
  b.PEDTMT AS PEDTMT,
  b.CRE_NAME AS CRE_NAME,
  b.CRE_DATE AS CRE_DATE,
  b.CRE_TIME AS CRE_TIME,
  b.CHA_NAME AS CHA_NAME,
  b.CHA_DATE AS CHA_DATE,
  b.CHA_TIME AS CHA_TIME,
  b.ASTDTF AS ASTDTF,
  b.ASTTMF AS ASTTMF,
  b.ASTDTT AS ASTDTT,
  b.ASTTMT AS ASTTMT,
  b.AEDDTF AS AEDDTF,
  b.AEDTMF AS AEDTMF,
  b.AEDDTT AS AEDDTT,
  b.AEDTMT AS AEDTMT,
  b.DEFAULTED AS DEFAULTED,
  b.VEH_NR AS VEH_NR,
  b.TSRFO AS TSRFO,
  b.TICKET_KEY AS TICKET_KEY,
  b.TICKET_ITEM AS TICKET_ITEM,
  b.TICKET_EV_NR AS TICKET_EV_NR,
  b.TPNUM AS TPNUM,
  b.DELIND AS DELIND,
  b.DRIVER AS DRIVER,
  b.CPARID AS CPARID,
  b.ADD_QTY AS ADD_QTY,
  b.ADQ_UOM AS ADQ_UOM,
  b.MATNR AS MATNR,
  b.LT_EVOPPOINT AS LT_EVOPPOINT,
  b.BERNR AS BERNR,
  b.BERID AS BERID,
  b.USER_ID AS USER_ID,
  b.UPDKZ AS UPDKZ,
  b.EVENT_SIM AS EVENT_SIM,
  b.CD_EVENT_NR AS CD_EVENT_NR,
  b.CD_NOMNR AS CD_NOMNR,
  b.CD_TYPE AS CD_TYPE,
  b.CD_DOC_TYPE AS CD_DOC_TYPE,
  b.CD_UPDFLAG AS CD_UPDFLAG,
  b.CD_EV_SEQ AS CD_EV_SEQ,
  b.CD_DOC_NUMBER AS CD_DOC_NUMBER,
  b.CD_SHITEM AS CD_SHITEM,
  b.CD_STATUS AS CD_STATUS,
  b.CD_CRE_NAME AS CD_CRE_NAME,
  b.CD_CRE_DATE AS CD_CRE_DATE,
  b.CD_CRE_TIME AS CD_CRE_TIME,
  b.CD_CHA_NAME AS CD_CHA_NAME,
  b.CD_CHA_DATE AS CD_CHA_DATE,
  b.CD_CHA_TIME AS CD_CHA_TIME,
  b.CD_DEFAULTED AS CD_DEFAULTED,
  b.CD_VEH_NR AS CD_VEH_NR,
  b.CD_TSRFO AS CD_TSRFO,
  b.CD_TICKET_KEY AS CD_TICKET_KEY,
  b.CD_TICKET_ITEM AS CD_TICKET_ITEM,
  b.CD_TICKET_EV_NR AS CD_TICKET_EV_NR,
  b.CD_TPNUM AS CD_TPNUM,
  b.CD_DELIND AS CD_DELIND,
  b.CD_DRIVER AS CD_DRIVER,
  b.CD_CPARID AS CD_CPARID,
  b.CD_ADD_QTY AS CD_ADD_QTY,
  b.CD_ADQ_UOM AS CD_ADQ_UOM,
  b.CD_MATNR AS CD_MATNR,
  b.CD_LT_EVOPPOINT AS CD_LT_EVOPPOINT,
  b.CD_BERNR AS CD_BERNR,
  b.CD_BERID AS CD_BERID,
  b.CD_PSTDTF AS CD_PSTDTF,
  b.CD_PSTTMF AS CD_PSTTMF,
  b.CD_PSTDTT AS CD_PSTDTT,
  b.CD_PSTTMT AS CD_PSTTMT,
  b.CD_PEDDTF AS CD_PEDDTF,
  b.CD_PEDTMF AS CD_PEDTMF,
  b.CD_PEDDTT AS CD_PEDDTT,
  b.CD_PEDTMT AS CD_PEDTMT,
  b.CD_ASTDTF AS CD_ASTDTF,
  b.CD_ASTTMF AS CD_ASTTMF,
  b.CD_ASTDTT AS CD_ASTDTT,
  b.CD_ASTTMT AS CD_ASTTMT,
  b.CD_AEDDTF AS CD_AEDDTF,
  b.CD_AEDTMF AS CD_AEDTMF,
  b.CD_AEDDTT AS CD_AEDDTT,
  b.CD_AEDTMT AS CD_AEDTMT
FROM oijnomi AS a
INNER JOIN Cds_Oijne ON /* join condition not captured in parsed metadata */
;