BICS_PROV_META_QUERY SAP (Metadata Properties of the Query) Structure details

Dictionary Type: Structure
Description: Metadata Properties of the Query




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




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

BICS_PROV_META_QUERY 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 "Metadata Properties of the Query" 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_PROV_META_QUERY TYPE BICS_PROV_META_QUERY.

The BICS_PROV_META_QUERY table consists of various fields, each holding specific information or linking keys about Metadata Properties of the Query data available in SAP. These include PERIV (Fiscal Year Variant), COMPUID (UUID in compressed form), DUEDATE (Date with which texts, attributes and hierarchies are read), OBJVERS (Object version).. 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_PROV_META_QUERY 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
CURKZCurrency Translation in the Query Definition RRCURKZCHAR1BOOLE
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
COMPUIDUUID in compressed form SYSUUID_25CHAR25SYSUUID_25
DUEDATEDate with which texts, attributes and hierarchies are read RRSRDATEDATS8RSDATE
OBJVERSObject version RSOBJVERSCHAR1RSOBJVERS
INFOCUBEInfoCube RSINFOCUBECHAR30RSINFOCUBERSI
INPUT_MODEMode of Input Processing RRINPUTMODUSNUMC1RRINPUTMODUS
GENUNIIDInternal display of the report identifier RSGENUNIIDCHAR25GENIDRSRREPDIR_SYSUUID_25GID
INFOPROVIDER_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
COMPTYPEType of a reporting component RSZCOMPTPCHAR3RSZCOMPTP
INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
COMPIDName (ID) of a reporting component RSZCOMPIDCHAR30Assigned to domainRSZCOMPIDRSZCOMPID
BASE_INFOPROVIDER_NAMECharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
CURKZCurrency Translation in the Query Definition RRCURKZCHAR1BOOLE
BASE_INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
QUERY_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
DUEDATEDate RSBOLAP_DATEDATS8DATUM
QUERY_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
INPUT_MODEMode of Input Processing RRINPUTMODUSNUMC1RRINPUTMODUS
QUERY_TRANSIENTBoolean RS_BOOLCHAR1RS_BOOL
QUERY_CREATED_BYOwner (Person Responsible) RSOWNERCHAR12Assigned to domainXUBNAMERS_OWNER
INFOPROVIDER_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_CREATION_DATEChanged On RSTSTPDATDATS8AS4DATE
QUERY_CREATION_TIMEChanged at RSTSTPTIMTIMS6AS4TIME
BASE_INFOPROVIDER_NAMECharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_CHANGED_BYLast changed by RSTSTPNMCHAR12Assigned to domainXUBNAME
BASE_INFOPROVIDER_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_NAMEObject Name RSBOLAP_OBJECT_NAMECHAR40RSBOLAP_OBJECT_NAME
QUERY_CHANGE_DATEChanged On RSTSTPDATDATS8AS4DATE
QUERY_TEXTCharact. text RSBOLAP_OBJECT_TEXTCHAR60RSBOLAP_OBJECT_TEXT
QUERY_CHANGE_TIMEChanged at RSTSTPTIMTIMS6AS4TIME
QUERY_TRANSIENTBoolean RS_BOOLCHAR1RS_BOOL
DATA_REFRESH_DATEChanged On RSTSTPDATDATS8AS4DATE
QUERY_CREATED_BYUser RSBOLAP_USERCHAR12Assigned to domainXUBNAME
DATA_REFRESH_TIMEChanged at RSTSTPTIMTIMS6AS4TIME
DATA_ROLLUP_DATEChanged On RSTSTPDATDATS8AS4DATE
QUERY_CREATION_DATEDate RSBOLAP_DATEDATS8DATUM
DATA_ROLLUP_TIMEChanged at RSTSTPTIMTIMS6AS4TIME
QUERY_CREATION_TIMETime RSBOLAP_TIMETIMS6AS4TIME
QUERY_CHANGED_BYUser RSBOLAP_USERCHAR12Assigned to domainXUBNAME
DATA_ROLLUP_DATE_MAXChanged On RSTSTPDATDATS8AS4DATE
QUERY_CHANGE_DATEDate RSBOLAP_DATEDATS8DATUM
DATA_ROLLUP_TIME_MAXChanged at RSTSTPTIMTIMS6AS4TIME
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_PROV_META_QUERY using ABAP code?

As BICS_PROV_META_QUERY 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_PROV_META_QUERY as there is no data to select.

How to access SAP table BICS_PROV_META_QUERY

Within an ECC or HANA version of SAP you can also view further information about BICS_PROV_META_QUERY 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!