Prev Next

SAP / SAP Beginner (0 2 yrs) Interview questions

What is the difference between an internal table and a database table?

A database table stores data persistently on disk, managed by the underlying database and shared across every program and user that accesses it. An internal table exists only in memory, scoped to a single running program, and disappears once that program ends (or the variable is cleared).

Database TableInternal Table
Persistent, stored on disk.Temporary, exists only in memory during program execution.
Shared across programs/users.Local to the program that declared it.
Defined in the ABAP Data Dictionary.Defined within the ABAP program itself.
Accessed via Open SQL statements.Accessed via ABAP statements like LOOP, READ TABLE.

A typical program pattern is reading data from a database table into an internal table, processing it in memory (which is much faster than repeatedly querying the database), and then optionally writing results back to the database afterward.

Where does a database table's data persist?
Why is it common to read data into an internal table before processing it?

Invest now in Acorns!!! 🚀 Join Acorns and get your $5 bonus!
Acorns Logo

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Earn passively and while sleeping

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Robinhood Logo

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.


Webull Logo

Webull! Receive free stock by signing up using the link: Webull signup.

More Related questions...

What is SAP? What does ERP stand for and what is its purpose? What are the different SAP modules? What is SAP R/3? What is SAP S/4HANA? What is a client in SAP terminology? What is a transaction code (T-code) in SAP? What is the SAP GUI? What is the 3-tier architecture in SAP? What is the presentation layer in SAP's 3-tier architecture? What is the application layer in SAP's 3-tier architecture? What is the database layer in SAP's 3-tier architecture? What are the advantages of a 3-tier architecture? What is a work process in the SAP application server? What is ABAP? What is the difference between ABAP and ABAP Objects? What are the data types in ABAP? What is an internal table in ABAP? What is a structure in ABAP? What is a work area in ABAP? What is the difference between an internal table and a database table? What are the types of internal tables in ABAP? What is a function module in ABAP? What is a BAPI? What is a report program in ABAP? What is a module pool program in ABAP? What are events in ABAP reporting (e.g., START-OF-SELECTION)? What is a selection screen in ABAP? What is Open SQL in ABAP? What is the difference between Open SQL and Native SQL? How do you retrieve data from a database table using Open SQL? What is the SELECT-OPTIONS statement used for? What is a foreign key in SAP table definitions? What is a check table in SAP? What is the difference between a transparent table and a pooled table? What is a data dictionary (DDIC) in SAP? What is the ABAP debugger used for? How do you set a breakpoint in ABAP? What is the difference between a session breakpoint and a watchpoint? What is an external (dynamic) breakpoint in ABAP debugging? How do you inspect variable values during debugging in ABAP? What is the difference between a static breakpoint (BREAK-POINT statement) and a dynamic breakpoint? What is the Waterfall model in software project methodology? What is Agile methodology? What is the difference between Waterfall and Agile approaches? What is a sprint in Agile methodology? What is SAP ASAP methodology? What are the typical phases of a Waterfall-based SAP implementation project?
Show more question and Answers...

#

Comments & Discussions