ESPP_PRDGRP_STRE

Transparent Table Application Table

Product Group Selection Tree

ESPP_PRDGRP_STRE is an SAP database table in S/4HANA. Product Group Selection Tree. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrvcPrtsProdGrpSelCondition view_entity from BASIC Product Group Selection Conditions

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY name ESPP_PRODGROUP_SELECTION_NAME Prod Group Selection
KEY id ESPP_PRODGROUP_SLCTN_COND_ID Condition ID
parent ESPP_PRODGROUP_SLCTN_PARENT_ID Condition Parent ID
connector ESPP_PRODGROUP_SLCTN_CONNECT Condition Connector
matgrptype /SAPAPO/MATGRPTYPE Prod. Group Type
sign /SAPAPO/SIGN_RANGE Sign
opt /SAPAPO/OPTION_RANGE Option
low /SAPAPO/GROUPVALUE Product Group
high /SAPAPO/GROUPVALUE Product Group

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 Group Selection Tree
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESPP_PRDGRP_STRE (
    CLIENT,      -- abap.clnt
    NAME,        -- Prod Group Selection [ESPP_PRODGROUP_SELECTION_NAME]
    ID,          -- Condition ID [ESPP_PRODGROUP_SLCTN_COND_ID]
    PARENT,      -- Condition Parent ID [ESPP_PRODGROUP_SLCTN_PARENT_ID]
    CONNECTOR,   -- Condition Connector [ESPP_PRODGROUP_SLCTN_CONNECT]
    MATGRPTYPE,  -- Prod. Group Type [/SAPAPO/MATGRPTYPE]
    SIGN,        -- Sign [/SAPAPO/SIGN_RANGE]
    OPT,         -- Option [/SAPAPO/OPTION_RANGE]
    LOW,         -- Product Group [/SAPAPO/GROUPVALUE]
    HIGH,        -- Product Group [/SAPAPO/GROUPVALUE]
    PRIMARY KEY (CLIENT, NAME, ID)
);