Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jun 26 at 10:46 AM Sridhar is correct. Within the Infoset, you can define code and do the select manually. This assumes that you can narrow your select in such a way that you will get only one record returned. Otherwise, you will have to deal with a multi-record situation and narrow it down.
You can define the two new fields as Sridhar suggests, and for the code in each, just issue the "clear" command so you don't have the infoset telling you there's no code or value for them:
Then in a code block that you can define, you do your select:
tables: konv
select single kawrt kmein into ( zkawrt, zkmein ) from konv
where . . . .
If you have the possibility of having multiple rows that you would have to loop through, you would have to declare an internal table, fill it, and then loop through it and select one record based on your need. If you could have more than one record that satisfies this selection, you can't do it. You have no access to the infoset's internal tables to put in more than one row for a given row coming out of the LDB.
I hope that helps.
Lou
| | | ---------------Original Message---------------
From: jwtsap
Sent: Tuesday, June 26, 2012 9:58 AM
Subject: SQ1 Report to Export Showing All Open Pick Lists
I have completed most of this report, but I am missing one crucial piece. In the pick list there is a reference to the KONV table, where it picks up the following fields:
KONV-KAWRT
KONV-KMEIN
Which are the qty and Units appearing on the invoice.
I used the logical DB VLV, but I can't join KONV to any table in that logical BD. I may need to back out and do a manual table join.
Other fields needed:
Customer Part #
Our Part Num
Delivery #
Part Descr
Number of Parts in the delivery
Can anyone help? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
