cancel
Showing results for 
Search instead for 
Did you mean: 

NO Entry in table T549Q

Former Member
0 Kudos

Hi All

i want to generate the Absence Quota though PT60

we have copied TM04 to Zm04 ,time status is 9 is maintained

when generate it gave me the following Errors No Entry in Table T549Q

Generation of Payroll Period  till 31.12.2031

i dont know how pt60 works and where to  look for the end result if the pt60 ran successfully 

I have tried to Attached the Document for Clear understanding ,,however it is not getting done

i have prepared the word document with all the screen shorts ,it not taking  any one wants a screen shots i will mail it to directly

Plz Input ur Precious Ideas ...

Thank Q

Accepted Solutions (1)

Accepted Solutions (1)

VWITS01
Active Contributor
0 Kudos

Let me know why your are selecting multiple EE... as you have got to know that there is issue with 0007 date .

I advice you.. take one EE... change date in 0007 ... check work schedule start date...maintain "increase".. check quomo feature ..

Then try to run PT60 for that particular EE .. not for multiple.

Do it , check , test and then come out with issue you are getting now.

Please first try for only one EE

Regards

Priya

Former Member
0 Kudos

HI Priya

as i told you earlier i have changed the PA03 (control record , IT007,IT0003) have the same date

still getting the same error that is why i have treid the multiple employee to see if iam getting the

same error message on the date , but system for other employee it gave the different error message ..now iam getting

No entry in table T549Q for key 01 at 20120101"Person rejected: 00004100"

Configuration part  "increase" in table v_556_a

 

Regards

VWITS01
Active Contributor
0 Kudos

No entry in table T549Q for key 01 at 20120101"Person rejected: 00004100

This error means that for Period parameter 01 , payroll period does not exist for date

01 12 2012....

As per you , you have maintained period parameter 67, but here your system is showing error for period parameter 01... So now you have to check with period parameter.. Then check payroll periods. Try generating it again.

You go to V_T549Q, enter your period parameter and check that all periods are available or not... I hope periods are not there...

So u need to generate payroll period first and yes while generating Payroll periods, u need to check "carry out table"

Try and then check.... Alwayz advice .. frst do all testing on one particular EE.. once you get ur error resolved then start working for rest employees.

Regards

Priya

Former Member
0 Kudos

Please re-chk below steps :

Please check IT0001 , check the payroll area that you gave is a right one

Check your  period parameter T549R

Check date modifiers  T549L

Check you generated payroll periods with your combination of Pyroll area,period parameter and date modifier  T549Q

please regenerate payroll period with your combination

payroll ->  payroll india -> basic settings -> payroll organisation -> generate  payroll periods

please  do the following also

1)Check master data of the employee as well number range

2)Check your cluster table ,if the problem is  related with that please  delete that results , and check

Sushilkumar.

Former Member
0 Kudos

Finally i successfully ran pt60 for an Employee

First problem was

1)Infotype 0007 not found on 31.12.2009"Person rejected: 00003379"  TM Ststus :9

in pa0003 there is a PDC recalculation and Earl.pers.rec.date  i have set the same date

now when i ran the pt 60 again it gave me different error this time

No entry in table T001p

then i used the

S_AHR_61015471 - Infotype Overview for Employee  to check the all the infotype date

there was some infotype maintianed before the Earl.pers. RA date in pa0003

in my case 2006 quota was generated from 01.01.2010 but the Earl.pers. RA date was 01.04.2010

so i delete the entry from there and ran PT60 i got another problem ...

No entry in table $ for key $ at $ T555A 110600 01.01.2009

Technical error no. 57

there is link i followed ..

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

Then Ran pt60 finally successfully

Thank q all for the help

VWITS01
Active Contributor
0 Kudos

Thats great !!!!

Cheers

Priya

VWITS01
Active Contributor
0 Kudos

John

Mark it as an answered one if you feel so and can close this thread now..

Regards

Priya 

Former Member
0 Kudos

yes i want to close this threat

but How to i do that?

since the format have been changed  other thing if i want to see all my threats where do i look for ?

Plz suggest ..

