‎2008 Mar 18 1:35 PM
Hello.
I'm looking for a table wich contains every useable infotype in PD.
I've fount this table: T777t. But it returns some infotypes that don't seem to exist in the dictionary like for example '1022', '1207', ..
Anyone who knows a better table?
Greets
‎2008 Mar 19 10:29 AM
hi,
try this table
T588C Infotype Menus/Info Groups
T588M
T591
T582A, CHECK ALL TABLES START FROM T582
REGARDS,
PANKAJ
‎2008 Mar 19 3:09 AM
Hi,
Try this...
T582A - Infotypes
T582B - Infotypes Which Are Created Automatically
T582S Infotype Texts
Reward points if useful...
Regards
AK
‎2008 Mar 19 10:29 AM
hi,
try this table
T588C Infotype Menus/Info Groups
T588M
T591
T582A, CHECK ALL TABLES START FROM T582
REGARDS,
PANKAJ
‎2008 Mar 20 8:12 AM
Ok but all these tables also give infotypes that doesn't exist when you try to open them with HRP1nnn.
Any idea what the problem is?
ex: infotype 0022 ==> HRP1022 gives message "not active in the dictionary".
‎2008 Mar 20 9:57 AM
Hi Bert Neels,
In HR, Infotypes range 1000 to 1999 reserved for PD and OM.
It does not mean that all are existed.
infotypes Database tables
-
1000-1999 HRP1000-HRP1999.
Thanks,
Venkat.O
‎2008 Mar 20 12:38 PM
Ok, but how can I check if they exist.. I have to make a program that dynamically selects all PD infotypes..
‎2008 Mar 20 3:10 PM
Hi Bert Neels,
As you said T777T is base table for the infotypes. Write a query like this.
DATA : i_infotypes TYPE TABLE OF t777t.
SELECT *
from t777t
into table i_infotypes
WHERE langu = sy-langu
and infty ge '1000'
AND infty le '1999'.
Regards,
Venkat.O
‎2008 Mar 20 3:58 PM
LOL!
Ok I understand that :d
The problem is, when I execute your querry, the internal table also contains infotype 1022 wich doesn't exist in the library if you check it with hrp1022..
So I thought there was maybe a table with only the infotypes that do exist in the library..
Anyway, I just have to give an output of every existing PD infotype so I guess I need to test in the program wether the table HRPnnnn exists. Anyone knows how to do this?
Edited by: Bert Neels on Mar 20, 2008 4:58 PM
‎2008 Mar 20 6:13 PM
Hi Bert ,
There is no specific for PD ,PA and others . All Infotype tables start with PA<infotype name> like PA0001, ---Pa9999 . check in SE11 . its availble . Check PD what are the data required select related info ...
if u have doubts reply me.
if its helpful reward me.
Thanks,
Suresh
‎2008 Mar 21 8:23 AM
Yes ok, I can check this manually thats no problem. The problem is that I have to create a dynamic program that gives a list of all the active infotypes so..
‎2008 Mar 22 8:54 PM
Infotypes ( PA and PD ) might contain data based on the HR implementation done
For example there will not be any Infotype 71 entries if no Pensions is configured in your system.
The differenece between PA and PD infotypes is that
PA Infotype are stored in PAxxxx table (thats the end of it)
PD Infotypes are slightly tricky.
For One HRPxxxx record there can be multiple HRTxxxx records with the key derived from HRPxxx
So for your requirement, just check if there is any entry in the tables HRPxxxx or PAxxxx
and Output
Any more queries?
Please reward points