table name for action log

[Former Member]

Dear All,

Can anyone please tell in which table data of action logs for maintenance orders,purchase

requisition,maintenance plan with maintenance item stores? please note that in SPRO ,change

documents for maintenance plans is not flagged.Even though is it possible to view changes at

table level for maintenace plan & item.For other document type, the check box for change

document is flagged.

I need these tables name to pull both new & old value for any changes of a field for the

maintenance order,purchange requisiotion,maintenance plan or maintenace item.

Thanks in advance.

Rgds

Rajib

[peter_atkin]

Since many of the Action Log values are status driven - have a look at table JCDS (status changes)

PeteA

[former_member220863]

Hi,

Please check table CDPOS for the same. You can check the entries based on OBJECTCLAS or OBJECTID.

For ex: if u want to check changes for order then pass ORDER as Objectclas.

Thanks,

Sunil

[Former Member]

Hi Sunil,

Thanks for your response.But in table CDPOS ,I am entering maintenace order no in field

OBJECTCLAS or in other field also OBJECTID,sytem is throughing message as no values found.

Even I have tried by entering the order no in field OBJECTID .But same result.While from front

screen in IW33 following menu path extras-action log , changes are reflecting.Can

you please tell where I am doing mistake?

Also what about change document in maintenace plan/item as in SPRO change documents check box

are not flagged.Is it possible to get the change document in CDPOS table even though in SPRO

it is not maintained.

Thanks in advance

Rgds

Rajib

[former_member187991]

hi

CDPOS table only gets updated when the change document is marked . i think it is not possible to get the values. check with technical team on this

regards

thyagarajan

[former_member220863]

Hi,

Pass the text ORDER in Objectclas field not the order no.

Thanks,

Sunil

[Former Member]

Hi

Thanks for your quick response.I need to find out the changes by object specific such as maintenace order no wise.Suppose, in a order, initialy main work center is X , later on it is chnaged to Y.So ,from the table I need to find out the changes both old & new value for this order .Please suggest how & from which table I can find out.

regards,

rajib

[Former Member]

Hi

Thanks for your quick response.I need to find out the changes by object specific such as maintenace order no wise.Suppose, in a order, initialy main work center is X , later on it is chnaged to Y.So ,from the table I need to find out the changes both old & new value for this order .Please suggest how & from which table I can find out.

Also in case change document is not marked for maintenance plan in SPRO, from which table I can find out the changes happened in maintenance plan.

regards,

rajib