Get Comment field (ADDR1_DATA-REMARK) from XD03

[Former Member]

Hi.

I have to do a report and need to get some information form Customers. One of the needed information is the Comment Field (ADDR1_DATA-REMARK) in the Address tab inside the XD03 transaction.

How can I get this field? Is there a function or bapi to get it?

Thanks for your help

Regards,

Giancarlo

[former_member188076 · Accepted solution]

Hi

With reference to your Customer Code pick the ADRNR from KNA1 Table, and then with reference to this ADRNR pick the REMARK from ADRC Table.

Regards,

Amitesh Anand

[Former Member · Accepted solution]

Thank you very much Amitesh, you helped me a lot. With your info I have found that value (Remark from XD03) is not from ADRC table but it is from ADRCT table.

Thanks again for your help.

Regards,

Giancarlo

[Former Member · Accepted solution]

You can actually just link ADRCT table with LFA1 (KNA1 table may need authorization to view).  Link ADRNR in LFA1 to ADDRNUMBER in ADRCT.  The REMARKS field in ADRCT is indeed the Comments field in the basic view.  Thanks Giancarlo and Amitesh.