UPC_VAR_HIE_SELA SAP table for – Variables – Selections using Hierarchies (Active Values)

Here we would like to draw your attention to UPC_VAR_HIE_SELA 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_VAR_HIE_SELA is a SAP standard transp table used for storing Variables – Selections using Hierarchies (Active Values) related data in SAP. It comes under the package UPC.

SAP UPC_VAR_HIE_SELA table

Table UPC_VAR_HIE_SELA technical data

TableUPC_VAR_HIE_SELA
Data storingVariables – Selections using Hierarchies (Active Values)
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP UPC_VAR_HIE_SELA 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_VAR_HIE_SELA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AREA : Planning Area
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • VAR : Variable
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • VARUSER : User Name
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • SEQNO : Sequence Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Hierarchy Key
  • HIENM : Hierarchy
    Its data type is CHAR (Character String) with field length 30
  • HIEVER : Hierarchy Version
    Its data type is CHAR (Character String) with field length 3
  • DATETO : Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANM : Characteristic
    Its data type is CHAR (Character String) with field length 30
  • NODENAME : Node name
    Its data type is CHAR (Character String) with field length 60
  • HIECHA : Characteristic
    Its data type is CHAR (Character String) with field length 30
  • DUMMY_LEAF : Indicator: Help Nodes
    Its data type is CHAR (Character String) with field length 1