Data Browser - SAP SD

The data browser allows you to search database tables and fetch stored records. To access the data browser, use the path SAP Menu > Tools > ABAP Workbench Over view >Data Browser (SE16), and enter the name of the table that you want to study.

The next screen contains selection parameters that can help you search for appropriate database records. the selection screen for order header table VBAK. If you know the sales order number, you can enter it in the Sales Document field on the selection screen. If, on the other hand, you do not know the order number, you can carry out a search based on any of the parameters listed. For example, you may want to find all the sales orders created on a specific date.

Data Browser: Selection Screen

Data Browser: Selection Screen

After entering the selection criteria, click the Execute button.SAP will fetch the database record and display it on the screen. The details of the record (in our example, order details such as order type, sales organization, distribution channel, division, net value, and so on) will appear.

Also note the Number Of Entries button on the selection screen. If you want to know how many records fit the selection criteria, click this button. It will give you the number of records found.

Another important field that controls the database search is Maximum Number Of Hits. If you enter a limiting value (say, 200) here, SAP will stop the search after finding the first 200 records. If the number of entries is high and you want to see all of them, make sure that your maximum number of hits is set to a higher number.
Data Browser: record display

Data Browser: record display
On the selection screen, you can change or add more selection parameters if the standard list does not meet your requirements. From the menu on the top of the screen, select SettingsFields For Selection. Then, from the list of fields, select the ones you need to be displayed as selection criteria.

You can use SettingsUser Parameters to control the display. This lets you choose to view the results in a standard list format or an ALV grid format. Also note the Keyword tab. Each field in the database table has a field label (a meaningf ul description) and a field name (a technical name). You can choose either mode of display.

To understand the difference between a field label and a field name, They both show records from table VBAK for the sales order 12369.you can see field labels such as Net Worth.you see the field name NETWR. This is the technical name for the net worth. The contents of the field are the same in both views.

User-Specific Settings for the Data Browser

User-Specific Settings for the Data Browser
Data Browser: display showing field names

Data Browser: display showing field names

You will need to be familiar with field names to communicate effectively with your technical team. Furthermore, if you ever need to create a custom enhancement in SAP, you will need all the technical information, such as table and field names.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP SD Topics