SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table for relation b/w contract account and Premise

Former Member
0 Likes
4,092

Hi All,

Could you please tell me is there any table available for relation b/w contract account and premise.

Regards,

Ram

5 REPLIES 5
Read only

Astrid_Gambill
Contributor
0 Likes
1,960

Hi Ram

Not directly, but you can join EVER to EANL on the installation number (ANLAGE) and then get the premise from EANL for contract accounts in EVER. need to be careful with your move-out dates in EVER depending on whether you are looking for all contracts for an account, or just the currently active ones.

Cheers

Astrid

Read only

0 Likes
1,960

Hi ,

I need contract account based on premise before contract creation only.

Could you please tell me is there any function modules are there.

Regards,

Ram.

Read only

0 Likes
1,960

Without a contract, there is no link between account and premise, they are unrelated master data items.

Read only

0 Likes
1,960

Without existing contract, there is no link between Contract Account and premise. But after move-in (existing contract) you can use FM ISU_STRUCTURE_READ which can help you to overcome need of table joins.

Hope it was helpful

Vlado

Read only

0 Likes
1,960

Hi,

Before the creation of the contract , you cannot link a contract account with a premise.

You can only find a realtionship b/w contract account and premise, if there is contract created, which is linked to Contract account on one side and installlation on the other which subsequently is linked to the premise.

You can use the FM 'ISU_GET_OBJECTS' to find the link b/w Contract account and premise, provided a contract exists in there.

Hope it helps....

Thanks,

Amlan