The database plays a key role in each SAP system, as it houses all the data Ultimately much more useful, spreadsheet. Thus, a database can be thought of as a much more complex, and Theīiggest difference between a database and a spreadsheet is simply that databasesĬan contain multiple tables that are connected to one another through Spreadsheet wherein columns (fields) store row after row of records (data). The basic structure of a database is quite similar to a Microsoft Excel Numbers-essentially an electronic version of a telephone book, which Use of a database program is to store names, addresses, and phone Records), the simplest form of data in the database. Within each of these fields exists rows (or Within this table is typically found three columns (or fields)-name,Īddress, and telephone number.

The telephoneīook can be considered a table, a storage container for information (see Figureģ.1). A classicĮxample of a database is a telephone book, which is organized alphabetically soĪs to make it possible to quickly find a desired piece of data. In the simplest form, a database is composed of tables, columns (calledįields), and rows (called records or data). Houses a collection of information organized in such a way that allows aĬomputer program to quickly find desired pieces of data. Sams Teach Yourself SAP in 24 Hours, 2nd EditionĪ database is essentially an electronic filing system that

Use of basic data structures