Adhoc Query

[Former Member]

Hi Experts,

Can anyone have Adhoc query Creation Step by Step Document.

Please send it to shakthigin@yahoo.co.in

Higher points will be rewarded for the useful inputs.

Thanks in Advance,

Dharani

[Former Member]

SAP HR Ad-Hoc Query

One of the key requirements of a Human resources management system is the ability to facilitate decision-making use of the information in the system. The reporting functionality within SAP HR is one of the main reasons why clients have chosen SAP rather than another HRIS - one of our former research articles takes a closer look at the different reporting tools available and how to make most use of them.

Reporting can become very challenging when the differing needs of many decision-makers - human resources, payroll and benefits professionals, line managers, and executives - must be met. SAP HR has responded to this challenge and offers a variety of access methods designed for the needs of different users. This article focuses on the functionality of Ad-hoc Query, a tool that still isn’t used by all companies who have SAP HR. Some of these organizations are still unfamiliar with the full potential of Ad Hoc query and are afraid to use it. This article has a closer look at how easy it is to use ad hoc query and how this simple but powerful tool can make your reporting so much more efficient and less time consuming.

AD HOC QUERY AS AN IDEAL TOOL FOR DIFFERENT TYPES OF USERS

The advantage of Ad Hoc Query is that it enables occasional system users or people with little experience to define their own reports according to their personal requirements in an easy and quick fashion. It is an ideal query tool for anyone who needs to obtain human resource information when and as needed.

An overview of different types of available HR information (for example Personal data, Addresses, Basic pay, Organizational assignment etc.) is displayed in a list, which includes all the infotypes and the relevant fields, users need to pull the information from. This list is obtained by creating a functional area. Users simply select the information they want by marking checkboxes in the list. Report results can then be formatted to users' needs and preferences; for example the presentation style or the sequence of columns in the report can be changed. Users can create and then format the output of the desired report all in one screen and save the query to run it whenever needed.

HR Professionals

The Human resources, payroll, and benefits departments need to run a great array of reports – SAP provides reporting tools supporting both regulatory reporting via a series of standard reports as well as query options that support customized reports and strategic analysis tools. While the legally required reports are included as a standard part of the SAP HR system and have some degree of selection options (usually organizational assignment selection options), these reports cannot be altered by the user to suit his or her specific requirements – they might not include all the data users need to obtain, might not have the option to be downloaded to an Excel spreadsheet or might not have the right format. This is where Ad Hoc Query is so significant. HR Ad Hoc Query enables users to create company-specific reports that respond to their ever-changing needs for information about employees and the organization. The user simply selects the fields he needs to report on from a check-box screen. This report creation process requires minimal training and allows users to perform detailed analysis of human resources, payroll, and benefits information to support the needs of their organization. Integration with Microsoft Word and Excel allows users to format and modify the output to suit their needs or to save their reports in HTML format in order to e-mail them to other users.

Occasional Users

Even individuals such as Managers outside the HR/Payroll/Benefits departments who have no previous experience with SAP HR can use Ad Hoc Query to define the reports they need. It is critical for these managers to be able to report on information about their staff. It happens all too often that they need a specific report and have to ask HR to produce the right data – this is both frustrating for the Line Manager having to wait and for HR who might have other critical deadlines. Ad-hoc reporting, which provides occasional users with easy access to the right information for their specific decision-making needs is an ideal solution. And since users can run and create their own reports, it frees both HR and the User considerable amounts of time.

Line managers are able to access information about their specific organizations when they need it, in the formats that they require and can easily access data in the SAP HR system, as well as information from other business applications, to obtain the company-wide information they need for analysis and planning.

ACCESS

As will all other SAP applications, flexible security and access authorization can ensure that access to information is restricted to defined areas for each user. HR reports almost always contain confidential data and special attention needs to be brought to setting up proper activity groups. Whereas regular HR users will use the Ad hoc screen within the HR module to create and run their reports, Line Managers – rather than using the HR module should be using Manager’s desktop which provides access to the same standard and ad hoc reporting capabilities as described above but also include cross-application functions such as workflow tasks or CO reports, the display of Intranet and Internet pages etc...

AD HOC QUERY IN PRACTICE

Prerequisite Activities

