Could u kindly help me finding some ref doc or material for understanding process flow for us net part of payroll with example.I have seen one for india payroll.Tnak in advance .
Came across this thread,hope u find some help with this
"SAP / ADP Payroll Interface - Master Data Only
This example contains an application example showing you how to use the Interface Toolbox (Transaction PU12).
Ashutosh Vatsayan
With the Interface Toolbox you can set up and perform the export of master data and payroll results to an external system.
Application example:
You have already performed payroll accounting for a personnel number with program RPCALCU0 (gross payroll accounting or complete payroll accounting); now you want to perform the following activities for this payroll period:
Export payroll results (table RT) and master data (infotype 0001 Organizational assignment),
Execution of a conversion you have already set up.
You can find the documentation specified in the online help under HR Personnel Administration & Payroll Accounting - Tools - Interface Toolbox.
Remark: This example is based on an export in the USA. If you perform payroll accounting with program RPCALCx0 (x = your country ID), note the remark under 1c) 'Selection of table RT (payroll results)' and modify this step before proceeding with it.
Additional key words Cause and prerequisites
Example of an entire application scenario:
In the SAP System, you start the gross payroll.
You export master data and payroll results to your payroll accounting system
In the payroll accounting system, you start the net payroll.
You transfer the net wage types from the payroll accounting system to the SAP System and then you make them available for payroll accounting and so on .
Solution
To set up an interface, proceed as follows:
1. Create an interface format
2. Set up a change validation
3. Generate the export program from the interface format
4. Export
5. Create a file layout (user-specific conversion)
6. Generate the file layout
7. Convert the export file
8. Download and display the files
9. Options for importing the data back to the SAP system
1. Create an interface format (documentation: Interface format)
Here you select the data you want to export.
Example: You want to export the organizational assignment of the employee (infotype 1) and table RT from the payroll results to an external system. This example is based on the payroll cluster RU (USA), in the same way use the cluster on which you save your payroll results (that is RD for Germany or RK for Canada).
If you only want to export the gross payroll results and if there is no payroll program (RPCALCx0) for your country, you can use the international payroll driver (RPCALCX0). The results are saved on cluster RX.
Documentation for the following activities:
General functions for processing the interface format
a) Creating the interface format
Call Transaction PU12, choose the 'Interface format' pushbutton, assign a new name, for example ZTTT, for the interface format you want to edit.
Choose : 'Change'.
In the following screen enter a short text for the interface format and your country grouping (for example USA: 10, Germany: 01) .
b) Selecting infotype 0001 (master data)
In the next screen select the 'Master data' radio button and in the next list select Infotype 0001.
You can use Edit -> Expand to display the selected fields of the infotype. You can delete fields you do not want to export from the field list.
c) Selecting table RT (payroll results).
Place the cursor on field MDTA and choose the 'Create' pushbutton. Select the 'Import/export file' radio button, enter File PCL2 and confirm the selection.
Enter RU in the 'Cluster' field and RP-IMP-C2-RU in the 'Import module' field and click the 'Create include' pushbutton. In the following screen, enter the name of your payroll driver (USA: RPCALCU0) and confirm. If you have modified the payroll driver, enter the name of the modified report (for example ZPCALCU0).
(Remark: If you want to export payroll cluster RX (x = the respective country ID, for example U for USA, D for Germany, X if your country does not have a payroll driver yet and you have to use the international payroll driver RPCALCX0 for gross payroll), select cluster Rx, payroll module RP-IMP-C2-Rx and payroll driver RPCALCx0.
For countries which offer payroll accounting as of Release 4.0 or later, there is a new naming convention for the payroll driver: HxxCALC0, in which xx is the two-digit country ID, for example TW for Taiwan or VE for Venezuela. )
See also F1 help on the fields of the screens.
In the next screen, choose the 'Create' pushbutton and enter a program name, that is the name you want to use to save the new include, for example ZPINCLRU. Enter a development class for the Include and confirm the message which says that the Include is created. Press 'Continue'.
From the list of tables, select table RT.
Use 'Edit' -> 'Expand' to display the selected fields in table RT. You can delete fields which you do not want to export from the field list.
Remark: You can use the interface tool box to export time evaluation data (cluster B2) and payroll results (cluster Rx, for example RU for USA, RD for Germany) from file PCL2.
d) Assigning a name to the export program and includes.
Choose 'Interface format - Export program' and specify a program in which you want to save the generated export program.
(See F1 help on the fields of the screen.)
e) Defining attributes for the interface
Choose Interface format - Attributes and define the attributes. To do so, position the cursor on each checkbox (press F1 if you need help on the entries). In this application example, leave all checkboxes empty. In this application example, check 'Direct file layout conversion' and leave all other checkboxes empty.
f) Control of retroactive accounting for wage types (Documentation: Wage type processing with the interface toolbox, wage types in the interface format)
Position the cursor on field LGART of table RT and choose the 'Restrictions' pushbutton. In the next screen select the radio button 'For result wage types' and enter an * in field 'Wage type'. Select field DT and then select radiobutton R4.
In this way differences in wage types between retroactive accounting periods are saved in table $DRT of the current period and exported with it.
g) Saving the interface format and leaving it with
Interface format -> Close.
2) Set up a change validation.
Here you can set up whether you only want to export changed data.
Read the documentation on 'Change validation'.
Creating a change check:
Choose the 'Change validation' pushbutton and enter the name of your interface format (ZTTT).
In the next screen select the 'Create' button and select the tables for which you only want to export changed data. For example table P0001.
Position your cursor on 'P0001' and choose the 'Single field valid' pushbutton.
Save your entries.
3) Generate the export program
In the initial screen of the interface tool box select the button 'Generate export program'. Then the interface toolbox generates an export program from your data on the interface format and change validation.
4) Export
Also read the documentation: 'Export program' for information on the export options.
Click 'Export' in the main menu of PU12 to open the selection screen of the export. Also read the F1 help on the individual fields.
If you want to use another format than the SAP export program, you can create a user-specific conversion.
Read the documentation on the 'File layout'.
Application example:
You want to print the wage types and the company code for each personnel number in the form
Line 1: Personnel number Company code
(Remark: The system uses the company code which is valid at the end of the period. Due to the activated change validation for infotype 1, the company code is only printed if it has been changed since the last export. If it has not been changed, field 'Company code' contains the value '####'.
If you do not want to export the company code if it contains the value '####' you can select the export parameter 'Depending on content' in the structure).
Line 2: Personnel number, Wage type, Amount
(Remark: this line may exist more than once if there are several wage types.)
a) Creating a file layout
Click the button 'File layout' and specify a name for the file layout. In the next screen specify the interface format for the output file you want to convert (in this example ZTTT).
b) Making specifications leading to the output in line 1:
b.1: Block definition, documentation 'Block functions in the file layout'
- Select the pushbutton 'Create' and specify a block name, for example LINETYPE1.
- Select Edit - Expand
- Create the block attributes
- Position your cursor on the icon in front of 'Process' and select 'During processing employee data' as the point in time.
- Position the cursor on the icon in front of 'Repeat' and select repetition type 'Once'.
- Position your cursor on the icon in front of 'Output to file' and select 'Main export file'.
b.2: Structure definition, documentation 'Structure functions in the file layout
- Create a structure.
- Position the cursor on the block name LINETYPE1 and
choose the 'Create' pushbutton.
- Select the option 'Assign new structure' and specify a structure name, for example STRUCTURE1.
- Choose Edit - Expand
- Position your cursor on the icon in front of 'Export' and select the option 'Always = irrespective of content'.
b.3: Field definition, documentation 'Field functions in the file layout'
- Create a field 'PERNR'.
- Position the cursor on the structure names STRUCTURE1 and choose the 'Create' pushbutton.
- Select the 'Assign new field' option and specify the field name, for example PERNR.
- Position your cursor on the 'Length' icon and select 'Referenced length'.
- Use the F4 help and select P0001-PERNR. (Documentation 'Interface variable as an input parameter')
- Position your cursor on the icon in front of 'Contents' and select 'Dynamic value'.
- Use the F4 help and select &VAR-PERNR. Select the option 'Last entry'.
- Create field 'BUKRS' in the same way as a reference of field P0001-BUKRS.
b.4: Result:
LINETYPE1
Processing 'During processing'
Repeat 'Once'
Output to file 'Main export file'
User exit before
User exit after
STRUCTURE1
Export 'Always' (irrespective of contents)
User exit before
User exit after
PERNR
Length 8 bytes (as P0001-PERNR)
Contents from &VAR-PERNR (last entry)
BUKRS
Length 4 bytes (as P0001-BUKRS)
Contents from P0001-BUKRS (last entry)
c) Making the specifications which lead to the output in line 2:
Create block LINETYPE2, structure STRUCTURE2 and fields LGART and AMOUNT with the following specifications:
LINETYPE2
Processing 'During processing'
Repeat (RT, all entries)
Output to file 'Main export file'
User exit before
User exit after
STRUCTURE2
Export Always (irrespective of contents)
User exit before
User exit after
PERNR
Length 8 bytes (as &VAR-PERNR)
Contents from &VAR-PERNR (current entry)
LGART
Length 4 bytes (as RT-LGART)
Contents from RT-LGART (current entry)
AMOUNT
Length 16 bytes (as RT-BETRG)
Contents from RT-BETRG (current entry)
If you also want to add field PERNR to this structure, place the cursor on the structure name and select the icon 'Insert'. Then select field PERNR and confirm the selection.
d) Specifying the conversion program
Under 'File layout - conversion program' specify the name of the main program and the Include the Interface Toolbox should create with the data you specify.
6) Generate the file layout.
Documentation: Generation of file layout
7) Convert your export file.
Documentation 'Layout conversion'
In the main menu select 'Layout conversion' and in the next screen select the option 'User defined'. In the next screen enter your file layout ZTTT and select 'Convert'.
In the selection screen enter the export file you created in field 'Import file' and enter the target file for the conversion in field 'Export file'.
Result: Example of personnel number 211270 in BUKRS US01:
00211270US01
00211270/101+000000000200000
00211270/102+000000000200000
00211270/114+000000000200000
00211270/550+000000000200000
00211270/559+000000000200000
00211270/560+000000000200000
00211270/5UY+000000000000000
00211270/700+000000000200000
00211270/840-000000000021109
00211270/001+000000000000000
00211270M003+000000000200000
00211270MMRR+000000000178875
😎 Download and display files
Documentation: 'Interface results', 'Export file' and in Release 4.5A additionally 'Display TemSe file', 'Maintain TemSe file'
9) Options for importing the file back into the SAP system
(documentation 'Import program')
You can transfer wage types from the payroll system to the SAP system. To do so, perform the following two steps:
Fill table T558A (or T558D if you need splits)
Start payroll accounting with an import schema, for example XINF
You can fill table T558A with the help of the import in the Interface Toolbox. The precondition for this process is that the file you want to import exists in the format of the SAP import file. (Documentation: 'File format of the export or import file')
Alternatively you can fill the table with a separate report. ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.