Category Archives: SAP FI HR Integration

Payroll Postings to FI

1 ) First you need to create symbolic accounts. goto PAYROLL INDIA – REPORTING FOR POSTING PAYROLL RESULTS TO ACCOUNTING – ACTIVITIES IN THE HR SYSTEM – EMP GRP AND SYMBOLIC ACCOUNTS – DEFINE SYMBOLIC ACCOUNTS

2) DEFINE POSTING CHARACTERISTICS OF WT ( ASSIGN WT TO SYMBOLIC ACCOUNTS)

3) goto PAYROLL INDIA – REPORTING FOR POSTING PAYROLL RESULTS TO ACCOUNTING – ACTIVITIES IN THE AC SYSTEM – ASSIGNING ACCOUNTS – ASSIGN BALANCE SHEET A/C AND ASSIGN EXPENSE A/C

4) EASY ACCESS – HR – PAYROLL-INDIA – SUBSEQUENT ACTIVITIES – PER PAYROLL PERIOD- EVALUATION – POSTING TO A/C-EXECUTE RUN

The prerequisite for posting is -Enter posting information in Master data and run payroll. After doing that follow this posting process:-

a) Create a document
b) release document ( it asks do u want to release for posting-say post immediately)
c) post document

Though the t.code FB03 you can do completeness check of the document.

Now execute the posting run – a posting run can be performed as a test run without documents / a simulation run / a productive run.

In a simulation and production run the system checks all HR and FI tables and the posting info in master data to determine whether they exist.

In a test run the system checks only the balance of expenses and payables.

Now you chose execute run – next select release post run – now post post run – finally it generates index info.

[b]I have to create a new wage type for additional payments. This has to look at a payroll constant and calculate the amount to be paid. What I would like to know is when I do this do I have to do anything so that the amount in this Wage Type will be posted to FI like create a G/L ? Or will this be posted automatically along with other wage types? [/b]

If you are copying wage type xxxx to create your new wage type for additional payment, there is a chance that your posting will take place similar to wage type xxxx.

Rest is pure config in payroll. There is a full section for it. Symbolic accounts…… G/Ls….Accrual A/Cs…. pretty involved stuff. Without a FI guru with you …I won’t advise proceeding forward.

That depends on how you create the wage type. The link is done in some T52E* table, which is for instance copied by PU30. If you create the wage type by creating it directly in T512W (via view V_512W_T), then you will have to do
the link additionally. The standard way to create a wagetype is however to find a corresponding wage type, which has the same (or similar) functionality as the one you want to create and then use PU30 to copy this wage type to the new wage type.
Thereby a lot of tables (I think in the newest, 4.6C, it’s around 95 tables) are checked and if needed the entries are copied. Amongst those tables you will also find the ones establishing the links to FI’s G/L.

Following comments relate specifically to 3.1H. They may or may not apply to your system.

Normally a new wage type is created by copying an existing wage type, either a model wage type that has some standard attributes, or an existing actual wage type in production use.

Your config changes will need to set up the new wage type so that the amount is derived from your payroll constant. However, the posting to FI will have been copied from the wage type you copied. The posting is represented by processing class 32 and evaluation class 01 (of table T512W) for a payment wage type. Provided the new wage type is similar in its
posting requirement to the one you have copied you only need to do two things now:

1. ensure that processing class 32 is the correct option for the type of posting you want.

2. ensure that the value in evaluation class 01, also known as a symbolic account, correctly represents the
target account number in FI for this expense.
If you have to post to an existing account number, for which there is already a symbolic account allocated,
you can set evaluation class 01 to that symbolic account.
If the payment is so different from existing payment types, that your accountants want it posted to a new
account code, you need to

3. allocate a new symbolic account number (next available number in the range)

4. insert a new entry in table T030, “Posting of HR to FI/CO”, linking the new symbolic account to the account
number advised by your FI administrator.

Configuration Steps In payroll for FI

Table V_T52EM
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the HR System -> Employee Grouping and Symbolic Accounts -> Define Employee Grouping Account Determination
Details of Configuration Maintain SAP Standard entries. Account assignment can also be done based on various employee subgroup using the feature ‘PPMOD’ which can be seen under this node.

2 nd alternative.

check witht he follwing

V_T52EL in this table u assign the symbols for the wage types

V_T52EK in this table u define the symbolic accounts for the wage type and assign the character stics for the wage type whether is has to be go to balance sheet or expenses accounts

than assign the synbolic account to the GL accounts useing the tcodes OBYE and OBYG

and later run the simulation for the pay roll account posting useing PC00_M99_CIPE

if it is error free than check with the tcode PCP0 and post it to FICO.

3 rd alternative.

Transaction Code:-SPRO

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemEmployee Grouping and Symbolic AccountsDefine Employee Grouping Account Determination

Transaction Code:-SPRO

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemEmployee Grouping and Symbolic AccountsDefine Symbolic Accounts

Transaction Code:-OH02

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemMaintain Wage TypesDefine Posting Characteristics for Wage Types

Transaction Code:-OH02

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemMaintain Wage TypesDefine Posting Characteristics for Wage

Transaction Code:-OG00

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemMaintain Wage TypesMaintain Posting Periods for Payroll Periods

Transaction Code:-OH00

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemMaintain Wage TypesMaintain Posting Periods for Payroll Periods

Transaction Code:-SPRO

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemCreate Posting Variants

Transaction Code:-OBYE

Payroll Payroll IndiaReporting for Posting Results to AccountingAssigning AccountsAssign Expense Accounts

