How can query the table MARD using the parameters

[Former Member]

Hi,

I have inputs as material number , sales organization , distribution chanel and plant , using this i have query the table MARD . in MARD table material number and plant is available , how can i relate sales organization and distribution chanel to query the table, please help.

Regards,

Ratheesh

[Former Member]

Hi,

I have inputs as material number , sales organization , distribution chanel and plant , using this i have query the table MARD . in MARD table material number and plant is available , how can i relate sales organization and distribution chanel to query the table, please help.

Regards,

Ratheesh

[Former Member]

Hi,

Read MVKE to get the sales org view of the material master.

Darren

[Former Member]

Hi,

MVKE table contains the relationship between material, sales org. and distribution channel.

You can hence create a join between MARD and MVKE tables and create a query.

Regards,

Aditya

[Former Member]

Hi,

You can innerjoin the table MARD and MVKE (Sales Data for Material). In MVKE table you have both Sales Org and Dist Channel