free download sap,abap,basis,fico information mate

RSS Feed Homepage

Articles: 1, 2

Creating Queries
2008-02-07 20:53:00
If you want to create a new query, you have to specify the following information so that the system can generate your report:Functional area Title and list format Field selection (fields used in the list) List layout (structure of basic list, statistics and ranked lists) To create a new query, proceed as follows: Call the component Maintain Queries. Choose the user group to which you want to assign the new query. Enter the desired query name. The name of the query can have up to 14 characters and should not already exist in the user group.Choose Create. You then see a list of the functional areas assigned to your current user group.To select the functional area you require, place the cursor on the functional area and choose Choose. For further information about creating functional areas, refer to Creating and Changing Functional Areas. If many functional areas with multiple fields are assigned to one user group, you can use the search function to find the right functional...

Assigning Title, Format and Notes
2008-02-07 20:53:00
The first attributes you must define when creating or changing a query are the title and page format. This is the first screen of the Field selection sequence.ABAP Query uses the title you define in this screen later as the title of the screen or, when printing, as the first line of the heading for the lists generated by the query.Additionally, there are three lines where you can enter notes which are used to document the query. When you request the query directory, the system displays these notes with the title.There is a standard format for lists displayed on the screen, but you can always overwrite this. Unless you specify otherwise, the system automatically adapts the standard format to the output device used. For output to the screen, the default is a dynamic page size (i.e. no fixed number of lines) and 83 columns. In the case of output to a printer, the system proposes a standard format on the print option screen, but you can also overwrite this.With the number of columns, yo...
More About: Notes , Title , Format

Direct Interaction
2008-02-07 20:52:00
It is possible to execute queries without displaying the query list on the screen. You can instead run interactive further processing functions, display the list as a table or interactive list, or save the list automatically. The section below refers to this process as direct interaction or direct further processing of the list. When using direct interaction, you should bear in mind the following points:The radio buttons for the interactive functions Display as table, Interact ive list, Download to file, Word processing, Table calculation, Graphics, ABC analysis, EIS, Private file, and Additional function pool appear on the query selection screen only if the first sublist is a single-line basic list, a statistic or a ranked list. The option Download to file allows you to include a suggested name for your file as well.You cannot enter the name of an Additional function pool function directly; it must be inserted in the field with the help of the possible entries pushbutton on the sele...
More About: Direct , Interaction , Rect

Additional Function Pool
2008-02-07 20:52:00
All interactive functions for adjusting (comparison of) query lists (display as table, download to file, ABC analysis, and so forth) work according to the same principle: Sublist data together with descriptions of this data are passed by way of an interface to another program (a function module). The number of functions that can be attached to query lists in this way is not limited. The Additional function pool acts as a container for these functions.The Additional function pool function bundles an arbitrary number of interactive functions for single-line sublists together. Each of these functions must be implemented using a function module with a defined interface. Which and how many of the functions you want to make available to the user can be determined by using the maintenance component for the Additional function pool. For further information, refer to the section on Maintaining the Additional Function Pool . The following functions are delivered in the Additional function po...

Private File
2008-02-07 20:51:00
If you are using the version of ABAP Query supplied by SAP, you do not have this function. However, the delivery system includes an enhancement (SQUE0001) which allows all customers to add their own interactive functions. The Private file function appears on your screen only if you take advantage of this enhancement option. To do this, you (or your system administrator) must take the necessary steps and activate the enhancement. For further information, see Enhancement SQUE0001: Private File s).Generally, this function works in the same way as the other standard interactive functions. It gathers the data from your query together in a table and then passes it to a function module written in the course of the enhancement. What actually happens to the data is up the customer.The Private file function has largely been made obsolete with the introduction of the Additional function pool (see Additional Function Pool). SAP will continue to support the Private file function for reasons o...

EIS
2008-02-07 20:51:00
This function provides a link to the Executive Information System (EIS). It transfers the data in your query to the EIS database via an interface and you can then perform further analyses. When you activate the function, you specify various options for storing the data in a dialog box. For further information, see the EIS implementation guidelines.

