I_STOCKREQUIREMENTITEM

CDS View
52 Fields 1 CDS Views

MRP Stock Requirement Item

I_STOCKREQUIREMENTITEM is a CDS View in S/4HANA. MRP Stock Requirement Item. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_StockRequirementItem view from CONSUMPTION MRP Stock Requirement Item

Fields (52)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MaterialShortageDefinition MaterialShortageDefinition 1
KEY MRPArea MRPArea 1
KEY MRPPlanningSegment MRPPlanningSegment 1
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 1
KEY RowIndex RowIndex 1
AggregationDemandProfile AggregationDemandProfile 1
AggregationSupplyProfile AggregationSupplyProfile 1
Assembly Assembly 1
HasDecisionSupport HasDecisionSupport 1
HasSuppliedInThePast HasSuppliedInThePast 1
HorizonForSelectionInDays HorizonForSelectionInDays 1
IsNonAggregated IsNonAggregated 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialExternalID MaterialExternalID 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialShortageCriticalQty MaterialShortageCriticalQty 1
MaterialShortageQuantityThld MaterialShortageQuantityThld 1
MaterialShortageStatus MaterialShortageStatus 1
MfgOrderStatusInternalCode MfgOrderStatusInternalCode 1
MRPAvailability MRPAvailability 1
MRPAvailableQuantity MRPAvailableQuantity 1
MRPElement MRPElement 1
MRPElementAvailyOrRqmtDate MRPElementAvailyOrRqmtDate 1
MRPElementBusinessPartner MRPElementBusinessPartner 1
MRPElementBusinessPartnerName MRPElementBusinessPartnerName 1
MRPElementBusinessPartnerType MRPElementBusinessPartnerType 1
MRPElementCategory MRPElementCategory 1
MRPElementCategoryGroupName MRPElementCategoryGroupName 1
MRPElementCategoryShortName MRPElementCategoryShortName 1
MRPElementDocumentType MRPElementDocumentType 1
MRPElementDocumentTypeName MRPElementDocumentTypeName 1
MRPElementIsPartiallyDelivered MRPElementIsPartiallyDelivered 1
MRPElementIsReleased MRPElementIsReleased 1
MRPElementItem MRPElementItem 1
MRPElementOpenQuantity MRPElementOpenQuantity 1
MRPElementQuantityIsFirm MRPElementQuantityIsFirm 1
MRPElementScheduleLine MRPElementScheduleLine 1
MRPRequestSupplierResponse MRPRequestSupplierResponse 1
ProductionVersion ProductionVersion 1
QuantityUnitDcmls QuantityUnitDcmls 1
RequirementPlan RequirementPlan 1
SolutionRequestStatus SolutionRequestStatus 1
SourceMRPElement SourceMRPElement 1
SourceMRPElementCategory SourceMRPElementCategory 1
SourceMRPElementItem SourceMRPElementItem 1
SourceMRPElementScheduleLine SourceMRPElementScheduleLine 1
StorageLocation StorageLocation 1
TargetQuantityUnitDcmls TargetQuantityUnitDcmls 1
UnitOfMeasure_E UnitOfMeasure_E 1
UnitOfMeasureTechnicalName UnitOfMeasureTechnicalName 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 Stock Requirement Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STOCKREQUIREMENTITEM (
    MATERIAL,
    MATERIALSHORTAGEDEFINITION,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    ROWINDEX,
    AGGREGATIONDEMANDPROFILE,
    AGGREGATIONSUPPLYPROFILE,
    ASSEMBLY,
    HASDECISIONSUPPORT,
    HASSUPPLIEDINTHEPAST,
    HORIZONFORSELECTIONINDAYS,
    ISNONAGGREGATED,
    MATERIALBASEUNIT,
    MATERIALEXTERNALID,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGECRITICALQTY,
    MATERIALSHORTAGEQUANTITYTHLD,
    MATERIALSHORTAGESTATUS,
    MFGORDERSTATUSINTERNALCODE,
    MRPAVAILABILITY,
    MRPAVAILABLEQUANTITY,
    MRPELEMENT,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTBUSINESSPARTNER,
    MRPELEMENTBUSINESSPARTNERNAME,
    MRPELEMENTBUSINESSPARTNERTYPE,
    MRPELEMENTCATEGORY,
    MRPELEMENTCATEGORYGROUPNAME,
    MRPELEMENTCATEGORYSHORTNAME,
    MRPELEMENTDOCUMENTTYPE,
    MRPELEMENTDOCUMENTTYPENAME,
    MRPELEMENTISPARTIALLYDELIVERED,
    MRPELEMENTISRELEASED,
    MRPELEMENTITEM,
    MRPELEMENTOPENQUANTITY,
    MRPELEMENTQUANTITYISFIRM,
    MRPELEMENTSCHEDULELINE,
    MRPREQUESTSUPPLIERRESPONSE,
    PRODUCTIONVERSION,
    QUANTITYUNITDCMLS,
    REQUIREMENTPLAN,
    SOLUTIONREQUESTSTATUS,
    SOURCEMRPELEMENT,
    SOURCEMRPELEMENTCATEGORY,
    SOURCEMRPELEMENTITEM,
    SOURCEMRPELEMENTSCHEDULELINE,
    STORAGELOCATION,
    TARGETQUANTITYUNITDCMLS,
    UNITOFMEASURE_E,
    UNITOFMEASURETECHNICALNAME,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEDEFINITION, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT, ROWINDEX)
);

Learn More