UPC_NODES SAP table for – Hierarchy Node

Here we would like to draw your attention to UPC_NODES 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_NODES is a SAP standard transp table used for storing Hierarchy Node related data in SAP. It comes under the package UPC.

SAP UPC_NODES table

Table UPC_NODES technical data

TableUPC_NODES
Data storingHierarchy Node
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP UPC_NODES 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_NODES 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
  • FIELDNAME : Field Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • 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