topic Re: Extract statement - Run time error in Application Development and Automation Discussions

Extract statement - Run time error

Former Member — Thu, 26 Oct 2006 13:43:26 GMT

Hello All,

I have used EXTRACT statement for a field group, after the INSERT statement in a Pre-FM in SXDA. During the first run of SXDA processing, everything works fine. But, if i execute the SXDA for one more run ( without executing the transaction once again or refreshing the SXDA transaction), the run results in Run time errors.

The two types of errors are basic errors for EXTRACT statement:

INSERT_INTO_LOCKED_FIELD_GROUP and

EXTRACT_AFTER_SORT/LOOP

I have tried refreshing the field group at the start of function module. But, it still gives the same errors, during the second run.

Is it mandatory to refresh the SXDA transaction for every run if we use EXTRACT statement or is there any other procedure to skip these errors.

Any help in this regard would be helpful.

Thanks and Regards,

Pavan

Re: Extract statement - Run time error

venkata_ramisetti — Thu, 26 Oct 2006 13:55:26 GMT

Hi,

can you paste your code here?

Thanks,

Ramakrishna

Re: Extract statement - Run time error

Former Member — Fri, 15 Feb 2008 17:47:06 GMT

SXDA needs to be refreshed all the time.

Re: Extract statement - Run time error

Former Member — Mon, 14 Jun 2010 12:03:56 GMT

Hi Pavan, How did you fresh the sxda tcode? I am facing the same problem, but I am still finding ways to refresh the field groups, but still not successful. Can you share some ideas? Thanks in advance.