I_MRPSolutionItem

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_MRPSolutionItem.
-- 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: IMRPSOLUTIONITEM

CREATE VIEW I_MRPSolutionItem AS
SELECT
  mrp_sol_view.itemindex AS RowIndex,
  mrp_sol_view.orderid AS MRPElement,
  mrp_sol_view.orderitemid AS MRPElementItem,
  mrp_sol_view.orderschedulelineid AS MRPElementScheduleLine,
  mrp_sol_view.acctassignmentcategory AS AccountAssignmentCategory,
  mrp_sol_view.assembly AS Assembly,
  mrp_sol_view.changestateid AS ChangeStateID,
  mrp_sol_view.itemcomment AS MRPElementItemComment,
  mrp_sol_view.companycode AS CompanyCode,
  mrp_sol_view.contactmail AS EmailAddress,
  mrp_sol_view.contactname AS FullName,
  mrp_sol_view.contactphone AS MobilePhoneNumber,
  mrp_sol_view.currentdlvquant AS CurrentDeliveryQuantity,
  mrp_sol_view.denominator AS QuantityDenominator,
  mrp_sol_view.materialid AS Material,
  mrp_sol_view.materialbaseunit AS MaterialBaseUnit,
  mrp_sol_view.materialbaseunitshort AS UnitOfMeasureTechnicalName,
  mrp_sol_view.materialexternalid AS MaterialExternalID,
  mrp_sol_view.materialgoodsreceiptduration AS MaterialGoodsReceiptDuration,
  mrp_sol_view.materialgroupname AS MaterialGroupName,
  mrp_sol_view.materialprocurementtype AS MaterialProcurementType,
  mrp_sol_view.materialsafetystockqty AS MaterialSafetyStockQty,
  mrp_sol_view.materialshortagecriticalqty AS MaterialShortageCriticalQty,
  mrp_sol_view.materialshortagedefinitionid AS MaterialShortageDefinition,
  mrp_sol_view.materialshortageprofile AS MaterialShortageProfile,
  mrp_sol_view.materialshortageprofilecount AS MaterialShortageProfileCount,
  mrp_sol_view.materialshortagequantity AS MaterialShortageQuantity,
  mrp_sol_view.materialshortagestartdate AS MaterialShortageStartDate,
  mrp_sol_view.materialshortageenddate AS MaterialShortageEndDate,
  mrp_sol_view.materialshortagethresholdqty AS MaterialShortageQuantityThld,
  mrp_sol_view.mrparea AS MRPArea,
  mrp_sol_view.mrpavailabilitydate AS AvailabilityDate,
  mrp_sol_view.mrpavailablequantity AS MRPAvailableQuantity,
  mrp_sol_view.mrpavailability AS MRPAvailability,
  mrp_sol_view.mrpelementavorrqmtdate AS MRPElementAvailyOrRqmtDate,
  mrp_sol_view.mrpelementcategory AS MRPElementCategory,
  mrp_sol_view.mrpelementcategoryshortname AS MRPElementCategoryShortName,
  mrp_sol_view.mrpelementchangedavorrqmtdate AS MRPElementChgAvailyOrRqmtDate,
  mrp_sol_view.mrpelementchangeddeliverydate AS MRPElementChangeDeliveryDate,
  mrp_sol_view.mrpelementchangedopenquantity AS MRPElementChangedOpenQuantity,
  mrp_sol_view.mrpelementdeliverydate AS MRPElementPlndDeliveryDate,
  mrp_sol_view.mrpelementdocumenttype AS MRPElementDocumentType,
  mrp_sol_view.mrpelementdocumenttypename AS MRPElementDocumentTypeName,
  mrp_sol_view.orderid_ext AS MRPElementExternalID,
  mrp_sol_view.orderitemid_ext AS MRPElementItemExternalID,
  mrp_sol_view.mrpelementopenquantity AS MRPElementOpenQuantity,
  mrp_sol_view.mrpelementquantityisfirm AS MRPElementQuantityIsFirm,
  mrp_sol_view.orderquantityunitdisplaydcmls AS MRPElementQtyUnitDisplayDcmls,
  mrp_sol_view.orderschedulelineid_ext AS MRPElementScheduleLineExtID,
  mrp_sol_view.orderunit AS MRPElementUnit,
  mrp_sol_view.orderunitshort AS QuantityUnitTechName,
  mrp_sol_view.mrpplanningsegmentnumber AS MRPPlanningSegment,
  mrp_sol_view.mrpplanningsegmenttype AS MRPPlanningSegmentType,
  mrp_sol_view.mrpplant AS MRPPlant,
  mrp_sol_view.numerator AS QuantityNumerator,
  mrp_sol_view.orderedchangedquantity AS OrderedChangedQuantity,
  mrp_sol_view.orderedquantity AS OrderedQuantity,
  mrp_sol_view.originaltotalquant AS OriginalTotalQuantity,
  mrp_sol_view.originaltotalquantbaseunit AS BaseUnit,
  mrp_sol_view.partiallydelivered AS MRPElementIsPartiallyDelivered,
  mrp_sol_view.itemprecision AS OrderQuantityUnitDcmls,
  mrp_sol_view.proposalranking AS ProposalPriority,
  mrp_sol_view.purchasecontract AS PurchaseContract,
  mrp_sol_view.purchasecontractitem AS PurchaseContractItem,
  mrp_sol_view.purchaseordertype AS PurchaseOrderType,
  mrp_sol_view.purchasingdocumentcategory AS PurchasingDocumentCategory,
  mrp_sol_view.purchasinginforecord AS PurchasingInfoRecord,
  mrp_sol_view.purchasinggroup AS PurchasingGroup,
  mrp_sol_view.purchasingorganization AS PurchasingOrganization,
  mrp_sol_view.receivingplant AS ReceivingPlant,
  mrp_sol_view.receivingstoragelocation AS ReceivingStorageLocation,
  mrp_sol_view.released AS MRPElementIsReleased,
  mrp_sol_view.requeststatus AS MRPRequestStatus,
  mrp_sol_view.salesorder AS SalesOrder,
  mrp_sol_view.salesorderitem AS SalesOrderItem,
  mrp_sol_view.solution_option AS SolutionRequestStatus,
  mrp_sol_view.solution_type AS MaterialShortageSolutionType,
  mrp_sol_view.sourcemrpelement AS SourceMRPElement,
  mrp_sol_view.sourcemrpelementcategory AS SourceMRPElementCategory,
  mrp_sol_view.sourcemrpelementitem AS SourceMRPElementItem,
  mrp_sol_view.sourcemrpelementscheduleline AS SourceMRPElementScheduleLine,
  mrp_sol_view.storagelocation AS StorageLocation,
  mrp_sol_view.supplyingstoragelocation AS SupplyingStorageLocation,
  mrp_sol_view.supplyinthepast AS HasSuppliedInThePast,
  mrp_sol_view.targetdate AS TargetDate,
  mrp_sol_view.targetquantity AS TargetQuantity,
  mrp_sol_view.targetquantityunitdisplaydcmls AS TargetQuantityUnitDcmls,
  mrp_sol_view.targettotalquant AS TargetTotalQuantity,
  mrp_sol_view.unitofmeasurecommercialname AS UnitOfMeasure_E,
  mrp_sol_view.vendor AS Supplier,
  mrp_sol_view.vendorname AS SupplierName,
  mrp_sol_view.vendorplant AS SupplierPlant,
  mrp_sol_view.vendorstatus AS MRPRequestSupplierResponse,
  mrp_sol_view.wbselement AS WBSElement,
  mrp_sol_view.bp_type AS MRPElementBusinessPartnerType,
  mrp_sol_view.requirementcounter AS NumberOfMRPRequirements,
  mrp_sol_view.isproposal AS IsProposal,
  mrp_sol_view.issimulationactive AS MRPRunSimulationIsActive,
  ( mrp_sol_view.targettotalquant - mrp_sol_view.mrpelementopenquantity ) AS IncreaseQuantity,
  mrp_sol_view.solutionindex AS MaterialShortageSolution,
  mrp_sol_view.solutionreschedule AS NumberOfDaysToReschedule,
  mrp_sol_view.simulationquantiy AS SimulationQuantity,
  mrp_sol_view.simulationdate AS SimulationDateTime
FROM mrp_sol_view
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;