Pull data

[Former Member]

Hi everyone,

I need to pull the fallowing data for a report

PERNR, NAME, AMOUNT and WAGE TYPE.

the user drill down to this info throw transaction FS10N

and the account number XXXX what I will like to know from which table can I pull that data. I use F1 on the fields that where display it and this are the tables that show me (T512T, PPDIX, PPDIT) but I didn't see the relation within this tables...

Please help,

Gregorio.

[Former Member]

Hi

You can try this:

CALL FUNCTION 'CU_READ_RGDIR'

EXPORTING

persnr = it_pemp-pernr

TABLES

in_rgdir = tp_rgdir

EXCEPTIONS

no_record_found = 1

OTHERS = 2.

IF sy-subrc = 0.

cd-key-pernr = it_pemp-pernr.

sy-subrc = 0.

rp-init-buffer.

rp-imp-c2-cd.

loop at tp_rgdir.

<b>rx-key-pernr = it_pemp-pernr.

rx-key-seqno = it_rgdir-seqnr.</b> <b>rp-imp-c2-in</b>.

endloop.

<b>rt</b> will have the required data...

Regards,

Raj

[Former Member]

Hi Raj,

The function 'CU_READ_RGDIR' is not showing me the info that I need.

my selection criteria should be

Company Code

Selection Period

Cost Center

PERNR

Posted amount

and all is posted in a specific G/L account

[Former Member]

Does anyone know where this HR information links with FI, better yet, which table/s in FI has this INFO?

Thanks in advanced,

Gregorio

[suresh_datti]

You must first get the Document Numbers from the table PPDHD for the Company code & Posting period;

You will get the reqd info from the Table PPDIT restricting by G/L acct & Cost Center.

The Amounts by Wagetype can be obtained from PPOIX

~Suresh

Message was edited by: Suresh Datti

[Former Member]

Thank u so much Suresh, you have saved my life.

Kind Regards,

Fidel

[Former Member]

Hi everyone,

How will I know for sure that the information that I have from PPDHD and PPDIT correspond to PPOIX, will the RUNID from table PPDHD be enough?, and why PERNR is not populated in table PPDIT?

Please respond, I will award some points and incase if is necesary I will post a new message to award the points.

thanks in advanced,

Gregorio.