I'm working in SAP BW, I have created the folowing rountine in update rules.
SELECT * FROM /bic/azobadr0100
WHERE BA_1FTRAN = COMM_STRUCTURE-BA_1FTRAN
AND CALDAY = COMM_STRUCTURE-CALDAY.
result value of the routine
RESULT = /BIC/AZOBADR0100-BA_1EAD.
This routine select information of two tables.
The problem is: When I load the objets, it took me ten hours to finish it.
How can I improve it?"