Regarding material search

[Former Member]

Hi Experts,

is there any standard BAPI or FM available for material search

desired output parameters are material details and sales area and respective plants for that material in given slaes area...

if no BAPI or FM is present,

can any one help me which tables i look for especially plant related (selected sales area and material).

Marc table cant define which sales area the plant is assigned to....

Giri

[Former Member]

Hi

try to use- BAPI_MATERIAL_DISPLAY

[Former Member]

>

> Hi Experts,
> 
> is there any standard BAPI or FM available for material search 
> 
> desired output parameters are material details and sales area and respective plants for that material in given slaes area...
> 
> if no BAPI or FM is present,
> 
> can any one help me which tables i look for especially plant related (selected sales area and material).
> 
> Marc table cant define which sales area the plant is assigned to....
> 
> Giri

MARC is table which stores plant level information. and MVKE is the table which store the slaes related information.

[Former Member]

Vijay,

but i want to search for a material which is in given sales Org. and Plant.

Ex: when u create item in quotation enter the material number and search for plant it shows the plant assigned to the material and also assigned to respective sales. org only, it doesn't show all plants available for that material in MARC.

hope u understand my problem

Giri

[former_member585060]

Try this BAPI

BAPI_MATERIAL_GET_ALL

Regards,

Bala Krishna