AVORRAT SAP table for – Worklist

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

SAP AVORRAT table

Table AVORRAT technical data

TableAVORRAT
Data storingWorklist
ModuleMM
ComponentMM-PUR
SAP PackageWBON
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AVORRAT 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 AVORRAT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BRZET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • BNAME
    Its data type is C (Character String) with field length 12
  • BSTAT
    Its data type is C (Character String) with field length 1
  • PERF_MESS
    Its data type is N (Character String with Digits Only) with field length 10
  • OBJTYP
    Its a key field. Its data type is C (Character String) with field length 2
  • OBJVWD
    Its a key field. Its data type is C (Character String) with field length 2
  • OBJVER
    Its a key field. Its data type is C (Character String) with field length 12
  • OBJVAKEY
    Its a key field. Its data type is C (Character String) with field length 50
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is AVORRAT_DATA
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ENAME
    Its data type is C (Character String) with field length 12