What is the Database Management System in SAP
Basically SAP, an enterprise application is made up of programs together with the data used and formed by programs. The data are organized in a meaningful way within the database, making it easy for the programs to access and find the data necessary to do something useful like run a financial report or create a sales order. Both the programs as well as data exist in the same database in the case of an SAP component or products such as ECC. Normally each and every component has its own database a production system landscape composed of SAP ECC, SAP Business Warehouse (BW), and SAP Customer Relationship Management (CRM) consists of three production databases.
Database Structure:
Essentially database is an electronic filing system that houses a collection of information organized in such a way that allows a computer program to find preferred pieces of data in a rapid way. A database is composed of tables, columns (called fields), and rows (called records or data). The fundamental structure of a database is same as the Microsoft Excel spreadsheet wherein columns (fields) store row after row of records (data). The difference between a database and a spreadsheet is simply the databases that contain multiple tables are connected to one another through relationships.
Database structure is an alternative technical term that does not need to concern with you, but are important nonetheless. Structures are triggered and are very well defined in the ABAP/4 Data Dictionary and have only temporary data. The database plays a key role in each SAP system, as it houses all the data that are used by that SAP component or product specifically. Numerous brands of databases exist, making it easier for an IT shop to opt for a database vendor with which they are almost well-known. Moreover, it is imperative to note that not all database vendors and versions are supported by SAP. Rather it tends to stick with the market leaders, over the years adding and removing support for certain vendors.
Primary Key
Database tables in an RDBMS are obligatory to hold a unique field that distinguishes one particular record separately from others found in the database. This unique field is called a primary key and is composed of one or more fields that make each and every record in a database as a unique one.
Foreign Key
Use the primary key field in one table for linking it with another. The common link field in the other table is usually not the primary key in the other table: and is known as a foreign key.
Database Concepts:
The SAP system contains lots of types of constructs along with structures inside the R/3 Data Dictionary (DDIC). The majority of these constructs tend to be very technical.
Transparent Tables
SAP uses another concept called transparent tables, which are SAP database tables that contain only data at runtime. When a table is activated in the ABAP/4 Data Dictionary, a transparent table is created automatically in the database. This transparent table encloses the same name as your database table contained in the ABAP/4 Dictionary. Each of its fields contains the same names as their database counterparts though the sequence of the fields might get varied. This unstable field sequence makes it possible to insert new fields into the table without having to convert it, all of which pays a way for more rapid access to data during runtime.
About the Author
Did you find this article useful? For more useful tips and hints, points to ponder and keep in mind, techniques, and insights pertaining to credit card, do please browse for more information at our websites.
http://www.yoursgoogleincome.com
http://www.freeearningtip.com
Buffalo Bills - Are You Ready?!?!?!
|
|
Lot of 342 x 100% Original Dell 9W657 PC2-5300 667MHz DDR2 ECC 2GB Memory Dimms $8,999.99 |
|
|
Lot of 71x 4GB PC3-8500R DDR3-1066MHz ECC SERVER MEMORY $5,990.00 |
|
|
Lot of 99x 4GB PC3-10600R DDR3-1333MHz ECC SERVER MEMORY $5,790.00 |
|
|
LOT OF TEN 2GB MEMORY 256X72 168 PIN PC100 8NS 3.3V ECC REG SDRAM RAM DIMM $2,900.00 |
|
|
LOT OF TEN 2GB MEMORY 256X72 168 PIN PC133 6NS 3.3V ECC REG SDRAM RAM DIMM $2,900.00 |
|
|
Lot of 200 Samsung and other 1GB DDR Non-ECC Desktop memory $2,800.00 |
|
|
Lot of 600 pcs PC2-3200R 1GB DDR2, ECC, 400MHZ memories $1,990.00 |
|
|
Lot of 100 GENUINE HP 2GB PC2-5300F ECC REG Memory 398707-051 $1,795.95 |
|
|
Lot of 100 GENUINE HP Elpida 2GB PC2-5300F ECC REG Memory 398707-051 $1,795.95 |
|
|
Lot of 100 Samsung GENUINE HP 2GB PC2-5300F ECC REG Memory 398707-051 $1,795.95 |
|
|
Lot of 62x 2GB PC3-8500R DDR3-1066MHz ECC SERVER MEMORY $1,730.00 |
|
|
2GB PC2-5300F ECC MEMORY LOT OF 100 FOR DELL POWEREDGE 1950 $1,599.99 |
|
|
HP PROLIANT DL380 2GB PC2-5300F ECC MEMORY LOT OF 100 $1,599.99 |
|
|
2GB PC2-5300F ECC MEMORY LOT OF 100 FOR DELL POWEREDGE 2950 $1,599.99 |
|
|
HP PROLIANT DL360 2GB PC2-5300F ECC MEMORY LOT OF 100 $1,599.99 |
|
|
QIMONDA 2GB PC2-5300F ECC HYS72T256920HFA-3S LOT OF 100 $1,599.99 |
|
|
WHOLESALE LOT 300X 512MB DDR DESKTOP RAM. NON-ECC 512 MB DDR1 MEMORY USED TESTED $1,500.00 |
|
|
Huge LOT of (466) 512MB Sticks PC2700-PC3200 DDR Non-ECC Ram $1,499.00 |
|
|
Lot of 400 Samsung Kingston and other brand DDR 512MB Non-ECC Desktop memory $1,498.00 |
|
|
Lot 500 Samsung MT and other brand 1GB DDR Double-chip (36 ICs) ECC Server RAM $1,299.00 |
|
|
Lot 50 ATP 2GB PC3200 DDR ECC Reg Server Memory $1,249.95 |
|
|
LOT OF 100 1GB 2Rx8 PC2-3200E ECC NON REG MEMORY 73P3628 $1,200.00 |
|
|
WHOLESALE LOT 194X 512MB & 31x 1GB DDR DESKTOP RAM. NON-ECC 512 MB DDR1 MEMORY $1,200.00 |
|
|
1GB PC133 Server Memory SDRAM ECC 245PC LOT TESTED $1,200.00 |
|
|
Lot 150 SMART 1GB DDR2 PC2-3200 ECC Reg SB1287RDR2124351A Server Memory $1,195.95 |
|
|
Lot of 12x 8GB Hynix PC3-10600R DDR3-1333MHz ECC SERVER MEMORY hmt31gr7bfr4c-h9 $1,190.00 |
|
|
Lot of 4x NEW Elpida PC2-5300F 8GB memory, FBDIMM, ECC, REG, DDR2, 667MHz $1,149.00 |
|
|
Lot of 42x 2GB PC3-10600R DDR3-1333MHz ECC SERVER MEMORY $1,090.00 |
|
|
Lot of 960 Kingston Samsung and other 256MB DDR Non ECC Desktop memory $1,055.00 |
|
|
LOT OF 7 LAPTOP RAM DDR2 4GB 28GB DDR2 ECC $1,000.00 |
|
|
WHOLESALE LOT 270X 512MB DDR 1 ECC RAM. 512 MB DDR1 MEMORY USED TESTED $1,000.00 |
|
|
WHOLESALE LOT 112X 1GB DDR2 DESKTOP MEMORY MODULES. 112X 1 GB DDR 2 NON ECC RAM $1,000.00 |
|
|
Lot Of 140 512MB DDR2 400mhz PC2 3200R 512 MB RAM ECC $1,000.00 |
|
|
GENUINE HP 1GB PC2-5300F ECC FULLY BUFFERED MEMORY 398706-051 *LOT OF 100* $999.99 |
|
|
lot 417438-061 HP 24GB 12X 2GB PC2-5300e DDR2 ECC UNBUFFERED $999.99 |
|
|
Lot 180x 1GB DDR2 PC2-3200 REG ECC Server memory sticks $945.00 |
|
|
6N2P-EV / 12AX7 / ECC83 tubes. Lot of 500 pc. NOS/NIB. $849.99 |
|
|
Dell OEM 32GB 8x 4GB PC2-5300F ECC RAM Poweredge PE 1950 2950 DDR2 667 LOT ESXi $849.99 |
|
|
LOT HYNIX 100x1GB PC2 5300S DDR2 667MHz NON-ECC SODIMM LAPTOP NOTEBOOK HP DELL $848.00 |
|
|
WHOLESALE LOT 95X 1GB 133MHZ 133 MHZ ECC SERVER RAM MEMORY. TESTED PC133 SDRAM $800.00 |
|
|
LOT OF 30 Elpida 1GB EBD10RD4ABFA-7B ECC REG CL2.5 184 $800.00 |
|
|
Lots of 100 2GB Hynix Sun Server Memory PC2-5300P-555-12 ECC 667MHz $799.99 |
|
|
#52 LOT[100]: Micron MT18VDDF6472G-40BG3 PC3200 512MB DDR RAM ECC Server memory $789.99 |
|
|
LOT OF TEN 1GB SDRAM MEMORY RAM PC133 NON-ECC NON-REG $789.00 |
|
|
WHOLESALE LOT 78X 1GB ECC DDR RAM SERVER.1 GB DDR1 ECC MEMORY FOR SERVERS $780.00 |
|
|
LOT OF TEN 4GB DDR2 MEMORY RAM PC2-3200 NON-ECC DIMM $725.00 |
|
|
LOT OF TEN 4GB DDR2 MEMORY RAM PC2-4200 NON-ECC DIMM $725.00 |
|
|
LOT OF TEN 4GB DDR2 MEMORY RAM PC2-5300 NON-ECC DIMM $725.00 |
|
|
LOT OF TEN 4GB DDR2 MEMORY RAM PC2-6400 NON-ECC DIMM $725.00 |
|
|
Lot of 129 Micron Samsung 512MB PC133R 133MHz ECC Server Memory $700.00 |
