_MATERIALTEXT

4 Fields

_MATERIALTEXT is an SAP database table in S/4HANA. It contains 4 fields.

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language Language 2
KEY ProductDescription ProductDescription 6
MaterialName ComponentDescription,FashionGenericMaterialName,MaterialDesc,MaterialName,ParentMaterialName,ProductName,PurchaseOrderItemText,SourceMaterialName 121
ProductName MaterialName,ProductName 4

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MATERIALTEXT (
    LANGUAGE,
    PRODUCTDESCRIPTION,
    MATERIALNAME,
    PRODUCTNAME,
    PRIMARY KEY (LANGUAGE, PRODUCTDESCRIPTION)
);

Learn More