Day 19 — FOR ALL ENTRIES

1. What is FOR ALL ENTRIES? 2. Why do we use FOR ALL ENTRIES?

1. FOR ALL ENTRIES is used to fetch related data using an Internal Table. 2. It reduces multiple database calls. 3. It improves program performance. 4. Always check that the Internal Table is not empty before using it. 5. It is commonly used instead of nested SELECT statements.

1. Fetch Sales Orders from VBAK into an Internal Table. 2. Use FOR ALL ENTRIES to fetch Sales Order Items from VBAP. 3. Match records using Sales Order Number. 4. Display Header and Item details together. 5. This reduces database access and improves performance.

1. What is FOR ALL ENTRIES? 2. Why do we use FOR ALL ENTRIES? 3. Why should we check if the Internal Table is empty? 4. Which statement can FOR ALL ENTRIES replace? 5. Give one real-time example.