questions

[Former Member]

hello all,

i need some assignments in report program , actually i m learniNG ABAP .I NEED MUCH PRACTICE OVER THAT

[Former Member]

Hi,

Check this link.

http://www.erpgenie.com/abap/example_code.htm

http://abapprogramming.blogspot.com/2007/03/abap-assignment.html

Reward if helpful.

Regards,

Ramya

[Former Member]

Hi...

Ok very gud ...so how do I send...

regards

sg

[Former Member]

Hi,

here are some assignments for starting of report.

*ASSIGNMENT 1*

*============*

Create the following Report with the following options,

Selection Screen Should contain:-

=================================

1.Sales Order No (Multiple)

2.Material No (Multiple)

3.Option to select either of the above two inputs,

Process by sales order

(ii) Process by Material No

Logic:-

=======

If 1st option is selected then input should be accepted for sales order no.

On the basis of this no. corresponding records should be extracted from

VBAK & VBAP and the following fields should be displayed. Displayed Records

should be grouped according to VBELN. Also the summation of the NETWR field

should be done and the total should be dislayed for each group below NETWR field.

If 2nd option is selected then input should be accepted for MATNR. On the basis

of this no. corressponding records should be extracted from VBAP & VBAK and the

following fields should be displayed. Displayed Records should be grouped

according to MATNR. Also the summation of the NETWR field should be done and

the total should be dislayed for each group below NETWR field.

VBAK Fields

===========

vbeln "Sales Document

erdat "Date on which the record was created

erzet "Entry time

ernam "Name of Person who Created the Object

audat "Document date (date received/sent)

vbtyp "SD document category

VBAP Fields

===========

vbeln "Sales Document

posnr "Sales Document Item

matnr "Material Number

matkl "Material Group

netwr "Net value of the order item in document currency

prodh "Product hierarchy

aufnr "Order Number

Important Points

================

Display Report in a suitable format.

Make use of lines, symbols, icons & Colors.

At the footer Display Username & Page no.

Display the header per page.

***********************CODE OF STATIC HEADER************

*initialization.

• sy-tvar0 = sy-uname.

• sy-tvar1 = sy-uzeit.

• sy-tvar2 = sy-datum.

**********************************************************

Extend the assignment with 1 following conditios :-

1. In the o/p list i.e. basic list when the user cicks on any MATNR (Material no.)

irrespective of check box then material no. details must be extracted from MARA (Material Master table)

Followings are the field

MATNR

MAKTX (To be fetched from text table of material)

ERSDA

ERNAM

MTART

MBRSH

MATKL

MEINS

BRGEW sum

VOLUM sum

KUNNR

2. From above secondary list, in order to display the details of the competitor.

execute the transation XD03 when user clicks on KUNNR field

Imp points.

Modularise your code by usinng subroutines

Display respective headers

ASSIGNMENT 2

=============

Extend the Assignment 1 with following additions,

1. In the o/p list i.e basic list, when the user clicks on any MATNR (Material No.)

irrespective of check box then material details will be extracted from MARA.

Following are the fields:-

MARA Fields

===========

MATNR

MAKTX ( To be fetched from Text table of material)

ERSDA

ERNAM

MTART

MBRSH

MATKL

MEINS

BRGEW

VOLUM

KUNNR

2. From the above secondary list, execute the transaction XD03 when the user clicks

on KUNNR field in order to display the details of the Competitor.

Important Points

================

Modularize your code by using subroutines.

Display respective headers for respective lists.

Rest of the things same as assignment 1.

ASSIGNMENT 3

=============

Create the following Report with the following options,

Selection Screen Should contain:-

=================================

1.Purchase Order No (Multiple)

2.Material No (Multiple)

3.Option to select either of the above two inputs,

Fetch purchase order data

(ii) Fetch Material data

4.Push Buttons to select Summary report & Detail report.

Logic:-

=======

If 1st option is selected then input should be accepted for purchase order no.

On the basis of this no. corresponding records should be extracted from

EKKO & EKPO and the following fields should be displayed. Displayed Records

should be grouped according to EBELN. Also the summation of the KTMNG & Menge field

should be done. Displayed Records should contain a checkbox for multiple selection.

Basic list also contain one button 'Display'.

EKKO fields

===========

EBELN

BUKRS

BSTYP

BSART

AEDAT

ERNAM

LIFNR

ADRNR

EKPO fields

===========

EBELN

EBELP

MATNR

WERKS

LGORT

KTMNG

MENGE

MEINS

If the user clicks on lifnr then transaction code 'XK03' will be called.

If the user selects the purchase order by selecting checkbox and clicks on Display

then scheduling data from EKET should be dispalyed.

EKET fields

===========

EBELN

EBELP

ETENR

MENGE

BANFN

CHARG

If 2nd option is selected then input should be accepted for MATNR. On the basis

of this no. corressponding records should be extracted from MARA and the

following fields should be displayed. Displayed Records should contain a checkbox

for multiple selection.

MARA fields

===========

MATNR

MAKTX ( To be taken from MAKT table)

ERNAM

MTART

MBRSH

MATKL

BISMT

MEINS

BRGEW

NTGEW

GEWEI

VOLUM

VOLEH

PRDHA

So, the above fields will be displayed in the basic list. In the list, there should be

3 buttons ( Sales Data, Stock Data, Plant data).

If the user clicks on Sales Data button,then these fields will get displayed in the

secondary list from table MVKE.

MVKE fields

===========

MATNR

VKORG

VTWEG

AUMNG

LFMNG

EFMNG

Last 3 fields should display the summation results on the basis of 1st 3 fields. Group

according to matnr.

If the user clicks on Stock Data button,then these fields will get displayed in the

secondary list from table MARD.

MARD fields

===========

MATNR

WERKS

LGORT

Group according to matnr.

If the user clicks on Plant Data button,then these fields will get displayed in the

secondary list from table MARC.

MARC fields

===========

MATNR

WERKS

BWTTY

XCHAR

MMSTA

MMSTD

MAABC

Group according to matnr.

Important Points

================

1. Display Report in a suitable format.

2. Make use of lines, symbols, icons & Colors.

3. At the footer Display Username & Page no.

4. Display the header per page.

5. Use Text elements.

6. Back,Cancel & Exit button should be there.

7. Inner join should be implemented between Ekko & Ekpo as a part of the Function module.

8. No more inner joins.

9.NO SECONDARY LISTS FOR SUMMARY REPORT .

Please reward if useful.