0% found this document useful (0 votes)
495 views107 pages

Development, Advance Topics - Part Three

The document discusses how to create a remuneration statement or payslip in SAP. Key steps include copying the standard SAP form for payslips, editing fields to include company name, period, allowances, deductions and other required information. Windows are created to display specific sections like allowances and deductions by defining line and column structures. Wage types from relevant tables are grouped and added to the windows.

Uploaded by

SAPHRM
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
495 views107 pages

Development, Advance Topics - Part Three

The document discusses how to create a remuneration statement or payslip in SAP. Key steps include copying the standard SAP form for payslips, editing fields to include company name, period, allowances, deductions and other required information. Windows are created to display specific sections like allowances and deductions by defining line and column structures. Wage types from relevant tables are grouped and added to the windows.

Uploaded by

SAPHRM
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1.

0 Remuneration Statement
Remuneration Statement is used to display the payroll result employee wise, it is an employees pay slip. SAP has its own unique way to develop these reports. We are going to discuss it in detail. Technically Remuneration Statement form is a combination of data from several tables e.g. Background (V_ T512P), Single Fields (V_T512Q), Window(V_ T512F, V_ T512E), Line Structure (V_T512D) etc, see the following screen the red color boxes showing data from Background table, Blue Color from Single fields table, and Green Color from windows table. Yellow color data is arranged by the usage of line structure table.

1.1 To have a close look on the form, lets start with the transaction PE51. Use this transaction the following screen will appear.

1.2 Enter 99 in Country grouping, as we are using country grouping (Molga) 99, For Molga 99 SAP standard form for remuneration statement is XF01, do not make any change in it, simply copy it to your own form name, in our case it is ZPAY. 1.3 Click on the copy button the following screen will appear.

1.3 Enter 99 in country grouping and ZPAY in form name. and press the copy button. It will copy XF01 to ZPAY and will return you back to the previous screen as under.

1.3 Now we can edit the form ZPAY as per our requirement. We dont need to go to any table directly as, you can see, the screen has all the options to go into respective tables for changes in Remuneration form. For example, we want to write company name Pakistan Refinery Limited. on the top of Pay slip, then we will select Background and press on Change button. The following will appear.

1.3 As per our requirement (see 1.1), we have changed the background, you can see, the background can changed line by line. I have deleted all those data which was inherited by copying SAP default form. After that just simply type at the exact place where you want labels should print on Payslip. It is as simple as typing in msword. After typing press the save button and go back to the main form screen.

1.4 See 1.1, we need to print the field data which is showing in the blue color boxes. Simply select the option Single Field and press the Change button as showing blow.

1.4 See 1.1, we need to print the field data which is showing in the blue color boxes. Simply select the option Single Field and press the Change button as showing blow.

1.5 The entries in the boxes are the filed that SAP standard Form already have, just select one by one each one and press the delete button. It will clear all these from the form. After deleting I have changed lot of fields as per our requirement and screen is showing as follows.

1.6 We want to put a Felid Period in front of Background text REMUNERATION STATEMENT FOR THE MONTH. To insert place the cursor there and press the create button. The following screen will appear.

1.7 Here you can see the following options Page Type: The page type determines whether a single field will be printed on particular pages, or on all pages of the form. The most important page types are: o EP (information printed on each page) o FP (information printed on the first page) o LP (information printed on the last page) Enter EP as we want that Payslip period should print on each page. The form class determines which page types are available. We will discuss form class later on. Position: Its the path in Row and Column where our field is going to be printed. We want to print the period field at line no 2 and column no 45. Constant: Text that is printed in exactly the same way when the form is printed. This text is language-independent. Other than background, you can print any thing you like on this constant field and it will simply print on that form at the given location.

Text Module: We create text module in a separate task and then simply select its No for use. It will print on the form. To create the text module go back to main screen and select option text module and press change button.

By pressing change button the following screen will appear.

Here you can create Text module and give them appropriate numeric number. This numeric number will be used to place the text module on the form.

Table Field: Every SAP Form has a form class that is referred and used as table. For country grouping 99 the remuneration statement has form class named CEDT. You can view it by the transaction PE51_CHECKTAB. Use this transaction the following screen will appear.

Enter values as shown above and press the View button. The following screen will appear. If you want to add or edit any field you will enter in change mood. Other wise enter into view mood. As this CEDT is only a reference of the main ifotype tables so by pressing Delete Reference all CEDT table entries and fields will be deleted. So dont press Delete reference button even by mistake.

You can see, many tables are available that you can choose as Table Field (See 1.7). If any table is not available for which you want to access the data, simply add that table. And also add its field in field tab. Here you can a tab Page Types that we discussed in 1.7. as shown under.

For table fields go to the Fields tab you can see every table has its respective fields.

Going back to 1.7, select table and table fields. In our case table is SCHLW and field is PERIODE. It will print the period (like Jan-2007) on the pay slip for each page.
Enter all the remaining felids same way from its respected table and at the its position.

1.8 See the activity 1.1, now we want to create a Window on the Remuneration form (marked in green color box), window will hold the detail section of pay slip i.e. the Allowances, Deduction, Net Allowances , Net Deduction, Final Gross amount. For each of these activity we need a window. Every window will use wage types from its concerned table to show the data. We need Text Module or Background fields to insert a window as per our requirement.

1.8.1 To create a window, go back to the main screen of PE51 select option Window and press Change button. The following screen will appear.

1.8.2 We want to insert a window from line 011 to line 019. it will show the allowances detail for each employee. Like showing in Green box in activity 1.1.

1.8.3 To create a window from line 011 to line 019 we need a background line or a text field on both of these lines so that we can put our cursor up to the most right position up to which we need our window should grow. To insert the background line go back to the main screen of PE51 select the background option, press the change button and enter two dotted lines as shown blow.

Now after saving these two lines go back to the man screen and select Window option again and press the change button, now you can see the appearance as under.

1.8.3 You can see the two dotted lines are showing on the line 011 and 019, Red circle on the lines showing that you have to put your curser at these positions one by one to complete the process of creating window. 1.8.3.1 First of all place the curser at the start of line 011 where there is red circle showing and then click on Create button. 1.8.3.2 A message will appear on the task bar Please Mark the opposite corner and you will see at this point the tool bar has changed and showing only two icons as under.

1.8.3.3 Do not press any button, just place the cursor on the end of line 019 where there is second red circle is showing. Then press the button Select End of Block(F9) which marked red in above picture. When you will click that button the system will ask you the name of Window that you are creating. Enter 01 as shown blow.

1.8.3.4 Press the continue button a window will be inserted and looked as under.

.8.3.5

You can see in the above screen a window, named 01, is inserted from line no 011 to 019. Double click any where in the window the following screen will appear.

.8.3.6

We want to combine the wage types in a same group that have the same behavior (e.g allowances, deductions etc). Press the New Line button and enter the three groups. We choose their names as 10, 20, 40 as shown blow.

.8.3.7

Select the first line and press the detail button the following screen will appear. Here group 10 is for all those wage types that exist in Basic Pay infotype and 20 is for those wage type that exist in infotype 14 (Recurring payments and deductions) and 40 is loan payments.

1.8.3.10 Here you will add all those wage type which will appear in that particular part of your window. Sgr (subgroup no) You use the group and subgroup to determine in which order the information in the window is printed. All the information within a window, belonging to the same group and subgroup, is printed sequentially. 1.8.3.11 Then you give Table from which you want to select the wage types. e.g. RT. You can see RT by transactions PC_PAYRESULT, open that transaction then enter the employee no for whom the payroll has already run then double click its detail salary information it will show all corresponding tables like RT, CRT etc. 1.8.3.12 Then enter the wage type no here, all those wage types which you want to group in this particular part of window then you will select all these here. 1.8.3.13 PTyp, CTy. These are the line structures that we must have to define prior than this activity. 1.8.3.14 The combination of line type and column type identifies the line layout. The fields for line layout define how and where the line is printed in the window. For example, I want to print Wage type No, Text and Amount in single line then it should appear as under.

Wage Type No

Wage Type Text

Amoun

