on 08-24-2009 6:13 AM
Hi Gurus,
I am working on smartforms now and I am stuck with reuirement now.
The requirement is something like this.
I have got a PO, where If the conditions of that PO is maintained Item wise then we will get the conditins from the item else we will get the conditions from the header.
For this I have made test programs,where it is working fine independently, but when both are combined the output is erroneous.
I have used the following select queries.
FOR ITEM.
select knumv from eslh INTO TABLE
tt_knumv FOR ALL ENTRIES IN tt_esll
where packno = tt_esll-sub_packno.
*-----------------------------------------------change
*SELECT SINGLE ebelp from ekpo INTO l_ebelp
* WHERE ebeln = p_ebeln.
*
*select kschl kbetr kwert
* from konv
* into table tt_konv
* where knumv = l_knumv
* and kposn = l_ebelp.
SELECT ebelp from ekpo INTO table tt_ebelp
WHERE ebeln = p_ebeln.
select knumv kschl kbetr kwert
from konv
into table tt_konv
FOR ALL ENTRIES in tt_knumv
where knumv = tt_knumv-knumv.
* AND kposn = tt_ebelp-ebelp.
.
For Header
Working for 177
select ebeln knumv from ekko INTO
TABLE tt_knumv
where ebeln = p_ebeln.
*-----------------------------------------------change
*SELECT SINGLE ebelp from ekpo INTO l_ebelp
* WHERE ebeln = p_ebeln.
*
*select kschl kbetr kwert
* from konv
* into table tt_konv
* where knumv = l_knumv
* and kposn = l_ebelp.
SELECT ebelp from ekpo INTO table tt_ebelp
WHERE ebeln = p_ebeln.
select knumv kschl kbetr kwert
from konv
into table tt_konv
FOR ALL ENTRIES in tt_knumv
where knumv = tt_knumv-knumv.
* AND kposn = tt_ebelp-ebelp.
.
Now how to solve this problem.
Any kind of help or logic will be highly appreciated.
Regards,
Abhinab Mishra
Well in this case,
the problem was with my logic with a simple solution.
We will have check whether the RFQ is maintained or not .
If maintained then fetch data item wise else header wise
Thanks and Regards,
Abhinab Mishra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.