topic Displaying the captured data in Application Development and Automation Discussions

Displaying the captured data

Former Member — Wed, 30 May 2007 09:08:29 GMT

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

Re: Displaying the captured data

sreeramkumar_madisetty — Wed, 30 May 2007 09:11:07 GMT

Use Select single/Upto opne rows to fetch.

Using write you can display the captured data.

Regards,

Sree

Re: Displaying the captured data

Former Member — Wed, 30 May 2007 09:11:30 GMT

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

Re: Displaying the captured data

Former Member — Wed, 30 May 2007 09:12:17 GMT

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

Re: Displaying the captured data

Former Member — Wed, 30 May 2007 09:16:26 GMT

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

Re: Displaying the captured data

Former Member — Wed, 30 May 2007 09:21:17 GMT

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

Re: Displaying the captured data

Former Member — Wed, 30 May 2007 09:22:13 GMT

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