Ansicht
Dokumentation

HINUDNUP - System Interface with EXCEL (Download from IT8/Upload into IT15)

Addresses (Business Address Services)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Title

Utility program to download data from IT0008 and appraisal points from appraisal model, and upload data to IT0015.

Purpose

1. To download Basic Pay from IT8 and Appraisal points into an Excel file.

2. To upload data from an Excel file to IT15.

Integration

Prerequisites

1. The excel file should be in 'text tab delimited' format for upload to happen.

2. Appraisal model should be present and the appraisal done for the employees for whom the program is being run.

Features

Selection

Selection is only on personnel number

Standard Variants

Output

Activities

1. Running the program to download data from IT0008 and getting appraisal points from the appraisal model and saving this in an excel file in "tab delimited" format.

2. Calculating bonus amount based on the excel obtained above and saving the information in the same excel.

3. Running the program again to upload the bonus details to IT0015 from the excel file.

Example

1. Downloading Basic Pay and Appraisal Points.

Procedure:

1. Run the report HINUDNUP.

2. Select the 'Download' radio button.

3. On the selection screen enter the following data: Personnel number range, Appraisal period begin date, Appraisal period end date.

4. Also enter the effective date of download (data valid as of this date will be picked up from IT8). Batch session name should not be entered for download.

5. Execute the report.

6. The list that comes up has three pushbuttons. 'Correct cases' and 'Error cases' can be used to display the correct cases and error cases respectively. 'Download' button can be used to download the correct cases or the error cases to an Excel file.

7. When the 'Download' button is pushed, the system asks for a file name. Enter the file name and press 'Ok'. The file is saved as a '.xls' file and the system returns to the previous screen.

2. Entering wage types for Infotype 15 in the Excel file:

Procedure:

1. Open the Excel file, which was saved during the download process.

2. Excel will pop up a 'Text Import Wizard' window confirming the type of data to be imported. Press the 'Finish' button.

3. The file that is opened will contain four columns: A (personnel no.),B (basic pay Wage Type), C (basic pay amount) & D (Appraisal points).

4. Add these 2 new columns for each personnel no.: column E(Wage type to be uploaded to Infotype 15) & column F(amount for this wage type). The wage type entered in column E should be one of those, which is allowed for Infotype 15.

5. After completing the data entry, save the file. The file should be saved without the '.xls' extension and ensure that the 'Save as type' drop down contains 'Text(Tab delimited)'. Press the 'Save' button.

6. Close the file. This action will pop up a window confirming the data type in which the file is to be saved. Press 'Yes'. This will pop up the 'Save as' window, press 'Save'. This will pop up yet another window saying 'The file already exists. Do you want to replace the existing file'. Press the 'Yes' button.

3. Uploading data to Infotype 15.

Procedure:

1. Run the report HINUDNUP.

2. Select the upload button.

3. Provide following data on the selection screen: Personnel number range, effective date for upload (this is the date which is stored in IT15 as the 'Date of origin') and the Batch Session name.

4. Execute the program, the system asks the file name from where the data is to be uploaded. Provide the file which was saved in step 2 (i.e. file without .xls extension). Note this file will have the Notepad icon against it instead of the Excel icon. Press 'Open'.

5. The correct cases list is displayed. Error cases can be displayed by using the 'Error cases' pushbutton.

6. To create the batch session for upload to Infotype 15, use 'Batch session' pushbutton when the correct cases list is there.

3. Running the Batch Session to upload data to Infotype 15.

1. Go to transaction SM35.

2. Select the Batch Session, which was mentioned in the selection screen

3. From the menu select Session -> Process in background. Press enter, when the window pops up.

4. Check Infotype 15 for the selected personnel numbers.

ROGBILLS - Synchronize billing plans   General Material Data  
This documentation is copyright by SAP AG.

Length: 4919 Date: 20240531 Time: 233818     sap01-206 ( 77 ms )