10-08-2008 1:02 PM
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
10-08-2008 1:06 PM
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
10-08-2008 1:04 PM
Hi,
Read MVKE to get the sales org view of the material master.
Darren
10-08-2008 1:06 PM
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
10-08-2008 1:07 PM
Hi,
You can innerjoin the table MARD and MVKE (Sales Data for Material). In MVKE table you have both Sales Org and Dist Channel