SAP table WAGPD (Plant/customer group items)

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

WAGPD foreign key relationships

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