Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 03, 2009 at 05:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03, 2009 at 09:00 AM

    Hi

    Check the tables

    A071 or

    A152 or

    A070 or

    MABW

    These tables have all the four fields.

    Thanks

    Sahitya

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.