Before users can create and run their own reports, an administrator must create a functional area and a user group. These are created using the ABAP query component and necessary to set up the appropriate working environment for end users. The R/3 System contains hundreds of thousands fields in logical databases and tables and a logical database is simply a special ABAP program that combines the contents of specific database tables. For example the logical database “PNP” contains all tables related to HR Master data.

Since a user cannot be presented with thousands of fields to choose from – even from one particular logical database, to create a report, functional areas are created. When creating a functional area, first a logical database is selected, such as PNP which contains all the relevant tables for a particular module or sub-module. When selecting PNP which is relevant to HR master data, the administrator needs to pick which infotypes should be included in that particular functional area from the total number of infotypes attached to the logical database. A functional area determines which fields of a logical database can be evaluated in queries.

A functional area also allows defining auxiliary fields. In many cases, the information that a logical database supplies is insufficient. For this reason long texts are normally stored in tables that are not part of the logical database. These long texts are, however, useful when evaluating queries, for example when you want to display the full text of an advertisement (within recruitment) rather than just its number. Both additional tables and additional fields can be added to a functional area. Any table can be added as additional tables, provided they are defined in the ABAP Dictionary and when adding a field, the ABAP code must be specified and the field assigned to a functional group.

By creating functional areas and assigning them to user groups, the system administrator determines the range of reports the end-users can access.

Four essential questions have to be answered before creating a functional area in order to determine the reporting requirements:

1) Which logical database do we need data from? PNP – HR Master and time data, PCH – Personnel Development, PAP – Applicant Master data or other?

Choose Database PNP if you want to create a functional area covering only Human Resources master data and/or time management data.

Choose PCH if you want to create a functional area covering only Human Resources Planning data.

Choose Database PCH, (since this database can refer to Database PNP) if you want to create a functional area covering Human Resources master data and following an organizational structure from Human Resources Planning.

2) Which infotypes do we need to include in the functional area?

PNP includes infotypes 0000 to 0999 and 2000 to 2999,

PCH includes infotypes 1000 to 1999 and

PAP includes infotypes 4000 – 4005 (as well as some PA infotypes)

3) Is there any information we need that is not available in the logical database? If so, where is this information? This step might involve having to create additional fields – (e.g. to display the long text of the ethnic origin instead of the code only).

4) What should the report selection criteria be? For example, employee subgroup, job, personnel subarea etc.

Once these questions have been answered, the administrator can create the functional area using transaction SQ02.

Step 1: In the field Functional area, specify any name and choose Create. First, you enter a description of the functional area. Since the end-user sees this name when creating a query, it should easily identify the functional area.

Step 2: You can also enter an authorization group at this point – which is not to be confused with user groups. Authorization groups can be assigned for any reports and determine a user’s right to execute a program whereas user groups help you to control access and change authorizations for queries.

Step 3: Next specify the logical database,

Step 4: In the Selection screen version field, you can enter an ID for the version of the selection screen. If you leave the field blank, the system calls the standard selection screen when the query is executed.

Step 5: Save the functional area, choose the infotypes you want to include – this list should have been determined previously and execute to fill the functional area with data.

Step 6: The system will display the screen for defining functional groups. This screen is divided into 2 trees: the first one “Functional groups” will display all the infotypes that were included into the functional area. By opening one functional group, users can display what fields are currently selected and decide which fields are needed and which one’s are not. Adding and removing fields for each functional group is carried out via the second tree “Logical database” which lists all the fields that can be included for selection for each infotype. Determine which fields you want to include into the functional groups in the second tree. If there are certain fields that will almost always be used in a report, such as personnel number or employment status, these should be added into the functional group “key fields”.

Step 7: Save and generate your functional area.

Step 8: Functional areas are available to an end-user for each user group of which he is a member. In these functional areas, the end user can define queries and execute them to generate the desired lists. A functional area therefore needs to be assigned to one (or several) user-groups. Go to the user group screen (via environment > user groups) and assign the functional area to the chosen user groups. Each user group should contain user names.

Now that you have generated your functional area and assigned it to a user group, users can create and manipulate their own Ad hoc queries. Unlike ABAP query, in which you users have to define reports, Ad Hoc query only requires to choose the selection (e.g. report should be run for an employee subgroup, or job or personnel area or cost center etc) and output fields (what should the report display and in what order?) by flagging them in a tree structure reflecting those infotypes chosen when creating the Functional area.

CREATING A QUERY

Users can access Ad hoc query via: Human resources -> Information system -> Info tools.

