I_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 I_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: ISTOCKREQITEM

CREATE VIEW I_StockRequirementItem AS
SELECT
  mdps.line AS RowIndex,
  mdps.mrpplant AS MRPPlant,
  mdps.materialid AS Material,
  mdps.mrparea AS MRPArea,
  mdps.materialshortagedefinitionid AS MaterialShortageDefinition,
  mdps.mrpplanningsegmenttype AS MRPPlanningSegmentType,
  mdps.mrpplanningsegmentnumber AS MRPPlanningSegment,
  mdps.mrpelement AS MRPElement,
  mdps.mrpelementitem AS MRPElementItem,
  mdps.mrpelementscheduleline AS MRPElementScheduleLine,
  mdps.mrpelementcategory AS MRPElementCategory,
  mdps.mrpelementcategoryshortname AS MRPElementCategoryShortName,
  cast( mdps.materialbaseunit as abap.unit( 3 ) ) AS MaterialBaseUnit,
  mdps.materialbaseunittext AS UnitOfMeasureTechnicalName,
  cast( mdps.unitofmeasurecommercialname as abap.unit( 3 ) ) AS UnitOfMeasure_E,
  mdps.mrpelementavailyorrqmtdate AS MRPElementAvailyOrRqmtDate,
  mdps.mrpavailablequantity AS MRPAvailableQuantity,
  mdps.mrpelementopenquantity AS MRPElementOpenQuantity,
  mdps.materialshortagecriticalqty AS MaterialShortageCriticalQty,
  mdps.materialshortagethresholdqty AS MaterialShortageQuantityThld,
  mdps.materialsafetystockqty AS MaterialSafetyStockQty,
  mdps.mrpelementquantityisfirm AS MRPElementQuantityIsFirm,
  mdps.mrpelementdocumenttype AS MRPElementDocumentType,
  mdps.mfgorderstatusinternalcode AS MfgOrderStatusInternalCode,
  mdps.storagelocation AS StorageLocation,
  mdps.assembly AS Assembly,
  mdps.productionversion AS ProductionVersion,
  mdps.requirementplan AS RequirementPlan,
  mdps.sourcemrpelement AS SourceMRPElement,
  mdps.sourcemrpelementitem AS SourceMRPElementItem,
  mdps.sourcemrpelementscheduleline AS SourceMRPElementScheduleLine,
  mdps.sourcemrpelementcategory AS SourceMRPElementCategory,
  mdps.mrpelementbusinesspartnerid AS MRPElementBusinessPartner,
  mdps.mrpelementbusinesspartnername AS MRPElementBusinessPartnerName,
  mdps.mrpelementbusinesspartnertype AS MRPElementBusinessPartnerType,
  mdps.quantityprecision AS QuantityUnitDcmls,
  mdps.materialshortagestatus AS MaterialShortageStatus,
  mdps.released AS MRPElementIsReleased,
  mdps.partiallydelivered AS MRPElementIsPartiallyDelivered,
  mdps.requeststatus AS SolutionRequestStatus,
  mdps.vendorstatus AS MRPRequestSupplierResponse,
  mdps.mrpavailability AS MRPAvailability,
  mdps.mrpevaluationhorizonindays AS HorizonForSelectionInDays,
  mdps.decisionsupport AS HasDecisionSupport,
  mdps.shortagecount AS NumberOfShortages,
  mdps.mrpelementdocumenttypename AS MRPElementDocumentTypeName,
  mdps.supplyaggregation AS AggregationSupplyProfile,
  mdps.demandaggregation AS AggregationDemandProfile,
  mdps.mrpelementcategorygroupname AS MRPElementCategoryGroupName,
  mdps.supplyinthepast AS HasSuppliedInThePast,
  mdps.aggregatedmrpelements AS IsNonAggregated,
  mdps.targetquantityunitdisplaydcmls AS TargetQuantityUnitDcmls,
  mdps.materialexternalid AS MaterialExternalID,
  mdps.creationdatetime AS CreationDateTime
FROM mrp_sup_dem_item AS mdps
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;