topic Re: Problem with material price in Application Development and Automation Discussions

Problem with material price

Former Member — Wed, 31 May 2006 10:02:53 GMT

Hi,

I have used bapi BAPI_MATERIAL_GET_DETAIL,then i am getting material price as "0".But when i use a bapi BAPI_SALESORDER_CREATEFROMDAT2 for all the materials it is calculating the price and it is even displaying the unit price of that material.whether i am using the wrong bapi to get material detail or any problem.pls send me the related information regarding that.

Regards,

Kiran.

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:06:41 GMT

Hi,

Are you passing the values to VALUATIONAREA and VALUATIONTYPE? Unless you do that PRICE will not be calculated. You should get the values for these from your functional person.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:08:20 GMT

Which export parameter are you looking at?

Did you see whatis there in MATERIALVALUATIONDATA-STD_PRICE??

Regards,

Ravi

See sample code:

CALL FUNCTION 'BAPI_MATERIAL_GET_DETAIL'

EXPORTING

MATERIAL = ls_matnrlist-MATERIAL

PLANT = '1000'

VALUATIONAREA = '1000'

VALUATIONTYPE =

IMPORTING

MATERIAL_GENERAL_DATA = ls_generaldata

RETURN =
MATERIALPLANTDATA =

MATERIALVALUATIONDATA = ls_MATERIALVALUATIONDATA.

move ls_matnrlist-MATERIAL to ls_MATDATA-MATERIAL.

move ls_generaldata-MATL_DESC to ls_MATDATA-MATL_DESC.

move ls_generaldata-BASE_UOM to ls_MATDATA-BASE_UOM.

move ls_MATERIALVALUATIONDATA-MOVING_PR to ls_MATDATA-MOVING_PR.

append ls_matdata to lt_matdata.

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:08:31 GMT

Hi,

check the following threads.

this might be of some help.

Regards,

Aswin

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:37:19 GMT

HI,

My problem is i could not get the material price when i run BAPI_MATERIAL_GET_DETAIL. But in BAPI_SALESORDER_CREATEFROMDAT2, I can get NetValue

Regards

Guru

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:42:18 GMT

Hi,

The SALES ORDER BAPI internall might be passing the valuation data to the MATERIAL BAPI. But when you are calling the same you might not be passing the same.

Regards,

Ravi

Note :Please mark all the helpful answers

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:45:31 GMT

hi,

check these links for examples:

http://help.sap.com/saphelp_nw04/helpdata/en/78/21745d51ce11d189570000e829fbbd/content.htm

regards,

keerthi.

Re: Problem with material price

Former Member — Wed, 31 May 2006 10:48:51 GMT

hi ravi

can u please tell me how see material price in sapgui.

and give me the importparameters

regards

Guru

Re: Problem with material price

Former Member — Wed, 31 May 2006 11:31:25 GMT

Hi Bhogi.

i did it on this way and it works correct!

REPORT ZTEST.

data: itab like BAPIMATDOBEW.

data: rt like BAPIRETURN.

CALL FUNCTION 'BAPI_MATERIAL_GET_DETAIL'

EXPORTING

MATERIAL = '000000000000500000'

PLANT = '2000'

VALUATIONAREA = '2000'

VALUATIONTYPE = 'EIGEN'

IMPORTING

MATERIAL_GENERAL_DATA =

RETURN = rt

MATERIALPLANTDATA =

MATERIALVALUATIONDATA = itab.

Itab has the right values. Do you use the right VALUATIONTYPE. Sometimes it will be different. Look

at MBEW and find the right one.

Hope i can help you.

Regards, Dieter

Re: Problem with material price

Former Member — Wed, 31 May 2006 11:51:44 GMT

Did u try using FM MBEW_ARRAY_READ_MATNR_ALL.

Pass material number in the table IPRE03 and it will give u all the MBEW records.