Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FOR ALL ENTRIES not working?

Hi.

I have the following Query:--

  • internal table to get the INOB values

Data: begin of lit_inob occurs 0,

cuobj like inob-cuobj,

objek like inob-objek,

end of lit_inob.

  • internal table to get the AUSP values

Data: begin of lit_ausp occurs 0,

atwrt like ausp-atwrt,

end of lit_ausp.

  • internal table for data type conversion

Data: begin of lit_inob1 occurs 0,

objek like ausp-objek, "for AUSP

end of lit_inob1.

Select cuobj "OBJECT KEY

objek "MATERIAL NUMBER

from inob into table lit_inob

where objek = '000000000013222869' and klart = 'Z01'.

if sy-subrc = 0.

***to convert data type.

Loop at lit_inob.

move lit_inob-cuobj to lit_inob1-objek.

append lit_inob1.

clear lit_inob1.

Endloop.

select atwrt "Characteristic value

into table lit_ausp from ausp

for all entries in lit_inob1

where objek = lit_inob1-objek

and atinn = 'C02000' "used for material category

and klart = 'Z01'

and atwrt ne '00001'.

endif.

The sy-subrc should be 0. but its not in my case.

I couldnt understand where I am wrong.

Kindly provide me with solution.

Thanks

Tags:
Not what you were looking for? View more on this topic or Ask a question