I_MATERIALMRPAREA

CDS View
13 Fields 8 CDS Views

MRP Area Details for Material

I_MATERIALMRPAREA is a CDS View in S/4HANA. MRP Area Details for Material. It contains 13 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_DemandDrivenMaterialData view from BASIC Data related to materials
I_MRPMfgOrderItem view left_outer COMPOSITE MRP Manufacturing Order Item
I_ProductPlantMRPArea view union_all COMPOSITE Product Details By Plant and MRP Area
I_ProductPlantMRPAreaVH view union_all COMPOSITE Value Help for Product Details By Plant and MRP Area
P_DDMATERIAL view union COMPOSITE
P_FallBackTargetStock view left_outer BASIC
P_ProductMasterLeadTime view inner CONSUMPTION Lead Time Details from Product Master
P_SubcontrgResvnStk view inner COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPArea MRPArea 5
KEY Plant Plant 4
LotSizingProcedure LotSizingProcedure 1
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity 1
MaterialProcurementProfile MaterialProcurementProfile 1
MinimumLotSizeQuantity MinimumLotSizeQuantity 1
MRPController MRPController 2
MRPGroup MRPGroup 2
MRPType MRPType 2
PlanningTimeFence PlanningTimeFence 1
ReorderThresholdQuantity ReorderThresholdQuantity 1
SafetyStockQuantity SafetyStockQuantity 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 Area Details for Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALMRPAREA (
    MATERIAL,
    MRPAREA,
    PLANT,
    LOTSIZINGPROCEDURE,
    MATERIALMAXSTOCKLEVELQUANTITY,
    MATERIALPROCUREMENTPROFILE,
    MINIMUMLOTSIZEQUANTITY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPTYPE,
    PLANNINGTIMEFENCE,
    REORDERTHRESHOLDQUANTITY,
    SAFETYSTOCKQUANTITY,
    PRIMARY KEY (MATERIAL, MRPAREA, PLANT)
);

Learn More