find contract accounts using functional location numbers

[Former Member]

Hi Experts

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

Regards,

Mbuso

[ivor_martin]

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 Member]

Hi Ivor

Thank you for your help, very helpful.

regards

Mbuso

[william_eastman]

You can use ISU_FINDER to find the objects

[daniel_mccollum]

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.