Skip to Content
avatar image
Former Member

Tables to relate material, sales organisation and storage location

Hi,

I have to develope a program to download a file for stock.

On my selection screen I have

Material

Sales Organisation

Storage location

and the file structure is

MATERIAL | STORAGE LOCATION | QUANTITY | TODAY DATE |

Can anybody please tell me what Table I shouid use bacause when I am trying to use VBAK and VBAP the order no is the key and here I am not doing anything with order no.

Regards.

Kusum.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2008 at 09:43 AM

    Hi,

    use tables - MSEG,

    MVKE.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 09:52 AM

    Hi,

    You can use table

    MABW - Management of Differently Maintained Material Data in Retail

    or a combination of

    MARD and MVKE - where MARD gives Storage Location and MVKE gives the Sales Organization of the material number

    Regards,

    Sumalatha N.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 09:53 AM

    Hi ,

    You have material Number ,sales organisation and storage location .

    Use following tables .

    MARC and MARD.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 09:43 AM

    Tables : MARD, MVKE

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 09:55 AM

    Hi Kusum ,

    Try Join of table

    MSEG : Document Segment: Material

    MVKE : Sales Data for Material

    Regards,

    Sandeep Patel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 01:55 PM

    Thanks all for your quick response 😊

    Regards.

    Kusum.

    Add comment
    10|10000 characters needed characters exceeded