If your job is to write ABAP programs/ reports you need to familiarize yourself with various functionalities of SAP. The SAP Sales and Distribution module (SD) allows you to create a Sales order. As an ABAPer you need to know at least the basics of Sales order creation. The transaction for creating a sales order is VA01, to Edit Sales order is VA02 and just to display a sales order is VA03. In case you are unable to create a sales order you can play around with an existing one in the development server. First open the sales order in the display mode and understand the fields that need to be extracted. Make a note of the tables.
In this program we will display the sales order header data.Following fields will be displayed
- Sales Order number
- Sold to party number
- Ship to party
- Buyer
- Net Value
- Payment Terms
Focus
1) Retrieve the data from the SAP database using the SELECT statement and the WHERE clause
2) Selecting SINGLE rows
3) Using SELECT-OPTIONS
4) Displaying data from tables using SE11
5) Using TEXT ELEMENTS
6) Data Declaration
7) Table Declaration
8) Using the WRITE statement
9) Using the debugger
10) Using double click to display the table
Tables used
VBAK Sales Document Header Data
VBPA Sales Document Partner
VBKD Sales Document Business Data
To get help on any of the statements in SAP, move the cursor on the statement and press F1
Fully Functional Sample Code for the Program.
****************************************************************************************************
*ABAP Report to display Sales Order Data
****************************************************************************************************
REPORT ZEXERCISE_1 .
Tables: VBAK, " Sales Document: Header Data
VBPA, " Sales Document: Partner
VBKD. " Sales Document: Business Data
data: d_soldto(10),
d_shipto(10),
d_buyer(10),
d_billto(10).
Select-options: S_VBELN for vbak-vbeln.
Select vbeln
netwr
waerk into (vbak-vbeln, vbak-netwr, vbak-waerk) from vbak where
vbeln in s_VBELN.
endselect.
select single kunnr
into d_buyer from vbpa where parvw = 'BU' or parvw = 'RE' and
vbeln = S_VBELN-LOW.
select single kunnr
into d_billto from vbpa where parvw = 'BP' or parvw = 'WE' and
vbeln = S_VBELN-low.
select single kunnr
into d_soldto from vbpa where parvw = 'SP' or parvw = 'AG' and
vbeln = S_VBELN-low .
select single kunnr
into d_shipto from vbpa where parvw = 'SH' and
vbeln = S_VBELN-low .
write:/ vbak-vbeln, d_buyer, vbak-netwr, d_billto, d_soldto, d_shipto,
vbak-waerk.
******************************************************************************************