Application Development 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
Showing results for 
Search instead for 
Did you mean: 

item field from KONV

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

former_member229729
Active Participant
0 Kudos

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

5 REPLIES 5

former_member215917
Active Participant
0 Kudos

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.

former_member229729
Active Participant
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks