I_PRODTOEXPLICITASSTMTMODULE

CDS View
11 Fields 3 CDS Views

Product Assignment to Assortment Module

I_PRODTOEXPLICITASSTMTMODULE is a CDS View in S/4HANA. Product Assignment to Assortment Module. It contains 11 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 (11)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleName AssortmentModuleName 1
KEY AssortmentModuleUUID AssortmentModuleUUID 2
KEY Product Product 2
_ModuleVersion _ModuleVersion 1
_Product _Product 2
_Text _Text 2
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 (
    ASSORTMENTMODULENAME,
    ASSORTMENTMODULEUUID,
    PRODUCT,
    _MODULEVERSION,
    _PRODUCT,
    _TEXT,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    PRODUCTISMANDATORYINASSORTMENT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ASSORTMENTMODULENAME, ASSORTMENTMODULEUUID, PRODUCT)
);

Learn More