Database Tables in ABAP

 Client-dependent and client-independent table in ABAP

In SAP, highest level of organization structure is client. Whenever we login to SAP system, we login to a specific client. Data in the R/3 system is categorized as client dependent and client-independent.

Client dependent table:

Client dependent tables are always client-specific. These cannot be accessed from any other client.. First column of any client-dependent table is always client (type MANDT) by default and it's a primary key, this field contains the client no.

A client-dependent table may have different dataset for different clients.

Client independent table:

Client-independent table are cross-client i.e. independent of any client, so accessible from any other client and changes made in this table under one client, will be reflected in all the other clients. Hence, a client-independent table will always have same dataset for all clients.

Identifying the client dependent and independent tables:

Open the table DD02L in SE11 or SE16 and observe the field CLIDEP.

 

Type of Data Dictionary Tables:

  1. Transparent Table: One table in Data Dictionary will have a replica at database level called as transparent table. These tables are created by us.
  2. Pooled Table: Many small tables in Data Dictionary will be clubbed together into one table at database level called as pooled table. This is used to store customization data. These tables are provided by SAP.
  3. Cluster Table: Few large tables in Data Dictionary will be clubbed together into one table at database level called as cluster table. This is used to store primary key information. These tables are provided by SAP. Cluster tables cannot be buffered since they are very large tables.

Attributes in Table creation

  • Delivery Class: This controls the transport of table data for installation, upgrade, client copy and when transporting between customer systems.
  • Data browser / Table View Maintenance: Gives authorization to view, insert, update or delete rows of a table
  • Technical Settings: are required to improve the performance while the application server is interfacing with physical database.
  • Data class: Specifies in which physical area of the database should the table be stored
  • Size Category: Specifies about the number of records, the table can probably hold.
  • Domain: provides technical definition or attributes for a field. We cannot delete/change a domain that is being used by/assigned to data elements.
  • Data element: provides semantic attributes for a field in a specific business context. We cannot delete/change a data element that is being used by/assigned to table fields.

 Approaches for creating Tables

There are two approaches you can use when creating tables:

Bottom up

Top down

In the bottom-up approach, you can create the domains first, then the data elements, and then the table.

In the top-down approach, you can create the table first, and then create the data elements and domains as  you go along.

 

 

Comments

Post a Comment

Popular posts from this blog

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more