Production Order (TCODE - CO01) where data is tored.

[Former Member]

Hi all,

For the production Order in which table data is stored?. Also specificaly the component ( In Component overview data - Compnant end all other field in which table it store)

Tcode - CO02 -

Give Production order #

Then press "F6".

It will shows the component overview. - In which table it stores?

Like in sales order we have VBAK - VBAP ...etc....

[Former Member]

Hi,

I think this can be done by you itself.

Just use SQL trace to do the same,

you will get all the tables required by you.

Do the following task.....

OPen TCODE - CO02
Open a new session as well.
In the tcode session five the production order number.
now go to the new session.
click on system -> utilities -> performance trace.
activate the trace.

once the trace is activated go to the session where you have entered the production order number and then press F6.
once you get the details on the screen.
go to the performance trace session and deactivate the trace and then click on display trace.
and hit enter.
this will give you the list of tables used by the TCODE CO02 from the time you pressed F6.

Hope this is useful now and in future tooo.

Regards,

Siddarth

[Former Member]

Hi,

U can refer to my reply in the thread\

Also, the relevant tables are afko, afpo, aufk

[GauthamV]

Tables : AFKO,AFPO.

[Former Member]

Get Component details from Table RESB For Production Order No AFKO-AUFNR

Get Component details from Table RESB

AFKO-RSNUM = RESB-RSNUM

Hope this helps....