Address of the PO creator

[Former Member]

I have to populate the details of PO creator in the PO layout.

I queried on table ADRC for the name, telephone and fax where name_co = ekko-ernam.

Nothing was retrieved.

Let me know where i am going wrong.

regards

Alok Pathak

[Former Member · Accepted solution]

Hi

You can also try to use fm ADDR_GET to find all address data, but those data you need should be USR03.

SELECT SINGLE * FROM USR21 WHERE BNAME = EKKO-ERNAME.

ADDR1_SEL-ADDRNUMBER = USR21-ADDRNUMBER

CALL FUNCTION 'ADDR_GET'

EXPORTING

ADDRESS_SELECTION = ADDR1_SEL

............

Max

[andreas_mann3]

hi,

try that (join btw. adrc/adrp and usr21)

SELECT
      a~name1
      a~city1
      a~street
      a~house_num1
             INTO table usrtab
             FROM  ( usr21 AS u INNER JOIN adrc AS a
                       ON u~addrnumber = a~addrnumber )
      WHERE  u~bname = ekko-ernam.

Andreas

[former_member188685]

Hi,

Don't try to do any Query on ADRC , try to do it on <b>USR03</b> table. using the ERNAM , here you get the FAX and telephone number etc.

do it on USR03(address data of users)

Regards

vijay

[Former Member]

Hi,

First you need to get the ADRNR from USR21 table by giving USR21-BNAME = EKKO-ERNAM.

Then pass thes ADRNR to ADRC table and retreive the address of PO creator.

Hope it helps.

Regards,

Shashank