Day 3 — Transparent Table vs Structure

What is the difference between a Transparent Table and a Structure in SAP ABAP? How Interviewers Ask What is a Transparent Table? What is a Structure? What is the difference between a Table and a Structure? Have you created custom tables in your project? When do you use a Structure instead of a Table?

A Transparent Table stores data physically in the database. Whatever data is saved in the table is permanently stored and can be retrieved later. A Structure does not store any data. It is only used to group related fields together and define a format for data processing. In simple words, a Transparent Table stores data, whereas a Structure only holds field definitions.

Real-Time Project Scenario 1 In one project, the business wanted to maintain Vendor Bank Details. We created a custom transparent table called ZVENDOR_BANK. The table stored: Vendor Number Bank Account Number IFSC Code Bank Name Since the information needed to be saved permanently, we used a Transparent Table. Real-Time Project Scenario 2 While developing an ALV report, we needed to display data from multiple tables such as LFA1, EKKO, and EKPO. Instead of creating a database table, we created a Structure to hold all required fields temporarily. The Structure was used only during report execution and no data was stored permanently. Real-Time Project Scenario 3 For an OData service, we needed a response structure containing: Material Number Material Description Plant Stock Quantity Since this data was generated dynamically and not stored in the database, we used a Structure. --------------------------------------------------------------- Follow-Up Question Can a Structure store data? Interview Answer No. A Structure only defines fields and their properties. It does not store any data physically in the database. Follow-Up Question Can we perform SELECT statements on a Structure? Interview Answer No. Since Structures do not store data, we cannot perform database operations directly on them. Common Mistake Many candidates say Structures and Tables are the same. This is incorrect. A Table stores data physically. A Structure only defines the format of data. Interview Tip When answering this question, always mention a project example. For example: "In my project, I used Transparent Tables to store Vendor Master extension data and Structures to combine fields from multiple tables for ALV reporting." This answer shows practical experience.

What is a Transparent Table? What is a Structure? Can a Structure store data? Can we perform SELECT on a Structure? Where have you used Transparent Tables in your project? Where have you used Structures in your project?