Skip to Content

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

Business Partner Master Data Properties Query

Hi there

I am trying to write a query that will display all of the BP's with more than 1 property ticked. I'm not too sure which table that data is stored in or how it's linked to OCRD - the OCQG table seems to just be a table of group names.

Any suggestions?

Tags:
Former Member
replied

HERE YOU GO.

Just add all QryGroup4 until QryGroup64.

SELECT * FROM OCRD

WHERE ASCII (QryGroup1) + ASCII (QryGroup2) + ASCII (QryGroup3) .......

+ ASCII (QryGroup64)  > 78 * 63 + 89 * 1

Frank

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question