UPS_LOCKS SAP table for – Lock Table for Status and Tracking System

Here we would like to draw your attention to UPS_LOCKS 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). UPS_LOCKS is a SAP standard transp table used for storing Lock Table for Status and Tracking System related data in SAP. It comes under the package UPS.

SAP UPS_LOCKS table

Table UPS_LOCKS technical data

TableUPS_LOCKS
Data storingLock Table for Status and Tracking System
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPS
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TEILPLAN : Subplan in STS
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • VERSION : Planning Session/Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • ORGVL : Org. Value for Status and Tracking System
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • SPERRE : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • CHANGETIME : Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHANGEDATE : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGEDFROM : User Name
    Its data type is CHAR (Character String) with field length 12