Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Add flag in sap query based on existence of status in another table

former_member597211
Discoverer
0 Kudos

halo,

I have been trying using sap query to add column that has x flag if there is certain value in another table, for each record in affh-aufpl i need to know if there is jest-stat = 'e0003' (tables connet with objnr).

basiclly - show me all the rows for AFFH and tell me if there is active E0003 status in JEST.

I tried to use code to filter all the other status in sq02 and in sq01 whike set JEST as left join, didnt work.

Any ideas?

Thx.

  • SAP Managed Tags:
0 REPLIES 0