Deleting obselete master and tarnsaction data

[Former Member]

Hi Experts,

We are on APO 7.0.

The question I had was regarding deletion of obselete master and transaction data.

We have obselete master data and transaction date residing in APO system as result of which the CIF process takes little longer.

Hence in order to delete obselete master/transaction data and hence improve the CIF effeciency,is there any standard master program which can be used?

If not,will the best approach be creating a custom "master" programm which will delete first all obsolete transaction data using standard programs like /sapapo/delete_PP_order ,/SAPAPO/RLCDELETE,/sapapo/sdorder_del,/sapapo/bp2 and /SAPAPO/DELETE_STOCK or std master data deletion program like /SAPAPO/PWBSRC2,/sapapo/scc03 and /sapapo/cull_rto_del.

How are other experts handlign this situation at their place?Any inputs will be highly appreicated.

Thanks.

[sourabh_jain66]

Hi SRM,

Use transection WUF in apo system, you should get to know what all linked data is there and you can delete the same data from there itself.

Best would be to check at location level.

Rgds

Sourabh

[Former Member]

Normally it is not recommended to deleted lot of master data through automated process chain setup; it is better to delete manually by running programs, for the benefit of control. Transaction data can be deleted by process chains.

[Former Member]

Hi,

You can try to delete obsolete change pointes in ECC and try to do CIF. Ask basis to delete old BALHEADER tables and BDCP2 tables extra..it'l improve CIF runtimes.

Thanks,

Chandra

[Former Member]

SRM,

There are lots of things that can slow down CIF transfers, but obsolete master and transactional data residing in APO are pretty low on the list.  High on the list is keeping the runtime version of the active Integration models consistent and up-to-date.  See the help doc about this subject at

http://help.sap.com/saphelp_scm70/helpdata/EN/81/21699c7a6a924d93f4f955c398fada/frameset.htm

General housekeeping tips for SCM can be found in the SCM Applications operations guide. 

http://service.sap.com/~sapidb/011000358700001365472009E

If you are not currently following all the recommended procedures today, you will surely see improvements in efficiency after you start to perform these tasks.

Also, many tips can be found in BP for solution management here:

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000725135&_SCENARIO=01100035870000000202&

Also, read and follow the instructions in note https://service.sap.com/sap/support/notes/563806

Actually, there are many other notes available concerning CIF performance, just search for them.

Deleting 'obsolete' data is not a trivial task.  You first need to identify EXACTLY which transactional data is to be considered as obsolete.  This normally involves asking the business people what their requirements are.  The decision of which Master Data to delete is even more critical.  Deleting the wrong Master data and you are up to your eyeballs in transaction failures.

There is a menu path on the standard SAP 7 menu APO > APO Admin > Reorganization.  In this menu area, you will find many transactions to reorganize existing data.  FYI, 'Reorganize' in SAP mostly means 'deleting unneeded data'.  Many of the transactions can be run in background, and committed to a regularly scheduled job if you are so inclined.

Best regards,

DB49