link between QALS and AFRU

[Former Member]

Hi,

Is there any link between AFRU and QALS tables?

The requirement is to get the scrap quantity from AFRU table to be displayed in QA32/ QA33. The only link found is the order.

But for the same order there are multiple entries in both AFRU and QALS (multiple confirmation counters and inspection lots).

How to link these two?

Auto goods receipt is active. But the material document field in AFRU is not getting updated. Is this field something different?

Thanks and Regards,

Raghu

[kim_tae_kuk]

select single b~rueck b~rmzhl

into....

from qals as a

inner join afru as b

on a~WERK = b-WERKS

and a~AUFNR = b~AUFNR

and a~MBLNR = b~WABLNR

and a~MJAHR = b~MYEAR

where a~prueflos = ....................

[former_member207609]

Hi,

Here is the relationship.

QALS-AUFNR = AFKO-AUFNR -> AFKO-AUFPL = AFVC-AUFPL -> AFVC-RUECK = AFRU-RUECK

AFVC-APLZL AFVC-RMZHL = AFRU-RMZHL

Hope this can make them clear.

[Former Member]

Hi,

Add scrap filed in Layout and save the layout. Whenever you will execute QA32 that time select the layout, so you can get inspection lot wise scrap qiantity.

Hope this will solved your problem.