Skip to Content

Getting address for Business Partners shown in WEB UI using HANA SQL

Hi, I am new to SAP and am required to extract using SQL in HANA the mailing addresses of business partners that are listed in the WEB UI. Each business partner listed has a single address associated with the transaction they have been listed against. I am using links from crmd_orderadm_h via crmd_link to crmd_partner. I then use addr_nr from crmd_partner to link to adrc, which I believe should be the address I am seeing on the WEB UI screen. This however does not always correspond. On Web UI screen sometimes partners show with no address, yet when I run my query they are shown to have an address via this method. It is like the Web UI is storing address links somewhere else, but where. A lot of people have asked about addresses and are told to get them by linking to BUT000 then BUT020, then to ADRC, but this returns all addresses associated with the partner, not the single address associated with the partner and the transaction. Any help is greatly appreciated. I've spent ages searching for an answer to no avail.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers