topic Re: Production Order (TCODE - CO01) where data is tored. in Application Development and Automation Discussions

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

Former Member — Mon, 09 Mar 2009 23:36:14 GMT

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....

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

Former Member — Mon, 09 Mar 2009 23:43:33 GMT

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

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

Former Member — Tue, 10 Mar 2009 06:53:25 GMT

Hi,

U can refer to my reply in the thread\

Also, the relevant tables are afko, afpo, aufk

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

GauthamV — Tue, 10 Mar 2009 06:57:15 GMT

Tables : AFKO,AFPO.

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

Former Member — Tue, 10 Mar 2009 07:12:42 GMT

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....