cancel
Showing results for 
Search instead for 
Did you mean: 

Data Inconsistency in T7INI7/T7INI9 TABLES

chandra_sekhar96
Participant
0 Kudos

Dear Guru's,

I required your help for resolving the below issue.

I have successfully done manual changes and applied Snote for Sec80 CCD(1B) few months and tested and shared to user.

Client also tested and it has worked fine.

Recently we have applied the Patch for 2016 FY budget change and Notified that Subsection 17 values are changed to old values in DEV/QTY and PRD systems.And i found inconsistency in each Server.

I have done some changes in DEV server in T7INT7 table .

Now the entry is like below.

I have modified the entry in DEV system and deleted the previous one, now there is only one entry in I7 table like below Screen shot.

entry in T7INT9 table in DEV.

I7 and I9 tables screen shots in Quality and PRD server like below screen shot.

Please help/Suggest how to delimit the entries.

appreciate your quick response.

Accepted Solutions (0)

Answers (2)

Answers (2)

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

Further regarding you T7INI7 and T7INI9 tables , there should be records should be existing as follows from tax year 01.05.2015 for subsection 17.

01.04.2015     to 31.12.9999     2,00,000.00 INR

The entry prior to 01.04.2015, i.e.01.04.2010 to 31.03.2015 should be delimited.

Kindly make changes likewise in all your systems .

Thanks and Kind Regards

Ramana

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

attaching screenshots for the two tables taken from the standard system

v_t7ini7

v_t7ini9

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

I have checked the Budget note 2290356 , manual changes , and find that that there were no changes to T7INT7 and T7INT9 tables, for serial number 17.

I am not sure why the tables above were changed, and what change was done.

Also can you please explain what exactly you would want to have /do with these tables?

Thanks and Kind Regards

Ramana

chandra_sekhar96
Participant
0 Kudos

Hi Ramana,

Symptom

As per Union Finance Bill 2015 there has been an amendment to Section 80CCD. The amendment says that Sub-section(1A) has been omitted and a new sub-section (1B) has been introduced.

The Sub-section (1B) is in addition to the deduction allowed under Sub-section(1), under a pension scheme notified or as may be notified by the Central Government and shall not exceed fifty thousand rupees.

Example:


CASE 1:

If an Employee 'X' has monthly salary of 1 Lakhs and he contributes 2 Lakhs towards NPS in a Financial Year and he has no other investments. He shall be able to claim total deduction as per calculation shown below:

(a) 10% of Annual NPS basis = 10% * 1200000 = 120000 INR

(b) Total NPS contribution = 200000 INR

Deduction u/s 80CCD(1) = 1.2 Lakhs [ Minimum of (a) , (b)]

Deduction u/s 80CCD(1B) = 50,000 INR

Total Deduction for  = 1.2 Lakhs [80CCD(1) + 50,000 [80CCD(1B)] = 1.7 Lakhs

I have done the manual changes sugested in the Snote 2168787. and Tested.

technical wage types such as /3I7 and /3I9 is generated.

But as per our current system configuration.I am not getting the exemption.

Please let me know how to congifure/Delimit the values.

Can i delete the Subsection and Configure once again from starting point onwards ?

is their any impact happens if i delete ?

Please suggest asap.

Thanks in advance.

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Sekhar

Kindly check the following :-

A)SAP note 2168787 is implemented completely and consistently in your system, both manual steps and code corrections.

B)Wage Types /143 and /144 are calculated/appearing in RT of the employee payroll. For this to happen , as explained above, you should have the cummulation class 43, 44 ticked for the such wage types relevant for NPS basis.

C) Execute the payroll and check INS80 output IT table .

Thanks and Kind Regards

Ramana

Message was edited by: Jayanti Venkata Ramana

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

http://scn.sap.com/thread/3918099


You may refer this thread for additional information on this NPS topic !

chandra_sekhar96
Participant
0 Kudos

Hi Ramana,

I have done the Manula changes,but core corrections didn't done.

Could you please let me know what is the SP level for code correction.

Currently our system status  ; SAP_HRCIN 604 0084 SAPK-60484INSAPHRCIN

Please suggest.

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

This note 2168787 version 7 went  in HRSP 89 for SAP HR 604 release.

Therefore kindly apply the code changes using snote transaction.

Having done that , Kindly also check on point no.(B) of the above reply , and then check and execute the payroll again.

Thanks and Kind Regards

Ramana

chandra_sekhar96
Participant
0 Kudos

Hi Ramana,

So we need to update the Patch level upto 89 ?

Please confirm.

jayantvenkata
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sekhar

Either you can patch your system up to 89 level, else you can apply the code corrections using snote transaction.

Thanks and Kind Regards

Ramana