SAP PGWIL Work item list for static pegging Table data and field list

PGWIL is a standard SAP Table which is used to store Work item list for static pegging data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PGWIL table consists of various fields, each holding specific information or linking keys about Work item list for static pegging data available in SAP. These include OBJNR (Object), COUNTER (Counter for entries in worklist (static pegging)), PSPNR (Work Breakdown Structure Element (WBS Element)), WERKS (Plant)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PGWIL table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP PGWIL table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PGWIL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
OBJNRObject J_OBJNROUTCHAR22OBJNRJ_OBJNROUTONR
COUNTERCounter for entries in worklist (static pegging) PGWLCNTNUMC4NUMC04
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
DQUANQuantity difference (+/-) for work item list in base unit PGDQUANQUAN13(3) MENGV13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
GRDATPlanned goods receipt date of replenishment element PGGRDATDATS8SYDATS

Key field Non-key field



How do I retrieve data from SAP table PGWIL using ABAP code

The following ABAP code Example will allow you to do a basic selection on PGWIL to SELECT all data from the table
DATA: WA_PGWIL TYPE PGWIL.

SELECT SINGLE *
FROM PGWIL
INTO CORRESPONDING FIELDS OF WA_PGWIL
WHERE...

How to access SAP table PGWIL

Within an ECC or HANA version of SAP you can also view further information about PGWIL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).