ABC Analysis
2008-02-07 20:50:00
The ABC Analysis function can be used for any single line basic list, all statistics and any ranked list that contains at least one numeric field. For the ABC analysis the data records of a dataset are divided into three groups (A segment, B segment, C segment). Each of the data records must include a key figure (a numeric field) and an arbitrary number of other characteristics (non-numeric fields). The dataset is initially sorted on the key figure in either descending or ascending order. The data records can then be divided into groups according to one of four strategies: Key figure (percentage) The data records are divided into groups according to the size of the partial sum of the key figures considered as a percentage of the sum of all the key figures. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A as long as the sum of the key figures does not exceed 50% of the total. The data records will then be ...

Word Processing
2008-02-07 20:50:00
The word processing functions can be called from the list display and from the table display (display with the help of the table view control). There are two different functions available:Form letters using MS WORD A WORD file is created using the data from the current partial list and is linked to another WORD document. Substitution variables can be incorporated into the WORD document and these can be filled with values from the created WORD file. Special functions are made available to MS WORD via OLE2 for this purpose. This form letter functionality can be used only if MS WORD has been installed on the PC. Creating a document The current partial list can be stored on the presentation server as a file in RTF format. The use of this format allows the file to be used as a WORD document. One can specify whether the colors in the list should be taken into account. The filename (the complete path) must be specified in the dialog. If MS WORD is installed on the PC then it can be used...
More About: Word , Word Processing

Graphics
2008-02-07 20:49:00
This function allows you to display the information from your list using SAP Business Graphics .In contrast to the other functions described in this section, the Graphics function can only handle an extract from one column of your sub-list and the column must contain numeric values.You can choose which values you want to display by placing the cursor on them when activating the function. Position the cursor on the column of the partial list whose values you want to display in graphic format. You should note here that SAP Business Graphics can handle only a limited number of values (between 6 and 32). Since the cursor position determines the first value to be processed, place the cursor directly on that value. The function then processes the value together with all the subsequent values in the same column.If you do not position the cursor as described above when activating the function, the system itself determines a start value somewhere near the cursor position. For this reason, you...

Table Calculation
2008-02-07 20:49:00
This function exports data via the XXL interface. If you activate it, you see a dialog box where you can decide how you want to proceed further with the data. You canpass the data to a table calculation program (e.g. Excel) and start the program using this data orstore the data as a file for a table calculation program orstore the data as a SAPoffice document. The connection to table calculation programs described here requires these programs to be installed according to the XXL interface guidelines. For further information on how to perform this installation, refer to the relevant documentation.The option to start the table calculation program is not available if the start itself is not possible.If you pass a basic list, the lines at the beginning of the control level and all sub-totals lines and overall totals lines are not taken into account. If you pass a statistic, the totals line is not taken into account.
More About: Table

Download to File
2008-02-07 20:49:00
The Download to file function allows you to download the data retrieved by the query to a local file on the presentation server. The function module DOWNLOAD performs this process. When you activate the function, you see a dialog box where you can specify the file name and the data format. The system uses the contents of the input field located next to the radio button Download to file on the selection screen as a default for your file name. If no file name was entered on the selection screen, the system chooses a default name for you. This name contains the name of the query and the user group name.You can choose the check box With column header in the dialog box. This will save your data with column headers if its data format so allows (DAT and DBF). Whereas the Download function available in the System menu (choose System ® List ® Save ® Local file) stores the list on the presentation server as an ordinary text file without structured list lines, the Download to f...
More About: File

Interactive Functions for Further List Processing
2008-02-07 20:48:00
ABAP Query also provides a range of interactive functions allowing you to pass lists (or, more precisely, data retrieved by a query and displayed in lists) to other software products for further processing: Further information is contained it the following sections.
More About: Interactive , List , Functions , Interact

Common Principles when Passing Lists for Further Processing
2008-02-07 20:48:00
The interactive functions for further processing lists are governed by certain common principles:If a list consists of several sub-lists (a basic list, statistics and ranked lists), you can pass only one of these for further processing. This is always the sub-list where the cursor is when you call the function or the first sub-list to be displayed on the screen.These functions can handle any statistics and ranked lists, but can only be used with basic lists if they are defined as one-line lists. In one-line basic lists, all the lines displayed on the screen have the same structure with the obvious exception of those lines which introduce a control break or contain the sub-totals or overall totals. Lines of one-line basic lists may sometimes extend onto the next line, if the line width you choose when defining the query is too small, but this does not alter the fact that you are dealing with a one-line list. You can also call these interactive functions from the display with the ta...
More About: Lists , Common , Passing , Principles

