04-11-2006 10:30 AM
Hi All,
For a certain S.O. the details of the ED, C.S.T., L.S.T., calculated can be viewed in the Pricing Procedure, But if i need the value to be used in report i am unable to retrieve the data's b'cas the values are stored in the Structures KOMV,KOMP.
Is there any DB tables which store the data's for the structures KOMV and KOMP?. or any other psbl way to get the revelant data's.if any pls do suggest me.
Help and Suggestions will be much appricieated.
Thanks & Regards.
Ramesh.
04-11-2006 10:33 AM
See if the FM CONDITION_RECORD_READ is useful to you.
REgards,
Ravi
04-11-2006 10:33 AM
See if the FM CONDITION_RECORD_READ is useful to you.
REgards,
Ravi
04-11-2006 10:34 AM
Ramesh,
The values you are talking about are dynamically calculated depending on the pricing conditions and are not stored any where. If you want to display the same, you will have to get the conditions and calculate the same.
Regards,
Ravi
Note : please mark the helpful answers
04-11-2006 10:35 AM
Based on the conditions on which u r calculating ED, CST & LST, u can go to KONV and get the details.
04-11-2006 10:40 AM
Hi,
You can use the tables KONV and KONP for getting the details based on condition record number in Sales order header(VBAK) and the condition type.
Thanks,
Rashmi .
04-11-2006 10:58 AM
Hi Ramesh,
get KNUMV from vbak table..put this in KONV table ...u get details for all the condition types ( KSCHL field ).. use this field for ur particular values in the field KBETR(percentage) & KWERT(value).
Hope it helps,
Regards,
Bikash
04-11-2006 11:16 AM
Check tables <b>KONV and KONP</b>
check functions
PRICING
RV_PRICE_PRINT_HEAD
RV_KONV_SELECT
SD_SALES_DOCUMENT_READ
SD_SALES_DOCUMENT_READ_POS
RV_BILLING_PRINT_VIEW
regards
vinod