I_HistoricMaterial

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 I_HistoricMaterial.
-- 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: IHISTMAT

CREATE VIEW I_HistoricMaterial AS
SELECT
  Material,
  Plant,
  StorageLocation,
  TechnicalObject,
  RcrrcOfMatlUsageInTechObj,
  TechObjIsEquipOrFuncnlLoc,
  _Material.AuthorizationGroup AS AuthorizationGroup,
  _Material.IsBatchManagementRequired AS IsBatchManagementRequired,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _Material.MaterialGrossWeight AS MaterialGrossWeight,
  _Material.MaterialGroup AS MaterialGroup,
  _Material.MaterialManufacturerNumber AS MaterialManufacturerNumber,
  _Material.MaterialManufacturerPartNumber AS MaterialManufacturerPartNumber,
  _Material.MaterialNetWeight AS MaterialNetWeight,
  _Material.MaterialType AS MaterialType,
  _Material.MaterialWeightUnit AS MaterialWeightUnit
FROM P_HistMaterialsRecurrence
LEFT OUTER JOIN I_MaintNotifTypesPerPlant AS _MaintNotifTypesPerPlant ON Plant = _MaintNotifTypesPerPlant.Plant  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialUnrestrictedUseStock AS _MaterialUnrestrictedUseStock ON Material = _MaterialUnrestrictedUseStock.Material AND Plant = _MaterialUnrestrictedUseStock.Plant AND StorageLocation = _MaterialUnrestrictedUseStock.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_UnrestrictedUseStkOnPlntLvl AS _UnrestrictedUseStkOnPlntLvl ON Material = _UnrestrictedUseStkOnPlntLvl.Material AND Plant = _UnrestrictedUseStkOnPlntLvl.Plant  -- association [0..1]
;