1. SAP Tutorial
  2. Business Warehouse

RSQISET SAP table for – Directory of all InfoSets

Here we would like to draw your attention to RSQISET table in SAP. As we know it is being mainly used with the SAP BW-WHM (Warehouse Management in BW) component which is coming under BW module (Business Warehouse). RSQISET is a SAP standard transp table used for storing Directory of all InfoSets related data in SAP. It comes under the package RSQBW_META_DATA.

SAP RSQISET table

Table RSQISET technical data

TableRSQISET
Data storingDirectory of all InfoSets
ModuleBW
Sub ModuleBW-WHM-MTD
SAP PackageRSQBW_META_DATA
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

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

  • INFOSET : InfoSet
    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
  • .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
  • INFOAREA : InfoArea
    Its data type is CHAR (Character String) with field length 30
  • BCTCOMP : Component
    Its data type is CHAR (Character String) with field length 10
  • .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 : Author
    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

    • RSQISET related tables

    • RSQISETT : Texts for InfoSets
    • RSQFOBJ : Field Objects in the InfoSet
    • RSQISET : Directory of all InfoSets
    • RSQTOBJ : Table Objects in the InfoSet

    Related References

    Related Tutorials

    RSQISETX SAP table for – Directory of all InfoSets (Technical Enhancements)

    RSQISETX table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Directory of...

    RSQISETT SAP table for – Texts for InfoSets

    RSQISETT table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Texts for...

    RSQISETLOC SAP table for – Local Properties InfoSets

    RSQISETLOC table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Local Properties...

    RSISET SAP tcode for – Maintain InfoSets

    RSISET tcode in SAP BW (Warehouse Management in BW) module. This transaction code is used for Maintain InfoSets. See the...

    RSQ02 SAP tcode for – Maintain InfoSets

    RSQ02 tcode in SAP BW (Warehouse Management in BW) module. This transaction code is used for Maintain InfoSets. See the...

    RSQFOBJ SAP table for – Field Objects in the InfoSet

    RSQFOBJ table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Field Objects...

    RSQTOBJ SAP table for – Table Objects in the InfoSet

    RSQTOBJ table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Table Objects...

    «
    »