I_MRPSOLUTIONITEM

CDS View
103 Fields 1 CDS Views

MRP Solution View Items

I_MRPSOLUTIONITEM is a CDS View in S/4HANA. MRP Solution View Items. It contains 103 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MRPSolutionItem view from CONSUMPTION MRP Solution Item

Fields (103)

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- MRP Solution View Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPSOLUTIONITEM (
    MRPELEMENT,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    ROWINDEX,
    ACCOUNTASSIGNMENTCATEGORY,
    ASSEMBLY,
    AVAILABILITYDATE,
    BASEUNIT,
    CHANGESTATEID,
    COMPANYCODE,
    CURRENTDELIVERYQUANTITY,
    EMAILADDRESS,
    FULLNAME,
    HASSUPPLIEDINTHEPAST,
    INCREASEQUANTITY,
    ISPROPOSAL,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALEXTERNALID,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUPNAME,
    MATERIALPROCUREMENTTYPE,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGECRITICALQTY,
    MATERIALSHORTAGEDEFINITION,
    MATERIALSHORTAGEENDDATE,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MATERIALSHORTAGEQUANTITY,
    MATERIALSHORTAGEQUANTITYTHLD,
    MATERIALSHORTAGESOLUTION,
    MATERIALSHORTAGESOLUTIONTYPE,
    MATERIALSHORTAGESTARTDATE,
    MOBILEPHONENUMBER,
    MRPAREA,
    MRPAVAILABILITY,
    MRPAVAILABLEQUANTITY,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTBUSINESSPARTNERTYPE,
    MRPELEMENTCATEGORY,
    MRPELEMENTCATEGORYSHORTNAME,
    MRPELEMENTCHANGEDELIVERYDATE,
    MRPELEMENTCHANGEDOPENQUANTITY,
    MRPELEMENTCHGAVAILYORRQMTDATE,
    MRPELEMENTDOCUMENTTYPE,
    MRPELEMENTDOCUMENTTYPENAME,
    MRPELEMENTEXTERNALID,
    MRPELEMENTISPARTIALLYDELIVERED,
    MRPELEMENTISRELEASED,
    MRPELEMENTITEMCOMMENT,
    MRPELEMENTITEMEXTERNALID,
    MRPELEMENTOPENQUANTITY,
    MRPELEMENTPLNDDELIVERYDATE,
    MRPELEMENTQTYUNITDISPLAYDCMLS,
    MRPELEMENTQUANTITYISFIRM,
    MRPELEMENTSCHEDULELINEEXTID,
    MRPELEMENTUNIT,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    MRPREQUESTSTATUS,
    MRPREQUESTSUPPLIERRESPONSE,
    MRPRUNSIMULATIONISACTIVE,
    NUMBEROFDAYSTORESCHEDULE,
    NUMBEROFMRPREQUIREMENTS,
    ORDEREDCHANGEDQUANTITY,
    ORDEREDQUANTITY,
    ORDERQUANTITYUNITDCMLS,
    ORIGINALTOTALQUANTITY,
    PROPOSALPRIORITY,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERTYPE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    QUANTITYDENOMINATOR,
    QUANTITYNUMERATOR,
    QUANTITYUNITTECHNAME,
    RECEIVINGPLANT,
    RECEIVINGSTORAGELOCATION,
    SALESORDER,
    SALESORDERITEM,
    SIMULATIONDATETIME,
    SIMULATIONQUANTITY,
    SOLUTIONREQUESTSTATUS,
    SOURCEMRPELEMENT,
    SOURCEMRPELEMENTCATEGORY,
    SOURCEMRPELEMENTITEM,
    SOURCEMRPELEMENTSCHEDULELINE,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERPLANT,
    SUPPLYINGSTORAGELOCATION,
    TARGETDATE,
    TARGETQUANTITY,
    TARGETQUANTITYUNITDCMLS,
    TARGETTOTALQUANTITY,
    UNITOFMEASURE_E,
    UNITOFMEASURETECHNICALNAME,
    WBSELEMENT,
    PRIMARY KEY (MRPELEMENT, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, ROWINDEX)
);

Learn More