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

Problem with Material price

Former Member — Fri, 12 May 2006 11:44:01 GMT

hi,

my requirment is to get the materils and their price from sapR/3. i can get materials from MATERIAL_GETLIST.

cau u tell me how get material price (that means in which bapi)

regards

Guru

Re: Problem with Material price

Former Member — Fri, 12 May 2006 11:48:21 GMT

Try this FM:

MSR1_MD_MATPRICE_GETLIST

REgards,

Ravi

Re: Problem with Material price

Former Member — Fri, 12 May 2006 11:49:03 GMT

try this one....

CK21_MATERIAL_PRICES_READ

Re: Problem with Material price

Former Member — Fri, 12 May 2006 11:49:25 GMT

BAPI_MATERIAL_GET_DETAIL.

Re: Problem with Material price

Former Member — Fri, 12 May 2006 11:53:24 GMT

Ideal BAPI would be BAPI_MATERIAL_GET_ALL. You have to just pass the material number for it to work.

Price related data is available in tables parameter 'VALUATIONDATA'.

Re: Problem with Material price

Former Member — Fri, 12 May 2006 12:15:51 GMT

HI,

BAPI_MATERIAL_GET_ALL : while run this papi it giving error like function module does not exits.

MSR1_MD_MATPRICE_GETLIST: when i run this i did not get price field(can u tell me price field)

CK21_MATERIAL_PRICES_READ:when i run this i did not get

price field(can u tell me price field)

Can u please tell me field name and bapi name

regards

Guru

Re: Problem with Material price

Former Member — Fri, 12 May 2006 12:20:58 GMT

Hi,

Check the fm: BAPI_MATERIAL_GET_DETAIL.

The price field will be in the parameter: MATERIALVALUATIONDATA-STD_PRICE.

Regards,

Ravi

Re: Problem with Material price

Former Member — Fri, 12 May 2006 12:37:40 GMT

HI,

when i run this i am getting all fieldvalues are zeros

regads

Guru

Re: Problem with Material price

Former Member — Fri, 12 May 2006 12:41:07 GMT

Hello Guruvulu,

U can access table MBEW and get the proce for the valuation area.