Monday, October 15, 2012

Steps to find the where used list for variables used in Queries


Steps to find the where used list for variables used in Queries

The information associating query elements and variables can be found first in RSZGLOBV.  Now we need
to link this UID’s with BEX reporting component UID’s this linking information can be found in RSZELTXREF
table.
The elements are not stored directly in the query so this reference needs to be done repeatedly, if it returns a
report then it is added to the list of queries, if not, it must be a subcomponent and this is added to the list to
be searched again.
Finally we use these UID’s against the COMPID’s of main reporting table RSRREPDIR and the RSZELTTXT
to get a more information on the query, such as description and author.

Check the below link
How to Find the Where used Lists for Variables in BEX Queries and also DTPs
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a084dec5-c145-2f10-e6b7-8a442f5066b5?QuickLink=index&overridelayout=true&53820235228245

HANA SandBox System - Developer Access -30 Days trail



Are you looking for SAP HANA Sandbox system developer access for trail, here you go... click on the below link

FAQ SAP HANA Developer Access (Test and Trial) – HANA Sandbox System

Using Excel with SAP HANA

Check the below Video -- Really Nice presentation

FAQs: SAP HANA

How to find the info package associated with Data source

Follow the below steps to find the info packages associated with respect to a particular Data source.

1) Goto SE16
2) Give the table name :RSLDPIO
3) Enter the Data Source name in field OLTPSOURCE and execute (F8).

  LOGDPID field gives you the Info Package associate to the Data Source.