Remove test data uit Customer Checkout Manager

[rdijkhuizen]

I have a test environment for customer checkout manager, but I want to remove all test data. In CCO it self that is no problemen. In CCO monitor is also possible, however in CCOm (customer checkout manager) it is not possible in an easy way. If I want to remove this data I need to reconfigure the manager. See KB note 2716022.

Has someone else an idea to remove this data? So I don't need to reconfigure the whole thing again.

I also created an issue in the influence zone.

https://launchpad.support.sap.com/#/notes/2716022

[Former Member]

Dear ronald_dijkhuizen ,

thanks for your effort.

I am personally not so deep into development, so unfortunately I cannot help with your question.

But I can share the experience that we always have two tier landscape: a) test environment b) productive environment. So we are sure even if tables are modified with patchlevels, we are on the safe side with the customer within an implementation project.

Have a good day,

Julian

[rdijkhuizen]

For this issue I created a SQL-script to remove the data. However I am not yet sure if I removed all data with this script and if perhaps too much data is removed. Can someone who take a look at this script? Perhaps it is usefull for the community.

Because of some foreign keys on Receipt and debtor item I need to remove 1 of these keys and place it back later.

delete from ccocs.[ACCOUNTRECEIPT]
delete from ccocs.[ASYNCQUEUEENTRY]
delete from ccocs.[ASYNCQUEUEPARAM]
delete from ccocs.[ASYNCQUEUERESULT]
delete from ccocs.[AUDIT_LOG_ATTRIBUTE]
delete from ccocs.[AUDIT_LOG] 
delete from ccocs.[DRAWERDETAILS]
delete from ccocs.[CLOSINGASSETENTITY]
delete from ccocs.[HISTORYITEM]
delete from ccocs.[MONITORINGADDITIONALOPTIONENTRY]
delete from ccocs.[MONITORINGENTRY]
delete from ccocs.[PASSWORDRESETATTEMPT]
delete from ccocs.[PAYMENTITEM]
delete from ccocs.[PAYMENT_ITEM_METADATA]
delete from ccocs.[PRICEELEMENT]
delete from ccocs.[SALESITEM]
delete from ccocs.[SALES_ITEM_METADATA]
delete from ccocs.[MATERIAL]
delete from ccocs.[LOYALTY_PAYMENT]
delete from ccocs.[SEQUENCE_NUMBER_CONSUMER]
delete from ccocs.[TAXITEM]
delete from ccocs.[TIMERECORD]
delete from ccocs.[USER_IDENTITIES]
delete from ccocs.[VOUCHERLOYALTYACCOUNT]
delete from ccocs.[USERDATA]
delete from ccocs.[VOUCHERLOYALTYITEM]
ALTER TABLE [CCOCS].[DEBTORITEM] DROP CONSTRAINT [FK_DEBTORITEM_rcpt_key]
GO
delete from ccocs.[RECEIPT]
delete from ccocs.[RECEIPT_METADATA]
delete from ccocs.[DEBTORITEM]
delete from ccocs.[DEBTOR_ITEM_METADATA]
delete from ccocs.[BUSINESSPARTNER]
delete from ccocs.[CASHDESKCLOSING]
delete from ccocs.[CUSTOMERDATA]
ALTER TABLE [CCOCS].[DEBTORITEM]  WITH CHECK ADD  CONSTRAINT [FK_DEBTORITEM_rcpt_key] FOREIGN KEY([rcpt_key])
REFERENCES [CCOCS].[RECEIPT] ([OBJECTKEY])
GO
ALTER TABLE [CCOCS].[DEBTORITEM] CHECK CONSTRAINT [FK_DEBTORITEM_rcpt_key]
GO