CTM performance - SAPAPO/CTMMAP table

[Former Member]

Hi All,

CTM run takes too long time. We were told by OSS that SAPAPO/CTMMAP table is too big, around 11million entries, and we should index it.

Is there anybody who knows what this table is and who has an idea on how to reduce the number of entries in that table?

Thanks in advance,

Regards,

Claire

[Former Member]

Hi Claire,

Refer SAP note 375174 which best explains your scenario.

Please let me know whether this helps you.

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi,

We also have same problem. We deleted entries in CTMMAP table with the program given in the note. However, while copying/deleting planning version system tries to read this table and it takes long time although there is 0 entry in table. Should we create index for this table?

Regarding CTM performance, when CTM runs, it spends too much time while running DB procedure APS_ORDER_GET_DATA. Is there a way we can minimize this time?

Thanks and regards,

Jenny