C_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 C_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: CMRPSOLUTIONITEM

CREATE VIEW C_MRPSolutionItem AS
SELECT
  I_MRPSolutionItem.RowIndex AS RowIndex,
  I_MRPSolutionItem.MRPElement AS MRPElement,
  I_MRPSolutionItem.MRPElementItem AS MRPElementItem,
  I_MRPSolutionItem.MRPElementScheduleLine AS MRPElementScheduleLine,
  I_MRPSolutionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_MRPSolutionItem.Assembly AS Assembly,
  I_MRPSolutionItem.ChangeStateID AS ChangeStateID,
  I_MRPSolutionItem.MRPElementItemComment AS MRPElementItemComment,
  I_MRPSolutionItem.CompanyCode AS CompanyCode,
  I_MRPSolutionItem.EmailAddress AS EmailAddress,
  I_MRPSolutionItem.FullName AS FullName,
  I_MRPSolutionItem.MobilePhoneNumber AS MobilePhoneNumber,
  I_MRPSolutionItem.CurrentDeliveryQuantity AS CurrentDeliveryQuantity,
  I_MRPSolutionItem.QuantityDenominator AS QuantityDenominator,
  I_MRPSolutionItem.Material AS Material,
  I_MRPSolutionItem.MaterialBaseUnit AS MaterialBaseUnit,
  I_MRPSolutionItem.UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  I_MRPSolutionItem.MaterialExternalID AS MaterialExternalID,
  I_MRPSolutionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_MRPSolutionItem.MaterialGroupName AS MaterialGroupName,
  I_MRPSolutionItem.MaterialProcurementType AS MaterialProcurementType,
  I_MRPSolutionItem.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  I_MRPSolutionItem.MaterialShortageCriticalQty AS MaterialShortageCriticalQty,
  I_MRPSolutionItem.MaterialShortageDefinition AS MaterialShortageDefinition,
  I_MRPSolutionItem.MaterialShortageProfile AS MaterialShortageProfile,
  I_MRPSolutionItem.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  I_MRPSolutionItem.MaterialShortageQuantity AS MaterialShortageQuantity,
  I_MRPSolutionItem.MaterialShortageStartDate AS MaterialShortageStartDate,
  I_MRPSolutionItem.MaterialShortageEndDate AS MaterialShortageEndDate,
  I_MRPSolutionItem.MaterialShortageQuantityThld AS MaterialShortageQuantityThld,
  I_MRPSolutionItem.MRPArea AS MRPArea,
  I_MRPSolutionItem.AvailabilityDate AS AvailabilityDate,
  I_MRPSolutionItem.MRPAvailableQuantity AS MRPAvailableQuantity,
  I_MRPSolutionItem.MRPAvailability AS MRPAvailability,
  I_MRPSolutionItem.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  I_MRPSolutionItem.MRPElementCategory AS MRPElementCategory,
  I_MRPSolutionItem.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  I_MRPSolutionItem.MRPElementChgAvailyOrRqmtDate AS MRPElementChgAvailyOrRqmtDate,
  I_MRPSolutionItem.MRPElementChangeDeliveryDate AS MRPElementChangeDeliveryDate,
  I_MRPSolutionItem.MRPElementChangedOpenQuantity AS MRPElementChangedOpenQuantity,
  I_MRPSolutionItem.MRPElementPlndDeliveryDate AS MRPElementPlndDeliveryDate,
  I_MRPSolutionItem.MRPElementDocumentType AS MRPElementDocumentType,
  I_MRPSolutionItem.MRPElementDocumentTypeName AS MRPElementDocumentTypeName,
  I_MRPSolutionItem.MRPElementExternalID AS MRPElementExternalID,
  I_MRPSolutionItem.MRPElementItemExternalID AS MRPElementItemExternalID,
  I_MRPSolutionItem.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  I_MRPSolutionItem.MRPElementQuantityIsFirm AS MRPElementQuantityIsFirm,
  I_MRPSolutionItem.MRPElementQtyUnitDisplayDcmls AS MRPElementQtyUnitDisplayDcmls,
  I_MRPSolutionItem.MRPElementScheduleLineExtID AS MRPElementScheduleLineExtID,
  I_MRPSolutionItem.MRPElementUnit AS MRPElementUnit,
  I_MRPSolutionItem.UnitOfMeasure_E AS UnitOfMeasure_E,
  I_MRPSolutionItem.QuantityUnitTechName AS QuantityUnitTechName,
  I_MRPSolutionItem.MRPPlanningSegment AS MRPPlanningSegment,
  I_MRPSolutionItem.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  I_MRPSolutionItem.MRPPlant AS MRPPlant,
  I_MRPSolutionItem.QuantityNumerator AS QuantityNumerator,
  I_MRPSolutionItem.OrderedChangedQuantity AS OrderedChangedQuantity,
  I_MRPSolutionItem.OrderedQuantity AS OrderedQuantity,
  I_MRPSolutionItem.OriginalTotalQuantity AS OriginalTotalQuantity,
  I_MRPSolutionItem.BaseUnit AS BaseUnit,
  I_MRPSolutionItem.MRPElementIsPartiallyDelivered AS MRPElementIsPartiallyDelivered,
  I_MRPSolutionItem.OrderQuantityUnitDcmls AS OrderQuantityUnitDcmls,
  I_MRPSolutionItem.ProposalPriority AS ProposalPriority,
  I_MRPSolutionItem.PurchaseContract AS PurchaseContract,
  I_MRPSolutionItem.PurchaseContractItem AS PurchaseContractItem,
  I_MRPSolutionItem.PurchaseOrderType AS PurchaseOrderType,
  I_MRPSolutionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_MRPSolutionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_MRPSolutionItem.PurchasingGroup AS PurchasingGroup,
  I_MRPSolutionItem.PurchasingOrganization AS PurchasingOrganization,
  I_MRPSolutionItem.ReceivingPlant AS ReceivingPlant,
  I_MRPSolutionItem.ReceivingStorageLocation AS ReceivingStorageLocation,
  I_MRPSolutionItem.MRPElementIsReleased AS MRPElementIsReleased,
  I_MRPSolutionItem.MRPRequestStatus AS MRPRequestStatus,
  I_MRPSolutionItem.SalesOrder AS SalesOrder,
  I_MRPSolutionItem.SalesOrderItem AS SalesOrderItem,
  I_MRPSolutionItem.SolutionRequestStatus AS SolutionRequestStatus,
  I_MRPSolutionItem.MaterialShortageSolutionType AS MaterialShortageSolutionType,
  I_MRPSolutionItem.SourceMRPElement AS SourceMRPElement,
  I_MRPSolutionItem.SourceMRPElementCategory AS SourceMRPElementCategory,
  I_MRPSolutionItem.SourceMRPElementItem AS SourceMRPElementItem,
  I_MRPSolutionItem.SourceMRPElementScheduleLine AS SourceMRPElementScheduleLine,
  I_MRPSolutionItem.StorageLocation AS StorageLocation,
  I_MRPSolutionItem.SupplyingStorageLocation AS SupplyingStorageLocation,
  I_MRPSolutionItem.HasSuppliedInThePast AS HasSuppliedInThePast,
  I_MRPSolutionItem.TargetDate AS TargetDate,
  I_MRPSolutionItem.TargetQuantity AS TargetQuantity,
  I_MRPSolutionItem.TargetQuantityUnitDcmls AS TargetQuantityUnitDcmls,
  I_MRPSolutionItem.TargetTotalQuantity AS TargetTotalQuantity,
  I_MRPSolutionItem.Supplier AS Supplier,
  I_MRPSolutionItem.SupplierName AS SupplierName,
  I_MRPSolutionItem.SupplierPlant AS SupplierPlant,
  I_MRPSolutionItem.MRPRequestSupplierResponse AS MRPRequestSupplierResponse,
  I_MRPSolutionItem.WBSElement AS WBSElement,
  I_MRPSolutionItem.NumberOfMRPRequirements AS NumberOfMRPRequirements,
  I_MRPSolutionItem.IsProposal AS IsProposal,
  I_MRPSolutionItem.MRPRunSimulationIsActive AS MRPRunSimulationIsActive,
  I_MRPSolutionItem.MRPElementBusinessPartnerType AS MRPElementBusinessPartnerType,
  I_MRPSolutionItem.IncreaseQuantity AS IncreaseQuantity,
  I_MRPSolutionItem.MaterialShortageSolution AS MaterialShortageSolution,
  I_MRPSolutionItem.NumberOfDaysToReschedule AS NumberOfDaysToReschedule,
  I_MRPSolutionItem.SimulationQuantity AS SimulationQuantity,
  I_MRPSolutionItem.SimulationDateTime AS SimulationDateTime
FROM I_MRPSolutionItem
;