We want that data should print in above structure. So we will a line Structure, go back to main screen and select Line structure as shown blow.

After selecting Line Layout press the change button. The following screen will appear.

1.8.3.15 Here you can see that many line structures are already define, just see See the line 01-01, we want that three fields should print on this line one is LGAR (wage type no) its from table T512T and second is LGTXT (wage type text) its from the same table T512T and last field is BETRG (wage type amount) its from table XRT. You can double click on any field and see the detail of it. If you want to insert a new line structure just add from the button marked in red circle. give the unique name for LT and CT and then enter the felids that you want to print and give the exact position where it should print on the window. The details of LGTXT are showing blow.

The detail of field LGTXT. Now go back to activity 1.8.3.10 , we have learnt what is all about line structure. Give required line structure. Enter all wage types like this way. This is all that require for the Group 10 Now for activity 1.8.3.7 remaining group 20 and 40 are used wage type for Recurring payment wage types and loan wage types respectively. Lets discuss some more about windows. See the activity 1.1 we are going to discuss a window showing Total Gross Amount.

I have inserted a new window named 02. you can see it only on line 021. as it will only show the total gross amount. Double click on it. It will show its detail add one group into it as showing blow.

We have added only one group 01 as it will only show one type of data, that is, Total Gross amount. Select the detail button and add the cumulated technical wage type from CRT, as shown blow.

Now see the windows in activity 1.1 for deductions, the deduction window will have all the wage types that we defined as deduction including tax and loan wage types. in the end we will insert a window for Net Payment. That window will have the wage type for Net payment as under.

Check the alignments of each field showing on the line. You can see we have changed the line structure for each window. This is because each window will show different column than the other. The line layouts 01-0, 01-1, 01-2 are as under.

You can see in line layout 01-0 we are only printing Amount of wage type, in line layout 01-1 we are printing Wage Type No, Wage Type Text and Wage type Amount, while for the line layout 01-2 two fields will be printed on window, that is, wage type text and wage type amount.

2.0 Loan
In this section, you make the settings required to enter data on employer loans and to enable you to process loans. You only need to make settings in this section if you want to implement the component Loans. 2.1 Adjust Value Date In your enterprise, payroll is performed for salaried employees at the start of the month using payroll area XA. In this case, the repayment installment should reduce the interest-yielding capital on the first of every month. Payments and special payments made via payroll should also be made at the start of the month. Just select the value date depending on when your accounts get effect of loan according to each payroll area. Adjust the value date for loan accounting to the payment date for your payroll areas.
ABKRS Text Start End Value date Z1 All Employees 01.01.1900 31.12.9999 End of period

2.1.1 To adjust the value date, go to the following path in IMG.

2.1.2 Click on the Adjust Value Date, the following screen will appear.

2.1.3 Select Value Date End of Period as we want to post the loans to accounting on every month end after every period of Z1 on each payroll run.

Result: We have successfully Adjusted Value Date. 2.2 Loan Wage Type SAP has many technical wage types to handle the different loan amount like loan installment, loan payment , loan balance, loan interest due etc the following table is showing the main five technical wage types that we will use in PRL loan component. /LID /LLB /LOP /LRP /LTE Interest due Loan balance Loan payment - payroll Regular repayment Transfer loan balance

We have to use our own wage type to handle these values. We will copy from these technical wage types to generate our own wage types, following table showing all the customized wage types that we will use. Wage Type No Car Loan 1LOP 1LRP 1LLB 1LID 1LEP Salary Loan 2LOP 2LRP 2LLB 2LID 2LEP Provident Fund Loan 3LOP 3LRP 3LLB 3LID 3LEP House Rent Advance 4LOP 4LRP 4LLB 4LID 4LEP Housing Loan 5LOP 5LRP 5LLB 5LID 5LEP Wage Type Text CAR LOAN PAYMENT CAR LOAN INSTALMENT CAR LOAN BALANCE CAR LOAN INTEREST CAR LOAN REPAYMENT SALARY LOAN PAYMENT SALARY LOAN INSTALMENT SALARY LOAN BALANCE SALARY LOAN INTEREST SALARY LOAN REPAYMENT PROVIDANT FUND LOAN PAYMENT PROVIDANT FUND LOAN INSTALMENT PROVIDANT FUND LOAN BALANCE PROVIDANT FUND LOAN INTEREST PROVIDANT FUND LOAN REPAYMENT HOUSE RENT ADVANCE PAYMENT HOUSE RENT ADVANCE INSTALMENT HOUSE RENT ADVANCE BALANCE HOUSE RENT ADVANCE INTEREST HOUSE RENT ADVANCE REPAYMENT HOUSE RENT ADVANCE PAYMENT HOUSE RENT ADVANCE INSTALMENT HOUSE RENT ADVANCE BALANCE HOUSE RENT ADVANCE INTEREST HOUSE RENT ADVANCE REPAYMENT

2.2.1 To create these wage types, go to the following path in IMG.

2.2.2 Click on Store Additional Values, the following screen will appear.

2.2.3 Select Copy Wage Types and press Choose Button, the following screen will appear.

2.2.4 Here we will copy customized wage types from technical wage types, unchecked the Test Run and entered the data by seeing the above wage type table, the screen will look like the following.

2.2.4 You can see every technical wage type, that we will use, will copy to its corresponding new customized wage type. Select all the wage types that you entered and simply press the Copy button. It will copy all technical wage types into customized wage types. Keep in mind that through this way system is only making the structure of new wage types based on the corresponding technical wage type. And still customized changes are required to tell the SAP system that we want to enter Car loan payment into 1LOP and Car Loan installment into 1LRP and so on. We will do this by changing the schema. Use the save above technique and create the remaining wage types by coping from the same corresponding technical wage types. Result: We have successfully created the Loan wage types

2.3 Maintain Loan Types In this step, you define the loan types that exist within your enterprise. Loan types are subtypes of the Loans infotype (0045). In PRL following loan type exists. Loan Type Name 1100 Car loan 1200 Salary Loan 1300 Provident Fund Loan 1400 House Rent Advance 1500 Housing Loan

2.3.1 To define these loan types, go to the following path in IMG.

2.3.2 Click on Maintain Loan Types, the following screen will appear.

2.3.3 We will define here Loan type according to above loan type table. Select any appropriate entry and select Copy button the following screen will appear.

2.3.4 Change the values as per your requirements, 1100 Car Loan. Press the save button to save the changes. Click on the Country Assignment in Dialog Structure, the following screen will be appeared.

2.3.5 a) Call the relevant view under "Dialog Structure", by double-clicking on Country Assignment. b) If there is no entry for this yet, choose New Entries. c) In the Inftyp (Infotype) field, enter 0045 and in the SType (Subtype) field enter the key which you have defined for the new loan type. d) In the CoGrp (County Grouping) field, enter the country for which you want to use the new loan type, and choose Enter. e) The system displays an information message

2.3.6 Define the conditions for your new loan type.

a) Call the relevant view by double-clicking on Conditions. b) If there is no entry for this yet, choose New Entries. c) Enter the loan type and define a period of validity for the loan condition. d) In the Loan Condition field, enter a freely definable two-digit key and an explanatory text for the condition. e) In the Debit Interest field, enter the interest rate for the loan calculation. f) If necessary, enter a special reference interest rate in the Reference interest rate field. g) If necessary, select the Interest Rate Advantage field. h) In the Period Parameter field, enter the key for the periodicity of the loan type. In our case for PRL its 01-Monthly i) Define the pattern for the deduction of interest and the repayment amount, by defining the first period and the interval to the subsequent periods. You must specify the interest pattern and repayment pattern for installment loans. You can define the conditions as many you want. Following is the list showing that we have defined the conditions for 1100-Car Loan.

To check these condition from SAP GUI, use transaction PA30, enter already defined employee no and enter infotyp 45 and in sub type enter 1100 (Car Loan) and Press the create button. Following screen will appear.

You can see that in Condition Tab the same loan conditions are appearing that we have defined in the above customizations activity. Result: We have successfully defined the loan types, its country setting and Conditions.

