We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] abap Query On Tables KONV, EKKO and EKPO

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from LCC352 on Jul 15 at 11:38 AM
Hi, Venkata - I got a chance to try it myself and it won't accept the "OR" in the list. It needs to be one value or one field.

Since you've put in KONV-STUNR and KONV-ZAEHK as the answers to the join, it will only give you the records matching that as it evaluates the values from KONV, nothing else. If I understand you correctly, you've created a parameter for STUNR, but you should have created a select option instead. Parameters are single values, whereas select options allow ranges and such. Perhaps if you create a select option in the query (in the Extras area, there is a tab called "Selections". You can create a selection criteria for STUNR. You need to answer the FOR question in the selections screen with KONV-STUNR. Then, if you put in a range of 15 to 31 in that select, each time it finds a record (15, 16, etc.) it should pick the corresponding record from your join.

Let me know if that works

- Lou

---------------Original Message---------------
From: abaper
Sent: Thursday, July 11, 2013 12:50 PM
Subject: abap Query On Tables KONV, EKKO and EKPO

Hi All,

I have developed abap query on tables KONV, EKKO and EKPO as in the below link.
http://www.erpgreat.com/abap/query-to-extract-po-specific-condition-type.htm

Now in select statement on KONV in where condition for field STUNR I want to fetch the values between 15 to 31. How to achieve this one?

Thanks in advance.
Venkata

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
LCC352  

President
21 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment