While
implementing a logic in user exit based BEx/BW variables a requirement of query
technical name determination may appear. Thus, I tried to research on this
topic a little bit. Fortunately, there is a structure called I_S_RKB1D, which has a description Query
Reporting Attribute. The structure has a lot of useful information. Among
others (see below) there is an also COMPID
information that has the query technical name. The structure is available since
a call of standard FM RRS_REPORT_INIT_START.
The structure is still available in memory at the point where the custom logic serving for purposes of specific variable is called.
Columns available in the structure:
COMPUID UUID in compressed form
INFOCUBE InfoCube
GENUNIID Internal display of the report identifier
COMPTYPE Type of a reporting component
COMPID Name (ID) of a reporting component
RFCSUPPORT Report supports access using OLAP API
OBJSTAT Object Status
SMODE Special reports
READMODE Read Mode
NOAGGRFL Flag: Do not use aggregates for this query
IDVERS Dictionary version (internal vers.) of report in RSIX
DVERS Dictionary version (current Release) of report in RSIX
RNAME ABAP Program Name
AUTHOR Name of author
GENTIME Query Generation Time (Cache Invalidation)
LASTUSER Last Changed By
MODTIME Last Change to Definition
REPTIME Last Change of Query Runtime Object
GEN1TIME Query Gen Time (no cache invalidation needed)
PACKFL Process Key Figure with High Precision
PACKFL_DEF Boolean
NOSPBUF SP Cannot be Permanently Buffered
CACHEMODE Query Cache Mode
CACHEUSAGEMODE Cache Usage Mode
KIDSEL Use Selection of Structure Elements
FAGGR_LATE Calculation of Commutative Formulas After Aggregation
OPT_OCCURS Boolean
OPT_OCCURS_TIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
OPT_OCCURS_MODE Optimization Mode
OPT_OCCURS_PER Optimization Periods
SUPPRMESS Suppress Messages
CACHEUSEREXIT Indicator: Cache Use Despite Virtual Characteristics/KF
NOPARALLEL No Parallel Processing
GENPROT Generation Protocol
INPUTABLE Make All Basic Indicators Ready for Input
PARTITIONMODE Type of SP Grouping for Delta Caching
DELTACACHE Update Cache Objects in Delta Process
ACTUALDATA Data Integrity
OLAPSTAT OLAP Statistic Properties of the Query
OLAPSTATDETLEV OLAP Statistics Detail Level
ADDNLS Should the Cold Store storage be read too?
NOHPA Obsolete Field (Do Not Use BWA Index)
READMODE_DEFT Boolean
ACTUALDATA_DEF Boolean
CACHEMODE_DEF Boolean
DELTACACHE_DEF Boolean
PARTITION_DEF Boolean
DIS_MODE Disaggregation on Totals
INFOPROV_SUPPORT Query is used as InfoProvider
NOPARALLEL_DEF Boolean
KIDSEL_DEF Boolean
ADDNLS_DEF Boolean
NOHPA_DEF Boolean
CHUSEREXIT_DEF Boolean
TREXOPS Operations in SAP HANA
TREXOPS_DEF Boolean
MATERIALIZEQUERYLAYER Materialize Intermediate Query Result
MATERIALIZEQUERYLAYER_DEF Boolean
IS_PLANQUERY Boolean
DATA_INTEGRITY_SCENARIO Data Integrity Profile
DI_SCENARIO_DEF Boolean
READ_CHILD_KIDS Also Read the Child Members with Hierarchy Structure Node
READ_CHILD_KIDS_DEF Boolean
OLAPEFFORT OLAP Effort for Query
QMODI Q Mode Implementation (relational browse)
DOCUMENT_SUPPORT Document Support
DEFAULT_DOC_APPL_ID Default Document Application ID
PROPVERS Version of Properties concerning Support Package
MOSTRECENT Read according to newest, possibly not active structure
VARIANT ABAP: Name of variant (without program name)
PMODE Mode in which a query is executed (online, batch)
TMSTMP_ROLLUP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TMSTMP_ROLLUP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TMSTMP_START TS for Start of RRI_REPORT_IMPORT_AND_CHECK
ODBO Using ODBO to Execute Query
EXPLAIN_QUERY This Is A Explain Query
NO_RTPERSISTENCE Does the query have a runtime persistency
USE_NLS Boolean
ONLY_SIMPLE_CU Boolean
MANDT_DEP Object is client-specific
No comments:
Post a Comment