I_CurrentAssignments

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_CurrentAssignments.
-- 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 I_CurrentAssignments AS
SELECT
  MRPArea,
  MatlStkOwnrGrpgWBSElmntIntID,
  ReplenishmentElement,
  ReplenishmentDate,
  RequirementDate,
  AssignedWBSElementInternalID,
  MaterialStockAndConsumptionSts,
  AlternateCostAssignmentObject,
  NextHigherAssemblyObject,
  TopLevelRequirementObject,
  Plant,
  Material,
  AcctAsgtGroupingWBSElmntIntID,
  AlternateCostAssignmentObjType,
  WBSElmntAssgdMatlQuantity,
  WBSElmntAssgdMatlExssQuantity,
  WBSElmntAssgdMatlScrapQuantity,
  WBSElmntAssgdMatlLossQuantity,
  WBSElmntMatlCarryFwdQuantity,
  MaterialBaseUnit,
  MaterialExcessAssgmtMethod,
  MaterialLossAssgmtMethod,
  MaterialScrapAssgmtMethod,
  ReplnmtElmntTotalOrderQuantity,
  TopLevelRequirementObjQuantity,
  TopLevelRqmtObjQuantityUnit,
  TopLevelRequirementObjRqmtDate,
  LeadingOrderOfCollectiveOrder,
  ReplnmtElmntIsStockGain,
  OriginOfPeggingAssignment,
  ShippingNotice,
  CreationDateTime,
  LastChangeDateTime,
  MRPElementCategory,
  NextHigherMRPElementCategory,
  TopLevelMRPElementCategory,
  _MaterialText.MaterialName AS MaterialName,
  _Plant.PlantName AS PlantName,
  _MaterialPlant.MRPController AS MRPController,
  _MaterialPlant._MRPController.MRPControllerName AS MRPControllerName,
  _MatlQtyBaseUnit._Text[ 1: Language = $session.system_language ].UnitOfMeasureName AS MaterialBaseUnitDesc,
  MRPElementIDForDisplay,
  MRPElementCategoryName,
  _MRPEleDocumentCategory.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  NextHigherMRPElmntIDForDisplay,
  NextHigherMRPElementCatName,
  _NextHigherDocumentCategory.PurchasingDocumentCategory AS NextHigherAssyPurgDocCat,
  TopLevelMRPElementIDForDisplay,
  TopLevelMRPElementCategoryName,
  AlternateCostAssgmtObjExtID,
  AlternateCostAssgmtObjTypeName
FROM I_PeggingAssignmentForDisplay
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND mrpcontroller = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialExcessAssgmtMethod AS _MaterialExcessAssgmtMethod ON MaterialExcessAssgmtMethod = _MaterialExcessAssgmtMethod.MaterialExcessAssgmtMethod AND _MaterialExcessAssgmtMethod.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialScrapAssgmtMethod AS _MaterialScrapAssgmtMethod ON MaterialScrapAssgmtMethod = _MaterialScrapAssgmtMethod.MaterialScrapAssgmtMethod AND _MaterialScrapAssgmtMethod.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MaterialLossAssgmtMethod AS _MaterialLossAssgmtMethod ON MaterialLossAssgmtMethod = _MaterialLossAssgmtMethod.MaterialLossAssgmtMethod AND _MaterialLossAssgmtMethod.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MaterialStockAndCnsmpnSts AS _MaterialStockAndCnsmpnSts ON MaterialStockAndConsumptionSts = _MaterialStockAndCnsmpnSts.MaterialStockAndConsumptionSts AND _MaterialStockAndCnsmpnSts.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_OriginOfPeggingAssignment AS _OriginOfPeggingAssignment ON OriginOfPeggingAssignment = _OriginOfPeggingAssignment.OriginOfPeggingAssignment AND _OriginOfPeggingAssignment.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PggngPurgDocumentCategory AS _MRPEleDocumentCategory ON MRPElementIDForDisplay = _MRPEleDocumentCategory.MRPElementIDForDisplay  -- association [0..1]
LEFT OUTER JOIN I_PggngPurgDocumentCategory AS _NextHigherDocumentCategory ON NextHigherMRPElmntIDForDisplay = _NextHigherDocumentCategory.MRPElementIDForDisplay  -- association [0..1]
;