BICS_DT_S_QUERY_PROPERTIES SAP (Design time query properties) Structure details

Dictionary Type: Structure
Description: Design time query properties




ABAP Code to SELECT data from BICS_DT_S_QUERY_PROPERTIES
Related tables to BICS_DT_S_QUERY_PROPERTIES
Access table BICS_DT_S_QUERY_PROPERTIES




Structure field list including key, data, relationships and ABAP select examples

BICS_DT_S_QUERY_PROPERTIES is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Design time query properties" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BICS_DT_S_QUERY_PROPERTIES TYPE BICS_DT_S_QUERY_PROPERTIES.

The BICS_DT_S_QUERY_PROPERTIES table consists of various fields, each holding specific information or linking keys about Design time query properties data available in SAP. These include COMPUID (UUID in compressed form), OBJVERS (Object version), INFOCUBE (InfoCube), GENUNIID (Internal display of the report identifier).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BICS_DT_S_QUERY_PROPERTIES structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
COMPUIDUUID in compressed form SYSUUID_25CHAR25SYSUUID_25
OBJVERSObject version RSOBJVERSCHAR1RSOBJVERS
INFOCUBEInfoCube RSINFOCUBECHAR30RSINFOCUBERSI
GENUNIIDInternal display of the report identifier RSGENUNIIDCHAR25GENIDRSRREPDIR_SYSUUID_25GID
COMPTYPEType of a reporting component RSZCOMPTPCHAR3RSZCOMPTP
COMPIDName (ID) of a reporting component RSZCOMPIDCHAR30Assigned to domainRSZCOMPIDRSZCOMPID
CURKZCurrency Translation in the Query Definition RRCURKZCHAR1BOOLE
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
DUEDATEDate RSBOLAP_DATEDATS8DATUM
INPUT_MODEMode of Input Processing RRINPUTMODUSNUMC1RRINPUTMODUS
INFOPROVIDER_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
BASE_INFOPROVIDER_NAMECharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
BASE_INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
QUERY_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_TRANSIENTBoolean RS_BOOLCHAR1RS_BOOL
QUERY_CREATED_BYUser RSBOLAP_USERCHAR12Assigned to domainXUBNAME
QUERY_CREATION_DATEDate RSBOLAP_DATEDATS8DATUM
QUERY_CREATION_TIMETime RSBOLAP_TIMETIMS6AS4TIME
QUERY_CHANGED_BYUser RSBOLAP_USERCHAR12Assigned to domainXUBNAME
QUERY_CHANGE_DATEDate RSBOLAP_DATEDATS8DATUM
QUERY_CHANGE_TIMETime RSBOLAP_TIMETIMS6AS4TIME
DATA_REFRESH_DATEDate RSBOLAP_DATEDATS8DATUM
DATA_REFRESH_TIMETime RSBOLAP_TIMETIMS6AS4TIME
DATA_ROLLUP_DATEDate RSBOLAP_DATEDATS8DATUM
DATA_ROLLUP_TIMETime RSBOLAP_TIMETIMS6AS4TIME
DATA_ROLLUP_DATE_MAXDate RSBOLAP_DATEDATS8DATUM
DATA_ROLLUP_TIME_MAXTime RSBOLAP_TIMETIMS6AS4TIME
MDX_ENABLEDBoolean RS_BOOLCHAR1RS_BOOL

Key field Non-key field



How do I retrieve data from SAP structure BICS_DT_S_QUERY_PROPERTIES using ABAP code?

As BICS_DT_S_QUERY_PROPERTIES is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BICS_DT_S_QUERY_PROPERTIES as there is no data to select.

How to access SAP table BICS_DT_S_QUERY_PROPERTIES

Within an ECC or HANA version of SAP you can also view further information about BICS_DT_S_QUERY_PROPERTIES and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!