Tables to relate material, sales organisation and storage location

[Former Member]

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.

[Former Member]

Hi,

use tables - MSEG,

MVKE.

[Former Member]

Tables : MARD, MVKE

[Former Member]

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.

[Former Member]

Hi ,

You have material Number ,sales organisation and storage location .

Use following tables .

MARC and MARD.

[Former Member]

Hi Kusum ,

Try Join of table

MSEG : Document Segment: Material

MVKE : Sales Data for Material

Regards,

Sandeep Patel

[Former Member]

Thanks all for your quick response

Regards.

Kusum.