I_MATERIALPLANT

CDS View
5 Fields 32 CDS Views

Material Plant

I_MATERIALPLANT is a CDS View in S/4HANA. Material Plant. It contains 5 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
C_InspPlanMatlPlantVH view from CONSUMPTION Material-Plant Value Help
C_InvtryTurnoverAnlysDets view from CONSUMPTION Inventory Turnover Analysis Details
C_MaintCompPlantWithStockVH view_entity from CONSUMPTION Plant with stock
C_MassUpdtMaterialVH view inner CONSUMPTION Material Value Help
C_MfgMaterialVH view from CONSUMPTION Mfg Material Value Help
C_MM_MaterialValueHelp view from CONSUMPTION Material Value Help
C_MngProdnRtgPlantMaterialVH view_entity from CONSUMPTION Plant Materials of a Shop Floor Routing
C_ProdnVersMatlPlntVH view from CONSUMPTION Material Plant Value Help
C_PurOrdMaintainUoMValHelp view left_outer CONSUMPTION Value Help Unit of measure
C_ResvnDocMaterialByPlantVH view from CONSUMPTION Material by Plant Value Help
C_RptvManufacturingProductVH view inner CONSUMPTION Repetitive Manufacturing Product
C_SalesDocumentItemPlantVH view from CONSUMPTION Plant
C_SSPProductVH view inner CONSUMPTION Product (Material) Value help for SSP PR
C_SubcontrgBatchVH view inner CONSUMPTION Batch Value Help
I_BatchVH view inner COMPOSITE Batch
I_BG_SAFTProduct view_entity inner COMPOSITE BG SAFT Products
I_EvaltCapWrkCtrGrpAreaOfRespy view_entity inner COMPOSITE Work Center Group Area of Responsibility
I_JITMaterialPlant view from COMPOSITE Material Plant info for JIT calls
I_MaterialStorLocMRPArea view from COMPOSITE Material Storage Location MRP Area Assignment
I_PlantMaterialCount view from COMPOSITE Count of materials in plant
I_RO_SAFTProduct view inner COMPOSITE RO SAFT Products
I_WrkCtrCapByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
P_DDOrderDetails view inner CONSUMPTION
P_DGR_Gen_PlantCCode_Material view inner COMPOSITE
P_JITStockAvailabilityAnlys view from COMPOSITE
P_MaterialPlantAreaOfRespy view_entity from COMPOSITE Material and Plant data
P_MaterialPriceVariance view inner CONSUMPTION Material Price Variance
P_MPE_MaterialMrpArea view_entity from CONSUMPTION Material Plant with MRP Area
P_MPE_MaterialMrpArea view_entity inner CONSUMPTION Material Plant with MRP Area
P_MPE_MaterialMrpArea view_entity union_all CONSUMPTION Material Plant with MRP Area
P_SchedProdnAORIndustryType view inner COMPOSITE
P_SpecAssignedMatlForKeyDate view left_outer COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Material Material,Product 12
KEY Plant MRPArea,Plant 18
_Material _Material 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MRPController MRPController 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.

-- Material Plant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALPLANT (
    MATERIAL,
    PLANT,
    _MATERIAL,
    MATERIALSAFETYSTOCKQTY,
    MRPCONTROLLER,
    PRIMARY KEY (MATERIAL, PLANT)
);

Learn More