Here we would like to draw your attention to UPS_TP_HIERARCHY 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_TP_HIERARCHY is a SAP standard transp table used for storing Connection Subplan-Hierarchy related data in SAP. It comes under the package UPS.
Table UPS_TP_HIERARCHY technical data
| Table | UPS_TP_HIERARCHY |
| Data storing | Connection Subplan-Hierarchy |
| Module | BW |
| Sub Module | BW-PLA-BPS |
| SAP Package | UPS |
| Delivery Class | C – Customer table, data is only maintained by the customer |
| Component | SAP_BW |
| Table Category | TRANSP |
SAP UPS_TP_HIERARCHY 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_TP_HIERARCHY table.
Its a key field. Its data type is CLNT (Character with length 3) with field length 3
Its a key field. Its data type is CHAR (Character String) with field length 8
Its a key field. Its data type is CHAR (Character String) with field length 8
Its data type is CHAR (Character String) with field length 30
Its data type is CHAR (Character String) with field length 3
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is CHAR (Character String) with field length 30
Its data type is CHAR (Character String) with field length 32
Its data type is NUMC (Character String with Digits Only) with field length 2
Its data type is NUMC (Character String with Digits Only) with field length 3
Its data type is CHAR (Character String) with field length 12
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6