Link between the tables CKML1 and MARD

[Former Member]

Hi to all,

Please let me know the Link between the tables CKML1 and MARD

Regards,

nagesh

[Former Member]

Hi,

This is not that much easy saying the direct relation between the tables like this.

Let's say MARD will hold the storage location data with respect to the material. i.e. material, plant, storage location combination it will have the stock details. and that to, quality, unrestricted, blocked stock etc kind of info will be available.

But in table CKML1 which holds the stock details based on the periods.

Regards,

Santhosh.

[Former Member]

Hi,

I could not find any link between these two tables....

Regards,

Siddarth

[Former Member]

Hi,

Go to SQ01--

---

Quick Viewer

---

Quick View(give text)

---

Create-Title-Data Source(Table Join)--Give Tick Mark

---

Edit(Insert table)--

---

Give Table name one more time Edit(Insert table).Like that u can find link between all tables.

This will not work in cluster tables.

Regards,

Bathri

[Former Member]

Hi,

Try with following.

CKML1-BDATJ = MARD-LFGJA.

Thank you,

Sekhar.

[Former Member]

You can find out cost estimate number for a material from table CKMLHD and go to CKML1 with that cost estimate no.

MARD-MATNR = CKMLHD-MATNR --->CKMLHD-KALNR = CKML1-KALNR.

Regards

Sathar