Relation between HRP1001 and HRPAD31

[Former Member]

Hi

I am making a report using PNP Logical database but I need read some Infotype of Organization, for example 1050, 1001, 1000, for each employee.

I am reading the infotype 1001 using the FM RH_READ_INFTY_1001_EXT, this function return me one structure type HRI1001, but never I found the field ADATANR correctly

How can I read the infotype 1001 for obtains the field ADATANR???

Next How can i do the relation between the infotype 1001 and the table HRPAD31?

Regards

Gregory

[suresh_datti]

>

> How can I read the infotype 1001 for obtains the field ADATANR???
> Next How can i do the relation between the infotype 1001 and the table HRPAD31? 
> Regards
> Gregory

You are on the right track, ADATANR is the link between HRP1001 & HRPAD31. Did you specify the OTYPE, OBJID & RELAT fields in the HRP1001 lookup? here is a sample SELECT ( to read Quals ) for you..

select a~objid a~sobid a~endda
           b~stext
           c~chara
              into table t_quals
              from ( hrp1001                 as a
                    left outer join hrp1000 as b on a~objid  = b~objid
                                      and          a~otype   = b~otype )
                        inner join hrpad31 as c on a~adatanr = c~adatanr
             where a~otype  = c_type_q
               and a~plvar  = c_plvar
               and a~rsign  = c_rsign_b
               and a~relat  = c_relat_032
               and a~istat  = c_istat
               and a~endda >= w_begda
               and a~endda <= w_endda.

~Suresh

[Former Member]

hi

Yes i have the field OBJID OTYPE RELAT when i read the infotypes 1001.

I have all fields the infotype 1001 that did me the function RH_READ_INFTY_1001_EXT

Do you know any function for do the search in the HRPAD31??

Or I need to do this using ABAP sentences

Regards

Gregory

[Former Member]

Ready

I finish using abap Sentence for solve my problem

Regards

Gregory