How is OCRD bound with OCQG ?

[Former Member]

Hi

I couldn't find the relation table or field between <b>OCRD</b> (Business Partners) and Properties tab table <b>OCQG</b>.

How are these 2 tables bound ?

[Former Member · Accepted solution]

the OCQG table gives you the labeml of the property

in OCRD table you have 64 properties (field QryGroupXX) where XX goes from 1 to 64.

off course, the label of property field QryGroup1 will have the label(GroupName) of property GourpCode=1 from table OCQG

[Former Member · Accepted solution]

Now I can use properties in reports.

Thanks once more Sébastien !

[AlexGrebennikov]

Hi!

as for me BPProp-feature (as well as ITMProp) isn't much convenient.

There are no any relations!!!

All you need is to write StoredProcedure (or UserDefFunction) to find out is specified property given as parameter checked or not..

Naturally the solutions depend on your problem..