RE lease-in and Lease-out contract relationship table/link

[Former Member]

Hello RE Management experts!

I have a requirement to build a report in BW which has both Lease-in and Lease-out contract numbers, as well as polled space and rental space information on same one line.

I reviewed Occupancy table (VIBDROOCC) which gives me all the information I need up (Lease-out contract number, pooled space and rental space) on the one line. But I'm missing the lease-in contract number. I tried to link them on Business Entity , but it looks like it is too broad .

Does anyone know a table that would give the relationship between lease-out and lease-in contract?

Thanks for your help

JHN

[bowen_cao]

Hi,

the table VICNCN is used to store all of the information of contracts.

Best regards,

Bowen