Rental object (RE-FX) connectivity with building

[sravya_ch]

Hello All,

Building had rental objects in it which i can see in table VIBDRO as well VIBDBU.

Sample example(VIBDBU)

Object id          Company code  IMKEY

BX78912345    1000                 000053

Sample Example (VIBDRO)

Object id     Company Code   IMKEY      asset id    asset assignment

iM0009          1000                  000053    200061     +09

IM0010          1000                  000054    200061     +10

IM0011          1000                  000055    200061     +11

here in the above example first 2 records belong to building(BX78912345).Want to know from which table i can get the object id of VIBDRO table 

Thanks In advance

Sravya

[rajkumarnarasimman · Accepted solution]

Hi Sravya,

Building number is available in VIBDRO table in Field SGENR, it will relate the VIBDRO and VIBDBU table.

Regards

Rajkumar Narasimman

[sravya_ch · Accepted solution]

Hello Narasimman,

Thanks for your answer,SGENR will not provide unique ness.

For a building if there are 3 rental object , i want to get only that 3 .

Thanks ,

Sravya