For All Entries Statement With Key Fields

For all entries statement does not bring “all entries” everytime. To get all data in tables, key fields must be used in select statement. You can see the differences between 2 select statements. The one  that without key fields returns 11 records, the one that with key fields returns 194 records even where conditions are the same. 

VBAP is the sales order item table which has sales order number and sales order item number as key fields. When we didn’t use key fields (vbeln,posnr) in select statement using “For All Entries In” doesn’t work properly. For this example we lose 183 records.

ABOUT Ekrem Güngörmez


comments powered by Disqus