1. SAP Tutorial
  2. Business Warehouse

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

    • RSPLS_ALVL related tables

    • RSPLS_ALVL : Planning: Primary Table for Aggregation Levels
    • RSPLS_TST_COPY : Test Table for TREX_EXT_PE_COPY
    • RSPLS_CR_RANGE : Char.Relationship: Range (for example, for DataStore Object)
    • RSPLS_DS_HEAD : Data Slices: Header Table
    • RSPLS_SELDR_LOG : Stores SELDR
    • RSPLS_CR_ROLE : Characteristic Relationships: Roles of the Characteristics
    • RSPLS_J2EE_URL : Planning: J2EE Installation for the Modeler
    • RSPLS_HDB_ACT : BW-IP: Activation of Deep HANA Integration
    • RSPLS_PM_LOG : Planning Modeler: Log
    • RSPLS_DST : Text Table: Data Slices
    • RSPLS_CHAS_LOCK : Planning: Lock-Relevant Characteristics per InfoProvider
    • RSPLS_ALVL_IOBJ : Planning: Aggregation Levels for InfoObjects
    • RSPLS_ALVLT : Planning: Text Table for Aggregation Levels
    • RSPLS_CR_STEPS : Relationships Between Characteristics in Basic InfoProvider
    • RSPLS_USAGE_LOG : Usage log for BPC unified
    • RSPLS_AUDIT : In-Memory Planning – License Check
    • RSPLS_DS : Data Slices
    • RSPLS_DS_FIELD : Data Slices: InfoObejcts with Restrictions
    • RSPLS_SEQUENCE : Planning Sequence
    • RSPLS_TST_LOOKUP : Test Table for TREX_EXT_PE_LOOKUP

    RSPLS_ALVL related transaction codes under SAP package RSPLS

    • RSPLSA : BI Planning: Starter Settings
    • RSPLSE : BI Planning: Lock Management
    • RSPLAN : Modeling BI Integrated Planning

    Related References

    Related Tutorials

    RSPLS_ALVLT SAP table for – Planning: Text Table for Aggregation Levels

    RSPLS_ALVLT table in SAP BW (Planning in BW) module. This table is used for storing data of Planning: Text Table...

    RSPLS_ALVL_IOBJ SAP table for – Planning: Aggregation Levels for InfoObjects

    RSPLS_ALVL_IOBJ table in SAP BW (Planning in BW) module. This table is used for storing data of Planning: Aggregation Levels...

    UPC_PROFILE_PL SAP table for – Planning Profiles – Planning Levels

    UPC_PROFILE_PL table in SAP BW (Planning in BW) module. This table is used for storing data of Planning Profiles -...

    UPC_PLEVEL SAP table for – Planning Levels

    UPC_PLEVEL table in SAP BW (Planning in BW) module. This table is used for storing data of Planning Levels. See...

    RSPLS_SEQUENCE SAP table for – Planning Sequence

    RSPLS_SEQUENCE table in SAP BW (Planning in BW) module. This table is used for storing data of Planning Sequence. See...

    UPC_PLEVELT SAP table for – Planning Levels – Text Table

    UPC_PLEVELT table in SAP BW (Planning in BW) module. This table is used for storing data of Planning Levels -...

    RSPLS_SEQUENCE_S SAP table for – Planning Steps

    RSPLS_SEQUENCE_S table in SAP BW (Planning in BW) module. This table is used for storing data of Planning Steps. See...

    «
    »