topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Tue, 22 May 2007 00:59:54 GMT

hei,

I have a select option for VBELN.

select-option: salesdoc for vbak-vbeln.

when I dont select any data(selection screen) and simply execute it......my ALV displays grid and also data in it. It works fine

but when I select the data in select option in selection screen...all i see is just the column headings.....no grid and no data......

my select stmt also has data retreival as....select........vbeln in salesdoc.

pl help.....is something wrong with fieldcat assignment? if its the case...its displaying all fine when no selection criteria is specified

Re: ALV

Former Member — Tue, 22 May 2007 01:08:17 GMT

Hi,

Go to VBAK table and check for the entries, pick any one VBELN and give it in your select-option.

Your issue will get resolved.

The problem may be that all the select statement may not be fetching records.

Reward points if useful.

Regards,

Atish

Re: ALV

Former Member — Tue, 22 May 2007 01:13:24 GMT

select-option: salesdoc for vbak-vbeln.

select vbeln erdat erzet ernam angdt bnddt audat

into CORRESPONDING FIELDS OF table hd_vbak

UP TO 15 ROWS

from vbak

where vbeln IN salesdoc.

this is my select stmt.

Re: ALV

Former Member — Tue, 22 May 2007 01:20:15 GMT

Hi,

Have you tried the things which I written in my ealier post.

Just give more entries, or a big range in your selct option and you will see the output.

Also you can write this code to check if the data is being fetched or not after the selct statement.

select vbeln erdat erzet ernam angdt bnddt audat

into CORRESPONDING FIELDS OF table hd_vbak

UP TO 15 ROWS

from vbak

where vbeln IN salesdoc.

<b>if sy-subrc NE 0.

message e000(su) with 'No Data in VBAK for given selection'.

endif.</b>

Reward points if useful.

Regards,

Atish

Re: ALV

Former Member — Tue, 22 May 2007 01:26:45 GMT

hei atish,

its not just abt displaying the data. i understand when u mentioned abt giving a greater range.i tried that. my problem here is......its not displaying the physical grid...at all...with all the rows and columns(if we forget the data for now....i guess fieldcat is not being read by the grid_display FM when i specify the selection criteria....

Re: ALV

Former Member — Tue, 22 May 2007 01:31:13 GMT

Hi,

If no data present in ITAB then it doesn't display any GRID in ALV. PLease check the data is present in database with ur selection screen and it populating the respective hd_vbak, it_vbak.....

Regards

SAB

Re: ALV

Former Member — Tue, 22 May 2007 01:35:03 GMT

hei

thanks syed and atish.....

i was not aware that it wouldn't display grid when there is no data.

i gave a greater greater range.....it works......

Re: ALV

Former Member — Tue, 22 May 2007 01:37:00 GMT

Hi Alchemi,

Then reward points and close the thread

Regards,

Atish