Tag: key fields

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 (
Read More »