Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

FM to get material available

Former Member
0 Kudos

Hi

Any FM or logic to get the material numbers of all materials available in a company code, plant and locations.

Regards

Praneeth

1 ACCEPTED SOLUTION

former_member181962
Active Contributor
0 Kudos

Hi KUmar,

1)Materials in a Plant are available in MARC table.

2)Materials in a Storage Location are available in MARD table.

3)The Function K_ABC_GET_WERKS_FOR_BUKRS will get the plants under a company code. ONce you have the plants, you can go to MARC table.

REgards,

Ravi

4 REPLIES 4

Former Member
0 Kudos

Hi,

Check out BAPI: BAPI_MATERIAL_GETLIST

Regds,

Akshay Bhagwat

Note: Pls mark helpful answers.

Former Member
0 Kudos

Hi,

Table T001W_EXT will have plants data pertaining to a specific company code.

Table MARC will have the materials pertaining to a specific plant.

Join these two tables, you can materials specific to a company code and plant.

MARC-WERKS - Plant

T001W-BUKRS - compnay code

T001W-WERKS - Plant.

Regards,

Ravi

Note : Please mark the helpful answers

nishanthbhandar
Contributor
0 Kudos

Try BAPI_MATERIAL_GETLIST

former_member181962
Active Contributor
0 Kudos

Hi KUmar,

1)Materials in a Plant are available in MARC table.

2)Materials in a Storage Location are available in MARD table.

3)The Function K_ABC_GET_WERKS_FOR_BUKRS will get the plants under a company code. ONce you have the plants, you can go to MARC table.

REgards,

Ravi