2013 Jun 29 7:13 AM
Hi,
I've attached 2 screen shots:
1. For Price procedure of a material in Sales Document - "S.OPP.GIF"
2. For KONV entries for document condition number of same item and same sales order - "KONV.GIF"
Value against Condition Type 'JA1X' in pricing procedure of a sales order for a material is 7303.40,
which is the value i need. But when i check the entry for that condition document for same item, it has value 780..
Where will i get 7303.40.. On F1, this value (7303.40) is stored in a structure KOMV but its not reflecting in
KONV table.. How to get this value without manual calculation, from database itself?
Thankyou,
KS
2013 Jun 29 8:24 AM
Hi KS,
use FM "SD_KOMV_ARRAY_SELECT".
Pass I_KOMV_KEYTAB-KNUMV and I_VBAK-VBELN & I_VBAK-ERDAT
the E_KOMV Structure will get popluated.
Hi,
I've attached 2 screen shots:
1. For Price procedure of a material in Sales Document - "S.OPP.GIF"
2. For KONV entries for document condition number of same item and same sales order - "KONV.GIF"
Value against Condition Type 'JA1X' in pricing procedure of a sales order for a material is 7303.40,
which is the value i need. But when i check the entry for that condition document for same item, it has value 780..
Where will i get 7303.40.. On F1, this value (7303.40) is stored in a structure KOMV but its not reflecting in
KONV table.. How to get this value without manual calculation, from database itself?
Thankyou,
KS
2013 Jun 29 7:53 AM
Hi KS,
At times the condition values are calculated and show and don't store exact values
Try using this code and see if the values come appropriate.
wa_head_i-belnr = wa_vbrk-vbeln.
wa_head_i-knumv = wa_vbrk-knumv.
wa_head_i-vkorg = wa_vbrk-vkorg.
wa_head_i-vtweg = wa_vbrk-vtweg.
wa_head_i-spart = wa_vbrk-spart.
clear i_tkomv.
CALL FUNCTION 'RV_KONV_SELECT'
EXPORTING
comm_head_i = i_comm_head_i
GENERAL_READ = 'X'
* READ_CONDITION_RECORD = ' '
* IMPORTING
* COMM_HEAD_E = i_a_tkomv
tables
tkomv = i_tkomv.
2013 Jun 29 10:54 AM
Hi Yakub,
Thanks for the reply and i tried it, but this FM would return records from table KONV and not structure KOMV..
Regards,
KS
2013 Jun 29 8:24 AM
Hi KS,
use FM "SD_KOMV_ARRAY_SELECT".
Pass I_KOMV_KEYTAB-KNUMV and I_VBAK-VBELN & I_VBAK-ERDAT
the E_KOMV Structure will get popluated.