_MATASSG

6 Fields

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

Fields (6)

KeyField CDS FieldsUsed in Views
KEY MasterRecipe MasterRecipe 1
KEY MasterRecipeGroup MasterRecipeGroup 1
KEY Plant Plant 1
KEY Product Product 3
KEY ValidityEndDate ValidityEndDate 1
KEY ValidityStartDate ValidityStartDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MATASSG (
    MASTERRECIPE,
    MASTERRECIPEGROUP,
    PLANT,
    PRODUCT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (MASTERRECIPE, MASTERRECIPEGROUP, PLANT, PRODUCT, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More