Master Data & Bex Query F4 Help

in the following we deal with various aspects of master data of BW characteristics. In particular, you can find a detailed discussion of the F4(Input) help to BW variables and query Filters(Selector) .

F4 Guided Answer

BW BEx F4-Help (Input Help, LOV list-of-values)

SAP Online Documentation

• RSD1 Tab Pabe 'Business Explorer'  --> see section 'Filter Selection in Query Definition' & 'Filter Selection in Query Execution'
• Input Help in Bex
• Selecting Characteristic Values

SAP Consulting Notes at a glance

List of all Consulting Notes

Types of Master Data

There are different options for accessing master data at query runtime:

• Standard: The values from the characteristic's master data tables(P,Q,X,Y) are displayed. 
• Own Implementation: You can define an ABAP class to implement the access to master data yourself.
• Direct Access:  You can access the data in a source system using a DTP based on a DataSource.
• SAP HANA View: It is possible to work with virtual master data based on a Hana Calculaction View.

F4 Topics

• F4 Modes
  • Performance Impact of F4 Modes
  • Identifying statements used for F4-help
  • BWonHANA
    • HCPR/ADSO F4 Mode D: see note 2094816. This note explains in detail when the Mode D is supported. Additional remarks
      • If the HCPR is based on Hana Calculation Views, the mode D is not supported. Hence for variable F4 help the system always uses the mode M (Master Data)
• F4 BADI for variables
• Dynamic Hierarchy Selection during Query Execution
• Sorting in F4
• Text and Key in F4
• F4 in a query based on a classic Infoset (SQ02)

Master Data Topics

• Special (Time and Technical) Characteristics
• Virtual Master Data based on SAP HANA View
• Master Data and SID Table
  • Deletion of Master data

SAP Support Troubleshooting Guideline

SSG BW-BEX-OT-F4