Note for Moderator ( This is not practice question and I have done enough search before posting this, The first table represents PO and second one its Line Items. If we have to close PO than we need to check delivery completed indicator whether all of them has status closed or not). Secondly I am not abap developer and need logical help in writing End routine in BW. Please do not remove this post.
I have one internal table with empty column E
A C D E
1001 John MMM
2001 Tom PPP
I have another internal table that has value x in column E
A B E
1001 10 x
1001 20 0
1001 30 x
2001 20 x
2001 30 x
My Requirement is to match key column A of table2 with table1and put value 1 in column E of table 1 in case all the values in column E of Table 2 are x otherwise put 0.
final output of table 1 should be
A C D E
1001 John MMM 0
2001 Tom PPP 1
Please suggest, any suggestion will be highly appreciated.