topic Material Valuation in Application Development and Automation Discussions

Material Valuation

Former Member — Wed, 23 Nov 2011 15:35:36 GMT

Hello,

I have been trying to extract material valuation data using the: BAPI_MATERIAL_GET_DETAIL and accessing the MATERIALVALUATIONDATA structure. However I always get 0 for all fields with NCO or JCO. I have tested the function in SAP and I am getting the same results. However If I check through the SAPGUI (MM03) : Accounting 1, these fields for Material Valuation contain values.

What am I doing wrong? Or is there another way to get this information, another BAPI for instance.

Thanks

Re: Material Valuation

Former Member — Wed, 23 Nov 2011 22:39:46 GMT

Hi,

To get the valuation data using this BAPI, you need to enter the valuation area field. It will show the valuation data only for specific valuation area. When you go to MM03, enter the material number and select accouting view then SAP must be giving you a pop up to enter the plant. Table "T001W" contains the cross reference between Plant and valuation area. So you need to first get the value of valuation area from this table for a plant and then enter the same in BAPI.

select * from t001 where werks = <Plant>.

Call Function BAPI_MATERIAL_GET_DETAIL

Exporting

MATERIAL = <Material>

VALUATIONAREA = T001W-BWKEY

Importing

........

Re: Material Valuation

madhu_vadlamani — Thu, 24 Nov 2011 04:28:24 GMT

Hi Kelvngdo,

Make a wrapper RFC and pass the valuation area and get the data in BAPI_MATERIAL_GET_DETAIL.

Regards,

Madhu.

Re: Material Valuation

Former Member — Thu, 24 Nov 2011 15:34:02 GMT

Thanks

Himanshu

I will try your suggesting and let you know. It sounds promising

Regards

kevlangdo

Re: Material Valuation

Former Member — Thu, 24 Nov 2011 15:36:39 GMT

Thanks for the info

madhurao123

I will try your suggestion. However, I have been having problems creating functions in dev env. I keep getting "not authorized to make changes (s_develop). However basis says that I have full access

Thanks for your help

kevlangdo

Re: Material Valuation

Former Member — Thu, 24 Nov 2011 20:17:36 GMT

Thanks for the Valuation area info. That helped a lot however I also needed to included leading zeros in the material field since this field has 18 char and my material code has only 6, so when I added 12 leading zeros, I began receiving my data. Weird.