Get settlement data for an order - Recursive

Former Member — Fri, 26 Nov 2010 12:36:48 GMT

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

Re: Get settlement data for an order - Recursive

Former Member — Sat, 04 Jan 2014 09:36:00 GMT

Did you find the solution?