2.4 Schema:
Wage Type Processing Basic Concepts
Relationship of Payroll Driver, Schema (Functions), Rules (Operations) Schemas (PE01)

Each country payroll version supported by SAP has a program called the "payroll driver" that Functions Rules calculates payrolls. For example, in the U.S., the (PE04) (PE02) payroll driver is RPCALCU0, in Mexico it is HMXCALC0, in Canada RPCALCK0 and for international RPCALCX0. Each one is different, Operations but they share a common core of functionality. (PE04) The job of the payroll driver is to process payroll functions as specified in a payroll schema. These payroll functions each perform a specific job, for example - reading data from infotypes, calculating Payroll Results taxes, and processing wage types. Some functions (pc payresult) process payroll rules. Rules are a collection of payroll operations. Each operation does a small unit of work, such as multiplying a wage types number by a rate to get an amount. Schemas are edited with transaction PE01, and rules Figure 1 Processing relationships
with PE02. Functions and operations are maintained with transaction PE04. To view payroll results,

use transaction pc_payresult (or in earlier R/3 releases go to Tools>Payroll result>Display in the Payroll menu). (See Figure 1.)The standard payroll schema for a country can be derived from table T500L (see the screen blow). If the country in table T500L has an X in the Old Naming Conv field, then the schema is HR Country Indicator plus 000. Otherwise, it is the ISO Code plus 00. So the U.S. has schema U000, for Mexico it is MX00 and for international its X000.

Table T500L. Cluster RX Different types of personnel administration and payroll data is stored in database tables PCLx (x = 1, 2, 3, 4). PCL1 contains the personal absence calendar, PCL2 payroll results and other data. PCL3 is reserved solely for recruitment data. Logs containing the changes that were made to HR infotypes are stored in PCL4. These database tables are divided into logical areas containing data clusters which combine fields, field strings and internal personnel administration and payroll tables. These areas are identified by two-character indicators. A data cluster is a group of data objects grouped together for the purpose of storage in a storage medium, which can only be edited using ABAP statements.
Header and Table Wage Type Concept

When calculating payroll, wage types are read from infotypes and the Time Management cluster and stored in an internal table called the Input Table (IT). (See Table 1.) In ABAP terms, this is simply an internal table. Various payroll functions and operations can read and update data in this table. Similar to ABAP internal tables, there is a header row. That header row defines which row of data can be accessed by the payroll operations. After manipulating the data in the header row, you can save the row back to the IT, save it to another payroll table, or ignore it. In Table 1 there are three wage types, and wage type 2100 is currently in the header row. After you are done with wage type 2100, wage type 4200 is moved into the header row.

Table 1 Wage type 2100 2100 4200 1500 Table 1 Input Table Number 0 0 0 40 Rate 0 0 0 10.30 Amount 100.00 100.00 20.00 412.00

Creating Custom Schemas and Rules Note: The following learning topic about schema is downloaded from internet which is using examples for USA schema.
Schema and Rule Naming Conventions

Customer modified schemas and rules need to begin with Z. Many customers simply replace the first letter of the standard schema with a Z i.e., their modified copy of UAP0 becomes ZAP0. Ive used a naming convention of Z plus the country identifier (in our example America-U) and a sequential number for modified rules and schemas. So a modified UAP0 would become ZU01 and a modified KAP0 becomes ZK01.
Editor Documentation

Documentation for the function, operation, schema, and rule editors is available online at http://help.sap.com. Click on SAP R/3 and R/3 Enterprise and then select your release level and language. Then navigate to the Human Resources>HR Tools section.
F1 Help

In the schema and rule editors, place your cursor on a function or operation and press F1 to get help text. A schema or a rules documentation is available in the editor via the Goto>Documentation menu. In the schema editor, the F4 key shows possible values for each of the four parameters for whatever function is entered on that line. The same documentation and more is available via transaction PDSY.
Creating a Test Schema

For testing purposes, it is useful to have a version of the payroll schema that does not care about the control record (transaction PA03) settings. Bypassing the control record lets you run and save the results for any pay period needed, without having to update the control record. Theres no problem with having such a schema around, since the payroll driver does not save payroll results from a schema that ignores the control record in a production system. For examples, I will show you how to create two schemas ZUA0, which will be used in production and will check the control record, and ZUAT, which ignores the control record and is used for testing purposes only. First, create a copy of SAPs schema UIN0 and name it ZUA2. In the schema editor (transaction PE02) enter schema UIN0, and click the copy button, or Schema>Copy in the menu. Enter ZUA2 for the To schema. Then edit ZUA2 and make the CHECK ABR line executable by removing the asterisk in the D column. (See Figure 2.) The CHECK

function is commented out by SAP in the standard schema, so you uncomment it here for use in the main ZUA0 schema.

Figure 2 Making the CHECK ABR line executable Now copy the SAP-standard schema U000 to ZUA1 and comment out the initialization schema UIN0 (Figure 3).

Figure 3 Comment out the initialization schema UIN0

In the schema editor, create the production schema (dont copy it from anything) in my example ZUA0. Be sure to check the Schema can be executed checkbox. (See Figure 4.) Only executable schemas can be entered into the payroll driver selection screen.

Figure 4 Check the Schema can be executed checkbox The production schema ZUA0 is a simple one, just two lines. (See Figure 5.) First, you call the initialization schema, and then you call the main calculation schema ZUA1.

Figure 5 Schema ZUAO Copy schema ZUA0 to your test schema ZUAT. (See Figure 6.) You want ZUAT to ignore the control record, so have it use schema UIN0 for initialization. Remember that CHECK ABR is commented out in UIN0. Therefore, both the production and test schemas now use the same calculation logic in schema ZUA1 which keeps them in sync.

Figure 6 Copy schema ZUA0 to test schema ZUAT Your custom rules for these examples will go in a copy of schema UAP0. Copy UAP0 to ZUA3 and add lines for each of the five examples. (See Figure 7.) Edit schema ZUA1 to COPY ZUA3 instead of COPY UAP0 (not shown).

Figure 7 Add lines for each of the five examples

Schema and Rule Documentation


Creating Documentation Objects

Many customizing objects in Payroll can be documented online in SAP. The documentation is added to a transport so that it can be migrated to each client in the development, QA, and production environments. There are three ways to document an object online in SAP. When changing schemas and rules, you can go directly to the Documentation section at the first screen of the editor. Or, while editing, use the Goto>Documentation menu. Either method takes you to an editor. The editor shown in Figure 8 is from the Enterprise release, and the appearance and functions can change from one release to another. Rule ZUA0 has no documentation.

Figure 8 Editor from the Enterprise release Typical documentation might look like what is shown in Figure 9. Another U2 heading was added for Modification History.

Figure 9 Modification History header added When modifying wage types, constants, and other data via views in transaction SM30 or the IMG, click on the blue i or Info button for documentation. The current documentation is brought up in display mode. Click on the edit button or press F5 to maintain it. Transaction PDSY is a universal way to access all this documentation, regardless of where it comes from. Via PDSY, you can view and edit documentation, using the same editor, for many different objects. Early releases of R/3 used report RPDSYS00 to view and maintain documentation, but it has been replaced with transaction PDSY. While RPDSYS00 may continue to exist, you cannot be assured it is showing you the most recent documentation.
Document the Why

Each rule, schema, wage type, and constant can be documented online. Click on the Goto menu and select Documentation. From there, you can enter documentation on why you are making the changes, reference the transport it is assigned to, and perhaps enter other change management information (i.e. issue number, ticket number and so on). The critical part is to define why you are making the change, not just saying what the rule does. Most people who have to come behind you to modify the rule can see what the rule is doing, but may not know why it was done a certain way or if there are other dependencies in the schema. This sort of documentation requires very little effort, and saves much time in the future.

Expanding the Schema and Rules Report RPDASC00 can be used to pull all the COPY schemas and rules into one list. This is very useful when you are looking for certain things in the schema for example, where is wage type 0COL used? Running the report as shown in Figure 10 lists all schemas, sub-schemas, rules, and sub-rules for the main schema ZUAT. Use transaction SE38 to execute the report.

