Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Rquired Table names with doc number and pernr

Former Member
0 Kudos

Dear Experts,

Developed a customized report based on posted Statutory values (Incometax.professional tax,ESI and provident fund).

using PPOIX and PPDHD tables to extract the values.Here what we are getting the problem with the Full and final settlement employees.

For example if an employee resigns in the month of April and whose full and final settlement was done in July month, Report is showing up the values in the month of April even though they were posted in July month.

Why system is showing the values in April month even though we posted the amounts in July month.

Is there any way to extract posting values from GL s with employee numbers.

We are trying with BKPF and BSEG tables.But we are not getting employee Id.

Could you advice the way to extract the report.

Thanks and Regards,

Thirukumaran. R

3 REPLIES 3

Former Member
0 Kudos

Hi,

Please check BSEG cluster table , it has employee Id field in it (PERNR).

Regards,

Srini.

0 Kudos

Hi srinivas,

In bseg table it has an field name pernr but, in FI all the employees are not maintained as vendor so its not updating the pernr value in bseg table,

Regards,

Thirukumaran. R

Former Member
0 Kudos

Hi Thirukumaran,

You have to look at the FI posting document and check against what reference the document has been posted.

They could maintain the same in BSEG-ZUONR or may be even in text.

Hope it helps.

Sujay