standard price from FM BAPI_MATERIAL_GET_DETAIL is huge ????

[Former Member]

Hi,

I have an issue. I am calculating price variance. so i am using the following formula :-

Consider the document 1900006713

Price Variance ( let us assume as Z ) = Inter Company cost price ( Let us assume as X ) minus NIC Rate - ( Let us assume as Y )

X = Sum of ( KZWI1 ) for all items

Y = VBRP-FKIMG * BAPI_MATERIAL_GET_DETAIL for valuation area same as the plant VBRP-WERKS- Standard price

But above bapi is returning huge value for standard price.

i.e some times its giving the stndrd price for 1 unit some times, its giving stndrd price for all the quantities

ex:- there are 2 line items in vbrp

vbrp table

VBELN POSNR FKIMG VRKME MATNR WERKS WAVWR kZWI1

1900007529 000010 100.000 CSE 000000210006868200 0398 1,295.00 1,295.00

1900007529 000020 100.000 CSE 000000210006116800 0398 1,201.00 1,600.00

In the Bapi, we are getting

for matnr 210006868200 (line item 10)

standard price as 12,950.0000 1,000 USD USD it should be 1.295 instead of 12,950.00 ( so huge price variation) ???????????? pl advice me on this .....

for matnr 210006116800,

std price as 12.0100 1,000 USD USD its correct as ( 12.01 * 100.00 (vbrp-fkime) is nearer to vbrp-kzw1 (1,600) little price variation)

Thanks in advance.

[Former Member]

Hi,

When you are passing the quantity to BAPI, multiply with 1000 and send it.

Y = VBRP-FKIMG * BAPI_MATERIAL_GET_DETAIL * 1000. This will give you right result.

Regards,

Sai