Ansicht
Dokumentation

PYAU_REP_GEN_UTIL - Configure Reports using Report Generation Utility

General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Purpose

You use this report in conjunction with the Report Output (HKWRPT_TOOL) to generate employee-specific, form-based reports (Adobe form and Smart form) and List only reports.

On the Report Generation Utility screen, you can view SAP-delivered reports that you can customize depending on your requirements. Alternatively, you can also create new reports.

Based on these customizing settings, the Report Generation Utility displays the output of a particular report either as List Only, List with Adobe Form or List with Smart Form depending on the report output type selected.

Integration

Business add-ins Populate or Override Field-level Data (HRPADKWRPT_TOOL), Populate or Override Employee-level Data (HRPADKWRPT_TOOL_RECORD) and Populate or Override Report-level Data (HRPADKWRPT_TOOL_REPORT) are implemented.

Note:

• It is strongly recommended NOT to change SAP standard BAdI implementations for meeting specific business requirements. Changes to standard BAdI implementations might result in data corruption issues that will NOT be supported by SAP.

• In case of specific requirements for custom needs, it is recommended to create customer-specific BAdI implementations.

Prerequisites

You have the requisite forms (Adobe form or Smart form) in the system with an associated structure (provided the Report Output Type you have selected is either List with Adobe Form or List with Smart Form).

Features

The Report Generation Utility screen has the following sections:

• Application Toolbar

The toolbar gives you options to create a new report, save the report configuration, delete an existing report and execute a report.

Note:

• On clicking Create, a dialog box appears where you can create a new report by providing the desired report name, report title (description), country grouping and report output type. Also provide the form name if you select the output type List with Adobe Form or List with Smart Form.

• Report deletion is an irreversible process.

• Click Execute to run the selected report. The system then opens the Report Output (HKWRPT_TOOL) program from where you can run the report with the desired selection criteria.

• Report Name/Title

This section displays the complete list of existing reports.

• Report Overview

On selecting an existing report in the Report Name/Title section, the Report Overview section is displayed where you can view and edit the following report properties:

• Report Name - Technical name of the report

• Report Title (editable) - Descriptive title of the report

• Country Grouping - Country for which the report is applicable

• Report Output Type - Output type of the report

• Form Name - Name of the particular Adobe or Smart form to be used if the output type is List with Adobe Form or List with Smart Form, respectively

• Employee Override BADI Implementation (editable) - BAdI implementation to be used to populate or override data in one employee record of the output at a time. Click the adjacent Information button to view the BAdI documentation.

• Report Override BADI Implementation (editable) - BAdI implementation to be used to populate or override output data at the report level, that is, for multiple or all employee records. Click the adjacent Information button to view the BAdI documentation.

• Period Determination for Payroll (editable) - If the report has fields with payroll as their data source, this indicates the payroll period for which the report should be executed, that is, either the FOR period or the IN period.

• Tabs to configure the report fields

This section allows you to customize the various aspects of a field of the report under the following tabs, based on the information you maintained in the Report Overview section:

Field Attributes tab

In this tab you can configure the following attributes of the field:

• Field Name

Enter the field name that should be displayed on the ALV output if the Report Type is List Only. If the Report Type is List with Adobe Form or List with Smart Form, the system fetches the field name automatically from the structure associated with the respective form.
Note: The field name cannot have spaces.

You can also use the following buttons available next to the field:

- Next Field and Previous Field to navigate to other fields configured in the report

- Add Field to configure a new field in the report

- Overview to view all the fields configured in the report

- Delete to delete the selected field

• Field Description

Enter a short description of the field if the Report Type is List Only. If the Report Type is List with Adobe Form or List with Smart Form, the system fetches the short description automatically from the structure associated with the respective form. This value will be displayed as the column header in the List output. (Note that this field value is case-sensitive.)

• Select the following checkboxes as needed:

- Required Field

- Selection Screen Field

- Display Field Text

- No Output

Processing tab

In this tab you can define the data source of the field.

• If you want to define a data source for the field, select Data Source Selection.

1. In Data Source, select one of the following as the source type of the field:

- Master Data (fetched from info-types)

- Payroll Data (fetched from cluster tables)

1. In Source Table, from the available search (F4) help select the relevant infotype in case of a master data source or a cluster table in case of payroll data source.
2. If the data source is master data, select the relevant Subtype of the chosen infotype, if any.
3. In Source Field, from the available search (F4) help select the relevant field of the source table.
4. In Source Criteria, select whether you wish to display the latest record, earliest record or all records of the infotype.

• If you want to assign a desired fixed value for the field, select Fixed Value.

In User Input Value, specify the fixed value that should be displayed in the output for all employees.

Custom Code tab

If the data source for the field is neither an infotype nor payroll nor a user input, in this tab you can specify BAdI information for populating or overriding data in the field.

You can use any of the existing (SAP-delivered) BAdI implementations. Alternatively, you can also create a new implementation under the SAP-delivered BAdI definition.

1. In BADI Implementation, select the BAdI implementation that should be used to populate the field or override its data. Click the adjacent Information button to view the BAdI documentation.
2. In Parameter 1, enter the value to be passed as the first input parameter to the BAdI implementation.
3. In Parameter 2, enter the value to be passed as the second input parameter to the BAdI implementation.

NOTE:

You can configure the value of a field in the following ways, and the system determines the value considering the options in the following order of priority:

1. User Input in the Fixed Value section of the Processing tab
2. BAdI Implementation in the Custom Code tab
3. Infotype or Payroll Cluster in the Data Source Selection section of the Processing tab

• Selection Criteria

In this section you can specify the conditions based on which the values of the report fields should be fetched from the source table.

• Using Insert Row, add conditions with the following information:

- In Source Table, select the payroll cluster table from which the field values should be fetched.

- In Query Field, select the field of the source table on which the condition will be applicable.

- In Comparison Operator, select one of the operators from the search help.

- In Comparison Value, enter the value with which the query field should be compared.

• Use Delete Row to delete existing conditions.

Note: Using the logical operator ‘AND’ or 'OR', either all or some of the conditions are considered for fetching the field values.

Selection

Standard Variants

Output

• The configurations maintained for a report through this utility will be saved in the following tables:

• Report attributes in T7KWRPT_ATTRIB and T7KWRPT_ATTRT

• Fields in T7KWRPT_CONFIG and T7KWRALV_FLDT

• Conditions in T7KWRPT_QUERY

• Upon executing a report from this utility, the selection screen of the report will appear in the Report Output (HKWRPT_TOOL) program.

Activities

• If you select Report Type as List Only, the system permits you to insert new fields and delete existing fields using the Add Field and Delete Field buttons in the Field Attributes tab, respectively.

• If you select Report Type as List with Adobe Form or List with Smart Form, you cannot insert new fields or delete existing fields. System will automatically fetch all the fields from the associated structure of the form, and you can only customize the fields in the different tabs of the configuration screen.

• To customize and then execute reports, run the transaction HRPADKWRPT_CONFIG.

• To execute reports that are already customized in the system, run the transaction HRPADKWRPT.

• Use Authority Object for Report Output (P_KW_REPT) to restrict users from accessing non-relevant reports.

Example

CPI1466 during Backup   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 14922 Date: 20240523 Time: 215022     sap01-206 ( 177 ms )