topic Re: Database Selections in Application Development and Automation Discussions

Database Selections

Former Member — Thu, 18 Jan 2007 21:46:56 GMT

can anybody help me to select data and write it to screen.

Objective:

To develop a simple ABAP Program to select data from Database Table.

Declarations

Tables: MARD.

Select-options: S_MATNR

Data: P_MATNR, P_WERKS, P_LGORT

Data: Define MAT_STR containing MATNR WERKS LGORT

Processing Flow

1. Select data from MARD into P_MATNR, P_WERKS, P_LGORT and write to screen

2. Select data from MARD into MAT_STR and write to screen

Thanks

Re: Database Selections

Former Member — Thu, 18 Jan 2007 21:50:03 GMT

Why don't you try writing the SELECTs yourself and post your code if you run into problems?

Rob

Re: Database Selections

Former Member — Thu, 18 Jan 2007 21:50:54 GMT

Hi,

select matnr werks lgort into correesponding fields of table mat_str

where matnr in s_matnr.

loop at mat_str.

write:/ mat_str-matnr,

mat_str-werks,

mat_str-lgort.

endloop.

Regards

Subramanian

Re: Database Selections

rahulkavuri — Thu, 18 Jan 2007 21:59:23 GMT

hi do u want to populate data in selection screen based on the values from MARD

ok try it this way

DATA: MAT_STR TYPE TABLE OF MARD WITH HEADER LINE.

" THIS WILL CREATE AN INTERNAL TABLE.

AT SELECTION-SCREEN OUTPUT.

SELECT MATNR

WERKS

LGORT

FROM MARD INTO (P_MATNR, P_WERKS, P_LGORT)

WHERE ( THIS DEPENDS ON UR CONDITION).

START-OF-SELECTION

SELECT * FROM MARD INTO TABLE MAT_STR.

END-OF-SELECTION.

LOOP AT MAT_STR.

WRITE:/ MAT_STR-MATNR, MAT_STR-WERKS.

ENDLOOP.

award points if found helpful