UPP_SPREADS SAP table for – Planning: Spreadsheet Customizing

Here we would like to draw your attention to UPP_SPREADS 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). UPP_SPREADS is a SAP standard transp table used for storing Planning: Spreadsheet Customizing related data in SAP. It comes under the package UPP.

SAP UPP_SPREADS table

Table UPP_SPREADS technical data

TableUPP_SPREADS
Data storingPlanning: Spreadsheet Customizing
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP UPP_SPREADS 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 UPP_SPREADS 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
  • PLEVEL : Planning level
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • PARAM : Parameter Group
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • RATIO : Screen Area Within Row/Column Structure
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SORT : Sequential Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SSTOP : Row position in Spreadsheet
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SSLEFT : Column position in spreadsheet
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Format Information
  • FRONT : Foreground color in spreadsheet
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BACK : Background color in spreadsheet
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • FONT : Text font
    Its data type is CHAR (Character String) with field length 30
  • FONTSIZE : Data Element Font Size
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ALIGN : Left/right alignment of text
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • STYLE : Name of a Format Template
    Its data type is CHAR (Character String) with field length 128