SAP Function SGPS_CALC_MVC_COMPONENT - Function to calculate the MVC Component - Ernst & Young

Parameter Reference Type Length Default Optional Text
EDATE SYST-DATUM D 8 Effective Date
LGART T510-LGART C 4 Wage Type
MOLGA T510-MOLGA C 2 Country Grouping
TRFAR T510-TRFAR C 2 Pay scale Type
TRFGB T510-TRFGB C 2 Pay scale area
TRFKZ T510-TRFKZ C 1 Employee subgroup grouping for CAP.

Parameter Reference Type Length Text
RETURN_CODE SYST-SUBRC I 4 Return Code

Parameter Reference Length Optional Text
DATATAB_T510 T510 47 Internal table of structure t510

Functionality
The main objective of this function is to calculate the MVC amount.This amount can be derived by the following formula.
1982 (%) 1983 (%) 1984 (%)
Super scale 7.45 7.70 12.00
Normal 3.25 3.00 8.20
Min Salary 568.00 604.00 680.00
Min % - 1.30 4.20
Program receives basic parameters like molga,trfar,trfgb,trfkz andlgart and internal table of structure t510.
Program Description.
* Select * from T5PBSR6J and move it to the Internal Table.
* Select * from T5PBSR6J and move it to the Internal Table.
* Move the data from datatab_t510 to tmp_tab for processing.
* For each record read, move its salary code into sal_code.
(Here Salary code can be obtained from "trfgr" Psgroup. PSgroup
is the combination of salary code and bar-indicator.
* For each salary code, retrieve corresponding Scheme code.
* Use Scheme code as the key field to retrieve the respective
percentage and amount from T5PBSR6J
* Calculate the MVC amount using the formula.
* Append the internal table datatab_t510
* Return the Internal table datatab_t510

Example
For officers with MVC built-in to the basic salary under the Normal
Scheme
Basic Salary = $2,460
MVC = $2460 - [ (($2460/1.082)/1.03)/1.0325)] = $322
Salary = $2460 - $322 = $2138
MVC = $322
Basic Salary = $2460
NPVP is calculate on the basic salary ($2460).
i.e. Working backwards based on the 1984 rates, using Division.
For officers with MVC built-in to the basic salary under the SuperScale Scheme
Basic Salary = $4,000
MVC = [ (($4000*1.0745)*1.077)*1.12)] - $4000 = $1,184.42
MVC = $1,184.42.
Basic Salary = $4000
NPVP is calculated based on the basic salary + MVC (i.e. $5184.42)
i.e. working forwards from 1982 rates, using multiplication.
Note:
If the basic salary is less then the specified min. salary amount,
the min % should be used instead of the % under the supersclae or
Normal.