Table for Item & IO Object link

[Former Member]

Hello Gurus,

Can you please give me any leads regarding the tables for finding an IO that is object linked to an Item.

Thank you,

Vasanth

[Former Member]

Check the table rpm_obj_link. Pass the object link type and item GUID to get the data.

Cheers

Amit

[Former Member]

Thanks Amit.

I have already tried this table but it does not necessarily give only the IO's for a particular Item. issue is we have 2 IO's for a cProject and only one of them has expenses other was created by mistake via cproject acc integration. As the roll up happens at Item we have object linked only the IO with expenses but when I look in the above table I see both the IO's even though theother was not actually linked to the Item.

Thanks

Vasanth

[Former Member]

Vasanth,

Please let me know the below points

1) How have you assigned internal order to portfolio item?

2) What is the object type for both records of internal orders in rpm_obj_link?

Cheers

Amit

[Former Member]

1. Yes

2. ZRPMINTORDER

Thanks

Vasanth

[Former Member]

Hi Vasanth,

It is quite strange that you have asssigned only one internal order to portfolio item manually. But in the backend, there are two records in table rpm_obj_link for that particular item.

Is it the consistent behaviour for many items?

Any other strange finding wrt this issue.

Cheers

Amit