topic Wrong pricing condition values when using GN_INVOICE_CREATE in Application Development and Automation Discussions

Wrong pricing condition values when using GN_INVOICE_CREATE

Former Member — Mon, 07 Jul 2008 01:53:36 GMT

Hi all,

I am currently handling a program where I have to display all the materials in a given sales area and some corresponding values that depend on pricing conditions. I am using FM GN_INVOICE_CREATE to extract table komv. However, I am experiencing a problem because the values I am getting are different from those in table konv. I am getting the price conditions without the value of field KNUMV.

I would like to ask if anybody has any idea on how to go about this or maybe another function module that I can use to get the data I need.

Thanks a lot..

Regards,

jac

Re: Wrong pricing condition values when using GN_INVOICE_CREATE

Former Member — Mon, 07 Jul 2008 02:49:32 GMT

Hi jac,

I cant help you on FM to be used but try reading KONV-KSTAT = SPACE only because kstat with 'X' is for statistical data use only and not consider as part of the billing amount. From there you can have correct amount for a certain material. hope it helps.. and please reward points..

regards,

booh

Re: Wrong pricing condition values when using GN_INVOICE_CREATE

Former Member — Mon, 07 Jul 2008 11:40:43 GMT

Hi,

Thanks for your reply. I only have the field AUART for checking on the pricing conditions.

Here is a the part of my code

CALL FUNCTION 'GN_INVOICE_CREATE'

EXPORTING

vbsk_i = i_vbsk

id_kvorg = ''

id_no_dialog = c_exis

invoice_date = p_datum

pricing_date = p_datum

IMPORTING

vbsk_e = i_vbsk

TABLES

xkomfk = i_komfk

xkomfkgn = i_komfkgn

xkomfkko = i_komfkko

xkomv = i_komv

xthead = i_thead

xvbfs = i_vbfs

xvbpa = i_vbpa

xvbrk = i_vbrk

xvbrp = i_vbrp

xvbss = i_vbss

EXCEPTIONS

OTHERS = 1.

The only parameters in those that have values are c_exis = X, p_datum = given date, and xkomfkgn. The other parameters are all initial when passed to the function module. I get a resulting komv table however, values are incorrect.

Thanks again for the help..

Regards,

jac

Re: Wrong pricing condition values when using GN_INVOICE_CREATE

Former Member — Tue, 08 Jul 2008 05:53:39 GMT

HI,

try below function module...

'pricing'.

-Prabhu

Re: Wrong pricing condition values when using GN_INVOICE_CREATE

Former Member — Thu, 10 Jul 2008 07:56:14 GMT

Hi,

Thanks for your reply, however, I cannot use pricing as it imports table KOMK, which I do not have...