I_MATERIALSHORTAGEDEFINITION

CDS View
3 Fields 7 CDS Views

MRP Material Shortage Definition

I_MATERIALSHORTAGEDEFINITION is a CDS View in S/4HANA. MRP Material Shortage Definition. It contains 3 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_MaterialShortageDefinition view from CONSUMPTION MRP Material Shortage Definition
C_MRPExternalRequirement view_entity inner CONSUMPTION MRP External Requirement
C_MRPInternalRequirement view_entity inner CONSUMPTION MRP Internal Requirement
I_CacheMRPMfgOrder view left_outer COMPOSITE Cache MRP Manufacturing Orders
I_MaterialCoverage view left_outer COMPOSITE MRP Material Coverage
I_MaterialSelectionVH view_entity inner COMPOSITE Material Selection ID
P_MRPProdDemandAggregation view left_outer COMPOSITE

Fields (3)

KeyField CDS FieldsUsed in Views
KEY MaterialShortageProfile MaterialShortageProfile 2
KEY MaterialShortageProfileCount MaterialShortageProfileCount 2
MaterialShortageDefinitionName MaterialShortageDefinitionName 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 Material Shortage Definition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALSHORTAGEDEFINITION (
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MATERIALSHORTAGEDEFINITIONNAME,
    PRIMARY KEY (MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT)
);

Learn More