From the initial Ad hoc query screen, users must decide if they want to run the report they are about to create for either individual personnel numbers or use the function Selection via Organizational structure to restrict the display to those personnel numbers that belong to the organizational unit selected. If no organizational unit is selected, the system will select all employees that correspond to the selection criteria.

The next step is to select both the selection fields and the output fields. By clicking on the field “Field selection” – users will be presented with the functional groups inherent to the functional area attached to their user group. They simply need to open up the tree structure, select the appropriate fields. For each field, users can decide whether they want to select it as a selection field or as an output field. For output fields users can further decide if they want to display the value (i.e. ethnic origin code “50”) or the actual text of the field (i.e. “White non-Hispanic”)

Once all the fields have been selected, those marked as Selection fields will appear on the “selection fields” column of the screen and those marked, as output fields will appear under the output column. Choose a value for your chosen selection criterion (or leave it empty to select all employees) and proceed to the “define output” tab. The order of the output fields can be changed here as well as the layout of the report – users have the choice between a basic list, a spreadsheet, word processing document, statistics, ranked list etc

Now the report is ready to be run. By clicking on the “Select” button, the report will select all the relevant personnel numbers found. Personnel numbers, which includes employees’ names, can be displayed by clicking on the “list” button. If required, users can mark personnel numbers to be excluded from the report field.

The expert mode enables users to request more complex reports providing enhanced functions for the Selection and Output fields. It is particularly useful when reporting on specific subtypes or wage types which is only possible using expert mode – in “Simple mode” the report will select all subtypes or wage types of a particular infotype. The expert mode needs to be turned on each time before running the report – saving the report in expert mode does not suffice.

Finally, by clicking on the “output” field, the report is run and will display all the found data in the chosen format. From this screen, the report can be emailed, graphical statistics can be run and the list can be sorted according the various criteria.

Before exiting, the system will prompt the user to save the Query. It makes sense to save a query so that it can be run again at any time in the future. A title and a name (proposed by the system but it can be overwritten) should be given at this point. The tab “Saved queries” allows to access all saved queries.

Users can also report on the selected personnel numbers using other reporting tools. By choosing Goto > Standard report, a dialog box appears in which they can either enter a report name directly or display a list of possible reports.

CREATING A QUERY

R/3 Release 4.6C has introduced “InfoSet Query”, a new tool based on SAP Query technology that enables end users to quickly and easily generate or modify ad hoc reports on their own. Via this new tool, which uses the SAP role concept, users can create and publish Web reports that can be accessed via a browser, and export reports to Microsoft Word and Excel. That's good news for end users, and even better news for IT departments, which are often overrun with end user requests for these types of requirements. This new tool is called InfoSet Query and includes the following new functions:

Reporting on Personnel Planning Data

Up to now, Ad Hoc Query only enabled to select sets of persons. No Personnel Planning data could be used to make initial selections. As of this release, users can select objects from Personnel Planning by using an InfoSet specially created for selecting a specific object type, such as business events or positions.

Deactivating Object Selection

The object selection such as the person selection can be deactivated to work in "basis mode". Thus, users can access all basis mode functions - for example, they can select according to texts.

Drag & Drop

As of release 4.6, users can “drag & drop” to select fields. They simply need to drag one or more selected fields to the required area. They then serve as selection and/or output fields.

Displaying the Last Queries Used

Up to now, users could only load former queries using a dialog box accessed by choosing Query -> Open – which is still available. But the Query menu now includes the last five queries used. A simple mouse click enables users to load them.

Processing Fields With Text

Up to now, you could select entries in separate columns for fields with text to determine whether the value and/or its text was output.

In 4.6, each InfoSet field is flagged with an icon that indicates whether it is a simple field, or a field with text.

Displaying Field Characteristics

The InfoSet Query screen enables you to show an additional screen area containing technical information on a field. If you want to show the screen area for a field or display technical information on a different field, access the context menu for the field in question and choose Display field information.

User Settings

Up to now, Ad Hoc Query was always started using the standard settings (for example, the basic list was always used as the type of output list).

As of this release, your settings are saved and then reloaded the next time InfoSet Query is started. For example, if you create a statistic, exit InfoSet Query (or log off the system), and then re-access InfoSet Query later, statistics is used again as the type of output list.

New Maintenance for HR InfoSets

Up to now, texts on particular field values were presented as additional fields, which had to be selected explicitly when a functional area was created.

