clean data from ACDOCC table

[former_member453328]

Hi gurus:

Since I am implementing RTC and the table ACDOCC has some wrong records created while testing business rules, how can I clean all the transactional data from this table? I need to start from the scratch and also I need to have a way to clean this table to start my integration test.

PS: is there a way to execute Integrated Planning functions in RTC?

regards

Joseph

[lucas_costa3]

Hi Joseph,

Currently there is no house-keeping functionality built for ACDOCC. Therefore your option is pretty much build an ABAP program yourself.

Remember that it's not just ACDOCC, if you need to start over, consider clearing RTC_PULL_REQ and RTC_PR_LOCK

You can definitely run Planning Functions on top of the Consol cubes, but the clear package will not have effect in ACDOCC> and other tables above.

Cheers

[former_member453328]

hi all, thanks for the answers....is there any risk on cleaning all acdocc data? is the document number sequence going to be affected?

Regards

Joseph

[lucas_costa3]

Not if done properly. The number can be reset in RTCNR by changing the NR Status - Careful with this one - I'd recommend changing this only if you delete the whole model data.

[alan_valenzuela]

I used the transaction SE14 for clean de table ACDOCC, using RTC_PULL_REQ and RTC_PR_LOCK, but the data continuios in the tabla ACDOCC.

I am losting somes steps in the process?

[nitin_choudhari4]

2 Ways

1. You can create a simple program and delete data from ACDOCC if its just Prelim Version (Without data submit)

2. As mentioned in post above cleat RTC_PULL_REQ and RTC_PR_LOCK , if its FINAL version (With data submit)

[Former Member]

Hi Nitin,

Can you tell me the code for the program to delete data from ACDOCC if its just Prelim Version? I need to clear ACDOCC table with some wrong records.

Thanks.

Regards,