UPC_STEPS SAP table for – Relations between Characteristics of a Planning Area

Here we would like to draw your attention to UPC_STEPS 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_STEPS is a SAP standard transp table used for storing Relations between Characteristics of a Planning Area related data in SAP. It comes under the package UPC.

SAP UPC_STEPS table

Table UPC_STEPS technical data

TableUPC_STEPS
Data storingRelations between Characteristics of a Planning Area
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP UPC_STEPS 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_STEPS 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
  • STEP : Number of the Characteristic Relationship
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • MTYPE : Type of Characteristic Relationship
    Its data type is CHAR (Character String) with field length 1
  • DERIVE : Derivation: X = Yes
    Its data type is CHAR (Character String) with field length 1
  • 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
  • REFID : UUID in compressed form (22 character UUENCODEd)
    Its data type is CHAR (Character String) with field length 22
  • FBDER : FM Derivation
    Its data type is CHAR (Character String) with field length 30
  • FBCOM : FM Combination Proposal
    Its data type is CHAR (Character String) with field length 30
  • FBVER : FM Combination Check
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Statistical Info
  • COUNTER : Change counter
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ATIME : Last changed at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6