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