Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Default Bill to address in SQL report

Hi Experts

i need to display the data of Customers, vendor & lead, based on 'Default Bill to Address'

Eg:-  if a BP is having more than 1 Bill to address and out of that one is Default, i need to get the data like

BP NAME          BP CODE                     BP ADDRESS (Default Address)

Pls suggest how to get it solved

Regards

Former Member
Former Member replied

Hi,

Hope this will help you,

select T0.Cardcode,T0.cardname,T1.Street  from ocrd T0

Inner join crd1 T1 ON T1.CardCode=T0.cardcode AND T1.Address=T0.BillToDef

Thanks,

Shan.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question