Figure 10 Report for main schema ZUAT Running the Payroll Driver The payroll driver can be run a number of different ways. From the payroll menu for a specific country, select the Payroll>Start payroll option. Or use transaction PC00_Mxx_CALC, where xx is the country identifier (or MOLGA). The payroll driver can also be executed from transactions SE38 and SA38. Any way you go, this selection screen comes up (using U.S. payroll and the test employee as an example). (See Figure 11.)

Figure 11 Payroll driver selection screen for the United States If you are using the schema ZUA0 for production payroll, the payroll period is always left at Current period unless you are only running simulations, which tells the payroll driver to get the current pay period from the payroll control record. If you use the test schema ZUAT, you could select Other period and then enter whatever period and year you want to run, and save those results (only in a non-production system). The payroll area in this section is required and tells the payroll driver which payroll area to use for deriving the current period, the period begin and end dates, and other payroll area-related data. The selection section specifies which groups of employees you include in the payroll run. The payroll area entered here determines which ones are included in the payroll run. These payroll areas need to have the same setup as the one entered at the top of the screen the same period definition and pay dates, for example.

General program control is used to tell the payroll driver how to run the payroll. Offcycle payroll uses various reason codes, and those codes can be entered here. If running an off-cycle payroll, you specify the type of payroll and the date of that payroll in the Off-cycle payroll line. The schema line specifies the main schema to use for the calculation. If you want to force a payroll run to go back to a certain date and recalculate everything since then, that date is entered in the Force retro.accounting as of field. And finally, there is an option for a test run also known as a simulation run. Each payroll function and operation has the ability to put additional diagnostic information in the payroll log. For testing payroll, it is good to have the log shown. In a production payroll, showing the log for a whole payroll area will severely affect system performance. The log requires a lot of temporary storage and significant processing resources. If the Display log for time management additionally is selected, then you will be able to jump from the payroll log into the day processing (DAYPR function) part of the gross payroll schema UT00. Otherwise, that part of the log is not generated. Display variants can be created to customize the way the payroll log is displayed, and if one has been defined you can select it in the Display variant for log line. Finally, the remuneration statement parameters are used to define which, if any, HR Form is displayed at the end of the payroll calculation. If a form is specified here and the log is not displayed, then the payroll driver displays the results via that HR Form. If the log is displayed, it first displays the log but also gives you a button at the top to display the HR Form. Reading the Payroll Driver Log The payroll log varies from one release to another and from one country to another. It can also vary from one customer to another depending on how the schemas were customized. For these examples, the payroll log follows the standard schema U000 very closely, on the Enterprise release. (See Figure 12.)

Figure 12 Payroll log in Enterprise The log tells you that one employee was selected, and one employee was successfully calculated. The number of periods calculated may be more than the number of employees, since it counts the current and retrocalculated periods. Employees rejected from payroll would be counted in the Rejected line. The payroll driver rejects employees for two primary reasons a lack of basic and consistent master data, and customization errors. Each node can be opened to view deeper levels of processing, until you get down to a particular function and/or rule. To get to my example, you expand the nodes to the point shown in Figure 13.

Figure 13 Expand the nodes For the PIT function and rule ZUA8, you can see the Input, Processing, and Output sections. These sections vary by function and operation, but are vital to testing and troubleshooting. If you double-click the PIT function, the payroll driver displays the contents of the input, processing, and output sections together in one list. Or you can double-click any one section to see its contents alone. Likewise, you can further expand each section to see individual components in this case, wage types. In many of the detailed lists, you can see two icons a green plus sign with a down arrow and a red minus sign with an up arrow (Figure 14). These icons control the level of detail that is displayed in the list. Click the green plus to see more detail and the red minus to see less.

Figure 14 Green and red icons control level of detail

Understanding Which Wage Types Are Processed A rule can also filter wage types, or it can process all wage types. It can filter by employee-subgroup grouping and by wage type. This is an attribute of the rule, and different logic can be executed for each set of filtered wage types. In Figure 15, you tell the editor you want to edit the section of the rule that will process wage type 0BAS for all employee subgroup groupings. To see all the various wage types a rule is set up for, click the overview button once you are editing the rule. The various sections can be managed by the Edit>ES Grouping wage or time type menu path inside the rule. If the employee subgroup grouping or wage type are set to asterisks, then they are valid for all values.

Figure 15 Select the section of the rule that will process wage type 0BAS The rules treatment of wage types is also affected by how it is called by the function. The rule gets its wage types from the function, so the function controls what the rule can process. Parameter 2 has the following values: GEN Only access the **** wage type section of the rule. Pxx Like GEN but brings along the value of the processing class xx. Exx Same as Pxx except for evaluation classes. (blank) Access the section of the rule that corresponds to the current wage type Parameter 3 can have two values: NOAB Only access the * employee subgroup grouping section of the rule. (blank) Access the rule specifically for each employee subgroup grouping The employee subgroup grouping for personnel calculations rules is maintained via view v_503_b. Example 1 Calculating a COLA Wage Type The first example multiplies wage type 0BAS by 0.15 and puts the result into wage type 0COL. Figure 16 shows the IT before rule ZUA1.

Figure 16 IT before rule ZUA1 Figure 17 shows the processing section for rule ZUA1, showing calculation done on wage type 0BAS.

Figure 17 Processing section for rule ZUA1 See Figure 18 for the IT after rule ZUA1 was processed, showing the new wage type 0COL with the same A and AP splits as wage type 0BAS, and 0.15 in the NUM field to reflect the percentage used in calculation.

Figure 18 IT after processing of rule ZUA1 Example 2 - Restricting COLA to Specific Groups of Employees Rule ZUA3 shows how to restrict COLA based on personnel area and employee subgroup. The calculation is the same 15 percent of wage type 0BAS is put into wage type 0COL. The IT is the same as rule ZUA1, both before and after processing. The difference is in the processing section (Figure 19).

Figure 19 Processing section for rule ZUA3 If the employee is in personnel area ACAF, then you look at which employee subgroup they are in (OUTWP operation with the PERSB option). If they are in employee subgroup PS, then you calculate COLA. For employees who are not in personnel area ACAF, or are in ACAF but not employee subgroup PS, you perform the ADDWT * operation. This copies wage type 0BAS from the header row to the IT. If you didnt do this, that wage type would be dropped from the payroll calculation at this point.

Example 3 - Bracketed Calculations & Flat-Amount Override The third example shows how to use the AMT operation to make decisions based on a wage types value. A nested decision structure is used calculate COLA with various rates. If wage type 0COL already has a value then you keep that amount instead of doing the calculation. Since you ran out of room in the variable key in rule ZUA4, you break the logic into two rules, calling rule ZUA5 from ZUA4 when needed. The IT before processing is the same as in the previous examples, but the processing is significantly different (Figure 20).

Figure 20 Processing using AMT operation

Notice how the PIT function starts with rule ZUA4, branches to ZUA5 and then returns. When wage type 0COL is entered via infotype 2010, the rules behavior changes. The IT before processing now has 0COL in it (Figure 21).

Figure 21 IT with 0COL

The processing section now sees 0COL and simply passes it on to the outgoing IT table (Figure 22).

Figure 22 Outgoing IT table with 0COL Notice that if wage type 0COL is entered for someone who is not in personnel area ACAF and employee subgroup PS, then it would be paid anyway. Rules ZUA4 and ZUA5 are processed only for wage type 0BAS. So if wage type 0COL existed in the IT before this rule, it would simply be passed on to the next function. This can be restricted by customizing views v_511_b, v_503_g and v_001p_k so that 0COL cannot be entered for this combination of personnel areas and employee subgroups.

Example 4 Hard-coding amounts and wage types into rule is a bad practice. Example 4 is the same calculation logic as Example 3, but the amounts are moved into constants, and use a processing class to specify the COLA wage base. Table t511k, or view v_t511k, holds payroll constants. These constants are date-effective, and are read with the end-date of the pay period being calculated. First you set up the new processing class. For customer-defined processing classes, start with 99 and work down. For this case, use processing class 90. In the IMG, go to the section for processing and evaluation classes (Figure 23).