VWITS01
Active Contributor
0 Kudos

Click on your thread name .... u'll get a full screen...

If its answred, click on correct answer..

Thread will appear as answered.... means its closed...

Reply at the end.. ITS CLOSED

VWITS01
Active Contributor
0 Kudos

To view your rest threads,

You can go to ur profile .... Click on Contents .. This is where your all threads are..

Cheers

Priya

Former Member
0 Kudos

Hi Priya,

Hope you are doing good.

Please let me out in solving this below issue.

When i am trying to run PT60 with TM04 Schema with TM Status " 9 ", it showing " Technical Error 72.

Please let me know how to fix this issue.

Thanks

Neehar

Answers (2)

Answers (2)

Sujith_EM
Active Contributor
0 Kudos

Please check the continuity of periods generated for period parameter 01.

While running time evaluation it will check for the periods generated for period parameter 01.

Former Member
0 Kudos

HI Sikindar /Sujith Nambiar

i have Generation of Payroll Period (RPUCTP00) from  01.01.1965 to 31.12.2015

Period Parameter :67 , Date Modifier :01,Start Date :01.01.1965, Final Year :2015 Start Date of Fiscal Year : 0401, Payday Rule :1 , Number of Days:2, Determine period number :1

Out Put was Generated  Period :10 ,year :1964, From:01.01.1965 To:31.01.1965, Payday 03.01.1965

TO Period :12 , year :2015 , From:01.03.2015 , To 31.03.2016 ,Payday 03.03.2016

When i generate with ZN00 it gave me

Total number selected :508,  Rejected :508 , Total Number of mesage and error message 508.

when i check the randon numbers the time status was 1...

then i ran with ZN04

Total number selected :1464,  Rejected :1464 , Total Number of mesage and error message 1464.

when i check the time status for random employees  some of them have time status 1 and 9

VWITS01
Active Contributor
0 Kudos

Hi John,

There are few thing I want input from you.

  • You are trying to generate quota through Time evaluation method, rght? Payroll is being implemented???
  • What TMS you have miantained.
  • Have you checked V_556_A table whether you have maintaine "increase" for you all absence quotas.
  • have you maintained QUOMO feature in PE03 correctly.
  • V_T559L. Have you checked that all steps are configured correctly ?

Please provide me these details ..

Regards

Priya

Former Member
0 Kudos

Hi Priya

Good to see a response from you Priya i though u have lost hope on me

1) yes iam trying to Generate Quota Through time Evaluation

reason is in my company they generate quota through RPTQTA00

yes payroll is implemented ..

2) we have A= Associate , B=Traineers, C=Contract  , O=Officer ,P=Apprentice ,R=Retire ,S= Staff, T= Technician

W= Worker ..

3) For T,O,W we have time status 9,

A,C,P,T we have time status 1

B,R time status 0

4)V_556_A it is set to "No Generation" that is the reson we use RPTQTA00 to generate manually every year ..

5)QUOMO feature is maintained , with all the employee group

then each employees group have atleat 6 personnel sub area  return value is 01,02,03,04,05,06 other wise 03

6)V_T559L. all the things have been configured properly , reduction rule , rounding rule , base entitlemnt

plz let me know any thing special need to be checked....

VWITS01
Active Contributor
0 Kudos

B,R time status 0 ------ You should not run PT 60 for them as TMS itself tells-- NO Time Evaluation.

4)V_556_A it is set to "No Generation" that is the reson we use RPTQTA00 to generate manually every year ..

So please tell me John, How could you run PT60, If in V_556_A "no generation" is checked?

You know where the mess is actually?? You have maintained 9 TMS which shows you are do'g time evaluation and again you have ticked "No generation"... So you can understand how system should response ... it will throw error only na.

So please be firm what method you want to go for

If time evalaution.... then

  • take TMT 9
  • Maintain "increase" in v_556_a
  • then run PT 60

So please do this first and then test what error you are getting .....

Note: Be clear from that you are using time evaluation only .... If you are go'h for RPTQTA. then things would be preety different

Hope my points are bit helpful to you.

Regards

Priya

Former Member
0 Kudos

Hi Priya

