Problem in Inspection Type Display

[Former Member]

Hi,

I want to display the materials having Inspection Types.

I have written a query it is displaying Inspection Types...

Bt my problem is

if '100000' is the material code it is having 4-Inspection Types 01,02,03,04

in my report im getting only first Inspection type(i.e. 01) for all Materials....

Can anybody tell me wr im wrong?

Regards

Smitha

[Former Member]

Hi,

I want to display the materials having Inspection Types.

I have written a query it is displaying Inspection Types...

Bt my problem is

if '100000' is the material code it is having 4-Inspection Types 01,02,03,04

in my report im getting only first Inspection type(i.e. 01) for all Materials....

Can anybody tell me wr im wrong?

Regards

Smitha

[Former Member]

Hi

I think the problem is in your Select query.

You need to use FOR ALL ENTRIES while fecthing the Inspection types on the base of materials.

Paste your code so that anyone can find the problem.

Regards

Aditya

[Former Member]

Hi

this is my query

form GET_DATA .

SELECT MATNR

WERKS

FROM MARC

INTO CORRESPONDING FIELDS OF TABLE IT_FINAL

WHERE MATNR IN S_MATNR.

IF IT_FINAL[] IS NOT INITIAL.

SELECT ART

MATNR

FROM QMAT

INTO TABLE IT_QMAT

FOR ALL ENTRIES IN IT_FINAL

WHERE MATNR = IT_FINAL-MATNR.

ENDIF.

[Former Member]

Hi

If IT_QMAT is of type QMAT

try by writing into corresponding fields of table.

Regards

Aditya

[Former Member]

Hi Aditya

I tried as u told...

Its not coming...

Any other way is there?

[Former Member]

Hi,

Use all key fields in your field list is select query.

Check r u sorting based on key fields and deleting adjucent duplicates based on key field comparision.

if not do everything based on DB table key field wise.

i.e.

whenever u r quering the MARD table and sorting and deleting duplicates do it based on key fields

select MATNR
         WERKS
         LGORT from mard  where....

sort i_mard by
MATNR
WERKS
LGORT.

delete adj . duplicates comparing 
MATNR
WERKS
LGORT.

Regards,

Nandha