Figure 23 IMG section for processing and evaluation classes Execute the Maintain processing classes and their specifications item, and create processing class 90. Note that you can click on the blue "i" icon to document the processing class (Figure 24).

Figure 24 Click on the blue "i" icon to document the processing class Select the processing class 90 row and then double-click on Processing class specifications. Here is where you define each value of processing class 90 (Figure 25). You can also document each value. Then go to view v_512w_o to set wage type 0BAS processing class 90 equal to 1.

Figure 25 Set wage type 0BAS processing class 90 equal to 1 Now you create the constants in t511k (using transaction sm30 and view v_t511k). Each constant can be documented (Figure 26).

Figure 26 Creating constants

Rule ZUA3 also changes since you now have to execute a rule for a specific processing class. Use the P90 value for parameter 1 (line 150). (See Figure 27.)

Figure 27 Use the P90 value for parameter 1 (line 150) When payroll runs, the processing section for rules ZUA6 and ZUA7 look much the same as before, except you see constants and processing classes (Figure 28).

Figure 28 Processing section for rules ZUA6 and ZUA7 with constants and processing classes Example 5 The last example involves the handling of wage type splits. Some of the splits have documentation, others dont. When viewing the RT table with the pc_payresult transaction (or the Display Results option in the Tools menu in Payroll), select a split value with your cursor and then press F1 for help. This gives you the full name for the split indicator. Some documentation is also available in transaction PDSY, using operations ELIMI and SPLIT. See Table 2 for common split indicators. Table 2 - Common Split Indicators Split Links to table in indicator payroll results A N/A Description This is the ES grouping for the wage type, and it is matched up to an ES grouping section of a payroll rule for processing Table WPBP holds basic data from infotypes 1, 7, and 8.

AP

WPBP

C1, C2, C3 KoRe vTvn

Country-dependent

This varies by country, but it is typically used to link a wage type to tax authorities. In the U.S., split C1 links the wage type to a tax authority in table TAX
Cost assignment overrides can be entered for wage types and time data, and that override data is stored in table C1.

C1 V0

The variable assignment type (vT) and number (vn) link a wage type to table V0, and the purpose varies per country. In the U.S., this is the link to a benefit plan.

Table 2 Common split indicators Let suppose there is an employee changing cost centers in the middle of a pay period. This causes wage type 0BAS to split allocating a certain amount to each cost center via the AP split. The challenge, though, is to calculate COLA for each split value, based on the whole-period amount of 0BAS. To do this, you create another wage type to hold the whole-period amount. When you cumulate to that wage type 9COL you eliminate the splits, and that is what causes it to store the amount for the whole period. By using 9COL and processing class 90, you can now have multiple wage types cumulate to the COLA wagebase, which is more realistic. The other thing you do, move the 0COL wage type from infotype 2010 to infotype 14. This was so that you could allocate the 0COL wage type across the multiple splits. Infotypes differ on how they work with splits. (See Table 3.) Table 3 how Infotypes 2010, 15 and 14 handle splits Infotype 2010 Split Handling Allocates the AP split based on whatever day it falls within the pay period. For example, the pay period is Jan 16 to Jan 31, and it splits on Jan 20. So Jan 16 to Jan 19 is AP split = 01, and Jan 20 to Jan 31 is split AP=02. If the infotype 2010 wage type is dated Jan 19, it will be assigned to AP split 01; if infotype 2010 is dated Jan 20 it is assigned to AP split 02. When read into payroll the AP split is eliminated, so its AP split is blank. For accounting and reporting purposes, it will be assigned to the last organization assignment (table WPBP in particular), but for payroll operations it is not associated with either split.

15

14

If processing class 10 is set to something other than zero, then it will be split across the pay periods. Otherwise it is handled like infotype 15. So if there is an AP split in the period, infotype 14 will create multiple wage types in the IT one for each AP split. Table 3 How infotypes 2010, 15, and 14 work with splits The behavior of each infotype can be customized in the payroll rules that are processed when functions P2010, P0015, and P0014 are executed. The logic listed in Table 3 is the

standard logic from SAP (for the U.S.) it could be customized in your system. So to get COLA in my example to work for splits, I moved 0COL to infotype 14 and set its processing class 10 to a 1. In this case, processing class 10 is used to tell payroll to allocate wage types across payroll splits. Now, instead of cumulating the COLA wage base to wage type 9COL, you could cumulate it into a payroll variable. This is similar to a wage type, but it is not stored in the payroll result. Instead of doing ADDWT 9COL, you would do ADDWT&9COL. The "&" adds it to the variable table VAR. To retrieve the value of the variable, you would do AMT=& 9COL. There are good and bad points with variables. The good point is that they are easily created dynamically in the payroll rules. The bad parts are that they do not have splits on them so you can not track values per split indicator, they are not stored in the payroll result so it makes auditing and explaining calculations more difficult, and if you do not clear them (ZERO=& 9COL for example), then the values from one gross-tonet loop flow into the next loop. Period 2 had a split in it a new event (infotype 0000) was processed on 1/20/03. Base pay was pro-rated, giving two wage types 0BAS to deal with (Figure 29).

Figure 29 0BAS with two wage types In the processing section of rule ZUA8, you can see that it was called once for each 0BAS (Figure 30).

Figure 30 Processing section of rule ZUA8 called once for each 0BAS For each of those executions, the same logic is performed. First, check to see if the current wage type has a processing class 90 of 1. Then, check to see if the employee is in a valid personnel area and employee subgroup. If it passes those two tests, then it first passes the current wage type along into the output you dont want to lose the base pay wage types. Eliminate all the splits and add the wage type to the output as 9COL. Wage type 9COL then has no splits for the whole pay period, and holds the sum of all wage types whose processing class 90 equals 1. (See Figure 31.)

Figure 31 Wage Building wagetype 9COL You can see that even though 0BAS had splits, wage type 9COL in the resulting IT does not have splits, and represents the sum of the two (Figure 32).

Figure 32 IT representing the sum of the splits Now that you have the whole-period amount for the COLA wage base, you can process COLA for each of the wage base components. Rule ZUAA is also processed for all wage types that have processing class 90 equal to 1. In this case, that is the two wage types 0BAS. Each one is processed as shown in Figure 33.

Figure 33 Processing of 0BAS wage types

First, set the amount equal to 0COL to see if there is an override COLA amount. The AMT operation looks for wage type 0COL in the IT where the split indicators in the IT are the same as in the header of the IT. So wage type 0BAS is in the header with an AP split of 01. It looks for wage type 0COL with a split AP of 01 in the IT. This is why you read 0COL into the IT via infotype 14 and processing class 10 = 1. If the amount is equal to zero, then you dont have a 0COL wage type. Now, eliminate the splits on 0BAS in the header row, and go look for 9COL in the IT. If you find 9COL, then test the amount to see what wage bracket you fit into. Then restore the original splits and reset the amount in the header back to the original amount i.e., from the 9COL amount to the 0BAS amount. Now you are back to the original 0BAS in the header row. Multiply that amount by the COLA rate (constant ZR003) and create wage type 0COL with the result. Wage type 0COL in this case has all the same attributes including the split values as wage type 0BAS. So the COLA amounts are split and allocated in the same manner as the wage types making up the COLA wage base (Figure 34).

Figure 34 COLA amounts split and allocated in the same manner as the wage types making up the COLA wage base.

2.4.1 SCHEMA IN PRL.


As we discussed above the standard schema for international payroll is X000. we will copy it by using first letter Z. 2.4.1 To Copy standard schema go to the transaction PE01, the following screen will appear.

2.4.2 X000 is international schema for Payroll driver PTCALCX0. We want to edit it for PRL, so we will copy it and make the changes in its copy and will use that copied schema for PRL. Press the copy button the following screen will appear.

2.4.3 Enter ZPRL in To Schema field. And press continue button. It will show the schema ZPRL in the main PE01 screen. Press the change button, The following screen will appear.

2.4.4 You can see the Schema ZPRL it is just a copy of X000. SAP provides the complete documentation of each Schema, function, just press the cursor on any function or rule and press F1 button, it will show you its documentation and you can take help from there. For example you want to know what is the specification of function COM. Simply put the cursor on it and press F1 button, the following help will come.

