Function Module Extactor

[Former Member]

Hi All,

I have one extractor which is using a Function Module. How could I know the underlying tables which the function module is reading data from?

Can anyone please help me in this?

Best Regards,

Nimma.

[Former Member]

Hi Nimma

Can you post the code ? that might help to answer your question.

[andrea_previati]

Hi Nimma

If i'm not wrong the details of cost from trans. IW33 are stored in table PMCO, with fetch OBJNR from AUFK.

Hope it helps

Andrea

[andrea_previati]

Hi Nimma

tipically Iw31/2/3 works on these tables

AFKO(PP header table)

AFPO(PP item table)

AUFNR- PRODUCTION ORDER NUMBER

VBELN- SALES ORDER NUMBER

Hope it helps

Andrea

[Former Member]

Hi Andrea,

Thanx for ur reply.

I just checked the tables but they are not showing the planned/actual costs.

I am looking for somethign to find out the sales order no./planned costs and actual costs using the internal order number.This means when we go to IW33 and give an internal order no. we will get a screen. In that screen there is a tab called Costs. I am lookin for that particular data.

Can u please try to help me out in this.

Best Regards,

Nimma.

[Former Member]

NImma,

can you try these tables...PMSDO, AFIH, PMCO, PMCOQT, and TBMOTX .

i tried in SQL Tracer. you can try the same you will get how to link these tables also.

all the best.

Regards,

Nagesh.

[Former Member]

Nimma,

Look into CSKT, CSKU and CSKB tables.

Hope it helps.

Thanks

sri

[Former Member]

Nimma,

The easiest way is to look into the code of the FM and see on what tables a selection is made.

Rgds,

Eddy

[Former Member]

analyze the code.

Nagesh.

[Former Member]

Hi Eddy,

I have tried that but there are lot tables in that. I am not sure which one is the correct one. Basically I am trying to find out the tables which stores the actual/plan costs from the transactions IW31/IW32/IW33.

Best Regards,

Nimma.

[edwin_harpino]

hi Nimma,

you can try open the function module with SE37,

and see inside the code what tables involved

and how they populate to the extract structure.

hope this helps.