D_BOMHeaderForExplosion_Out

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 D_BOMHeaderForExplosion_Out.
-- 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: DBOMHDREXPLOUT

CREATE VIEW D_BOMHeaderForExplosion_Out AS
SELECT
  cast ('' as matnr) AS B_O_M_Hdr_Root_Matl_Hier_Node,
  cast ('' as maktx) AS Material_Name,
  cast ('' as stnum) AS Bill_Of_Material_Root,
  cast (cast (1 as abap.dec( 3, 0 ))as wegxx) AS path,
  cast (cast (1 as abap.dec( 5, 0 ))as wegxx_2) AS path_2,
  cast ('' as name1) AS plantName,
  cast ('' as dismm) AS m_r_p_type,
  cast ('' as cadpo) AS is_c_a_d,
  cast ('' as lifnr) AS supplier,
  cast (0 as cs_e_peinh) AS price_unit,
  cast (cast ('' as abap.cuky(5) ) as waers) AS currency,
  cast ('' as sakto) AS cost_element,
  cast ('' as doknr) AS doc_number,
  cast ('' as cs_e_xalst) AS alt_nxt_lvl,
  cast ('' as klasse_d ) AS class,
  cast ('' as klassenart) AS class_type,
  cast ('' as kzkup) AS co_product,
  cast ('' as cim_count ) AS counter,
  cast ('' as cs_e_xlkzh) AS del_Ind_nxt_lvl,
  cast ('' as rform) AS formula_key,
  cast ('' as clmult) AS multiple_sel,
  cast ('' as objty) AS object_type,
  cast ('' as abteilung) AS org_area,
  cast ('' as cs_alprf) AS priority,
  cast(0 as roms1 ) AS size1,
  cast(0 as roms2 ) AS size2,
  cast(0 as roms3 ) AS size3,
  cast('' as romei ) AS size_unit,
  cast('' as cs_alpst ) AS strategy,
  cast(0 as sytabix ) AS table_row,
  cast('' as cs_e_msign ) AS item_sign,
  cast('' as meins ) AS base_uom,
  cast('' as kzech ) AS batch_entry,
  cast('' as xchar ) AS batch_mgmt,
  cast(0 as umren ) AS denominator,
  cast('' as dzeivr ) AS doc_version,
  cast('' as dzeinr ) AS doc,
  cast('' as stabk ) AS doc_status,
  cast('' as dzeiar ) AS doc_type,
  cast('' as kzdkz ) AS doc_reqd,
  cast('' as stlkn ) AS item_node,
  cast( cast (0 as abap.curr(11,2)) as verpr ) AS moving_price,
  cast('' as blanz ) AS no_of_sheets,
  cast(0 as umrez ) AS numerator,
  cast('' as dzeifo ) AS page_format,
  cast('' as blatt ) AS page_number,
  cast('' as werks_d ) AS plant,
  cast('' as rekri ) AS recurisve,
  cast('' as sortp ) AS sort_string,
  cast('' as dostx ) AS status_text,
  cast('' as kzwso ) AS uom_usage,
  cast(0 as sytabix) AS item_index
FROM I_BillOfMaterialAPITP_1
;