WRF_PRCT_WL_SHDW SAP table for – Shadow Table for Worklist Items

Here we would like to draw your attention to WRF_PRCT_WL_SHDW table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). WRF_PRCT_WL_SHDW is a SAP standard transparent table used for storing Shadow Table for Worklist Items related data in SAP. It comes under the package WRF_PRC_CTR_DDIC.

SAP WRF_PRCT_WL_SHDW table

Table WRF_PRCT_WL_SHDW technical data

TableWRF_PRCT_WL_SHDW
Data storingShadow Table for Worklist Items
ModuleMM
ComponentMM-PUR
SAP PackageWRF_PRC_CTR_DDIC
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WRF_PRCT_WL_SHDW Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in WRF_PRCT_WL_SHDW table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DL_ID
    Its data type is C (Character String) with field length 22
  • FOLDER_ID
    Its data type is C (Character String) with field length 8
  • BSART
    Its data type is C (Character String) with field length 4
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • BEDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is WRF_PCTR_RCT_WL_KEYS_STY
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • HANDOVER_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EINDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DL_STATUS
    Its data type is N (Character String with Digits Only) with field length 1
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • NOTE_ACTIVITY
    Its data type is C (Character String) with field length 4
  • ACTIVITY_ID : Configuration Activity ID
    Its data type is X (Byte string) with field length 1
  • EBELN : Purchasing Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • DATESHIFT_ALWD
    Its data type is C (Character String) with field length 1
  • DUNNING_ALWD
    Its data type is C (Character String) with field length 1
  • CNCL_ANCMT_ALWD
    Its data type is C (Character String) with field length 1
  • CANCELATION_ALWD
    Its data type is C (Character String) with field length 1
  • ACTIVITY_MODE
    Its data type is C (Character String) with field length 1
  • ORIGIN_DATE_ID
    Its data type is C (Character String) with field length 18
  • PROCESSING_TYPE
    Its data type is C (Character String) with field length 1
  • QTY_MONITOR
    Its data type is C (Character String) with field length 1
  • QTY_OVERDEL
    Its data type is C (Character String) with field length 1
  • QTY_UNDERDEL
    Its data type is C (Character String) with field length 1
  • EBELP : Item Number of Purchasing Document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • REM_QTY_AUTO
    Its data type is C (Character String) with field length 1
  • DISTANCE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • STAT_DAT_SHIFT
    Its data type is C (Character String) with field length 1
  • DELAYED
    Its data type is C (Character String) with field length 1
  • DATESHIFT_NUMBER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • ETENR : Delivery Schedule Line Counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its a key field. Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UNAME : User Name
    Its a key field. Its data type is C (Character String) with field length 12
  • PROGRAMM
    Its a key field. Its data type is C (Character String) with field length 40