Guidance for getting material master data from database table

[Former Member]

Hi,

I need guidance to fetch following Material master data from the system data base.Please guide me for the same.

BASIC DATA1

BASIC DATA2

MRP1,2,3,4

WORK SCHEDULING

QUALITY MANAGEMENT

ACCOUNTING1

ACCOUNTING2

COSTING1,2

PURCHASING

PURCHASE ORDER TEXTSALES ORG1,2

SALES GENERAL/PLANT

PLANT DATA/STOR.1,2

WAREHOUSE MGMNT1,2

Also please tell me in general what is the reason for error while uploading the data into system using BAPi(AM talking about return message error).

Thank you.

Edited by: sanu debu on Feb 24, 2009 12:41 PM

Edited by: sanu debu on Feb 24, 2009 12:42 PM

[Former Member]

Use BAPI's

BAPI_MATERIAL_GET_DETAIL

BAPI_MATERIAL_GETALL

BAPI_MATERIAL_GET_ALL

[Former Member]

Go to tcode MM17. u shall get all the Tables.

[GauthamV]

Use these tables.

MARA

MARC

MARD

MAKT

MBEW