table issue of Change document items

[cathy_liang]

Hello experts,

Please advise how to check the table cdpos based on a specific date. For example, want to see this table’s records for March 3, 2021.

The reason is the record count of cdpos in database increases fast recently. The record count is around 313069129. Or any other better way to know what has caused cdpos increasing faster, for example SD or which module, what kind of change document items?

[DominikTylczyn · Accepted solution]

Hello cathy.liang

You can report change documents in bulk with the RSSCD100 program, transaction RSSCD100 or S_ALR_87101238.

One of the possible culprit of a large number of sales order change documents might be sales order rescheduling (transaction V_V2) run on regular basis.

Best regards

Dominik Tylczynski

[cathy_liang · Accepted solution]

Hello Dominik,

Thanks for prompt advice. Very helpful.

[raymond_giuseppi]

Use first table CDHDR header which contains date/time field, then CDPOS if you actually require it. Also you get Object class, user and sometimes Transaction code.

Once you get the date/time, I would suggest you first go to SM37 to identify some background job/process.

NB: On a HANA system, CDPOS is no longuer a cluster table, so you can use a JOIN with CDPOS.

[cathy_liang]

Hello Raymond,

Thanks for prompt advice. Very helpful.