i have change the status to "Increase" of Officer Group (V_556A_B  )

checked the employee whose time Status is 9 Active Employee check infotype 0001(position)

When ran PT60 with ZM04   Evaluation up :31.12.2011

it gave me "Infotype 0007 not found on 31.12.2009" "Person rejected: 00003500"

pt60 with ZM00 NO Error message however no Personnel

However no personnel number selected  0, Rejected  0,

VWITS01
Active Contributor
0 Kudos

You please check start date in 0007 .. it should be before or on 31.12.2009.

Change the start date of 0007 and then check.

Regards

Priya

Former Member
0 Kudos

Hi Priya

Infotype date  was 01.04.2010 ,tried to change to 01.12.2009

it gave the error message "Change before earliest retro.date 01.04.2010 acc to control rec .to py area TO"

then i tried with diferrent employee with same status it gave the same error message

Infotype 0007 not found on 31.12.2009

Person rejected: 00003502

tried to change the start date of infotype  0007

gave the error message "Change before earliest retro.date 01.04.2010 acc to control rec .to py area TO"

VWITS01
Active Contributor
0 Kudos

Yes ...

Then go to infotype 0003 and change earliest retro date.. save it..

and Go to PA03 ... delete the control record and again create with new earliest retro date what u have maintained in 0003 infotype... save it.

Be in correction of payroll status of payroll record and then save it...

Then once gain run PT60 .... after mainating 0007 with start of 01.12.2009

Test it..

Hope it will help you.

Regards

Priya

Former Member
0 Kudos

Hi Priya

But why system is giving that particular date or month error message

i have already tried that option in 3 payroll change the Earl.pers. RA date 1.01.2009

in the pa03 control record it change the retro date

tried with other employees m gave the same error message

..

VWITS01
Active Contributor
0 Kudos

For every employee u need to maintain 0003 infotype and 0007 according to the date its throwing error..

Let me know if you got your issue resolved for atleast one employee.. If its so, you follow same track and wrk ahead.

Come up with updates please.

Priya

VWITS01
Active Contributor
0 Kudos

For every employee u need to maintain 0003 infotype and 0007 according to the date its throwing error..

Let me know if you got your issue resolved for atleast one employee.. If its so, you follow same track and wrk ahead.

Come up with updates please.

Priya

VWITS01
Active Contributor
0 Kudos

For every employee u need to maintain 0003 infotype and 0007 according to the date its throwing error..

Let me know if you got your issue resolved for atleast one employee.. If its so, you follow same track and wrk ahead.

Come up with updates please.

Priya

VWITS01
Active Contributor
0 Kudos

System error , thats why same msg 3 times... NEW SCN. .. Disappointing...

Yes system is throwing error related to date because EE should have Work schedules, Abesence types and quotas  for the date you are running PT60.. You are trying to run PT for 2009 and 0007 is maintained in 2010.then how system will take PT60 for 2009... Its a simple logic.

Regards

Priya

Former Member
0 Kudos

Hi Priya

PA03, IT0003,IT0007 all have the same starting date .

why the system is taking the date as

i have selected multiple employee

1)Infotype 0007 not found on 31.12.2009"Person rejected: 00003379"  TM Ststus :9

2)No entry in table T549Q for key 01 at 20120101:Person rejected: 00003539"  TM Status :9

3)Caution: Start of processing set from 20100101 to 20100201

No entry in table T549Q for key 01 at 20120101"Person rejected: 00003644" TM Status :9

4)Caution: Start of processing set from 20100101 to 20100701

No entry in table T549Q for key 01 at 20120101"Person rejected: 00003714" TM Status :9

5)No entry in table T549Q for key 01 at 20120101"Person rejected: 00003868"  TM Status :9

6)No entry in table T549Q for key 01 at 20120101"Person rejected: 00003985" TM Status :9

7)No entry in table T549Q for key 01 at 20120101"Person rejected: 00004100" TM Status :9

All of them have same PA03,it0003,it0007...

some of them have diferrent date problem

sikindar_a
Active Contributor
0 Kudos

Can you check the pay periods are generated for ......Period Parameter 01 too