C_BOMCreateForUI

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 C_BOMCreateForUI.
-- 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: CBOMCREATE

CREATE VIEW C_BOMCreateForUI AS
SELECT
  BOMApplicationArea,
  cast(' ' as char8 preserving type ) AS BillOfMaterial,
  cast(' ' as stlty preserving type ) AS BillOfMaterialCategory,
  cast(' ' as stlal preserving type ) AS BillOfMaterialVariant,
  cast(' ' as cs_versn preserving type ) AS BillOfMaterialVersion,
  cast(' ' as aennr preserving type ) AS EngineeringChangeDocument,
  cast(' ' as matnr preserving type) AS Material,
  cast(' ' as werks_d preserving type ) AS Plant,
  cast(' ' as stlan preserving type ) AS BillOfMaterialVariantUsage,
  cast(' ' as antxt ) AS BillOfMaterialVariantUsageDesc,
  cast(' ' as stlal preserving type ) AS BillOfMaterialVariantForEdit,
  cast(' ' as aennr preserving type ) AS EngineeringChangeDocForEdit,
  cast(' ' as werks_d preserving type ) AS PlantForEdit,
  $session.system_date AS HeaderValidityStartDate,
  cast(' ' as /plmb/cr_id preserving type) AS ChangeRecord,
  cast('X' as boolean preserving type) AS BOMComponentCopyIsRequired
FROM I_BOMModificationParameters
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [1..1]
-- UNION ALL with additional select branch(es): P_BillOfMaterialHeader
;