As of this release, texts are determined automatically. That is, if you select a value field for an InfoSet, its text is automatically selected too.

The selection of infotypes in an InfoSet can be changed as required later. Up to now, infotypes could only be added. As of this release, it is also possible to remove infotypes later (provided that none of the fields is used in a query).

Simulated infotypes

These infotypes enable users to run evaluations and reports using data from different data sources (infotype data, time evaluation results, personal work schedule data) available in an overview using the infotype concept. For example, users now have the option of defining time infotypes by combining any relevant time types, absence and attendance types, or wage types to create specific balances they looking for. The system reads the relevant tables in cluster B2 and stores a balance in a “simulated” infotype for each day. These balances can be queried as though they are infotypes (EE times = IT2502, Quota statuses = 2502) These simulated infotypes can be used similar to regular infotypes for Ad Hoc Query reports because they are provided in the same manner as other infotypes in the logical database PNP.

With the improved functionalities in release 4.6 there is really no excuse for not using Ad hoc Query – which is all about empowering the users and giving them instant access to information without having to involve HR or IT departments. Ad hoc query is the most powerful and user-friendly tool for evaluating Human Resources data. Its simple range of selection and output fields enable users to access data from all areas within HR - and this without any programming skills.

*****************************************************************************************

R/3 Reporting: Sessions

Build a rock-solid roadmap to take your R/3 reporting to the next level

Speaker: Taylor Erickson

Break your reliance on custom ABAP reports and propel your reporting processes to new levels of ease, effectiveness, and efficiency. Learn how to build a blueprint guaranteed to make the most of the R/3 reporting tools already at your disposal.

In this session, you will learn…

What 5 core reporting development tools are already in your arsenal, and when to use each

How SAP Query, ALV and other key tools are enhanced in R/3 4.6C and R/3 Enterprise

4 steps to optimize your report development cycles

Success factors for module-specific reporting tools for HR, Financials, and Logistics

6 drawbacks of creating custom ABAP reports — and how not to get burned by them

How Sarbanes-Oxley, new module rollouts, and other forces reshape your reporting environment

3 hallmarks of good R/3 reporting practices — and how to master each

New R/3 reporting tools that give your business users “quick view” and “ad-hoc” capabilities

BONUS TOOLS: Detailed matrix of the major R/3 reporting tools and when to use each; step-by-step roadmap for fulfilling report requests quickly and efficiently; sample organizational structure to speed and strengthen your report development cycles; answers to reporting FAQs; expert tips and R/3 version comments on each R/3 reporting tool.

Pinpoint the reports and data you need — Best practices and key methods

Speaker: Danielle Larocca Signorile

Before you take on custom development or start wielding any of the R/3 reporting tools, see if you can save yourself lots of time and money by first tapping into the thousands of ready-made reports that R/3 has pre-built into it. In this session, discover…

How to quickly get your hands on the R/3 reports you want using Report Navigator

How to find reports based on Standard Prefixes, using SE38

The key search, navigation and customization capabilities of the General R/3 Report Tree

5 steps to locate hidden reports within your R/3 environment

Proven techniques to upload pre-built reports to the Report Tree for quick access

Exactly where your R/3 data resides and how it is updated

The right way to copy and modify your Report Tree How to use hybrids of standard and custom reports to save time and money

BONUS TOOLS: “Cheat sheet” with the names and menu paths for key reports, listed by function; instructions to search your SAP system for pre-built reports you can use right away; OSS patches needed to enable the Report Navigator and General Report Tree; 5-step contingency plan for when you can’t find the canned report that fits your needs.

How to fully leverage HR and payroll reporting capabilities in R/3

Speaker: Danielle Larocca Signorile

Discover how to meet all your HR reporting requirements by optimizing your use of SAP Query, InfoSet Query (formerly the Ad Hoc Query), and the HR Information System (HRIS). Discover how these solutions can put important personnel, payroll and benefits information at your fingertips as you come to understand…

5 core HR reporting options you have — from Standard Reports to Infoset Query

Proven strategies and best practices to access PD and PA data

How to unlock the full potential of logical databases — specific do’s and don’ts

The latest HR reporting enhancements in R/3 4.6C and beyond

Best practices to deal with unique HR info types and exceptions

How to create robust payroll data reports with sorting, subtotaling and other built-in functions

Pitfalls of reporting on hierarchical data in Org Management — and how to avoid them with evaluation paths

