C_ProdnRtgVersAssignableBOM

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_ProdnRtgVersAssignableBOM.
-- 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.

CREATE VIEW C_ProdnRtgVersAssignableBOM AS
SELECT
  AssignableBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  AssignableBOM.BillOfMaterial AS BillOfMaterial,
  AssignableBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  AssignableBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  AssignableBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  AssignableBOM.BOMHeaderText AS BOMHeaderText,
  AssignableBOM.BOMAlternativeText AS BOMAlternativeText,
  AssignableBOM.Material AS Material,
  AssignableBOM.Plant AS Plant,
  AssignableBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  AssignableBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  AssignableBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  AssignableBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  AssignableBOM.BOMVersionStatus AS BOMVersionStatus,
  cast(AssignableBOM.HeaderValidityStartDate as pph_begda preserving type) AS ValidityStartDate,
  cast(AssignableBOM.HeaderValidityEndDate as pph_endda preserving type) AS ValidityEndDate,
  AssignableBOM.RecordCreationDate AS RecordCreationDate,
  cast(AssignableBOM.CreatedByUser as vdm_createdbyuserid preserving type) AS CreatedByUser,
  AssignableBOM.LastChangeDate AS LastChangeDate,
  cast(AssignableBOM.LastChangedByUser as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  AssignableBOM.LastChangeDateTime AS LastChangeDateTime,
  AssignableBOM._BOMChangeNumbers AS _BOMChangeNumbers
FROM I_MaterialBOM AS AssignableBOM
INNER JOIN I_MfgBOMUsages AS MfgBOMUsage ON /* join condition not captured in parsed metadata */
INNER JOIN I_Material AS Material ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialTypeToBOOType AS MaterialTypeToBOOType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_MngProdnRtgPlantMaterialVH AS _MngProdnRtgPlantMaterialVH ON Plant = _MngProdnRtgPlantMaterialVH.MRPPlant AND Material = _MngProdnRtgPlantMaterialVH.Material  -- association [1..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant  -- association [0..*]
;