Finding tables used by transaction CM29

[former_member541603]

Hi guys,

I have to create a report with information from transaction CM29 (Planning table SAPPI_G001).

The report must list all orders scheduled for a resource (orders in the 'Resources' area) in a period. My problem is to find the tables where that transaction saves the information. I have used ST05, looked for functions and tried debugging, with no success, so through tables I cannot know when the order is in the 'Resources' area or when it is in the 'Pool' area.

Has anybody worked with it?

I would appreciate any help.

Thanks.

[Former Member]

Hi,

Please check the following tables:

crhd,

kbed,

kako,

einzkap,

afih,

afpo,

cyafvg,

cyauko,

iloa,

plaf,

pers,

sauf,

tj48,

cyfi2.

Hope this helps.

Thanks,

Srinivasa

[former_member541603]

Hi Srinivasa ,

Thanks for you help. Some of the tables you sent I have checked already, but could not find the information I need, however some other tables you sent are new for me, so I'll check those. Thanks a lot!

[Former Member]

Hi\

Do like this..

1. Go to se93 , give your Tcode CM29 and select display

2. Now go to Display Object List ( Control +Shift +F5 )

3. Navigate from Dictinary Objects --> Database tables u will get the list of tables.

Hope this helps .

Praveen.

[former_member541603]

Hi Praveen,

Thanks for the tip!

Actually I have done that in a different way, just getting the package name and typing it at se80. But all the tables listed are not usefull, they're all tables starting with 'T' (what I call tables with configuration data). That's because CM29 is not a 'normal' transaction (at least for me, this is the first time I work with it).

Thank you for your time.

[former_member541603]

Table KBED, field BSTKZ = 3 , indicates the order is taken up into the the planning tables.