BONUS TOOLS: Complete decision matrix for choosing between the key HR reporting options; feature and function lists for core R/3 reporting tools; workarounds to common HR reporting challenges

Empower your business and end users with the SAP Query

Speaker: Danielle Larocca Signorile

Put this powerful cross-functional reporting tool in the hands of your end users, train them properly, and watch them get the R/3 data, reports, and customization capabilities they need without involving your IT staff. Learn why the SAP Query has overcome its reputation for being a performance hog. In this session, you will see how to…

Leverage the improvements in SAP Query that are built into the latest releases of R/3

Avoid performance bottlenecks and turbo charge your SAP Query reports

Configure and use SAP Query, with expert tips for administration Spruce up SAP Query report screens with images, charts and other visuals

Teach users to integrate reports with conditional analysis and “what if” statements (No programming needed!)

Unlock the advanced functionality of SAP Query via configuration screens

Use SAP Query for transaction-based reporting, and why you should stay away from hierarchical data

Use a simple performance trace test to predict the hit you’ll take when using SAP Query for specific tasks

BONUS TOOLS: Complete “Train the Trainer” roadmap for getting your end users up to speed on SAP Query; definitive guide for configuring SAP Query from A-Z; screencams of both the configuration steps and report creation steps; bonus instructional documents on the creation of variants, the creation of calculated fields, and on how to insert pictures and symbols into your SAP reports

Access R/3 data quickly and easily with InfoSet Query, Ad Hoc Query and Quickviewer

Speaker: Danielle Larocca Signorile

Streamline your report development and customization with these dynamic R/3 based tools. These tools offer those who know how to use them properly easy and valuable ways to get at important business data across all your modules. In this session, you will learn to…

Leverage these tools to generate quick lookups of SAP data with little work or customizing

Understand how to use strict naming conventions to ease deployment of these solutions

Compare and contrast each tool’s unique features to help users know which to use in each circumstance

Meet daily and weekly reporting requirements easily with these tools

Secure, administer and performance test reports created with InfoSet Query, Ad Hoc Query and Quickviewer

Avoid common user-training pitfalls, particularly when it comes to variants

BONUS TOOLS: Complete list of features and functions of each tool; answers to FAQs about Ad Hoc Query, InfoSet Query and Quickviewer; guidelines, examples and screenshots to implement and train users on these tools in just a few days; toolbar “cheat sheet” for each of these tools, so that you can learn their functionality faster

How to optimize LIS & SIS

Speaker: Taylor Erickson

Master the challenges of setting up and using LIS & SIS to get the data you need out of your core logistics and sales modules (SD, MM, PP, etc. ). See how these tools can help you extract new or changed data, and create reports that enable you to summarize, drill down, and present sales and logistics data with significant speed and flexibility. In this session, you will get expert advice that will help you. . .

Optimize the two primary functions of LIS: Collection and presentation of logistics data

Take 3 important steps to prepare your R/3 environment for using LIS

Access underutilized statistical and graphical functions of LIS, from ABC analysis to Gantt charts

React quickly to emerging trends, using LIS/SIS’s early warning and exception management mechanisms

Get a headstart on your future BW implementation with critical LIS terminology and characteristics

Properly design LIS/SIS infostructures

Use advanced LIS and SIS functionality incorporated into R/3 4.6C and R/3 Enterprise

Build reports that integrate data between LIS, COPA and other key functional areas

BONUS TOOLS: List of user exits and sample code to help you circumvent common LIS stumbling blocks; guidelines for when to create a report with LIS Flexible Analysis; step-by-step instructions to optimize and ease the development of LIS/SIS reports

Tips and tricks for getting the most out of Report Painter/Writer

Speaker: David Nowak

These important tools are not just for financial reporting. They can be your best options for getting data from other R/3 modules – if you know how. In this session, you will discover techniques and advice to get the most out of Report Painter and Writer, as you learn to:

Maximize your use of objects, including libraries, sets, and variables

Link to logistics data using statistical key figures

See important rules of thumb for setting up Report Groups to streamline access

Utilize best practices for setting up naming conventions

Take new, more effective approaches to using sets, including conversion in 4.5b and use of groups as sets

Take full advantage of the important changes to Summation levels in 4.5 and beyond

Handle all variable types with ease, including global, local, system updated, and even variable user exits

Build on existing reports and data links using SAP’s Report-to-Report interface