COM: Comment lines in a schema Object: Function Use: Function COM creates comment lines which explain the meaning of a schema and thus the type of payroll generated with this schema. Procedure:

Lines with the function 'COM' can be located anywhere in a payroll schema. Note: This function is used without specifying parameters.

The same way you can take help of each and every entity in the schema. We want to make our loan calculation schema in the main ZPRL schema. See the above screen there at line 120 and 130 we have done some changes. There a customized sub-schema (ZLON) for loan calculation is added, while the standard sub-schema for loan (XLON) is commented. We have copied ZLON from XLON. 2.4.5 Use the transaction PE01 and enter XLON and Press the screen will look like the following.

2.4.6 Enter ZLON in To Schema and press the continue button. ZLON will show in main screen of PE01. Enter the change button the following screen will show.

2.4.7 You can see that standard rule XLOZ is commended now as we have created our own rule for loan calculation. It is ZLOZ. To see the ZLOZ, use the transaction PE02 following screen will appear.

2.4.8 Enter ZLOZ and press the display button. (To create it you will go in change mode), the following screen will appear.

2.4.9 You can see that VAKEY is used to select the LNTYP. For detail information place the cursor on VAKEY and press F1. it will show you the documentation. You can see that when Employee will get Loan the system will automatically manage it in wage type /LOP. So for loan type 1100-Car loan we are adding that technical wage type into 1LOP. In the same way we add all other technical wage type into respective customized wage types.

2.4.10 the same logic is used as that of /LOP, but only difference is we are rounding the wage type amount first then adding it to customized wage type.

2.4.10 Interest due amounts are also being rounded here and added to corresponding customized wage types.

2.4.10 Payroll Repents are show with negative sign so after adding it to its respective wage type we also make reverse its sign. Let suppose there is a wage type amount /LEP -1935 then after adding it to customized wage type it will become 1LEP -1935 , and when we apply SUBWTE operation The wage type in question is passed on as a negative value to an internal table. It will become 1LEP 1935

2.4.11 Initializing Loan Balance Wage Types When the Payroll runs for an employee system add the wage type xLLB (Loan Balance) from previous payroll into IT table, and when current month loan balance is picked up from IT and adds up to xLLB in ZLOZ. It creates its amount double. To handle this error we can initialize xLLB amount to zero before ZLOZ schema. Or simply set AMT=0 before ADDWTE1LLB, ADDWTE2LLB etc.

Result: We have successfully created Loan Schema and added it to our main Schema PRL

2.5 Leave Without Pay. We have already discussed in detail about Absences in Development Part 2 file. Here we will only discuss shortly about what the different behavior Leave Without Pay have. In the Infotype 2001- Absences, we maintain leave without pay entry. In PRL Leave without pay will be configured as per following Rules. Management Employees: Leave Without Pay = Gross Salary / (no. of days in that particular month) * Number of absence days. Non-Management Employees: Leave Without Pay = (Basic Salary + House Rent Allowance + Shift Allowance + S.I.T.E allowance + Conveyance + Ex-Gratia + Utility Allowance + All COLAs) / (no. of days in that particular month) * Number of absence days. Provident Fund contribution will also be adjusted in case of leave without Pay

We have already Defined Leave Without pay along with the other absences that we have discussed in detail in Development Part 2 file. To configure this leave for Factoring go the following path in IMG.

Click on the Describe Absence Valuation Rules the following screen will show.

Standard SAP system already contain 4 entries, showing in the above screen, we will use the Rule 04-Unpaid Absence for our Leave Without Pay. To assign this rule to Absences go the following path in IMG.

Click Group Absences for Absence Valuation the following screen will show.

You can see from the above screen that all the other absences have been assign Valuation Rule 1 except LWOP and LWPN. We have assigned Valuation Rule 04 to them as these are unpaid absences. Now we will defined the counting class for the unpaid absence Counting classes provide a utility in payroll. They are used to form "buckets" to valuate paid and unpaid absences: 1. for period factoring - to determine a reduction in salary for unpaid absences 2. to generate statistics and for cost accounting.

To define the Counting Classes for Absence Valuation and then assign these counting classes to Valuation Rule, go to the following path in IMG.

Click on Create Counting Classes for Absence Valuation the following screen will show.

Select the option Define Counting Classes and press the Choose button, the following screen will appear.

Standard SAP system contains predefined four counting classes, for our leave without pay we will use 04-Unpaid Absence as counting class. And then we will assign it Valuation Rule. To assign the counting class to Valuation Rule go back to the following screen.

Now select the option Absence Valuation: Expert View the following screen will appear.

Select the Valuation Rule 04-Unpaid Absence and press the Detail button. The Following screen will appear.

Here in the above screen you can see that to our valuation rule 04-Unpaid Absence we have assigned a counting class 04-Unpaid absence and unchecked the Paid check boss to confirm that this is unpaid absence. Percentage 100 showing that we want to deduction 100 % of the those days that were taken as Leave Without Pay. In the second section of the above screen you can add any of your defined wage type that will automatically hold the unpaid hours of the employees for the Leave Without pay days. But in PRL we dont want to add its amount in any other wage type, we will simply deduction all the allowance who gets effect by leave without pay. So no extra amount storage wage type require for PRL

2.5 Change in Schema for Leave without Pay. As in PRL the formula for calculation of Leave without pay is dependant on Calendar days and standard schema is configured on working hours so slight change require in calculation Rule XPP1. XPP1 rule is called through the following way in main schema. XVAL (Factoring and storage) > XPPF (Determine monthly factors) > XPP0 (Determine partial period factors (subrule)) > XPP1 (Determine partial period factors (subrule)) As we need to change in XPP1, so thats why we have to change all the rule according and we create it by prefixing Z so the rules name will become as under ZVAL (Factoring and storage) > ZPPF (Determine monthly factors) > ZPP0 (Determine partial period factors (subrule)) > ZPP1 (Determine partial period factors (subrule)) ZVAL is a schema that exists in main ZPRL schema. So we start from the rule ZPPF.

ZPPF is showing above and the change is also highlighted by a red circle.

ZPP0 is showing above and we have changed the entries from XPP1of ZPP1.

ZPP1 is the main rule that got the big change. Here we have changed the fields according to Calendar days. You can press F1 and can see the further details of each field. KSOLL : Planned working time measured in calendar days KAUxx : Unpaid absence measured in calendar days KDIVI : Total working time measured in calendar days KGENAU is the constant value taken from the table V_T511K, as shown blow.

Now we want that our wage types should be reduced by the factor /801 that we have just configured in the above schema, To do this, use transaction SM30 and use that view V_512w_D. and press the maintain button after entering country grouping the following screen will appear.

Result: We have successfully configured Leave without pay

2.6 Posting Payroll Results to Accounting


