I_PRODTOEXPLICITASSTMTMODULE

CDS View

Product Assignment to Assortment Module

I_PRODTOEXPLICITASSTMTMODULE is a CDS View in S/4HANA. Product Assignment to Assortment Module. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProdAssgblToExplctModuleTP view_entity inner TRANSACTIONAL Product Assignable to Assortment Module
I_ProdAssgblToExplctModuleTP view_entity left_outer TRANSACTIONAL Product Assignable to Assortment Module
I_ProdToExplicitAsstmtMdlTP view_entity from TRANSACTIONAL Product Assignment to Assortment Module

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleUUID AssortmentModuleUUID 1
KEY Product Product 1
_Product _Product 1
_Text _Text 1
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment 1
ValidityEndDate ValidityEndDate 1
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.

-- Product Assignment to Assortment Module
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODTOEXPLICITASSTMTMODULE (
    ASSORTMENTMODULEUUID,
    PRODUCT,
    _PRODUCT,
    _TEXT,
    PRODUCTISMANDATORYINASSORTMENT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ASSORTMENTMODULEUUID, PRODUCT)
);