Table field for either item price or rate in invoice

[Former Member]

Hello friends,

I am working on Invoice smartform, in that I need table and field for either Item Price or rate or both.

In VBRP table NETWR field is there but the value in that is including Education Cess and Excise duty.

In KONV table KBETR is there but I cannot join VBRP and KONV, since KONV is cluster table.

Can any one tell me the exact table and field for this please ASAP.

Regards,

Chandu.

Edited by: chandra sekhar narra on Mar 2, 2010 2:10 PM

[kesavadas_thekkillath · Accepted solution]

select from VBRK first.

then use for all entries select from KONV based on VBRK-KNUMV.

Then use for all entries select from VBRP based on VBRk-VBELN and POSNR.

loop at item table.

read header, read conditions based on the key fields and format a final internal table.

[Former Member · Accepted solution]

Thankyou very much , my problem is solved.

[kesavadas_thekkillath]

Why do you wnat to JoIn both, is there no key field in bothe tables so that you can select the data from KONV.

You can link VBRK-KNUMV = KONV-KNUMV and VBRK-VBELN = VBRP-VBELN.

[Former Member]

HI,

In VBRK and KONV the common field is KNUMV, and in KONV and VBRP the common field is POSNR(Item number) based on Item number I am fetching ARKTX(Goods desc), FKIMG( Billed QUantity),NTGEW(Qunatity) from VBRP and KBETR(AMount/Rate) from KONV. That is my actual requirement.

Edited by: chandra sekhar narra on Mar 2, 2010 2:50 PM

Edited by: chandra sekhar narra on Mar 2, 2010 2:50 PM

[kesavadas_thekkillath]

Is it solved or still facing any issues.

[Former Member]

Now i am not joining both tables, but first retrieving from VBRP and then from KONV. What statement should I use in select statement for second table, when i use Into corresponding fields it is overwriting the other fields , when i use appending corresponding fields, one more record is getting created ,

how to deal with this issue. please help.

[kesavadas_thekkillath]

I guess you are using inside a loop.

select the data outside the loop into the internal table using for all entries.

[Former Member]

select kposn

into table it_item

from konv

where knumv = knumv.

IF NOT IT_ITEM[] IS INITIAL.

SELECT ARKTX

FKIMG

NTGEW

NETWR

INTO CORRESPONDING FIELDS OF TABLE IT_MAIN

FROM VBRP

FOR ALL ENTRIES IN IT_ITEM

WHERE POSNR = IT_ITEM-KPOSN.

SELECT KWERT

INTO CORRESPONDING FIELDS OF TABLE IT_MAIN

FROM KONV

FOR ALL ENTRIES IN IT_ITEM

WHERE KPOSN = IT_ITEM-KPOSN AND KSCHL = 'PR00'.

endif.

This is my actual code... please check this..

[kesavadas_thekkillath]

First select the header table data VBRK,

then the item table data VBRP,

then from KNOV.

In your select from VBRP- where is the billing document no.

First understand the Logic of header and item.

[Former Member]

First I am fetching KNUMV from VBRK, then based on KNUMV im fetching POSNR from KONV, Based on POSNR(item numbers)

I am fetching ARKTX, FKIMG.....etc from VBRP and KWERT from KONV.

[kesavadas_thekkillath]

In se11 search for J_1I*.

check tables

J_1IMOCUST - Customer

J_1IMOVEND - Vendor

[Former Member]

Hi Keshav,

Those table does not serve my purpose. I want Amout./Rate field for Item in invoice.

Regards,

Chandu