Hi Experts,
I have a peculiar requirement. For an internal order, determine its FERC indicator.
If the FERC Indicator for the internal object is 0000, then read the settlement rules
of the object for the period(s) being processed and re-perform the logic for the FERC
Indicator not equal to 0000 for each object in the settlement rule.
If the FERC Indicator is 0000 again, keep drilling down through the settlement rules until
an object is obtained where the FERC Indicator is not 0000 or the settlement object is a cost center.
For the above requirement i need to get order data from AUFK first,
and check the FERC indicator. If it is 0000 i need to get settlement rule data
from COBRB table,in these settlement rule data i will get some more orders. Again i need to
hit AUFK. This is like recursive action and may hamper the performance .How can i do
this without writing a SELECT query in a loop and hitting the same tables several times.
Thanks,
Bhanu.
Edited by: bhanu23 on Nov 26, 2010 1:37 PM
Bluesky
