currency key required

[Former Member]

Hi guys,

we need to write the query to get the currency key (WAERS) from T001 table.

we have the MATNR, plant id, order number, can u please guide us on writing the query.

Thanks & regards,

Ravish

[Former Member · Accepted solution]

Hi,

TABLES: T001, T001K.

DATA: v_waers TYPE t001-waers,

v_bukrs TYPE t001-bukrs.

CLEAR: v_waers, v_bukrs.

SELECT SINGLE bukrs FROM t001k INTO v_bukrs

WHERE bwkey EQ plantid. (replace plantid with the field where the plant details you're reading from).

SELECT SINGLE waers FROM t001 INTO v_waers

WHERE bukrs EQ v_bukrs.

The field v_waers will hold the currecy key details. Revert if you face any issues.

Regards,

Vivek

[Former Member]

Dear Ravish,

Post the same Query in FI/CO Forum

You will get quick response

Regards

kumar