Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 19, 2015 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 06:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded