This short guide details how to get available columns and SAP variables for a BW query using SAP Logon.

Preliminary Steps

Here is how to access the SAP Easy Access main menu:

  1. Look for "SAP Logon" in the Windows search bar and launch the app 
  2. Look for the server you want to connect to in the search bar on the top right of the window (e.g., BW - Production - WBP) and double-click on it
  3. Input your credentials (user and password) and press Enter
  4. This brings you to the main menu

Retrieving Column Names

Here is how to access the available column names for a BW query:

  1. From the main menu, launch the "mdxtest" transaction by writing it in the search bar on the top left of the window
  2. Under the "Metadata" section, select "Cube" in the drop-down list
  3. Under the drop-down list, input both the catalog name and the cube name, separated by "/" (e.g., CPSDSO56/DI_BW_QRY_CPSDSO56_0007)
  4. The Column variables can be explored in the window underneath and the query can be tested on the right

Retrieving SAP Variables Names

Here is how to access the available SAP variables names for a BW query:

  1. From the main menu, launch the "SE37" transaction by writing it in the search bar on the top left of the window
  2. In SE37, write "BAPI_MDPROVIDER_GET_VARIABLES" as the function module
  3. Click on the "Test/Execute" button in the toolbar
  4. In the function module, input the catalog name in CAT_NAM (e.g., CPSDSO56) and both the catalog name and the cube name (separated by "/") in CUBE_NAM (e.g., CPSDSO56/DI_BW_QRY_CPSDSO56_0007)
  5. Click on the "Execute" button in the toolbar
  6. Under the "Tables" section, click on the entries that were returned by the function
  7. This will open a new window containing the SAP variables