Skip to Content

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

Territory on Business Partner

Hello,

I have a Business Partner set up as a Customer. I need to know which SQL Table the Territory is stored in.

In looking at System Information it does not give my any Table Information and I can not find any information on where it is stored.

Thanks for any help.

Paul

replied

Hi Paul,

The key field to link the OCRD (Business Partner) table and the OTER table is a field called Territory in the OCRD. This maps to the territryID field in the OTER table. The SQL will look something like:

SELECT T0.CardCode, isnull(T1.descript, '') FROM OCRD T0 left outer join OTER T1 ON T0.Territory = T1.territryID

Hope this helps,

Owen

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