SAP WRF_PRCT_WL_SHDW Shadow Table for Worklist Items Table
Overview
WRF_PRCT_WL_SHDW is a standard SAP S/4HANA table that stores Shadow Table for Worklist Items data. There are total 39 fields in the WRF_PRCT_WL_SHDW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_PRCT_WL_SHDW belongs to Orders and Contracts (LO-RFM-PUR-POF) module and is located in the package Seasonal Procurement: DDIC Objects Procurement Controlling (WRF_PRC_CTR_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WRF_PRCT_WL_SHDW to other SAP tables and standard CDS views available based on WRF_PRCT_WL_SHDW table in S/4HANA 2020.
Techincal Settings of WRF_PRCT_WL_SHDW
Below are technical details of the table WRF_PRCT_WL_SHDW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_PRCT_WL_SHDW Fields
The following table gives you an overview of the fields available in WRF_PRCT_WL_SHDW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 |
| ETENR | Delivery Schedule Line Counter | EETEN | EKET | NUMC | 4 |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| UNAME | User Name in User Master Record | XUBNAME | * | CHAR | 12 |
| PROGRAMM | ABAP Program Name | PROGRAMM | * | CHAR | 40 |
| DL_ID | Date Line ID (GUID) | WRF_PSCD_DL_ID | CHAR | 22 | |
| BSART | Order Type (Purchasing) | BSART | * | CHAR | 4 |
| EKORG | Purchasing organization | EKORG | * | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | * | CHAR | 3 |
| BEDAT | Purchase Order Date | BEDAT | DATS | 8 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| WERKS | Plant | EWERK | * | CHAR | 4 |
| MATKL | Material Group | MATKL | * | CHAR | 9 |
| MATNR | Material Number | MATNR | * | CHAR | 40 |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| HANDOVER_DATE | Transfer Date | WRF_PSCD_HANDOVER_DATE | DATS | 8 | |
| EINDT | Item delivery date | EINDT | DATS | 8 | |
| DL_STATUS | Status of PO Item in Purchase Order Monitoring Reacting | WRF_PCTR_RCT_STATUS | NUMC | 1 | |
| NETWR | Net Order Value in PO Currency | BWERT | CURR | 13 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| NOTE_ACTIVITY | Activity Carried Out | WRF_PCTR_NOTE_ACTIVITY | * | CHAR | 4 |
| ACTIVITY_ID | Activity To Be Executed | WRF_PCTR_ACTIVITY_ID | INT1 | 3 | |
| DATESHIFT_ALWD | Indicator: Date Shift Allowed | WRF_PCTR_DATE_SHIFT_ALLWD | CHAR | 1 | |
| DUNNING_ALWD | Indicator: Reminder Allowed | WRF_PCTR_DNG_ALLWD | CHAR | 1 | |
| CNCL_ANCMT_ALWD | Indicator: Cancellation Threat Allowed | WRF_PCTR_CNCL_ANCMT_ALLWD | CHAR | 1 | |
| CANCELATION_ALWD | Indicator: Cancellation Allowed | WRF_PCTR_CNCL_ALLWD | CHAR | 1 | |
| ACTIVITY_MODE | Describes the Mode in Which Activity Is To Be Executed | WRF_PCTR_ACTIVITY_MODE | CHAR | 1 | |
| ORIGIN_DATE_ID | Triggering Date | WRF_PSCD_RESPONSIBLE_DATE_ID | * | CHAR | 18 |
| PROCESSING_TYPE | Procurement Controlling: Processing Type Remaining Quantity | WRF_PCTR_REM_QTY_PROC_TYPE | CHAR | 1 | |
| QTY_MONITOR | Monitor Quantity Variance | WRF_PCTR_QTY_MONITORING | CHAR | 1 | |
| QTY_OVERDEL | Monitor Overdelivery | WRF_PCTR_OVERDELIVERY | CHAR | 1 | |
| QTY_UNDERDEL | Monitor Underdelivery | WRF_PCTR_UNDERDELIVERY | CHAR | 1 | |
| REM_QTY_AUTO | Process Remaining Quantity Automatically | WRF_PCTR_REM_QTY_AUTO | CHAR | 1 | |
| DISTANCE | Total Interval | WRF_PSCD_DISTANCE | DEC | 3 | |
| STAT_DAT_SHIFT | Indicator: Shift Statistical Date | WRF_PCTR_STAT_DAT_SHIFT | CHAR | 1 | |
| DELAYED | Late Execution of the Activity from the Calling System | WRF_PCTR_DELAYED | CHAR | 1 | |
| DATESHIFT_NUMBER | Number of Current Date Shifts | WRF_PCTR_DATESHIFT_NUMBER | DEC | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRF_PRCT_WL_SHDW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_PRCT_WL_SHDW | EBELN | 1: CN | EKKO |
| WRF_PRCT_WL_SHDW | EBELP | 1: C | EKPO |
| WRF_PRCT_WL_SHDW | ETENR | 1: C | EKET |
| WRF_PRCT_WL_SHDW | MANDT | 1: CN | T000 |