1. Home
  2. Resources
  3. SAP Tables
  4. WAGPD - Plant/customer group items

SAP Table WAGPD

Plant/customer group items

WAGPD (Plant/customer group items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WAGPD to other SAP tables.

Source: WAGPD (Plant/customer group items)

WAGPD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
POSNR Item number W_POSNR NUMC 6 0
UPOSN Sub-item number for item number W_UPOSN NUMC 6 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
LOCNR Customer Number for Plant LOCNR KNA1 CHAR 10 0
WERKS Plant WERKS_D T001W CHAR 4 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
NAME1 Name 1 NAME1_GP CHAR 35 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
UPDKZ Update indicator UPDKZ_D CHAR 1 0

WAGPD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WAGPD AKTNR WAGPD MANDT WAKH Promotion Header Data, IS-R MANDT
WAGPD AKTNR WAGPD AKTNR WAKH Promotion Header Data, IS-R AKTNR
WAGPD KUNNR WAGPD MANDT KNA1 General Data in Customer Master MANDT
WAGPD KUNNR WAGPD KUNNR KNA1 General Data in Customer Master KUNNR
WAGPD LOCNR WAGPD MANDT KNA1 General Data in Customer Master MANDT
WAGPD LOCNR WAGPD LOCNR KNA1 General Data in Customer Master KUNNR
WAGPD MANDT WAGPD MANDT T000 Clients MANDT
WAGPD WERKS WAGPD MANDT T001W Plants/Branches MANDT
WAGPD WERKS WAGPD WERKS T001W Plants/Branches WERKS