05-04-2006 11:46 PM
Hi Folks!
I'm working on a report where I need a column that brings me a total of shipping(condition value) where its value is entered manually when creating the invoice.
I know that the table KONV is the table that contains the information of the conditions, though this shipping value is entered manually, so I can't look for this value in this table because it would be inconsistent, I already checked the data just to make sure.
I also tried to lookup at the table VBRP(Invoice detail) for the fields KZWI1-KZWI6, however I can't get the values showed on the conditions of the invoice details(Trans. VF03).
I was wondering if anybody can tell me where I can get the value for this kind of conditions.
Anyhelp will be really appreciated.
Thanks in advice.
Regards,
Gilberto Li
05-04-2006 11:54 PM
you can get the value from table KONV , filed is Kbetr . you have to get condiotion number for invoice from header table ( vbrk ) and put in KONV.
Hope thisll give you idea!!
<b>P.S award the points.!!! DOn`t forget :)!!!!</b>
Good luck
Thanks
Saquib Khan
"Knowledge comes but wisdom lingers!!"
"Some are wise and some are otherwise"
05-04-2006 11:54 PM
you can get the value from table KONV , filed is Kbetr . you have to get condiotion number for invoice from header table ( vbrk ) and put in KONV.
Hope thisll give you idea!!
<b>P.S award the points.!!! DOn`t forget :)!!!!</b>
Good luck
Thanks
Saquib Khan
"Knowledge comes but wisdom lingers!!"
"Some are wise and some are otherwise"
05-05-2006 12:28 AM
Hi Gilberto,
Have you looked this FM <b>CONDITION_RECORD_READ</b>?
Hope this will help.
Regards,
Ferry Lianto
05-05-2006 12:30 AM
the link field is vbrk-knumv... this points to konv for all conditions relating to the document.
05-05-2006 3:42 PM
Hi again!
Thanks for all your replies, i've found the field, it was KONV-KWERT, can't believe I couldn't see that. I was using the fieds KONV-KBETR * KONV-KAWRT, for those that were using a formula, but I never saw that KONV-KWERT already had the final value of the condition.
Thanks Again.
Regards,
Gilberto Li
Message was edited by: Gilberto Li