C_StockRequirementItem

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_StockRequirementItem.
-- 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: CSTOCKREQITEM

CREATE VIEW C_StockRequirementItem AS
SELECT
  I_StockRequirementItem.RowIndex AS RowIndex,
  I_StockRequirementItem.MRPPlant AS MRPPlant,
  I_StockRequirementItem.Material AS Material,
  I_StockRequirementItem.MRPArea AS MRPArea,
  I_StockRequirementItem.MaterialShortageDefinition AS MaterialShortageDefinition,
  I_StockRequirementItem.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  I_StockRequirementItem.MRPPlanningSegment AS MRPPlanningSegment,
  I_StockRequirementItem.MRPElement AS MRPElement,
  I_StockRequirementItem.MRPElementItem AS MRPElementItem,
  I_StockRequirementItem.MRPElementScheduleLine AS MRPElementScheduleLine,
  I_StockRequirementItem.MaterialBaseUnit AS MaterialBaseUnit,
  I_StockRequirementItem.UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  I_StockRequirementItem.UnitOfMeasure_E AS UnitOfMeasure_E,
  I_StockRequirementItem.MRPElementCategory AS MRPElementCategory,
  I_StockRequirementItem.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  I_StockRequirementItem.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  I_StockRequirementItem.MRPAvailableQuantity AS MRPAvailableQuantity,
  I_StockRequirementItem.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  I_StockRequirementItem.MaterialShortageCriticalQty AS MaterialShortageCriticalQty,
  I_StockRequirementItem.MaterialShortageQuantityThld AS MaterialShortageQuantityThld,
  I_StockRequirementItem.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  I_StockRequirementItem.MRPElementQuantityIsFirm AS MRPElementQuantityIsFirm,
  I_StockRequirementItem.MRPElementDocumentType AS MRPElementDocumentType,
  I_StockRequirementItem.MfgOrderStatusInternalCode AS MfgOrderStatusInternalCode,
  I_StockRequirementItem.StorageLocation AS StorageLocation,
  I_StockRequirementItem.Assembly AS Assembly,
  I_StockRequirementItem.ProductionVersion AS ProductionVersion,
  I_StockRequirementItem.RequirementPlan AS RequirementPlan,
  I_StockRequirementItem.SourceMRPElement AS SourceMRPElement,
  I_StockRequirementItem.SourceMRPElementItem AS SourceMRPElementItem,
  I_StockRequirementItem.SourceMRPElementScheduleLine AS SourceMRPElementScheduleLine,
  I_StockRequirementItem.SourceMRPElementCategory AS SourceMRPElementCategory,
  I_StockRequirementItem.MRPElementBusinessPartner AS MRPElementBusinessPartner,
  I_StockRequirementItem.MRPElementBusinessPartnerName AS MRPElementBusinessPartnerName,
  I_StockRequirementItem.MRPElementBusinessPartnerType AS MRPElementBusinessPartnerType,
  I_StockRequirementItem.QuantityUnitDcmls AS QuantityUnitDcmls,
  I_StockRequirementItem.MaterialShortageStatus AS MaterialShortageStatus,
  I_StockRequirementItem.MRPElementIsReleased AS MRPElementIsReleased,
  I_StockRequirementItem.MRPElementIsPartiallyDelivered AS MRPElementIsPartiallyDelivered,
  I_StockRequirementItem.SolutionRequestStatus AS SolutionRequestStatus,
  I_StockRequirementItem.MRPRequestSupplierResponse AS MRPRequestSupplierResponse,
  I_StockRequirementItem.MRPAvailability AS MRPAvailability,
  I_StockRequirementItem.HorizonForSelectionInDays AS HorizonForSelectionInDays,
  I_StockRequirementItem.HasDecisionSupport AS HasDecisionSupport,
  I_StockRequirementItem.MRPElementDocumentTypeName AS MRPElementDocumentTypeName,
  I_StockRequirementItem.AggregationSupplyProfile AS AggregationSupplyProfile,
  I_StockRequirementItem.AggregationDemandProfile AS AggregationDemandProfile,
  I_StockRequirementItem.MRPElementCategoryGroupName AS MRPElementCategoryGroupName,
  I_StockRequirementItem.HasSuppliedInThePast AS HasSuppliedInThePast,
  I_StockRequirementItem.IsNonAggregated AS IsNonAggregated,
  I_StockRequirementItem.TargetQuantityUnitDcmls AS TargetQuantityUnitDcmls,
  I_StockRequirementItem.MaterialExternalID AS MaterialExternalID,
  CreationDateTime
FROM I_StockRequirementItem
LEFT OUTER JOIN E_Purchaserequisitionitem AS _Extension ON MRPElement = _Extension.PurchaseRequisition AND MRPElementItem = _Extension.PurchaseRequisitionItem  -- association [0..1]
;