Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Selective Deletion in Infocube


Is selective deletion will be performance issue?

Our scenario is client want to see all data from sales (without billing), billing and delivery in one infocube...

Now, we are loading all the data in CUBE1.

CUBE1 contains:

- all billing data

- all sales w/o billing data

- all delivery w/o billing data

Now, since the sales w/o billing data is already uploaded in CUBE1. What if the sales w/o billing data has now billing data. This will cause duplicate in CUBE1. Now we are planning to have selective deletion to delete the sales data w/o billing IF it already has billing data uploaded in CUBE1. Is this possible?

If VBAP-SALESNO. (without billing) = VBRP-SALESNO. (with billing)

     DELETE VBAP-SALESNO. (wihtout billing) line item.

This is just our initial plan in mind, and of course, this will be done by an abaper. But we just wanted to check if this is possible enough to avoid duplciation.

This will be the same for delivery.


Former Member
Not what you were looking for? View more on this topic or Ask a question