Saving and Redisplaying Lists
2008-02-07 20:47:00
When you execute a query, ABAP Query evaluates the data from a database and outputs the results in a list which you lose as soon as you leave the list display. If you want to redisplay the same list later, you have to execute the query again with the same selections and ABAP Query has to re-evaluate the database. This is unsatisfactory, especially if you are dealing with lists such as year-end closings which do not change, but you need to display them often.ABAP Query allows you to save any lists you have generated and to redisplay them later. When you display a list which has already been saved, no more database accesses are necessary. For this reason, the response time is considerably faster than recreating a list by executing the query again. Saving lists Execute a query of your choice. For example, suppose you want to start the query G1 from the user group FB (for information about how to create this query, see the next chapter). After you have entered your selections, a lis...
More About: Lists

Calling Other Reports
2008-02-07 20:47:00
Reports residing in different applications can call each other in the R/3 System across the Report-Report-Interface RRI. The term ?report? is used here to include all of the following: ABAP reports (including query reports), transactions, Report Writer reports, EIS drill-down reports and report portfolio reports. The query is integrated into this interface. This means that query reports can both be called via this interface (as recipient) and can themselves call other reports (as sender). Before a query can be used as a sender or a recipient it has to be made known to the interface. You should refer to the remarks on using the Report-Report-Interface in Assigning Title, Format, and Notes.For query lists there are two interactive functions in the Goto menu which allow access to the Report-Report-Interface.Call report Reports are called using the interface either over the menu path Goto ® Call report or by double-clicking (F2) on the appropriate line. Before a further report ...
More About: Calling

Improving Response Times
2008-02-07 20:46:00
Response times depend largely on the type of system you have and the system load at the time, although the number of database accesses needed to process your query also plays a part. The actual processing of the data is virtually irrelevant as far as the runtime is concerned. Reducing database accesses The functional area you choose (see Creating and Changing Queries) determines the database to be evaluated. Each database has an associated selection screen which is automatically displayed when you start a query. Any selections you enter on this screen directly affect the response time. Therefore, the more precisely you select your data, the shorter the response time will be.Please also make use of the dynamic selections facility. Dynamic selections also directly affect response times.
More About: Times , Response

Interactive List Display Functions
2008-02-07 20:46:00
There is a range of interactive functions which allow you to display any list on the screen in a different way. List overview If your list consists of several parts, e.g. a basic list, two statistics and a ranked list, ABAP Query allows you to choose one of these list types directly. To do this, proceed as follows:Select List overview. You then see an overview of the sub-lists.Place the cursor on the desired sub-list and select Choose. You then return to the list display screen which contains the sub-list you selected. Selections If you want to know what selections were entered on the selection screen, use the Selections function. This is particularly useful with saved lists (see Saving and Redisplaying Lists). Drill-down functionality for multiple line basic lists With multiple line basic lists, you can sometimes choose between an expanded format and a compressed format. A multiple line basic list is a list containing several lines with a different structure. Suppose ...
More About: Interactive , Display , Functions , Interact

Executing Queries Online
2008-02-07 20:45:00
To execute a query online, select Query followed by Execute or Execute with variant. If you select Execute with variant, you see a dialog box where you can enter the variant name. A variant is a saved set of selection criteria for a query or the report generated by the query. If you specify a variant when starting a query, the system uses the values in the variant for the query selection criteria.You enter variants on the selection screen and save them under any name. For each query, you can create any number of variants. To create a variant, select Goto ® Maintain variants.With queries from the global query area you can create system variants. For further information, see Query Areas.For further information about variants, please refer to the appropriate sections in the ABAP User Manual or to the online documentation Getting started with R/3. You can create one standard variant per query. This standard variant is always used when you choose Execute. If you select Exec. wit...
More About: Online

Executing Queries in the Background
2008-02-07 20:45:00
If you want to execute the query as a background job, choose Exec. in background.When scheduling a job, you must define a variant and specify the start time.Please remember that background processing always requires a variant. If you have still not created a variant for the query, you can do this on the initial screen for background processing. For information on all other options and processes, refer to the online documentation Getting started with R/3.
More About: Background

Executing Queries
2008-02-07 20:44:00
When you have chosen a query and a user group on the initial screen, you can execute the query online or in the background. Further information about this is contained in the following sections.