Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Select statement not working in WHERE clause

Former Member

‎2008 Nov 07 7:22 PM

0 Likes
2,060

REPORT Zsap .

PARAMETERS : P_VKORG TYPE VBAK-VKORG.

TYPES: BEGIN OF TY_VBAK,

VBELN TYPE VBAK-VBELN,

END OF TY_VBAK.

DATA: IT_VBAK TYPE TABLE OF TY_VBAK,

WA_VBAK TYPE TY_VBAK.

SELECT VBELN

FROM VBAK

INTO TABLE IT_VBAK

WHERE VKORG = P_VKORG.

in selection screen im giving P_vkorg = '7999'.

error:

select stament is not working..

it_vbak is initails.

please let me know how i can get data into it_vbak

Edited by: Julius Bussche on Nov 7, 2008 8:58 PM

REPORT Zsap .

PARAMETERS : P_VKORG TYPE VBAK-VKORG.

TYPES: BEGIN OF TY_VBAK,

VBELN TYPE VBAK-VBELN,

END OF TY_VBAK.

DATA: IT_VBAK TYPE TABLE OF TY_VBAK,

WA_VBAK TYPE TY_VBAK.

SELECT VBELN

FROM VBAK

INTO TABLE IT_VBAK

WHERE VKORG = P_VKORG.

in selection screen im giving P_vkorg = '7999'.

error:

select stament is not working..

it_vbak is initails.

please let me know how i can get data into it_vbak

Edited by: Julius Bussche on Nov 7, 2008 8:58 PM

Reply
11 REPLIES 11
Read only

Former Member

‎2008 Nov 07 7:30 PM

0 Likes
1,578

Check the entries in VBAK for 7999.if there entries are exsist than only your it_vbak would get fill.

Read only

Former Member
In response to Former Member

‎2008 Nov 07 7:34 PM

0 Likes
1,578

YES it has more than 3,000 records in VBAK .

Read only

Former Member

‎2008 Nov 07 7:38 PM

0 Likes
1,578

Your select statement works... when I give '7999', the internal table is initial because there is not any record with 7999, but if a use another that I know exist.. it works fine.

Read only

Former Member

‎2008 Nov 07 7:40 PM

0 Likes
1,578

Laurence - the moderators take a dim view of such meaningless titles. The first thing you should do is edit it if you can.

Rob

Read only

Former Member
In response to Former Member

‎2008 Nov 07 7:52 PM

0 Likes
1,578

> 

> The first thing you should do is edit it if you can.
> Rob

Changed

Read only

Former Member
In response to Former Member

‎2008 Nov 07 8:03 PM

0 Likes
1,578

> 

> 
> Changed

But it only shows up on the individual thread. the original one stays the same.

Actually, this is probably a good thing

Rob

Read only

Former Member
In response to Former Member

‎2008 Nov 07 8:04 PM

0 Likes
1,578

Julius managed the things

Read only

Former Member
In response to Former Member

‎2008 Nov 07 8:07 PM

0 Likes
1,578

Yes - I was alittle confused to see that your title had takend.

BTW I wonder what the original question was

Rob

Read only

Former Member

‎2008 Nov 11 11:21 AM

0 Likes
1,578

In the where clause use P_VKORG-LOW or High instead of using only P_VKORG .

Thank You.

Read only

Former Member

‎2008 Nov 12 6:45 AM

0 Likes
1,578

ur select query is checking for vbeln which has vkorg = '7999'. Since it is not available it is not populating anything in the internal table.

Check for any other number that exists.

Regards,

SAPient.

Read only

Former Member
In response to Former Member

‎2008 Nov 12 5:24 PM

0 Likes
1,578

Check in debugging mode, if P_VKORG is getting populated or not...

If not getting populated, try using Programming Events like...

At selection-screen

start-of-selection ...