Default Address

[Former Member]

Dear Experts,

How can I get the Business Partner's default address. ? Plz help me in query.

Regards

[ANKIT_CHAUHAN · Accepted solution]

Hi Kuldeep,

There are 2 fields in OCRD Table named as ShipToDef and BillToDef. You can use the same for that.

Hope it helps.

Thanks & Regards

Ankit Chauhan

[Former Member · Accepted solution]

Hi,

Can you please explain and create some sample query ?

Regards

[ANKIT_CHAUHAN · Accepted solution]

Hi Kuldeep,

Try this:

Select  T0.[ShipToDef] , T1.[Street], T1.[Block], T1.[ZipCode], T1.[City], T1.[Country], T1.[State] FROM OCRD T0 JOIN CRD1 T1 ON T0.CardCode = T1.CardCode AND T0.[ShipToDef] = T1.Address WHERE T0.[CardCode]  = 'CARDCODE'

Hope it helps..

Thanks & Regards

Ankit Chauhan

[Former Member · Accepted solution]

Hi,

Thank you for reply. I was looking for the same.

But if there are multiple address then what to do ?

Regards

[ANKIT_CHAUHAN · Accepted solution]

Hi Kuldeep,

In that case you need to use the field AdresType From CRD1 Table.

Also you can have a look on LineNum Field in the CRD1 Table.

LineNum represents the addresses as it appear in SAP Application Address tab of the Business Partner Master Data.

Also you can refer these Links:

Hope it helps.

Thanks & Regards

Ankit Chauhan

[Former Member · Accepted solution]

Hi

I will check it and reply you about the same.

Regards

[Former Member · Accepted solution]

Hi,

Thank you. Problem Solved.

Regards