C_MaintJobWrkItmCompHistProdVH

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_MaintJobWrkItmCompHistProdVH.
-- 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_MaintJobWrkItmCompHistProdVH AS
SELECT
  I_MaintJobWrkItmCompHistlProd.Material AS Material,
  I_MaintJobWrkItmCompHistlProd.Plant AS Plant,
  I_MaintJobWrkItmCompHistlProd.StorageLocation AS StorageLocation,
  I_MaintJobWrkItmCompHistlProd.TechnicalObject AS TechnicalObject,
  MaintenanceOrderType,
  _BatchPlant.Batch AS Batch,
  _MaterialValuationCategory.InventoryValuationType AS InventoryValuationType,
  cast(_TechnicalObject.TechnicalObjectLabel as eams_tec_obj) AS TechnicalObjectLabel,
  _TechnicalObject.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  I_MaintJobWrkItmCompHistlProd.RcrrcOfMatlUsageInTechObj AS RcrrcOfMatlUsageInTechObj,
  _Material.MaterialType AS MaterialType,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _Material.AuthorizationGroup AS AuthorizationGroup,
  IsBatchManagementRequired,
  _ProductPlant.AvailabilityCheckType AS AvailabilityCheckType,
  _ProductPlant.IsMarkedForDeletion AS IsMarkedForDeletion,
  _ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  _SerialNumberProfileProcedure.SerialNumberProcedure AS SerialNumberProcedure,
  _SerialNumberProfileProcedure.SerialNumberUsageInAssignment AS SerialNumberUsageInAssignment,
  _MaterialValuationCategory.InventoryValuationCategory AS InventoryValuationCategory,
  cast( 0 as bdmng ) AS MaximumAvailableQuantity,
  _Material._MaterialType AS _MaterialType
FROM I_MaintJobWrkItmCompHistlProd
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN P_MaterialValuationTypesVH AS _MaterialValuationCategory ON _MaterialValuationCategory.Product = Material AND _MaterialValuationCategory.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN P_SerialNumberProfileProcedure AS _SerialNumberProfileProcedure ON _SerialNumberProfileProcedure.Product = Material AND _SerialNumberProfileProcedure.Plant = Plant AND _SerialNumberProfileProcedure.SerialNumberProcedure = 'MMSL'  -- association [0..1]
LEFT OUTER JOIN I_BatchPlant AS _BatchPlant ON Material = _BatchPlant.Material AND Plant = _BatchPlant.Plant AND IsBatchManagementRequired = 'X'  -- association [0..1]
;