Monday 12 May 2014

International Payroll - Document

International Payroll :
COM : Function
 Function COM creates comment lines which explain the meaning of a schema
 and thus the type of payroll generated with this schema.
 Lines with the function 'COM' can be located anywhere in a payroll
 This function is used without specifying parameters.
COPY:
The function COPY copies the schema specified in Par1 dynamically to the
current schema.
This allows partial processing sequences to be put together to an
effective schema.
This facilitates maintenance. Take into account that the COPY function
works only for initialization of the schema. A subsequent change during
during simulation is ineffective.
The function COPY copies the schema specified in Par1 dynamically to the
current schema.
You want to insert subschema ABCD into the current schema.
Access
Fct   Par1  Par2  Par3  Par4
 COPY  ABDC
  
XIN0:
Personnel calculation schema
Use :
 Important information/actions (switches), which are relevant to the
 further course of payroll, are specified/carried out in this subschema
 at the start of the payroll run.
Structure
 The subschema comprises the following main steps:
 1.  Specify program type (payroll or evaluation)
 2.  Set switch for database updates (YES/NO) All database updates are
     controlled via this switch (otherwise simulation)
 3.  Only infotypes from the HR master record which apply to the selected
     personnel number are read.
 4.  All Time Management infotypes are imported.
 5.  Specify check against control record PA03 (test or live).
XBD0 :
The subschema reads the basic data (master data) required for
International gross wage calculation. The basic data is then printed in
the payroll log (if program option = ON).
Structure
The subschema comprises the following main steps:
1.  Read name of employee (P0001-ENAME)
2.  Read relevant work centre and basic pay data from the following
    infotypes:
    a)  Personnel Actions P0000,
    b)  Organizational Assignment P0001,
    c)  Planned Working Time P0007,
    d)  Basic Pay P0008,
    e)  Wage Maintenance P0052 and
   f)  Cost Distribution P0027
Check that all necessary master data is accessible to the payroll
driver (otherwise program is cancelled)
Print the above basic data in the payroll log 
RFRSH :
This allows you to delete internal table
You specify the internal table you want to delete in the second
 parameter of the function (see Par2).
Syntax
 Par2                    Internal table
             AIT         Alternative input table
             ALL         All internal tables
             BT          Bank transfer table
             CRT         Cumulated results table
             GRT         Gross results table
             HZ          Gross results table
             INS         Bank transfer table
             IT          Input table
             NT          Nandemo Table (Jpn)
             NZRE        Nandemo Table (Jpn)
             OEPF        Nandemo Table (Jpn)
             OLD         All 0 tables
             ORT         Old results table

OSOC        Old results table
OSRT        Old results table
OTAX        Old results table
Q3          Old results table
RI          Old results table
RO          Old results table
RQ          Old results table
RRT         Old results table
RT          Results table
SRT         Results table
ST          Tax table
SV          SI table (NL)
TAX         Tax table
TT          Tax Table (Jpn)
TWOT        Tax Table (Jpn)
V0$         V0 table
VAR         Variable table

WPBP        Table WPBP
XIT         Table XIT
YTT         YEA Tax Table (Jpn)
ZL          Time wage types
ZTBA        Time table construction industry
ZVBA        Supplementary pension construction industry
XPRO:  Import previous result current period
Personnel calculation schema
During a retroactive accounting run, the system transfers the previous
results from table OV0 to table V0. To do this the previous result is
imported to this subschema.
Subschema XPR0 comprises the following steps:
1.  Import previous result (function IMPRT)
2.  Add table OV0 to table V0 of the current payroll result (function
    PITAB)
XLR0 :            Import last payroll result
  Payroll calculation schema
Use
  The last payroll result (can be from previous period) is read in this
  subschema, and made accessible to the current payroll run (for the
  current period).

  The imported last payroll results, or the values transferred, are then
  printed in the payroll log (if program option = ON).
Structure
  The subschema comprises the following main steps:
  1.  Import last payroll results (result table ORT)
  2.  Print results table (ORT) after import
  3.  Transfer relevant values to current payroll (LRT) Control is
      effected via processing class 06 in table T512W
  4.  Print transferred values from LRT after import
XT00 : -Gross remuneration (Time Management)
Personnel calculation schema

All the information from Time Management, included in the working time
calculation and the monetary valuation, is processed in the XTOO schema.

Structure
The schema is made up of the following main steps:
o   Structuring the personal schedule and retrieval of the partial
    period parameter.
