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.

 

 

What is Planning efficiency report in BW/BI?

The plan efficiency reports are needed plant wise, material wise to measure the efficiency of the planning. These are global reports whilst the information need to be collected at factory level. These reports will help a company to Continue reading “What is Planning efficiency report in BW/BI?”

How to give conditions in a BEx query designer

The query designer formulas sometimes involve if then else kind of conditions or case statement type of logic. These type of logic can be easily given in the query designer, however the procedure is little tricky as you cannot Continue reading “How to give conditions in a BEx query designer”

Process chain error due to # character in the file

While loading flat files on application server to BW targets via a process chain, the load to PSA may fail due to special characters in the file.

Thus the info package step itself will fail with Continue reading “Process chain error due to # character in the file”

When to use Navigational Attribute in SAP BW

Navigational attributes are discussed a lot of times in BW. They have an advantage as these attributes can be used for navigation in a query. However there are lot many more advantages of navigational attributes. I will discuss today one such scenario where navigational attributes has saved a week’s time. Continue reading “When to use Navigational Attribute in SAP BW”

When to use ‘Summation’ in a Standard DSO

While loading data to a standard DSO, a key figure can be updated as ‘Overwrite’ or ‘Summation’.

With an overwrite option, the previous value of the key figure which is already there in the active table of the DSO will be overwritten with the new value.

Whereas with the ‘Summation’ option, the values will be Continue reading “When to use ‘Summation’ in a Standard DSO”

How to update exchange rates via process chain in BW

The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain.

Include the step ‘Execute ABAP Program’ in the process chain.

Give the program name as Continue reading “How to update exchange rates via process chain in BW”

Currency Conversion from Local Currency to USD in BW

While loading the data from source to SAP BW system, the amount can be in local currency. If the user wants to see those amounts in USD in the BI reports, you can do the currency conversion either in the Continue reading “Currency Conversion from Local Currency to USD in BW”

ABAP routine for calculating AR buckets using master data look up

In Account receivables, there is a due date on which the outstanding amount has to be paid by the customer.

If the due date is passed and the customer has still not paid, the amount becomes overdue and bucket calculation starts Continue reading “ABAP routine for calculating AR buckets using master data look up”

DTP Performance Improvement: Semantic Groups

Semantic groups can be set in DTP in the extraction tab. These are the fields from the source which are available for selection as semantic keys.

capture

The BW system while doing the loads will Continue reading “DTP Performance Improvement: Semantic Groups”