How to Devlocation From Premise ?

[Former Member]

Hi Experts,

I have to code in User-Exit of TCODE ES60.

I have the Premise EVBS-VSTELLE which is just generated in USER EXIT.

Now my requirement is to get TPLNR from IFLOT of IFLOT-FLTYP = 'G' (Device Location).

Please help me how to proceed with this.

Regards,

Mohsin

[Former Member]

The relation between tables and fields.

EVBS-HAUS = EHAUISU-HAUS

EHAUISU-HAUS = IFLOT-TPLNR.

Regards,

Shiva Kumar

[Former Member]

Hi:

Put the select statement should like

select TPLNR from IFLOT where IFLOT-FLTYP = 'G' and TPLNR = evbs-haus.

Regards

Shashi

[Former Member]

Thanks a lot for your reply

But here the problem is that i have to do the coding in User-exit at time when Premise is saved (EXIT_SAPLES60_010). So here i can get only the premise which is created just now.

But the IFLOT table is not updated for this premise yet. It will be done later.

So now how to proceed?

Also my assumption is that the Premise which is just created will have the connection object which is assigned to many other premise so there can i get the TPLNR. But here also if this premise is the first to have that connection object then???

Please help.

[Former Member]

Premise will not have Functional Location

Connection Object will have the Functional Location.

So as menctioned above go to EVBS-HAUS = EAHUISU-HAUS

EAHUISU-HAUS = IFLOT-TPLNR.

You will get the TPLNR.

Just check with the connection object you will get to know .

Regards,

Shiva Kumar

[Former Member]

Hi,

We can use BAPI_ISUFINDER_FINDOBJOFDATA where u can give Object type as DEVLOC and premise as input and execute, u'll get the device location .

Regards

Haricharan

[Former Member]

HI,

Go to table IFLOT and pass pemise number to PREMS field and FLTYP as G.

Then you will get the Devicelocation.

Regards,

Saritha