Day 7 — Views in SAP ABAP

3Views

1Downloads

0Likes

0Comments

0Shares

Interview Question

1. What is a View in SAP ABAP? 2. Why do we use Views?

Answer

1. A View is used to combine data from one or more tables. 2. Views help users access related data without writing complex joins. 3. Views do not store data physically in the database. 4. They display data from underlying tables. 5. Common types of Views are: o Database View o Projection View o Maintenance View o Help View 6. Database Views are most commonly used in projects. 7. Easy Trick: View = Virtual Table created from one or more tables.

Real-Time Example

1. Suppose the business wants a report showing Sales Order and Customer details. 2. Sales Order Number is stored in VBAK. 3. Customer Name is stored in KNA1. 4. Instead of writing JOIN statements repeatedly, we create a Database View. 5. The View combines data from VBAK and KNA1. 6. Users can directly fetch data from the View. 7. This reduces coding effort and improves readability. 8. Example Data: Sales Order Customer Customer Name 50000123 100001 ABC Pvt Ltd 50000124 100002 XYZ Ltd 9. The View displays data from multiple tables in a single place. 10. No data is stored permanently in the View.