Business Partner Master Data Properties Query

[Former Member]

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?

[frank_wang6 · Accepted solution]

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

[Former Member · Accepted solution]

Really clever. Thank you.

[Former Member · Accepted solution]

Thx for Sharing !

[Former Member]

Hello Josh,

each Property has its own field. if activated value is 'Y'

empty = 'N'

first Idea is to create a query:

Select CardCode, Cardname, Qrygroup1, Qrygroup2,...

and after that use Export to Excel an make filters... Of course, it is not very smart.

Hope that helps.