PGMI

Transparent Table Application Table
12 Fields 1 CDS Views

Product Group/Member Allocation

PGMI is an SAP database table in S/4HANA. Product Group/Member Allocation. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductPlantPlanning view from BASIC Product Plant Planning Details

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pgtyp PGTYP Prd. group type
KEY prgrp PRGRP Product group
KEY werks WERKS_D Plant
KEY nrmit PRGRP Product group
KEY wemit WERKS_D Plant
KEY datum BISDAT Valid to
KEY vsnda VSNDA Prod. Version
prkof PRKOFF Factor
antei DANTEF Proportion
fixkz PGFIX FixedBranchInfo
statu PGSTA_D Branch status

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/Member Allocation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PGMI (
    MANDT,  -- Client [MANDT]
    PGTYP,  -- Prd. group type [PGTYP]
    PRGRP,  -- Product group [PRGRP]
    WERKS,  -- Plant [WERKS_D]
    NRMIT,  -- Product group [PRGRP]
    WEMIT,  -- Plant [WERKS_D]
    DATUM,  -- Valid to [BISDAT]
    VSNDA,  -- Prod. Version [VSNDA]
    PRKOF,  -- Factor [PRKOFF]
    ANTEI,  -- Proportion [DANTEF]
    FIXKZ,  -- FixedBranchInfo [PGFIX]
    STATU,  -- Branch status [PGSTA_D]
    PRIMARY KEY (MANDT, PGTYP, PRGRP, WERKS, NRMIT, WEMIT, DATUM, VSNDA)
);

Learn More