o   Calculating the valuation bases.
o   Valuating the absences.
o   Time wage types selection rule.
o   Processing remuneration statements.
o   Processing the differing payments.
·        Valuating time wage types.
·          Taking time tickets from incentive wages into consideration.
XLON : LOAN
Loan Accounting
   Object
     Personnel calculation schema
   Use
     In the XLON schema, accounting is performed for the company loans listed
     in the Loans infotype (0045).

   Structure

     In the first step, the last payroll results are imported. The P0045
     function is then called twice:

     o   If this function is accessed using the GRSS parameter, all
         calculations are made.
     o   If the NET parameter is used for access, the values are stored.
         As in previous releases, you can still perform your own processing
         by calling a personnel calculation rule after the P0045 function
         (  >XLON)
         SAP does not recommend this option!
     o   If you want to store additional values, after calling the function,
         you should call the PRT function with a calculation rule (for
         example, XLOZ)
XAP0: Import additional payments/deductions
Import Additional Payments/Deductions (INTERNATIONAL)
  Object
    Payroll subschema
  Use
    This subschema adds recurring payments/deductions or additional payments
    to the basic pay. These payments/deductions are processed separately in
    greater detail in the personnel calculation rule X011.
  Note
   If you want to process other payments and deductions apart from those
    from infotypes 0014 and 0015, you can use subschema XAP9.
  Structure

    The subschema comprises the following main steps:

    o   Import and process recurring payments/deductions from infotype 0014

·        Import and process additional payments from infotype 0015
XAP9: Import Additional Payments/Deductions (INTERNATIONAL)

Import Additional Payments/Deductions (INTERNATIONAL)

  Object

    Personnel calculation schema

  Use

    This subschema adds recurring payments/deductions or additional payments
    to the basic pay. These payments/deductions are processed separately in
    greater detail (in personnel calculation rule X011) for infotypes 0014,
    0015, and 0267.
  Note
    This schema is a copy of schema XAP0 which has been enhanced to include
    other functions in addition to payments/deductions from infotypes 0014
    and 0015, for example, external wage components or awards. If you do not
    require these functions, use subschema XAP0.

  Structure

    The subschema comprises the following main steps:

    1.  Importing and processing recurring payments/deductions from infotype
        0014

    2.  Importing and processing additional payments from infotype 0015

    3.  Importing and processing external wage components from infotype 0579

