Material Number, Plant,sales org ,distribution channel data base table

[Former Member]

Hello Experts,

i am extending the material through bapi bapi_material_savedata.

first i need to check whether material is available for this combination Material Number(MATNR),sales organization(VKORG),Distribution Channel(VTWEG),Plant(WERKS).

if it is not available i need to extend the paricualr combination.

i tried mvke,marc tables.

mvke - Material Number,sales organization,distribution channel is there

marc - Material Number,Plant is there.

Please tell me in which database table we can find these 4 fields. or any bapi is there for checking material for this combination.

Thanks,

Venkat.

[Former Member]

Hello,

There is no option other than these MVKE and MARC. Do the inner join this table or for all entries by collecting the data into 2 diffent internal tables.

Regards,

Mukund

[Former Member]

Hi

Check the tables

A071 or

A152 or

A070 or

MABW

These tables have all the four fields.

Thanks

Sahitya

[Former Member]

Hi,

through join between marc,mvke i tried but missing the some of the combination data.it's not working

Thanks for giving the all tables.

but these tables are not updating the material master data.

MABW : Management of Differently Maintained Material Data in Retail retail only it will be updated.

Thanks,

Venkat.

[Former Member]

What Data are you missing when you Join MARC and MVKE?

[Former Member]

Hi,

first i will create material for the below three combinations.

45 45 45 44

DI ST IU DI

FCP1 FCP1 FCP1 FCP1

same material need to be extended for these combinations

45 45 45I 44 44 45 45

DI ST IU DI DI DI ST

101 101 101I 101E SBWH SBWH SBWH

first material will be extended 45 di 101.

but second case already 45 st in database table mvke already there,and plant 101 is also there in marc table.joiing both tables already there tah t combination.

message already exists in database will come .but particular combination not yet created.

Thanks,

Venkat.