Purchase Report

[Former Member]

Hi Frendz,

I want info from ekko table( fields po #, bukrs, ernam,ekgrp) and from table t024(purchase group description), so can u pls guide me how to link these two tables to get the information ?

Thanks in advance

Srini Kumar

[Former Member]

Hi Frendz,

I want info from ekko table( fields po #, bukrs, ernam,ekgrp) and from table t024(purchase group description), so can u pls guide me how to link these two tables to get the information ?

Thanks in advance

Srini Kumar

[Former Member]

selecT a_{EBELN a}BUKRS A_{ERNAM a}EKGRP B~EKNAM

INTO TABLE ITAB

FROM EKKO AS A INNER JOIN T024 AS b

ON A_{EKGRP = B}EKGRP.

[Former Member]

Thanks Anurag for help, i am awarding full points for u

[Former Member]

hi,

You can link two tables based on EKGRP.

Hope this helps.

[Former Member]

IN EKKO Table there is a field EKGRP purchasing group.

to get the description of a purchasing org we will use T024 table.

Once you got your data into EKKO internal table from EKKO,

you can go to T024 table and give your EKKO-EKGRP field in T024 and you can get its descriptions.

Regards

srikanth

Message was edited by: Srikanth Kidambi