‎2011 Feb 22 6:57 PM
Hi All,
Could you please tell me is there any table available for relation b/w contract account and premise.
Regards,
Ram
‎2011 Feb 22 7:12 PM
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
‎2011 Feb 22 7:27 PM
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.
‎2011 Feb 22 7:33 PM
Without a contract, there is no link between account and premise, they are unrelated master data items.
‎2011 Feb 22 9:43 PM
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
‎2011 Feb 22 11:21 PM
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