XAL0:

 Monthly Factoring and Storage (Cumul.of Gross Amount) INTERNATIONAL

   Object

     Personnel calculation schema

   Use

     After all the remuneration elements from master data and Time
     Management, and the bases for factoring (proportional reduction of
     remuneration by multiplying with a factoring parameter (number between
     zero and one) have been generated from the personal work schedule
     (including absences), you can use this subschema to perform the
     valuation. The proportional remuneration elements that accrue, for
     example, due to an employee's unpaid absence, are finally cumulated in
     gross buckets for further processing. As well as the "reduction" of
     remuneration in the case of partial periods, factoring is also used to
     distribute monthly lump sums and hourly rates to Cost Accounting (CO).

   Structure

     The schema comprises the following main steps:

     o   Generation of secondary wage types /801 to /8nn for partial period
         factors

     o   Creating partial period factors in line with specific regulations

     As different remuneration elements are subject to different reduction
     regulations, there must be different monthly factors.
  o   Calculating monthly lump-sums for cost accounting, that means,
      evaluating remuneration elements (multiplication of an amount by a
      factor).
  o   Calculating hourly rates for Cost Accounting
  o   Processing standard wage maintenance (Schema XWM0)
  o   Gross feeding and storage of the wage types no longer required
      during the course of further processing
  o   Calculation of gross amount and cost distribution for Cost
      Accounting (CO). Cost Accounting needs to know which part of the
      wage/salary was for "non-work" (paid leave, paid sickness, other
      paid absences, public holidays) so that redistribution to other cost
      centers can be effected where necessary (social cost center,
      overheads cost center).
XAL9:
XTBS :            Save tables before iteration
Save Tables before Iteration
  Object
    Personnel calculation schema
  Use
    Several tables must be saved before the arrears iteration for the
    deduction and tax functions. These are then reloaded in each iteration.
    Function PITAB is used for this purpose.
XTBL : Reload saved tables
 Reload Tables for Every Iteration
   Object
     Personnel calculation schema
   Use
     After the loop begin all of the saved tables have to be reloaded.
     Function PITAB is used for this purpose.
XDD9 : Processing deductions and storage
Monthly Factoring and Storage (Cumul.of Gross Amount) INTERNATIONAL
  Object
    Personnel calculation schema
  Use
    This subschema contains the functions for the deduction function:
    o   Benefits

    o   Balances and Totals

    o   Limits

·        Arrears
XNA0 :
Cumulation of net amount/payment amount
XNA9 :
Cumulation of net amount/payment amount
Cumulate Net Amount and Form Payment Amount (International)

   Object

     Personnel calculation schema

   Use

     All influencing factors from gross wage calculation are incorporated on
     a 1:1 basis in a non-country-specific net wage. Net elements are not
     taken into account in schema X000 (net = gross). The generated payment
     amount may be subsequently manipulated using payments/deductions. The
     payment amount is generated, if necessary taking account of claims from
     previous periods.

   Note

     This schema is a copy of schema XNA0 which has been enhanced to include
     the arrears processing functions. If you do not require these functions,
     use subschema XNA0.

   Structure

     The subschema comprises the following main steps:

     o   International cumulation of payment amount (net=gross)

     o   Arrears processing of deduction wage types

     o   Generation of the net pay prior to transfer

     o   Allowance for claims from previous periods during generation of the
         net pay.


XDNT – All deductions made ?


 Decision on Deductions Not Made (Loop End)

   Object

     Personnel calculation schema

   Use Function PRPRI checks all arrears deductions to determine whether or
   not the net amount is sufficient to cover them. If the function determines
   that at least one deduction cannot be made in full, iteration must be
   repeated.

XRR0 : Retroactive accounting

 Retroactive Accounting INTERNATIONAL

   Object

     Personnel calculation schema

   Use

     This subschema is used to calculate any differences which may exist if
     payroll takes place in a period for which retroactive accounting has
     been performed so that remuneration is no longer consistent with the
     original payroll run. The differences calculated are then taken into
     account in the same subschema in the original payroll run for the
     current period.

   Structure

     The subschema comprises the following main steps:

     o   Query whether original or retroactive run

     Original payroll run:

     o   Read differences calculated

     Retroactive accounting run:

     o   Read last payroll result (original payroll or old retroactive
         accounting run)

·        Print the values read (internal table ORT)
·        o   Calculate differences and transfer non-revisable wage types
·         
·         o   Derive new payment amount
·         
·         o   Store the difference between the new and old payment amount in
·             difference table (internal table DT)
·         
·         o   Transfer bank transfer(s) (from internal table BT) from last payroll
·             Result
XNN0: Net payments / deductions and transfer
 Net Payments/Deductions and Transfers (INTERNATIONAL)
   Object
     Personnel calculation schema

   Use
     The composition of the payment amount is carried out in this schema. The
     net payments/deductions are also taken into account. Following this, the
     transfers are performed - either external transfers and/or pay
     emittances. If advance payments from previous payment runs have already
     been made, they are checked and taken into account.

   Structure

     The subschema comprises the following main steps:

     o   Query original payroll run
         Original payroll run:
         -   Take external transfers from infotype P0011 into account
         -   Import net payments/deductions and store in results table
             (internal table RT)
         -   Process transfers from previous payment runs (advance payments)
         -   Form payment amount
         -   Read the bank details from infotype P0009 for wage and salary transfer
 Always takes place:
·        Storage of payment amount/claim
XAC0 : Month end accruals
Personnel calculation schema for Month End Accruals

   Schema Type
     This is a schema for month end accruals computations.
   Use
     In schema XAC0, month end accruals calculations are performed in a
     regular payroll run.
     The accruals are calculated using the function Function UACGF if the
     accruals switch Operation ACCMO is on. The results are stored in table
     ACCR, which is also printed in the payroll log.

   Structure

     Schema XAC0 consists of the following main steps:

     o   Determine if in a regular payroll run

     o   Accruals switch on or off

     o   Calculate accruals

   See also

     PC Rule XAC0

     More information about month end accruals can be found in the R/3
     library.
     Specific information about setting up month end accruals can be found in
     the implementation guide.’
XEND :
Final Processing INTERNATIONAL
  Object
    Personnel calculation schema
  Use
    At the end of the payroll process, this subschema performs a check to
    determine whether the internal processing table has finished processing.
    The cumulation is then recorded at wage type level, provided that this
    is programmed for the respective wage type. At the end of this
    subschema, the last act in the payroll process is the export of the
    payroll results to the payroll account. The results of payroll are
    printed in the payroll log (with program option = ON). Processing of the
    payroll results using Report RPCEDTX0 can be effected via the "Payroll
    form" parameter.
  Structure
    The subschema comprises the following main steps:
    1.  Printing of the processing table (internal table IT)
    2.  Break of payroll if the processing table has not been fully executed
    3.  Sort result table (internal table RT)
    4.  Printing of the result table (RT)
    5.  Printing of the transfer assignments (internal table BT)
6.  Updating the cumulation wage types (acc. to internal table CRT)
 7.  Printing of the cumulative values (from CRT)
 8.  Export of results from the payroll function to the payroll account
     (databank: PCL2 / cluster: RX non-country-specific)
 9.  Processing of payroll results (RPCEDTX0) can be selected via the

     "Payroll form" parameter.

3 comments:

  1. Thanks for this useful information. It is not easy to handle payroll system, its need good knowledge of payroll.

    Regard
    payroll providers guelph.

    ReplyDelete
  2. If you pay your invoice two days before the due date of the pay run, we will rebate you 2% of your gross wages (ex super) for the period! That’s right. We reward you for being fiscally responsible.
    Outsource Payroll Brisbane

    ReplyDelete
  3. Hello Raghav, this is a very useful blog. However, I needed more information on how accruals work, would you be kind enough to provide more information?

    ReplyDelete