Day 18 — COLLECT Statement

1. What is the COLLECT statement? 2. Why do we use COLLECT?

1. COLLECT is used to remove duplicate key values. 2. It automatically adds numeric fields for duplicate keys. 3. It is mainly used for summarizing data. 4. It reduces manual coding for total calculations. 5. It improves report development.

1. Customer sales data is fetched into an Internal Table. 2. Multiple records exist for the same customer. 3. COLLECT combines duplicate customer records. 4. Sales Amount is automatically added. 5. The report displays total sales for each customer.

1. What is COLLECT? 2. Why do we use COLLECT? 3. What happens when duplicate keys exist?