Boost performance by better leveraging data extracts P

ut Report Painter to work in project systems

BONUS TOOLS: Tactics for table usage, including standard delivered reporting tables and how to add evaluation structures; step-by-step procedures and tips for handling forms, sections and formulas, including normal constraints and calculated key figures, general data selection pointers, including what you must include in your Report Painter reports

Best practices for R/3 Financial Reporting and COPA Reporting

Speaker: Quentin Hurst

Get more mileage from the financial reporting tools at your disposal, including drilldown reporting, the Report-to-Report Interface of COPA, and Special Purpose Ledger. Learn what is possible and the best way to use specific tools, as you…

Optimize your use of drilldown reporting in PA (Profitability Analysis) and PC (Product Costing)

Fine-tune your COPA reports for optimal data flow

Understand what’s available with non-COPA drilldown reporting (FI, AR, AP, PCA)

Learn how to use “Report Splitting” and Summarization Levels to optimize COPA performance I

nventory your Product Costing reporting options

Discover the key decision factors for Special Purpose Ledger

Unleash the new graphical capabilities of drilldown reporting available with R/3 4.6C

Assess your Financial Statement Package from both tactical and strategic perspectives

Find out some key FI/CO reporting areas that are impacted by Sarbanes-Oxley and other new legislation

Understand R/3’s Liquidity Forecast and the Cash Management Position reporting capabilities

BONUS TOOLS: List of transaction codes that enable drill down reporting within each module; step-by-step process for getting Special Purpose Ledger up and running.

Winning R/3 report distribution strategies

Speaker: Quentin Hurst

Learn more efficient and flexible report distribution strategies so that you can easily get R/3 reports to the people who need them. Discover the many common and undocumented methods to put R/3’s built-in report distribution technologies to work, as you…

Uncover tricks for using R/3’s report scheduling, job creation, and background processing capabilities

Learn how to create shortcuts and add your custom reports to transaction codes and menu-paths

See how to display reports in Excel with SAP GUI using the latest features in R/3 4.6C

Understand where the Web fits into your report distribution options

Find out how to add reports to area menus for simpler user access Know how to exploit the mail and desktop application integration capabilities of SAP Office

Optimize your use of Report Trees to organize and access over 700 SAP reports

Incorporate variants and drill-down capabilities into your report distribution process

Know the best ways to distribute R/3 reports to SAP and non-SAP users

Employ user profiles and other proven security techniques

BONUS TOOLS: List of do’s and don’ts for scheduling report jobs, output, and background processing; step-by-step process for adding a custom report to a transaction code and menus; pitfalls and workarounds for uploading custom reports to area menus

Critical R/3 reporting lessons: 5 case studies

Speaker: David Nowak

Learn how other companies are leveraging R/3 tools to meet their real-world reporting problems. Avoid the mistakes they made and replicate their successes. You will…

Find out how one company reduced their custom ABAP requirements by over 80%

Get practical tips on everything from configuration to procedural changes to user exit/ABAP development

Discover creative ways to fulfill report requirements using standard R/3 tools instead of ABAP

Learn how one SAP customer tackled the challenge of daily forecasts using a 365-period fiscal year

Strategies from the trenches to push customization to end users

Discuss one company’s solution to analyzing its project system reporting problems

See how companies integrate user feedback into the report creation process to cut post—development work

Learn why production-related activity is much easier to gather through a link to LIS

BONUS TOOLS: Screenshots, sample reports, and strategies from successful reporting projects and major SAP customers; practical scenarios and solutions that you can put to work at your company

Web-enable your R/3 reports – Options and strategies

Speaker: Penny Silvia

You have some critical decisions to make in order to deliver R/3 reports over the Web. This session will give you a detailed explanation of your 5 key options, and show you which to focus on and which to avoid.

Know the tradeoffs between Web reporting strategies, from presentation to customizability to ease of deployment

Prepare for different security models required for each Web reporting option

3 factors to determine when it makes sense to redevelop reports on a Web AS server

Know your Web-enablement options for custom reports, list-based reports, ALV, Report Painter, and more

Avoid getting burned by hidden user licensing costs

Where to consider using third-party Web-enabling solutions and how to select the right one

Tap into BW’s Web-enabling features without moving your R/3 data or implementing a full data warehouse

Learn what function modules available with recent releases can make your Web reporting tasks easier

