P_PmBillOfMaterialUnion

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 P_PmBillOfMaterialUnion.
-- 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: PPMBOMUNION

CREATE VIEW P_PmBillOfMaterialUnion AS
SELECT
  I_Tpst.BillOfMaterial AS BillOfMaterial,
  I_Tpst.BillOfMaterialVariant AS BillOfMaterialVariant,
  cast( 'T' as stlty preserving type ) AS BillOfMaterialCategory,
  I_Tpst.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _ValidBOMItems.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  I_Tpst.FunctionalLocation AS FunctionalLocation,
  cast ( ' ' as equnr preserving type) AS Equipment,
  cast ( ' ' as matnr preserving type) AS Material,
  _FunctionalLocation.MaintenancePlanningPlant AS Plant,
  cast ( I_Tpst.FunctionalLocation as eams_tec_obj ) AS TechnicalObject,
  cast ( 'EAMS_FL' as eams_tec_obj_type_value ) AS TechObjIsEquipOrFuncnlLoc,
  cast ( ' ' as submt preserving type) AS ConstructionMaterial,
  BOMValidityStartDate,
  _EAMUserDefaultValues.IssuingPlant AS IssuingPlant,
  _EAMUserDefaultValues.StorageLocation AS BillOfMaterialasBillOfMaterial,
  _EAMUserDefaultValues.StorageLocation AS StorageLocation
FROM I_Tpst
INNER JOIN I_FunctionalLocation AS _FunctionalLocation ON /* join condition not captured in parsed metadata */
INNER JOIN I_EquipmentTimeSeg AS _EquipmentTimeSeg ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_Eqst, I_Mast, I_FlocConstMaterialBom, I_EquipmentConstructionMatBom
;