RSPLS_ALVL SAP table for – Planning: Primary Table for Aggregation Levels

Here we would like to draw your attention to RSPLS_ALVL 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). RSPLS_ALVL is a SAP standard transp table used for storing Planning: Primary Table for Aggregation Levels related data in SAP. It comes under the package RSPLS.

SAP RSPLS_ALVL table

Table RSPLS_ALVL technical data

TableRSPLS_ALVL
Data storingPlanning: Primary Table for Aggregation Levels
ModuleBW
Sub ModuleBW-PLA
SAP PackageRSPLS
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

SAP RSPLS_ALVL 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 RSPLS_ALVL table.

  • AGGRLEVEL : Planning: Aggregation Level
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • INFOPROV : InfoProvider
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Properties TLOGO object (available in A and M versions)
  • .INCLUDE : Properties TLOGO object (only available in A version)
  • OBJSTAT : Object Status
    Its data type is CHAR (Character String) with field length 3
  • CONTREL : Content release
    Its data type is CHAR (Character String) with field length 6
  • CONTTIMESTMP : Content time stamp: Last modification to the object by SAP
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • OWNER : Owner (Person Responsible)
    Its data type is CHAR (Character String) with field length 12
  • BWAPPL : BW Application (Namespace)
    Its data type is CHAR (Character String) with field length 10
  • ACTIVFL : Active and revised version do not agree
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Include: Last changed by, time stamp in internal format
  • TSTPNM : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • TIMESTMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CRNM : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • CRTSTP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : InfoCube: BW Statistics
  • BWSTATISTICS : Boolean
    Its data type is CHAR (Character String) with field length 1
  • BWSTATWHM : Boolean
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : InfoCube: Default Query Properties
  • QPROPVERS : Conversion Version Query Properties
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • READMODE : Read Mode
    Its data type is CHAR (Character String) with field length 1
  • CACHEMODE : Cache Mode
    Its data type is CHAR (Character String) with field length 1
  • CACHEDELAY : Cache Validity Period in Seconds
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NLREADMODE : Read Modus for Near-Line Storage
    Its data type is CHAR (Character String) with field length 1
  • NOPARALLELQDEF : no parallel processing
    Its data type is CHAR (Character String) with field length 1
  • KIDSEL : Use Selection of Structure Elements
    Its data type is CHAR (Character String) with field length 1
  • CACHEUSEREXIT : Indicator: Do not Use Cache for this Report
    Its data type is CHAR (Character String) with field length 1
  • NOHPA : Obsolete Field (Do Not Use BWA Index)
    Its data type is CHAR (Character String) with field length 1
  • TREXOPS : Operations in SAP HANA/BWA
    Its data type is CHAR (Character String) with field length 1
  • MATERIALIZEQUERYLAYER : Materialize Intermediate Query Result
    Its data type is CHAR (Character String) with field length 1
  • PACKFLQDEF : Process key figure with high precision
    Its data type is CHAR (Character String) with field length 1
  • HANAMODELFL : External SAP HANA view for BW object
    Its data type is CHAR (Character String) with field length 1
  • SUPP_QUERY_W_DUPL_KYF : Supp. queries w/ dupl. KYF which cont. diff. aggregations
    Its data type is CHAR (Character String) with field length 1
  • CACHEUSAGEMODE : Cache Usage Mode
    Its data type is CHAR (Character String) with field length 1
  • DATA_INTEGRITY_SCENARIO : Data Integrity Profile
    Its data type is CHAR (Character String) with field length 1
  • BCTCOMP : Obsolete – do not translate
    Its data type is CHAR (Character String) with field length 10
  • INFOAREA : InfoArea
    Its data type is CHAR (Character String) with field length 30
  • ALVLTYPE : Aggregation Level: Type
    Its data type is CHAR (Character String) with field length 1