06-13-2009 10:06 AM
Hi experts,
I want to fetch konv-kbeter.
So first i am fetch vbrk to vbeln , knumv
then konv to kbetr is it right or any mistake , plz provide me flow
06-14-2009 11:01 AM
Hi Srinu,
Please try:
Select single knumv into V_KNUMV from vbrk where vbeln = P_VBELN.
if sy-subrc eq 0.
Select knumv kposn kbetr
into table wa_konv
from konv
where knumv = V_KNUMV and
kposn = P_POSNR
Endif.
Rgds,
Ramani N
06-13-2009 1:25 PM
Hi Srinu,
The flow is right. You need to pick VBRK-VBELN and VBRK-KNUMV and select for that KNUMV from KONV-KBETR. Also, if you want to fetch item level condition values, you can compare VBAP-POSNR with KONV-KPOSN for that item level condition value. But, in this case, one more table VBAP will be added in flow.
Gouri.
06-14-2009 11:01 AM
Hi Srinu,
Please try:
Select single knumv into V_KNUMV from vbrk where vbeln = P_VBELN.
if sy-subrc eq 0.
Select knumv kposn kbetr
into table wa_konv
from konv
where knumv = V_KNUMV and
kposn = P_POSNR
Endif.
Rgds,
Ramani N
06-14-2009 12:26 PM
you may have to look into the following;
Header/Item conditions,Condition type,Currency,
Note: all the conditions values are not stored in this table as you see in your transaction screen.
06-15-2009 6:06 AM
Hi,
So first i am fetch vbrk to vbeln , knumv
then konv to kbetr is it right or any mistake , plz provide me flow
First fetch the 'KNUMV' from the table vbrk into itab(say)...
If the fetch is successful the select from konv for all entries in the previous internal table itab...
Using for all entries will increase your performance.
06-17-2009 3:05 PM