WRF_POTB_DB1 SAP table for – Worklist OTB Procurement

Here we would like to draw your attention to WRF_POTB_DB1 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_POTB_DB1 is a SAP standard transparent table used for storing Worklist OTB Procurement related data in SAP. It comes under the package WRF_PRC_OTB_DDIC.

SAP WRF_POTB_DB1 table

Table WRF_POTB_DB1 technical data

TableWRF_POTB_DB1
Data storingWorklist OTB Procurement
ModuleMM
ComponentMM-PUR
SAP PackageWRF_PRC_OTB_DDIC
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WRF_POTB_DB1 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_POTB_DB1 table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is WRF_POTB_KEYFIELDS_STY
  • 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
  • BSART
    Its data type is C (Character String) with field length 4
  • SUBMI
    Its data type is C (Character String) with field length 10
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UNAME : User Name
    Its data type is C (Character String) with field length 12
  • PROGRAMM
    Its data type is C (Character String) with field length 40
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • EBELN : Purchasing Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • BSTYP
    Its data type is C (Character String) with field length 1
  • POHF_TYPE
    Its data type is C (Character String) with field length 1
  • SPR_STATUS
    Its data type is C (Character String) with field length 2
  • RSN_PROFILE
    Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10