Skip to Content
0

clean data from ACDOCC table

Oct 17, 2017 at 06:15 AM

213

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lucas Costa Oct 17, 2017 at 08:19 AM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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.

0
avatar image
Former Member Oct 17, 2017 at 06:01 PM
0

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)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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,

0