UPC_STATISTIC3 SAP table for – Statistic for Executing Planning Functions

Here we would like to draw your attention to UPC_STATISTIC3 table in SAP. As we know it is being mainly used with the SAP BW-PLA (Planning in BW) component which is coming under BW module (Business Warehouse). UPC_STATISTIC3 is a SAP standard transp table used for storing Statistic for Executing Planning Functions related data in SAP. It comes under the package UPC.

SAP UPC_STATISTIC3 table

Table UPC_STATISTIC3 technical data

TableUPC_STATISTIC3
Data storingStatistic for Executing Planning Functions
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPC
Delivery ClassL – Table for storing temporary data
ComponentSAP_BW
Table CategoryTRANSP

SAP UPC_STATISTIC3 Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GUID : UUID in compressed form (22 character UUENCODEd)
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • NAME : Name of Statistic Records
    Its data type is CHAR (Character String) with field length 4
  • TYPE : Further Information on Name of Statistic Record
    Its data type is CHAR (Character String) with field length 20
  • DATUM : System Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UZEIT : System Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • AREA : Planning Area
    Its data type is CHAR (Character String) with field length 8
  • PLEVEL : Planning level
    Its data type is CHAR (Character String) with field length 8
  • PPACKAGE : Planning Package
    Its data type is CHAR (Character String) with field length 8
  • METHOD : Planning function
    Its data type is CHAR (Character String) with field length 8
  • PARAM : Parameter Group
    Its data type is CHAR (Character String) with field length 8
  • RUNTIME_BRUTTO : Total Execution Time
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BW_READ_RECS : Number of Data Records, which Have Been Read by BW
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BW_READ_RECS_DEL : Number of Deleted Data Records (All Key Figures Equal Zero)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BW_READ_CALLS : Number of Read Accesses
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BW_READ_TIME : Total Read Time for All Read Accesses for Transaction Data
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PF_RECS_READ : Number of Data Records Requested From Planning Function
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PF_RECS_CHANGED : Number of Data Records of Planning Function Changed
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PF_RECS_NEW : Number of Data Records of Planning Function Generated New
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PF_RECS_READ_REF : Number of Reference Data Requested by Planning Function
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MP_P_CELLS_TIME : Time to Transport and Presnt Data Cells to PC
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MP_P_CELLS_NUM : Number of Data Cells, which Are Transferred to the Front End
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MP_OPEN_VIEWER : Time to Start the Viewer and Open the Document
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MP_LOG_SCR : Time to Build the Logical Screen
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MP_P_DATA_TIME : Total Time Prepare and Write Data Frontend
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • WEB_PAI : Web Time for Input Processing
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • WEB_PBO : Web Time for Output Processing
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10