Ansicht
Dokumentation
RPCTRXT0 - File creation for ISCP Trexima
BAL Application Log Documentation CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
1Description
Program for creation of files for ISPV Trexima.
Requirements
It necessary to set following options for a proper functioning:
- settings of table T5T47N (Types of labour relation CZ) of
employment status (in compliance with CZ-ICSE classification). Information on
employment status is entered into the T5T47N-CZICSE field, that will
apply for all employees with given labor relation.
- settings of infotype 0033 (Statistics) for information about employment status
(in compliance with CZ-ICSE relation) and whether the employee
manages any staff. For entering the aforementioned
data we will use subtype CZ01 from IT0033 For employment position, value
is taken from a statistic no. 01, unless this
information is not already loaded for employee from the table T5T47N.
If no information about managing staff
is entered into statistic no. 02 the value
is set to "N", otherwise the value is taken from a statistic no. 02.
- settings of infotype 0033 (Statistics) for information about employee
membership in statutory bodies and cooperatives. For entering
we will use subtype CZ03 from IT0033 For members of company statutory bodies,
the value is taken from a statistic no. 01.
This value will be used to fill values in ODMSTATQ in the MI file.
- setting entry date into employment at employer in IT0041
If the entry date of the employee in IT0000 does not match
an actual entry date and the actual entry date
is earlier, we enter this date into IT0041.
It is possible to use any format of date, e.g. "T1" date format
(Corporate group entry date). The date is necessary for determining the time
of employment in report unit.
- setting a long-term absences in IT0033 for TREXIMA report.
In case an employee had a long-term absence (longer than a year)
at a current employer not filled in IT2001, it is necessary to
enter them into IT0033 subtype CZ02. The absence will be
passed into "Duration of long-term absence" in
the ISPV TREXIMA report.
- setting of an employment done in a reporting unit
(in compliance with KZAM-R classification) in a T5T13 table.
Field "Job" of an employee in IT0001
(P0001-STELL field) must have an entry in a table T5T13,
"Job" field (T5T13-STELL) (for creating an entry in T5T13 table
applies P0001-STELL = T5T13-STELL). In the T5T13 v table, we fill
job in the "Employment identifier" field (T5T13-KZAMP). Employment identifiers are
stored in the tableT5T50. If table T5T50 is empty we will fill the table
using RPUKZMT0 program.
- setting a highest completed education (in compliance with
KKOV code list).
If the highest completed education is selected from IT0022
"Type of school" field (P0022-SLART), value in this field
must match one of the values from KKOV codelist. In this case
the highest completed education will be stored in a T517T table
"Type of school" field (T517T-SLART) (to determine the highest
completed education, second character of
T517T-SLART is passed into ISPV TREXIMA, e.g. having "1T" entry
a value "T" is passed into ISPV TREXIMA).
If the highest completed education is selected from IT0022
"Education completion" (P0022-SLABS), value in this field
must match one of the values from KKOV codelist. In this case
the highest completed education will be stored in a T517A table
"Education completion" field (T517T-SLART) (to determine the highest
completed education, second character of
T517A-ABART is passed into ISPV TREXIMA, e.g. having "1T" entry
a value "T" is passed into ISPV TREXIMA).
- assignment of a wage types to the evaluation class (T512W).
The evaluation class is not strictly determined, it is selected on the entry
screen as a parameter. Its values are fixed as follows:
10 - basic wages
11 - other remunerations included in a wage (salary)
12 - incentives and payments included in a wage (salary) - valid until 31.12.2005
13 - compensations for wages (salaries)
15 - overtime remunerations included in a wage (salary)
16 - availability for work remunerations included in a wage (salary)
17 - regular incentives and rewards - valid since 1.1.2006
18 - irregular incentives and rewards - valid since 1.1.2006
19 - net wage - valid since 1.1.2006
20 - tax-exempt parts of tax base
21 - public holiday remunerations - hourly workers
22 - overpaid overtimes ,,
23 - paid public holidays included into ABSCELK, ABSPLAC and working hours
30 - worked hours
31 - duration of paid overtime
35 - incapacity for work paid by employer
36 - reward outside of work relationship
37 - DPC, DPP and statutories (item OONQ and
items ODMDPCQ ,HODDPCQ are filled, or items ODMDPPQ, HODDPPQ or ODMSTATQ (according to the PPV type) in the MI file)
38 - DPC, DPP and statutory authorities (item OONQ and items ODMDPCQ , or ODMDPPQ, or ODMSTATQ are filled (according to the PPV type) in the MI file)
39 - payoff, severance pay after employment termination (is filled
40 - incapacity for work paid by employer - amount addition without addition hours
OONQ and ODSTUPQ items in MI file)
- settings for absences in T5T04 table AWTY9 field. Values
of this table are fixed as follows:
001 - remunerated illness
002 - not remunerated illness
003 - remunerated absence excluding illnesses and vacations
004 - not remunerated absence excluding illnesses and vacations
005 - paid vacation
006 - unpaid vacation, time off from overtime - subtracted from ODPRACD and PRESCAS
008 - paternity after-birth nursing
- work performance region is determined in the following order:
1. From infotype 0006, subtype CZMV
2. From the customizing table T5T1L
3 From the selection screen
4. From user exitu 18TRXMVP
- settings of other input parameters
Period selection:
- Quarter - we fill in the quarter with its last day being the one the
personal data are valid - MPI part
- Year - fill in the year the processed quarter belongs to
- Reduction of long-term calculations - average earnings will be
calculated based on the setting. Possible values:
- SHRT - for an employee working for more than 22 days
for a given quarter, wage is calculated using formula
MZDA = ( AVGT + AVGDISTR * AVGH / AVGFPD ) / AVGH
where MZDA is an average wage
AVGT is a total amount from MD /202 (LHC basic average)
AVGDISTR is an amount from MD /T42 (incentives into LHC average per month)
AVGH is a number of hours from MD /202 (LHC basic average)
AVGFPD is a number of hours from MD /850 (working hours fund)
AVGH is a number of hours for MD /202 (LHC base average)
- SHTT - for an employee working for more than 22 days
for a given quarter, wage is calculated using formula
MZDA = ( AVGT + AVGDISTR * ( AVGH - AVGOVR ) / AVGFPD ) / AVGH
where MZDA is an average wage
AVGT is a total amount from MD /202 (LHC basic average)
AVGDISTR is an amount from MD /T42 (incentives into LHC average per month)
AVGH is a number of hours from MD /202 (LHC basic average)
AVGOVR is an amount from MD /204 (difference from back-calculations).
AVGFPD is a number of hours from MD /850 (working hours fund)
AVGH is a number of hours for MD /202 (LHC base average)
- SHNT - for an employee working for more than 22 days
for a given quarter, wage is calculated using formula
MZDA = ( AVGT + AVGDISTR * AVGH1 / AVGFPD ) / AVGH
where MZDA is an average wage
AVGT is a total amount from MD /202 (LHC basic average)
AVGDISTR is an amount from MD /T42 (incentives into LHC average per month)
AVGH1 is a number of hours from MD /202 (LHC base average) if it is lower or equal to number of hours
MD /850. If the number of hours from MD /202 is higher, AVGH1 takes its value from MD /850.
AVGFPD is a number of hours from MD /850 (working hours fund)
AVGH is a number of hours for MD /202 (LHC base average)
- SHOT - for an employee working for more than 22 days
for a given quarter, wage is calculated using formula
MZDA = ( AVGT + AVGDISTR * AVGH / AVGFPD ) / AVGH
where MZDA is an average wage
AVGT is a total amount from MD /202 (LHC basic average)
AVGDISTR is an amount from MD /T42 (incentives into LHC average per month)
AVGH is a number of hours from MD /202 (LHC basic average)
AVGFPD is a number of hours from MD /850 (working hours fund) + overtime hours in MD /852
AVGH is a number of hours for MD /202 (LHC base average)
- SHRP - for an employee working for less than 22 days
per quarter and a wage formula for
for SHRT
- SHTP - for an employee working for less than 22 days
per quarter and a wage formula for
for SHTT
- SHNP - for an employee working for less than 22 days
per quarter and a wage formula for
for SHNT
- SHOP - for an employee working for less than 22 days
per quarter and a wage formula for
for SHOT
If for reduction
type SHRP, SHTP, SHNP, or SHOP, employee worked more than 22 days, average income will be calculated using the formula
MZDA = AVGK / AVGH
where MZDA is an average wage
AVGK is income from MD /202-BETRG
AVGH is a number of hours for MD /202 (LHC base average),,
- 'X ' - FONDSTA,FONDSJE
by PPD - if checked the FONDSTA and FONDSJE will include hours based on a work schedule. If FONDSTA
by PPD = 0 the values will be included into FONDSTA and FONDSJE based on results of payroll. If not checked, values included into FONDSJE and FONDSTA will be based on results of payroll.
- 'X' - only employees with wage > 0 - if checked, only employees with ,,with an settled wage (wage > 0) will be included in the items of the file, otherwise employees w/o settled wage will be included as well.
- 'X' - only employees with EVIDDNY > 0 - if checked, only employees being in documented status more than 0 days will be included in the items of the file.
- 'X' - only employees with FONDSTA > 0 - if checked, only employees with working time fund set to more than 0 hour will be included in the items of the file.
- 'X' - only employees with FONDSJE > 0 - if checked, only employees with working time fund appointed to more than 0 hour will be included in the items of the file.
- 'X' - average income from /T11 - if selected, average income in the payroll results will be determined by MD /T11 or /T10. Otherwise, average income will be based on time worked during the determination period.
- Hours for PRUMVYD from MD /202 - if selected, hours for average income will be taken from MD /202. Otherwise, these hours will be based on the work schedule from IT0007. Hours are used to reduce long-term accountable income (e.g. annual incentives, ... )
- 'X' - Org.ass.WPBP/' ' fr. IT1 - organizational assignment of the employee is checked. If selected, organizational assignment of the employee will be read from table WPBP (included in the payroll results). Otherwise, organizational assignment of the employee will be based on the current setting of IT0001.
- 'X' - paid holidays from ABC - if selected, paid holidays will be read from table ABC (ABC-S will be incorporated to MP-ABSCELK, MP-ABSPLAC, MI-ABSCELKQ, MI-ABSPLACQ). Otherwise, absences will be read from table AB according to the absence subtype setting in table T5T04-AWTY9.
- 'X' - edit FOND by RT - affects the established and negotiated working hours fund. If you select this parameter, then:
a) if the established working hours fund (MP-FONDSTA) is less than MP-ODPRACD - MP-PRESCAS + MP-ABSCELK, then the value in MP-FONDSTA will be replaced by MP-ODPRACD - MP-PRESCAS + MP-ABSCELK..
b) if the negotiated working hours fund (MP-FONDSJE) is greater than MP-ODPRACD - MP-PRESCAS + MP-ABSCELK, then the value in MP-FONDSJE will be replaced by MP-ODPRACD - MP-PRESCAS + MP-ABSCELK.
- 'X' - generate MP file always - parameter valid since year 2011. If selected, the MP file will be generated for every quarter. Otherwise, the MP fill be generated only for 2nd and 4th quarter.
- XML output file format - if checked the output file
format will be XML
- DBF output file format - if checked the output file
format will be DBF
- TXT output file format - if checked the output file
format will be TXT
- TXT output file format onto server 'X' - if checked the output file
in TXT format will be created, files MI and MP
will be saved on the application server, with
filepath set in 'Path for seq.file of app.ser.'.
MI and MP files will have names <path>MI and <path>MP, where
path is set in 'Path for seq.file of app.ser.'.
Always store files on application server when
running the RPCTRXT0 program as a background job.
- 'Logic file name on AS.' - we set logic file name for MI and
MP files in case we want to store them on an application server.
MI and MP files will have names <path>MI and <path>MP, where
path if physical
file name, based on the logical file name as saved in ,,,, 'Logic file name on AS.'' parameter .
For subsequent processing of files from application server into a form
needed for ISCP TREXIMA we can use RPUTRXT0 program.
Other parameters:
- ICO - fill in the company registration number of the reporting unit
- Region - fill in the reporting unit's region code based on LAU1
- Region - fill in the reporting unit's region code based on NUTS
- OKEC - fill in the report unit's industry-specific classification of economic activities
based on OKEC code list
- Legal form - fill in a reporting unit's legal form based on CSU code list
- Name - fill in the reporting unit's name
- Street - fill in the reporting unit's street
- House number - fill in the reporting unit's house number
- Headquarters - fill in the reporting unit's residence
- ZIP code - fill in the postal code of reporting
unit's residence
- Financial Control (majority owner) - fill in a Financial Control's code
(majority owner's code):
1 fully state-owned
2 fully private property
3 shared property with state-owned majority
4 shared property with majority being private property
- Collective agreement - fill in 'A' if there is
collective agreement addressing rewards. Fill in 'N'
otherwise.
- Organization rewarding law. - fill in 'M' if the organization
rewards according to law no.1/1992 Coll. We fill in 'P' if
the organization rewards according to law no.143/1992 Coll.
- Employment entry date from IT0041 - select a type of date
for employment entry date (see above 'setting
entry date into employment at employer in IT0041').
- Evaluation class - fill in the class used
for selecting types of wages (see above)
- "Education" entry - fill in a field of infotype 0022, in which you register
completed education grade
- "Pay scale level" entry - choose whether to use value from
infotype 0008 or indirectly from T5T10 table.
- Conversion of KZAM code from 6 to 5 characters - in case your organization uses 6 characters long employment codelist ,,(KZAM), you can select characters to be used in ISPV TREXIMA. When choosing option ,,“'X' from the left” ,,ISPV TREXIMA will use from 1st to 5th character of KZAM (T5T13 table). When choosing option "'X' from the right" ,,ISPV TREXIMA will use from 2nd to 6th character of KZAM. If you use 5 characters wide KZAM, keep the option ,,,,“'X' from the left”
Output
Export runs into the files MI.DBF and MP.DBFor to files MI.TXT and
MP.TXT or to the file [year]_[quarter].XML,
or to the B2A storage (transaction PB2A). Decimal numeric fields in the .DBF file format
exceed the length required for ISCP. However, this is not an
issue. Files in .TXT format are created
with fixed field length without delimiters.
Directory settings after saving from trans. PB2A
Set a default directory for HOZ files saving using the parameter ID HR_CZ_B2A_FOLDER_TRX in the user master record.
Example
CPI1466 during Backup General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 18793 Date: 20240601 Time: 173041 sap01-206 ( 163 ms )
