Displaying the captured data

[Former Member]

Hi Friends,

I need to select single record from the database based on the ponumber. I also need the display the values captured from the database in the internal table on the screen (input fields).

Regards,

Line

[sreeramkumar_madisetty]

Hi

Use Select single/Upto opne rows to fetch.

Using write you can display the captured data.

Regards,

Sree

[Former Member]

HI,

Use SELECT SINGLE * UPTO 1 ROWS.

TO FILL THIS DATA SELECTED INTO AN INTERNAL TABLE create an Internal table with same field those u want to select and then use like

SELECT SINGLE * FROM <table name> INTO TABLE <INTERNAL TABLE NAME> UPTO 1 ROWS.

reward if useful.

Regards,

Harsha

[Former Member]

Hello,

First create a screen with all the fields. EKKO fields.

In the PBO of the screen create a module DISPLAY_DATA.

IN MODULE DISPLAY_DATA.
select single * from EKKO where ebeln = 'XXX'.
ENDMODULE.

This will display the data in the screen.

Regards,

Vasanth

[Former Member]

I would like to add something to what my friend has said above.

Give the field names as that of the internal table fields

like if u want to display ekko-ebeln and ekko-bukrs which u r fetching into

itab-ebeln and itab-bukrs, give the screen field name as itab-ebeln and itab-bukrs. Then proceed as what has been said above.

reward if useful

[Former Member]

Hi Friends,

This is my select querry I need to send the values capture to the screen fields,

SELECT * FROM zpo_input INTO TABLE itab WHERE ponumber EQ

zpo_input-ponumber.

the screen fields are

zpo_input-PONUMBER

zpo_input-INV_NO

zpo_input-VENDOR_NO

zpo_input-PODATE

zpo_input-POAMOUNT

zpo_input-TYPEOFMAT

zpo_input-PROJK

zpo_input-BUYER

zpo_input-PORECDATE

zpo_input-INV_AMOUNT

zpo_input-STATUS

zpo_input-REMARK

Please tell me how to move the data to these fields from internal table

Regards,

Line

[Former Member]

in your screen flow logic (se51)

PROCESS BEFORE OUTPUT.

module display.

in abap code.

declare the fields name as variable suppose you have assigned sebeln name to a input field in screen layout.

data : sebeln like ekko-ebeln.

now in pbo module.

module display output.

select single ebeln into sebeln from ekko where <cond>.

endmodule.

regards

shiba dutta