Oij05_Cdsnwbe

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

CREATE VIEW Oij05_Cdsnwbe 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_STATUS AS CD_STATUS,
  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 */
;