topic Display specified data by retrieving it from a particular database table. in Application Development and Automation Discussions

Display specified data by retrieving it from a particular database table.

Former Member — Wed, 24 Dec 2008 03:49:11 GMT

Hi friends, my database table consist of the followings: employee, department, position and salary.

I wanted to create a screen of displaying all the employees of a particular poistion in a particular department.( eg.: all managers in the Human Resource department.)

Table: department>position

The following is my current coding(i only manage to display screen but unable to retrieve the specificed data).

MODULE USER_COMMAND_0800 INPUT.

IF sy-ucomm = 'EXIT'.

LEAVE PROGRAM.

ELSEIF sy-ucomm = 'EXE'.

PERFORM set_memory.

SUBMIT z112_display.

ENDIF.

ENDMODULE.

FORM set_memory.

TABLES Z112_WORK2.

DATA: mem_DEPT(15) TYPE C.

mem_DEPT = Z112_WORK2-DEPT.

FREE MEMORY ID 'DEPT'.

EXPORT mem_DEPT TO MEMORY ID 'DEPT'.

ENDFORM.

Edited by: yingzi huang on Dec 24, 2008 4:54 AM

Re: Display specified data by retrieving it from a particular database table.

Former Member — Wed, 24 Dec 2008 04:14:27 GMT

Hi,

Looks like u r missing something.

You must be displaying this data on a Table Control based on the selection made on the selection Screen......Create an Internal Table of same structure as of Table Control and populate the same in the Program based on the selection Screen input.

In the PBO...simply populate the Table Control using Internal Table....

Re: Display specified data by retrieving it from a particular database table.

jayanthi_jayaraman — Wed, 24 Dec 2008 04:17:18 GMT

Hi,

If you want the data from memory, use import statement in PBO.

Re: Display specified data by retrieving it from a particular database table.

former_member194669 — Wed, 24 Dec 2008 04:22:17 GMT

What will be the code in z112_display ?

a®

Re: Display specified data by retrieving it from a particular database table.

Former Member — Wed, 24 Dec 2008 04:22:32 GMT

Hi Yingzi,

Try to use LEAVE TO LIST PROCESSING in the PAI. Use this if you are trying to display the output using a report program.

THank you,

Best Regards,

Shashikanth. D