UPS_HASH SAP table for – Connection Hierarchy Key/Hash

Here we would like to draw your attention to UPS_HASH 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_HASH is a SAP standard transp table used for storing Connection Hierarchy Key/Hash related data in SAP. It comes under the package UPS.

SAP UPS_HASH table

Table UPS_HASH technical data

TableUPS_HASH
Data storingConnection Hierarchy Key/Hash
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPS
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP UPS_HASH 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_HASH 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
  • HASH : Org. Value for Status and Tracking System
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • HKEY
    Its data type is STRG (Character String of Variable Length) with field length 0