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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

find contract accounts using functional location numbers

former_member1165438
Discoverer

‎2018 Sep 17 11:16 AM

0 Kudos
1,902

Hi Experts

How can i find Contract account numbers in ISU using Functional location (IFLOT-TPLNR).

Regards,

Mbuso

4 REPLIES 4

ivor_martin
Active Contributor

‎2018 Sep 17 11:48 AM

0 Kudos
762

Hi Mbuso,

The Functional Location number is the same as the Connection Object number in the Premise table EVBS.

From EVBS, look up the Installation table EANL and get the Installation number.

Using Installation number, look up the Contract table EVER, and get the Contract Account that is still active (Move-out date > current date).

I hope this helps.

Regards,

Ivor Martin

former_member1165438
Discoverer

‎2018 Sep 17 3:16 PM

0 Kudos
762

Hi Ivor

Thank you for your help, very helpful.

regards

Mbuso

william_eastman
Product and Topic Expert
Product and Topic Expert

‎2018 Sep 17 4:30 PM

762

You can use ISU_FINDER to find the objects

daniel_mccollum
Active Contributor
In response to william_eastman

‎2018 Sep 18 2:47 AM

762

Further to this, (& from Recollection) the supported objects are:

ISUPARTNER
ISUACCOUNT
ISUCONTRCT
CONNOBJ
PREMISES
INSTLN
DEVLOC
DEVICE
BUDBILPLAN
PRINTDOC
ISUSMORDER
ISUSMNOTIF
TECHINST
ISUPOD

X_FINDPAR is the structure of inputs for selection.

so for your example:

X_OBJTYPE = ISUACCOUNT

X_FINDPAR-O_HAUS = your functional location


YT_RESULT is your Contract Account return

YT_TRACE is the bread crumbs object types & keys ISU_FINDER used to determine the result.