topic Re: question on performance issue with AFRU table in Application Development and Automation Discussions

question on performance issue with AFRU table

Former Member — Wed, 19 Oct 2016 09:08:52 GMT

Hi Experts,

I need to get the posting date ( BUDAT) from AFRU table, based on production order nos (AUFNR) field . If I fetch data from AFRU table based on AUFNR ( prod order nos) its taking a lot of time as the we are fetching data based on non key fields.

I know we can use index , but is there any other way that we can get RUECK (completion confirmation number from any table ) and then get the data from AFRU table based on RUECK and AUFNR .

please suggest.

Thanks,

Re: question on performance issue with AFRU table

SimoneMilesi — Wed, 19 Oct 2016 09:17:30 GMT

Hi Ramya,

As general rule, you can check where the data element is used and investigate a bit the DB tables

To find any possible link.

Sometimes is easy and intuitive, sometimes not so easy but it's always the best way.

Other option: check if your DB table is used in any view 🙂

Re: question on performance issue with AFRU table

former_member196331 — Wed, 19 Oct 2016 09:23:30 GMT

Need Some clarification.You said.

its taking a lot of time as the we are fetching data based on non key fields.

A row contains Non key fields. and Key fields also.

Instead of using non key fields. use key fields.

Example:

key1 key2 Nonkey

1 a s1

2 b s12

3 c s13

May be you written the query like

select from table where nonkey field eq 's12'

I am suggesting that

select from table where key field eq '2'

Hope you understood.If you use key field also some time data is very slow.

Re: question on performance issue with AFRU table

Former Member — Wed, 19 Oct 2016 09:29:50 GMT

Hi RG,

You can take the field RUECK from AFKO along with AUFNR. Also, you can try FM "CO_OCM_FA_AFRU_DATA_GET".

Regards

Raj

Re: question on performance issue with AFRU table

Former Member — Wed, 19 Oct 2016 09:55:58 GMT

Thanks for your answer .. it worked..

🙂

Re: question on performance issue with AFRU table

Former Member — Wed, 19 Oct 2016 09:56:31 GMT

Thanks for ur replies

Re: question on performance issue with AFRU table

RaymondGiuseppi — Wed, 19 Oct 2016 09:58:54 GMT

Did you try a JOIN like

SELECT * INTO CORRESPONDING FIELDS OF TABLE itab
FROM afko
JOIN afvc
 ON  afvc~aufpl EQ afko~aufpl
JOIN afru
 ON  afru~rueck EQ afvc~rueck
 AND afru~rmzhl EQ afvc~rmzhl
WHERE afko~aufnr IN range_aufnr.

Regards,
Raymond

Re: question on performance issue with AFRU table

Former Member — Wed, 19 Oct 2016 16:19:21 GMT

Hi raymond,

Thanks for your reply, I think basically we are fetching data from AFKO table but we need to fetch data from AFRU table is what I needed.

Thanks,

Re: question on performance issue with AFRU table

RaymondGiuseppi — Thu, 20 Oct 2016 10:35:12 GMT

If you want to get the feeling of reading AFRU, try this syntax:

SELECT * INTO CORRESPONDING FIELDS OF TABLE itab
  FROM afru
  WHERE EXISTS (
    SELECT *
    FROM  afvc
    JOIN  afko
      ON  afko~aufpl EQ afvc~aufpl
    WHERE afvc~rueck EQ afru~rueck
      AND afvc~rmzhl EQ afru~rmzhl
      AND afko~aufnr IN range_aufnr ).

Regards,
Raymond

Re: question on performance issue with AFRU table

Arhum — Thu, 12 Dec 2024 16:37:03 GMT

Hi Ramya,

can you please tell me how you get to this. Means how we can view diff. tablein which the field exist , how to view this in the system.