topic Re: Pull data in Application Development and Automation Discussions

Pull data

Former Member — Wed, 06 Sep 2006 17:30:22 GMT

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.

Re: Pull data

Former Member — Wed, 06 Sep 2006 17:36:08 GMT

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.

rx-key-pernr = it_pemp-pernr.

rx-key-seqno = it_rgdir-seqnr. rp-imp-c2-in.

endloop.

rt will have the required data...

Regards,

Raj

Re: Pull data

Former Member — Wed, 06 Sep 2006 18:00:14 GMT

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

Re: Pull data

Former Member — Wed, 06 Sep 2006 18:47:55 GMT

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

Thanks in advanced,

Gregorio

Re: Pull data

suresh_datti — Wed, 06 Sep 2006 18:56:39 GMT

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

Re: Pull data

Former Member — Wed, 06 Sep 2006 19:09:43 GMT

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

Kind Regards,

Fidel

Re: Pull data

Former Member — Mon, 11 Sep 2006 14:13:29 GMT

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.