Understand and work around ITS’s Web limitations, especially when it comes to display and selection screens

BONUS TOOLS: 10-step questionnaire to identify the right Web-enablement option; complete list of benefits, challenges, and limitations of each option; warning signs for avoiding common Web reporting headaches

If, when, why and how to incorporate BW into your R/3 reporting landscape

Speaker: Penny Silvia

Discover exactly how SAP Business Information Warehouse (BW) complements your available R/3 reporting solutions, and prepare your R/3 team for integrating BW into your reporting landscape whether you’re about to implement BW or plan to use it further down the road. In this session, you will…

Understand BW’s unique terminology, components and architecture relative to R/3

Learn specifically where BW can improve upon R/3 with regard to analytics and display

Discover steps R/3 teams can take to accelerate ramp-up time for BW — especially for data extraction

See the proper process and key steps you need to take to migrate reports and data from R/3 to BW

Navigate the integration pitfalls between your R/3 and BW reporting landscapes

Know why and how you’ll always need to use R/3 reports, especially for real-time reporting

BONUS TOOLS: BW implementation key steps and challenges for R/3 teams; criteria to determine optimal timing of your migration to BW

Demystifying BW: Honest Answers to Twelve Frequently

Speaker: Penny Silvia, Ajay Bhardwaj

This session will eliminate misconceptions and clarify your understanding of what Business Information Warehouse (BW) is and how to prepare for it. Find out…

How BW content is delivered and how that impacts your team

What’s involved in bringing non-R/3 data into BW

What the end user training curve is and how to navigate it

The type of hardware you need to support BW

Typical implementation approaches that fit your organization

What hard and soft costs BW brings to the table

ALV for business analysts and power users

Speaker: Ajay Bhardwaj

Consolidate many of your custom ABAP reports and give executives, analysts and users the ability to generate, display and customize reports. The key is mastering the ALV Grid Control, which is new with R/3 4.6C. In this session, you will learn how to…

Tap into key ALV capabilities – take a tour of major features and configuration steps Avoid ALV performance hits

Collapse multiple reports into one, drastically cutting down your report development time

Save many hours using built-in ALV sorting, subtotaling and filtering capabilities

Add conditional structures into your ALV report: No programming required!

Combine ALV with display variants to meet a wide range of reporting requirements more easily

Dynamically reorder column layouts and add/subtract fields

Enable users and analysts to save their own personalized variants

Roll ALV out to your users – get proven strategies, complete with tips and pitfalls to avoid

See why you shouldn't use ALV for Balance and Formatting reports

BONUS TOOLS: Quick guide/desk reference covering all of the features in ALV; comprehensive training aids for users, including screenshots and real-world examples

Integrate the ALV Grid Control into your custom ABAP reports and programs

Speaker: Ajay Bhardwaj

This in-depth technical session will be of particular interest to developers, who will receive detailed instruction to get the most from this important tool. Find out how to…

Add ALV functionality to custom reports and screens, as well as your existing reports

Choose between ALV function module and class: Which is better for your implementation?

Master the key input parameters/methods to give users what they want when they need it

Access the ALV grid control via key SAP—delivered screens

Deliver ALV functionality with the fewest lines of code possible

Avoid potential performance hits with ALV before they drag down your production system

Disable certain ALV functionality before your users wreak havoc on your R/3 system

BONUS TOOLS: Step-by-step instructions to enable/disable fields; sample code and templates to preview the most useful ALV features; detailed debugging and tracing techniques; guidelines to leverage undocumented ALV features

DEVELOPERS BONUS SESSION:Performance-tune your custom ABAP reports the right way

Speaker: Ajay Bhardwaj

You will see how changes in remote connectivity to the Domino back-end can improve the performance of your applications. You uncover...

Expert advice to use the Domino JSP tag libraries to add custom tags to JSPs, and how to use them to build more dynamic Web pages

Techniques to leverage servlets for better applications and faster development

The differences between J2SE and J2EE, and how they impact your applications

Design considerations for calling Java from LotusScript using the new class interfaces

Tips to handle the differences between local and remote access from a Java servlet or application

Best practices to leverage code stored in Java libraries, and much more

[Former Member]

Hi dharani,

Go thru this link, It will very much help u.

http://help.sap.com/saphelp_nw2004s/helpdata/en/1e/ed7a38f7da1404e10000009b38f842/frameset.htm

Regards,

Kumar