Transaction Code:-OBYE

Payroll Payroll IndiaReporting for Posting Results to Accounting Activities in HR SystemAssigning AccountsAssign Expense Accounts

Transaction Code:-OBYG

Payroll Payroll IndiaReporting for Posting Results to AccountingAssigning AccountsAssign Balance Sheet Accounts

Transaction Code:-OBYG

Payroll Payroll IndiaReporting for Posting Results to AccountingAssigning AccountsAssign Balance Sheet Accounts

Transaction Code:-OG00

Payroll Payroll IndiaReporting for Posting Results to AccountingCheck Customizing for Account Determination

Transaction Code:-OG00

Payroll Payroll IndiaReporting for Posting Results to AccountingCheck Customizing for Account Determination

Transaction Code:-SPRO

Payroll Payroll IndiaPayroll CalenderDefine Schedule for Payroll Calender

Transaction Code:-SPRO

Payroll Payroll IndiaPayroll CalenderDefine Schedule for Payroll Calender

 

 

Define Symbolic Accounts

Table V_T52EK
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the HR System -> Employee Grouping and Symbolic Accounts -> Define Symbolic Accounts
Details of Configuration Define Symbolic accounts for balance sheet and expense accounts. Account assignment type = C for expense and F for Balance sheet accounts.

Maintaining Wage Types
Define Posting Characteristics of Wage Types

Table V_T52EZ, V_T52EL
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the HR System -> Maintaining Wage Types -> Define Posting Characteristics of Wage Types
Details of Configuration The posting characteristics of individual wage type can be done here depending upon the requirement. For example, the basic pay wage type ‘1000’ is linked to symbolic account ‘8888’(Salaries & wages) as below. If the model wage type is used for creating a new wage type, then this entry is created automatically.

2.1.1 Maintain Posting Date for Payroll Periods

Table T549S
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the HR System -> Maintain Posting Date for Payroll Periods
Details of Configuration Posting Date for different payroll periods can be done as follows. The Pay Day is already generated in the earlier step 4.1.5. This Pay Day can be created as Posting date. Otherwise, the difference in days has to be mentioned in the specification screen for different Posting date.

Create Posting Variants

Table V_T52E2
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the HR System -> Maintain Posting Date for Payroll Periods
Details of Configuration Posting Variants for payroll posting can be created here. This is an optional step.

Activities in the AC System

Assigning Accounts
Assign Balance Sheet Accounts

Table T030
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the AC System -> Assigning Accounts -> Assign Balance Sheet Accounts
Details of Configuration This is basically interface between HR & AC system by linking Symbolic accounts to the respective Balance sheet accounts as follow.
Assign Expense Accounts

Table T030
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the AC System -> Assigning Accounts -> Assign Expense Accounts
Details of Configuration This is basically the interface between HR & AC system by linking Symbolic accounts to the respective Expense accounts as follow.
Assign Technical Accounts

Table T030
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the AC System -> Assigning Accounts -> Assign Technical Accounts
Details of Configuration The single entry here is required for accounting key ‘1001’ to salary payable account ‘230116’ for the purpose of automatic account posting.

Assign Vendor Accounts

Table T030
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Activities in the AC System -> Assigning Accounts -> Assign Vendor Accounts
Details of Configuration This is basically the interface between HR & AC system by linking Symbolic accounts to the respective Vendor accounts(Account Assignment type K – Personal Vendor, KF – Fixed Vendor) which was created in Transaction ‘FK01’.
Check Customizing for Account Determination

Table None
Transaction Code SPRO
Menu Path IMG -> Payroll India -> Reporting for Posting Payroll Results to Accounting -> Check Customizing for Account Determination
Details of Configuration The account assignment for all the wage types through symbolic account can be displayed here

How the FI-HR integration works?

To link the symbolic accounts (from SAP HR) to GL accounts to ensure FI-HR integration. The FI-HR integration depends on the Symbolic GL Accounts. The flow is:

For every wage type you will have to assign the Sysmbolic account. The symbolic account will decide to which type of account (Expense Account, Balancesheet Account, Customer, Vendor) the postings will be made in Finance. In the Wage types Posting, you will define whether account will be debited or credited.

For each Symbolic account you will have to assign the GL account to which the postings in SAP FI has to be made. Symbolic Account act as a carrier between SAP FI & HR.

FI-HR Integration

Symbolic accounts are a way to bring together financial amounts from different sources that are all bound for the same General Ledger (G/L) account or accounts. Posting documents transfer liabilities and expenses from HR to FI. Symbolic accounts map wage types on the HR side to G/L account numbers on the FI side.

All the postings related to the wagetypes are posted to corresponding GL Accounts through symbolic account assignment. GL Accounts are created using FS00. Symbolic A/cs & GL A/cs mapping is to be done in OBYG transaction.

For FI-HR Integration first employee groupings will be done :

  1. EMP groupings like a) Employees b) Workers.this basic differentaition will be done becasue to post the FI entries like Salary account and Wages account.
  2. After employee groupings Symbolic Accounts will be defined.In this symbolic you differntiate whether the particular symbolic account is an expense or balance sheet account or vendor account or thrid party vendor account.
  3. Third step will be assigning symbolic accounts for wage types OH02 transaction
  4. At last you have to assign Gl accounts for symbolic accounts.

Tcode: OBYG (Balance sheet accounts)
Tcode: OBYE (Expense Accounts)
Tcode: OBYU (Vendor Accounts).

 

Follow

Get every new post delivered to your Inbox.