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
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
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
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.
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)
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,