Query Report in FX-RE

[Former Member]

Hi all,

I`ve had no luck creating a query report, neither using Table Join, nor Logical Database.

Has somebody had any similar experience?

Thanks

-S

[franz_posch]

Hi,

it is possible to create queries for RE-FX, at least using table join. Could you please describe your problem more in detail.

Regards, Franz

[Former Member]

Hi,

We need a report with following information:

Contract number (field name RECNNR) - Rental Object/Rental Unit(field name OBJIDENT) - rental unit number old (field name SALTNR)

The relationship is

Contract number : rent. object = 1 : n

Thanks

[Former Member]

Hi

It means u r asking abt SAP query or some thing else.Give more description abt ur query.

Mohan

[Former Member]

Hi,

You can make a query in SQ01 with a table join with tables VICNCN (contracts), VIBDROOCC (occupancy) and VIBDRO (rental object). The table join from VICNCN to VIBDROOCC uses the company code and the contract number. The join from VIBDROOCC to VIBDRO uses the intreno field.

All you have to do then is to select the appropriate fields.

Regards,

Jeroen