I_MATERIALGROUPTEXT

CDS View
3 Fields 13 CDS Views

Material Group Text

I_MATERIALGROUPTEXT is a CDS View in S/4HANA. Material Group Text. It contains 3 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_MaterialGroupLongText view from CONSUMPTION Text of a material group
C_SupDmndOpenDelivQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwDmndItmQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwSupAssgmtQuery view left_outer CONSUMPTION Consumption view for Assignments
C_SupDmndOvwTotDmndQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwTotSupQuery view left_outer CONSUMPTION Query View for Total Supply
C_SupDmndTotSlsOrdQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSTOQuery view left_outer CONSUMPTION Query View for Total Demand
I_SupDmndOvwAssgmtCube view left_outer COMPOSITE Supply Demand Overview Cube View(MDR)
I_SupDmndOvwCube view left_outer COMPOSITE Supply Demand Overview Cube View
P_CnsldtnMaterialGroupT view from COMPOSITE Consolidation Combined Material Group Text
P_Prchinforecords_FS view left_outer BASIC private factsheet - purchasing info records
P_Product_Fs view left_outer BASIC Private Factsheet - Product

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY MaterialGroup MaterialGroup 1
MaterialGroupName MaterialGroupName 10

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 Group Text
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALGROUPTEXT (
    LANGUAGE,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    PRIMARY KEY (LANGUAGE, MATERIALGROUP)
);

Learn More