In this section, you make the settings required for evaluating payroll results for Posting to Accounting. Employee Grouping Account Determination In this step, you define the employee groupings for account determination. You do not have to specify employee groupings unless you want to post wage types to various accounts in Financial Accounting (FI) in line with employee attributes. If you want to post to FI accounts with reference to a specific employee groupings, you must define an alphanumeric key of up to three characters for each of the required employee groupings. You then define the conditions for assigning employees to employee groupings that you have defined for posting to accounting. (You set conditions according to employee attributes, as defined by entries in the Workplace Basic Pay table (WPBP). Note that an employee can, at any one time, only be assigned to one employee grouping.

To create this grouping, go to the following path in IMG.

Click on Define Employee Grouping Account Determination the following screen will appear.

Click on Employee grouping for account determination: Define values the following screen will appear.

For PRL we have created five different groupings (4,5,6,7,8) as per our employee groups

Define assignment of EE char. to EE group account assgmt To assign these grouping to Employee groups, go back to previous screen and select option Define assignment of EE char. to EE group account assgmt, the following screen will appear.

You can see that feature PPMOD has been configured according to Employee Groups. For example you can see that for Management Employee (M) we have assigned grouping for account determination 4

Define Symbolic Accounts In this step, you create the symbolic accounts that you require for posting to Accounting. A symbolic account has the following characteristics: A four-character alphanumberic code A descriptive text An account assignment type (AA type). This defines the type of posting (posting to expense account, posting to payables account, and so on) that applies to the wage types that are posted to the symbolic account. An employee grouping for account determination (EG) indicator

The following are the list of all the symbolic account that we have created in PRL.

S.Acc Description P001 Basic Salary P002 Stipend GTE MGtrainee Chiemist P003 Stipend Apprentices P004 House Rent Allownace MPT P005 Conveyance Allowance MPT P006 Utility Allowance MPT P007 Refinery Allowance P008 Shift Allowance 1 P009 Shift Allowance 2 P010 Shift Cordinator Alow. P011 Site Allowance 1 P012 Site Allowance 2 P013 Annual Leave Encashment MPT P014 LFA MPT P015 LFA Trainee P016 Bonus MPT P017 Special Allowance P018 Pension NMPT P019 House Rent NMPT P020 Conveyance NMPT User P021 Conveyance NMPT not User P022 Conveyance NMPT User off Ro P023 Conveyance NMPT Kemari Ter P024 Conveyance Assistance P025 Utility Allowance NMPT P026 Shift Allowance NMPT P027 Site Allowance NMPT P028 COLA 75 P029 COLA 73 P030 COLA 74 P031 COLA 80 P032 COLA 81 P033 COLA 85 P034 COLA 86 P035 Sindh Add. Sp. Allow90-91 P036 COLA 93 P037 COLA 94 P038 Additional Sp. Allow 95 P039 COLA 97/Ahdoc Relief P040 COLA 2000 P041 Ex-Gratia 2003 P042 Ex-Gratia in Lieu of LPG P043 Annual Bonus NMPT P044 10 C Bonus P045 Annual Leave Encashment NMPT P046 Casual & Sick Leave En NMPT P047 Compensatory Rest Day Enca P048 Ex-Gratia Shut Down P049 Ex-Gratia NM OvertimeBisc P050 Ex-Gratia NM Ann ShutDown P051 Ex-Grat NM ShutDown 25%Taxi P052 Jersey Allowance NMPT

P053 Duffile Allowance NMPT P054 Meal Allowance Korangi P055 Korangi Breakfast Allowance P056 Kemari Meal Subsidiary P057 Kemari Breakfast Subsidairy P058 Daily Conveyance Ass User P001 Basic Salary P002 Stipend GTE MGtrainee Chiemist P003 Stipend Apprentices P004 House Rent Allownace MPT P005 Conveyance Allowance MPT P006 Utility Allowance MPT P007 Refinery Allowance P008 Shift Allowance 1 P009 Shift Allowance 2 P010 Shift Cordinator Alow. P011 Site Allowance 1 P012 Site Allowance 2 P013 Annual Leave Encashment MPT P014 LFA MPT P015 LFA Trainee P016 Bonus MPT P017 Special Allowance P018 Pension NMPT P019 House Rent NMPT P020 Conveyance NMPT User P021 Conveyance NMPT not User P022 Conveyance NMPT User off Ro P023 Conveyance NMPT Kemari Ter P024 Conveyance Assistance P025 Utility Allowance NMPT P026 Shift Allowance NMPT P027 Site Allowance NMPT P028 COLA 75 P029 COLA 73

To create Symbolic Account, go to the following screen in IMG.

Click on Define Symbolic Accounts the following screen will appear.

You can copy any appropriate felid and can define all the symbolic accounts as per showing above.
Account assignment type: The account assignment type determines which wage type characteristics are used during posting to an appropriate symbolic account. The account type of the account to which results are to be posted is also defined. The types are C F Q Posting to expense account Posting to balance sheet account Posting to bal.sheet acc. with pers.no.

You can see the difference in F and Q account types. If we want to post the result with Personnel numbers then we will chose Q, other wise F will be better option, it depends on company to company. If a company have a requirement to get the detail expense report employee wise then we will chose Q. Following is the list of all Symbolic Accounts.

S.Acc D001 D002 D003 D004 D005 D006 D007 D008 D009 D010 D011 D012 D013 D014 D015 D016 D017 D018 D019 D020 D021 D022 D023 D024 L001 L002 L003 L004 L005 L006 L007 L008 L009 L010 L011 L012 L013 L014 L015 P001 P002 P003 P004 P005 P006 P007 P008

Description Mosque Fund EOBI Canteen MPT Club Fee MPT Transport Deduction Sara Electronics LG Installments Pak Libya Holding Compnay Insurance Premium Provident Fund Contribution MPT Personal Account Trade Tax MPT Union Fee NMPT Provident Fund Contribution NMPT Club Fee NMPT Trade Tax NMPT Income Tax Other Deductions Shell Deductions PSO Deductions Chevron Deductions Provident Fund Contribution Second Canteen NMPT Canteen NMPT Rotation Car Loan Balance Car Loan Interest Car Loan Installment Salary Loan Balance Salary Loan Interest Salary Loan Installment Provident Fund Loan Balance Provident Fund Loan Interest Provident Fund Loan Installment House Rent Advance Loan Balance House Rent Advance Loan Interest House Rent Advance Loan Installment Housing Loan Balance Housing Loan Installment Housing Loan Interest Basic Salary Stipend GTE MGtrainee Chiemist Stipend Apprentices House Rent Allownace MPT Conveyance Allowance MPT Utility Allowance MPT Refinery Allowance Shift Allowance 1

Acc. Type Q Q C Q C Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q C C F C F F C F F F F F C F F F C C C C C C C C C

P009 P010 P011 P012 P013 P014 P015 P016 P017 P018 P019 P020 P021 P022 P023 P024 P025 P026 P027 P028 P029 P030 P031 P032 P033 P034 P035 P036 P037 P038 P039 P040 P041 P042 P043 P044 P045 P046 P047 P048 P049 P050 P051 P052 P053 P054 P055 P056 P057 P058 P059 P060 P061 P062 P063 P064

Shift Allowance 2 Shift Cordinator Alow. Site Allowance 1 Site Allowance 2 Annual Leave Encashment MPT LFA MPT LFA Trainee Bonus MPT Special Allowance Pension NMPT House Rent NMPT Conveyance NMPT User Conveyance NMPT not User Conveyance NMPT User off Ro Conveyance NMPT Kemari Ter Conveyance Assistance Utility Allowance NMPT Shift Allowance NMPT Site Allowance NMPT COLA 75 COLA 73 COLA 74 COLA 80 COLA 81 COLA 85 COLA 86 Sindh Add. Sp. Allow90-91 COLA 93 COLA 94 Additional Sp. Allow 95 COLA 97/Ahdoc Relief COLA 2000 Ex-Gratia 2003 Ex-Gratia in Lieu of LPG Annual Bonus NMPT 10 C Bonus Annual Leave Encashment NMPT Casual & Sick Leave En NMPT Compensatory Rest Day Enca Ex-Gratia Shut Down Ex-Gratia NM OvertimeBisc Ex-Gratia NM Ann ShutDown Ex-Grat NM ShutDown 25%Taxi Jersey Allowance NMPT Duffile Allowance NMPT Meal Allowance Korangi Korangi Breakfast Allowance Kemari Meal Subsidiary Kemari Breakfast Subsidairy Daily Conveyance Ass User Daily Conveyance Ass not User DailyConv Ass Useroff Rou DailyConv Ass Kemari Ter Good Attendance Allow Day Good Attendance Allow Rot Extra Work Allowance

C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C

P065 P066 P067 P068 P069 P070 P071 P072 P073 P074 P075 P076 P077

Wages and salaries House Rent Assistance GTE House Rent Allowance Contract Utility Allowance Contract LFA NMPT Conveyance Allowance Contract Utility Allowance Second Overtime Hours Day/Rotation Difference Previous Period Special Recognition Award Ex Gratia All Taxi Fare NMPT Day/Rotation Meal Allowance

F C C C C C C C C C C C C

Define Posting Characteristics of Wage Types In this step, you specify which wage types are to be posted, how often they are to be posted within the evaluation of one payroll result, and the symbolic account to be used for each posting. You can also maintain the following posting characteristics:

To define the Posting Characteristics of Wage Types, Click on Define Posting Characteristics of Wage Types the following screen will appear.

Select your wage type and double click the Posting a Wage type option in Dialog Structure. The following screen will appear.

1. Plus/minus sign The system stores wage types with a plus (+) or minus (-) sign in the payroll result. How specific wage types are stored depends on how the system processes them during the payroll run. In the standard system, the sign is usually set correctly for secondary wage types. If you enter a plus sign (+) in the V column, positive amounts are posted as debits, and negative amounts are posted as credits. If you enter a minus sign (-) in the V column, positive amounts are posted as credits and negative amounts are posted as debits. 2. Processing a wage type

You can use the processing type to assign posting characteristics of a wage type to the following business processes: Posting payroll results Posting month end accruals Supplying personnel cost data to Cost Planning 3. Symbolic account 4. Account assignment type The account assignment type determines which account type is to be used for posting. It is defined by the symbolic account, and can only be displayed in this column. 5. Indicator specifying whether the cost assignment for infotypes Recurring payments/deductions (0014), Additional payments (0015), and Employee remuneration information (2010) should be ignored (table C1). You only use this indicator if you want the system to ignore a different cost assignment when posting the wage type.

Following table is showing the +/- sign attached with each wage type for PRL.

WType /552 /560 0001 0010 0020 0030 0040 0100 0110 1000 1001 1002 1003 1004 1005 1006 1010 1011 1012 1013 1014 1015 1016 1017 1030 1031 1032 1033 1040 1042 1043 1045 1046

Description Difference prev. Period Payment Amount Basic Salary Stipend GTE Stipend Management Traine Stipend Chemist Stipend Apprentices Pension MPT Pension NMPT House Rent Allowance MPT House Rent Allowance Seco House Rent Allowance Cont House Rent Allowance NMPT House Rent Assistance GTE House Rent Assistance Mgt House Rent AssistanceChem Conveyance Allowance MPT Conveyance Allowance Seco Conveyance Allowance Cont Conveyance Allo NMPT User Conv All NMPT Not User Conv All NMPT User Off Ro Conv All NMPT Keamari Ter Conveyance Assistance Utility Allowance MPT Utility Allowance Second Utility Allowance Contrac Utility Allowance NMPT Refinery Allowance Shift Allowance 1 Shift Allowance 2 Shift Allowance NMPT Shift Coordinator Allow.

+/- Sign Positive amt credited and negative amt debited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited

1050 1051 1053 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1LID 1LOP 1LRP 2LID 2LOP 2LRP 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027

SITE Allowance 1 SITE Allowance 2 SITE Allowance NMPT COLA 75 COLA 73 COLA 74 COLA 80 COLA 81 COLA 85 COLA 86 Sindh Add. Sp. Allow90-91 COLA 93 COLA 94 Additional Spec Allow. 95 COLA 97 / Adhoc Relief COLA 2000 Ex-Gratia 2003 Ex-Gratia in lieu of LPG Special Allowance Car Loan Interest Car Loan Payment Car Loan Installment Salary Loan Interest Salary Loan Payment Salary Loan Instalment Leave Fare Assistance MPT Leave Fare AssistanceNMPT Leave Fare Assist Trainee Bonus MPT Annual Bonus NMPT 10 C Bonus Annual Leave Encash. MPT Annual Leave Encash. NMPT Casual&Sick Leave Enca NM Compensatory Rest DayEnca Ex-Gratia Shutdown Ex-Gratia NM OvertimeBisc Ex-Gratia NM Ann Shutdown ExGrat NM Shutdown25%Taxi Honorarium Partial Day Jersey Allowance NMPT Duffle Allowance NMPT Hajj Payments Edu Scolarship foChildren Education Assistance MPT Milage Meal Allowance Meal Allow. NMPT Korangi Korg. Breakfast AllowNMPT Keamari Meal Subsidy NMPT Keam BreakfaSubsidy NMPT Daily Conveyance Ass User Daily Convey Ass Not User

Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited

3028 3029 3030 3031 3032 3033 3034 3040 3041 3999 3LID 3LOP 3LRP 4000 4001 4002 4003 4500 4501 4502 4503 4504 4505 4506 4507 4508 4509 4510 4511 4512 4998 4LID 4LOP 4LRP 5000 5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5015 5016 5020 5021

DailyConv Ass User offRou DailyConv Ass Keamari Ter Good Attendance Allow Day Good Attendance Allow Rot Special Recognition Award Honorarium Full Day Ex Gratia All Taxi Fare NMPT Day Taxi Fare NMPT Rotation Bonus - Off Cycle Payment Provident Fund Lo Intrst Provident Fund Lo Payment Provident Fund Lo Install Overtime Hours Day Overtime Hours Rotation Extra Work Allowance Day Extra Work Allowance Rota Bonus Off Cycle Leave Fare Asst. MPT OffC Leave Fare Asst NMPT Leave Fare Asst Tra OffCy Bonus MPT Off Cycle Annual Bonus NMPT 10C Bonus Compensatory Rest Day Enc EX-Gratia Shut Down Off C Jersey Allowance NMPT Duffle Allowance NMPT Hajj Payment Education Asst MPT Off Cy Absence Hours I02 House Rent Adv Interest House Rent Adv Payment House Rent Adv Installmen Mosque Fund EOBI Canteen MPTs Canteen NMPT Day Canteen NMPT Club Fee MPT Club Fee NMPT Union Fee NMPT Transport Deduction Sara Electronics LG Installments Pak Libya Holding Company Insurance Premium Shell Deductions PSO Deductions Chevron Deductions Others Deductions Provident Fund Cont. MPT Provident Fund Cont. NMPT

Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited

Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited

5022 5500 5501 5503 5LID 5LOP 5LRP 6000 9997

Provident Fund Cont. Seco Donation Personal Account Trade Tax NMPT Housing Loan Interest Housing Loan Payment Housing Loan Installment Income Tax Annual Leave Encashment

Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt credited and negative amt debited Positive amt debited and negative amt credited Positive amt debited and negative amt credited

Maintain Posting Date for Payroll Periods

In this step, you generate and maintain the posting date for each payroll period of a payroll area. This setting is relevant if you set the According to period definition indicator as a default when you create the posting run

To create the Payroll Period Dates. Go to the following path in IMG.

Click the Maintain Posting Date for Payroll Periods the following screen will come.

Choose the option Generate Posting Date for Payroll Periods and press Choose button. The following screen will appear.

Enter the values as per shown above. Make sure that you have checked the Carry out table change. After creation the following table can be seen in Maintain Posting Date for Payroll Periods.

Create Posting Variants In this step, you maintain the posting variant that you have to specify in the selection screen when creating a posting run.

Click on Create Posting Variants. The following screen will show.

Enter the values as per shown above. This ZSAP variant will be used in Creating Posting Document.

In this step, you assign balance sheet accounts to the symbolic accounts with the following account assignment types. Postings to balance sheet accounts without personnel numbers (account assignment type F) Postings to balance sheet accounts with personnel numbers (account assignment type Q) Postings to balance sheet accounts to check the balance in retroactive accounting (account assignment type FL) Postings to balance sheet accounts in the original periods only, if the wage types do not change retroactively during retroactive accounting (account assignment type FO)

To Assign the Balance sheet accounts, Click on Assign Balance Sheet Accounts. The following screen will appear.

Select the chart of account PRL. And press the continue button the following screen will appear.

Here you can see, we will enter the balance sheet accounts to each account according to the grouping for account determination To Assign Expense Accounts go the following path in IMG.

Click on Assign Expense Accounts the following screen will appear.

In the same way above enter the GL Expense accounts to each corresponding Symbolic accounts according to the grouping for account determination

Result: We Have Successfully Configured the Posting to Accounting Activity.

THE END

P051 P052 P053 P054 P055 P056 P057 P058 P059

Salary Payable Wages Payable Staff Incom Tax Payable EOBI Payable Provident Fund Payable Social Security Payable Daily Wages Bonus Payable Permanent Staff Bunus Payable CR Bunus Payable

Miscellaneous :

V_T510H

You might also like