Display Database Content and Run SQL Queries

In ABAP Development Tools (ADT), open the database table snwd_so_inv_item by choosing Execute ABAP Development Object (or using Alt+F8). This will open the Data Preview which will allow you to explore the invoice items table.

Enter snwd_so_inv_item in the search field. Once the search has delivered a result or if the table is already in the history list, select SNWD_SO_INV_ITEM and choose OK.

In the Data Preview Click Select Columns to change which fields are retrieved from the database.

First click Deselect All. Only select the fields GROSS_AMOUNT and CURRENCY_CODE. Click OK to confirm your selection.

The Data Preview is refreshed accordingly.

Press Add Filter and choose CURRENCY_CODE.

Enter USD in the text field to filter the items that are in US dollars and press the Enter key.

The Data Preview is refreshed accordingly.

Click the SQL Console button to open the SQL Console.

The SQL Console shows the SELECT statement which was used to retrieve the data for the Data Preview. In the following steps you will adjust the SELECT statement to read the payment status of the order and the company name from the buyer.

Adjust the SELECT statement in SQL Console in order to get the payment status from the order header by doing the following: Add a JOIN condition for the table snwd_so_inv_head NOTE: You may get an error. You will solve this in the next step.

The FROM portion of the query should look like this:

SNWD_SO_INV_ITEM join SNWD_SO_INV_HEAD
on SNWD_SO_INV_ITEM~parent_key = SNWD_SO_INV_HEAD~node_key

Modify the WHERE clause to match the following:

SNWD_SO_INV_ITEM~CURRENCY_CODE = 'USD'

Add the field payment_status from the table snwd_so_inv_head to the SELECT list.

Click Run to execute the current query or press F8.

Check that the output on the right hand side contains the payment status.

Adjust the SELECT statement again in order to retrieve the company name from the table snwd_bpa by adding a JOIN condition for the table snwd_bpa.

join SNWD_BPA
on SNWD_SO_INV_HEAD~buyer_guid = SNWD_BPA~node_key

Add the field company_name from the table snwd_bpa to the SELECT list.

SNWD_BPA~company_name,
SNWD_SO_INV_ITEM~GROSS_AMOUNT,
SNWD_SO_INV_ITEM~CURRENCY_CODE,
SNWD_SO_INV_HEAD~PAYMENT_STATUS

Add an ORDER BY clause to sort the result by the company name of the buyer.

ORDER BY SNWD_BPA~company_name

Click Run to execute the current query or press F8.

Check that the output contains the company name. You will reuse this SELECT statement later for data retrieval in an ABAP class. So just leave the SQL Console open.