Cds_Nom_Details

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_Nom_Details.
-- 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_nom_detail
-- 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

CREATE VIEW Cds_Nom_Details AS
SELECT
  a.mandt AS mandt,
  a.nomtk AS nomtk,
  a.nomcl AS nomcl,
  a.nomtyp AS nomtyp,
  a.bustyp AS bustyp,
  a.nomnr AS nomnr,
  a.nomst AS nomst,
  a.nmshtype AS nmshtype,
  a.nmbalch AS nmbalch,
  a.stages_id AS stages_id,
  a.worklist AS worklist,
  a.sentdat AS sentdat,
  a.senttime AS senttime,
  a.sentnam AS sentnam,
  a.items AS items,
  a.counter1 AS counter1,
  a.counter2 AS counter2,
  a.counter3 AS counter3,
  a.counter4 AS counter4,
  a.counter5 AS counter5,
  a.counter6 AS counter6,
  a.nmblock AS nmblock,
  a.nomtypdesc AS nomtypdesc,
  a.shtyp AS shtyp,
  a.tknum AS tknum,
  a.lov_gl AS lov_gl,
  a.tsyst AS tsyst,
  a.nmshipper AS nmshipper,
  a.nmcarrier AS nmcarrier,
  a.cycle AS cycle,
  a.nmwerk AS nmwerk,
  a.nmlgort AS nmlgort,
  a.nmvehicle AS nmvehicle,
  a.nmvessel AS nmvessel,
  a.nmtplst AS nmtplst,
  a.route AS route,
  a.bookts AS bookts,
  a.ev_group AS ev_group,
  a.vktra AS vktra,
  a.qtyin AS qtyin,
  a.qtyout AS qtyout,
  a.unit AS unit,
  a.tst_from_min AS tst_from_min,
  a.tst_to_max AS tst_to_max,
  a.bloind AS bloind,
  a.delind AS delind,
  a.shnum AS shnum,
  a.erdat AS erdat,
  a.erzeit AS erzeit,
  a.ernam AS ernam,
  a.aedat AS aedat,
  a.aezeit AS aezeit,
  a.aenam AS aenam,
  a.nomit AS nomit,
  a.sityp AS sityp,
  a.istat AS istat,
  a.isubstat AS isubstat,
  a.idate AS idate,
  a.sched_tst_to AS sched_tst_to,
  a.locid AS locid,
  a.s_matnr_i AS s_matnr_i,
  a.matnr_i AS matnr_i,
  a.menge AS menge,
  a.unit_i AS unit_i,
  a.unit_i_t AS unit_i_t,
  a.docind AS docind,
  a.docnr AS docnr,
  a.docitm AS docitm,
  a.docschedln AS docschedln,
  a.qtyfcr AS qtyfcr,
  a.qtyfcr_uom AS qtyfcr_uom,
  a.worklist_i AS worklist_i,
  a.tank AS tank,
  a.cons AS cons,
  a.partnr AS partnr,
  a.conpat AS conpat,
  a.inspe AS inspe,
  a.impoexpo AS impoexpo,
  a.flag_imex AS flag_imex,
  a.owner AS owner,
  a.charg_o AS charg_o,
  a.charg_d AS charg_d,
  a.rvp AS rvp,
  a.shnum_i AS shnum_i,
  a.shitem AS shitem,
  a.ilock AS ilock,
  a.prorateqty AS prorateqty,
  a.assignedqty AS assignedqty,
  a.actdat AS actdat,
  a.acttime AS acttime,
  a.actuals AS actuals,
  a.actualqty AS actualqty,
  a.actualuom AS actualuom,
  a.itbotol AS itbotol,
  a.itbutol AS itbutol,
  a.itbotolabs AS itbotolabs,
  a.itbutolabs AS itbutolabs,
  a.ittolunit AS ittolunit,
  a.unlimited AS unlimited,
  a.bloind_i AS bloind_i,
  a.delind_i AS delind_i,
  a.updatexdok AS updatexdok,
  a.doctyp AS doctyp,
  a.ldrate AS ldrate,
  a.ldquom AS ldquom,
  a.ldtuom AS ldtuom,
  a.third_nomnr AS third_nomnr,
  a.upmat AS upmat,
  a.refitem AS refitem,
  a.stlty AS stlty,
  a.stlkn AS stlkn,
  a.co_carr AS co_carr,
  a.co_ship AS co_ship,
  a.co_tsyst AS co_tsyst,
  a.commctl AS commctl,
  a.soldto AS soldto,
  a.charg_l AS charg_l,
  a.tcnum AS tcnum,
  a.tcitm AS tcitm,
  a.ga_nmshipper AS ga_nmshipper,
  a.ga_conf_qty AS ga_conf_qty,
  a.ga_conf_uom AS ga_conf_uom,
  a.ga_rank AS ga_rank,
  a.cycle_item AS cycle_item,
  a.lesshnum AS lesshnum,
  a.lestpnum AS lestpnum,
  a.atl_delv_itm AS atl_delv_itm,
  a.atl_crdt_qty AS atl_crdt_qty,
  a.atl_crdt_uom AS atl_crdt_uom,
  a.atl_crdt_val AS atl_crdt_val,
  a.planind AS planind,
  a.locpt AS locpt,
  a.locsl AS locsl,
  a.quickconf AS quickconf,
  a.erdat_i AS erdat_i,
  a.erzeit_i AS erzeit_i,
  a.ernam_i AS ernam_i,
  a.aedat_i AS aedat_i,
  a.aezeit_i AS aezeit_i,
  a.aenam_i AS aenam_i,
  a.lov_ind AS lov_ind,
  a.ferryind AS ferryind,
  a.railcarqty AS railcarqty
INNER JOIN Cdsv_Nomtk ON /* join condition not captured in parsed metadata */
;