I_MATERIALTEXT

CDS View
3 Fields 23 CDS Views

Material Text

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

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_PH_InventoryQuery view inner CONSUMPTION Ph Inventory Query Philippines
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_ACMApplicationOverview view left_outer TRANSACTIONAL Interface Layer for ACM Application Overview
I_ACMMaterialValueText view from COMPOSITE Interface for Material Description
I_ACMPrcgMaterialValueHelp view from COMPOSITE
I_MatlsValueHelp view from COMPOSITE
I_SettlementUnitLienHldrData view left_outer BASIC Interface layer for Unit Lien Data
I_SupDmndOvwAssgmtCube view left_outer COMPOSITE Supply Demand Overview Cube View(MDR)
I_SupDmndOvwCube view left_outer COMPOSITE Supply Demand Overview Cube View
P_CnsldtnMaterialT view from COMPOSITE
P_HU_MMInvoiceConsignment view inner COMPOSITE
P_HU_MMINVOICECONSIGNMENTNEWR view_entity inner COMPOSITE
P_material_value_help view from COMPOSITE
P_Product_Fs view left_outer BASIC
P_Salesview_Fs view left_outer COMPOSITE
R_DCBProductText view_entity from BASIC Deal Capture Product - Text
R_EvtBsdPostingRuleRcvrName view from COMPOSITE EB Posting Rule Receiver Name

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Language Language 2
KEY Material Material 1
MaterialName MaterialDescription,MaterialName,ProductName 14

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

Learn More