Connection Object and Street name

[former_member199650]

Hi,

Could anybody please specify the table name in which we can find the Connection object and Street name?

Thanks and Regards

[Former Member]

TPLNR in ILOA table you can specify connection object

where you will get ADRNR

From ADRC you can get Street

Regards,

Prajakta

[former_member199650]

Hi,

Thanks for your reply please.

I know we can go with the address no.but my question was : Table name in which we can find the connection object and the corresponding street.

As there can be many address nos can be associated with a connection object but only one street will be attached with any connection object.

Please guide.

Thanks and Regards

[Former Member]

To do this you can also use ISU_FINDER: BAPI "BAPI_ISUFINDER_FINDOBJOFDATA"

where you can specify connection object number and will get the exact street address.

Regards,

Prajakta

[former_member199650]

Hi,

Thanks for your reply please.

Could you please guide me: in which table, the entry gets populated when we enter a street name for a connection object?

Thanks and Regards

[Former Member]

Not sure about street address at Connobj level

But Street address get populated in EVBS table with Premise here you can also see HAUS conn obj number

Please check it.

Hope it solves problem

Regards,

Prajakta

Edited by: Prajakta Shringarpure on Jun 22, 2009 12:45 PM

[former_member199650]

Hi,

Thanks for the reply please.

I know about EVBS table,but suppose if the premise is not yet created and i want to know what are street names which are defined for connection objects(only unique entries).

Is this information available in any table? Please guide.

Thanks for all your support.

Thanks and Regards

[Former Member]

I dont think so such data is available in one table because from ILOA you will get only those address which are related to Conn Obj.

In ADRC this is unique record with ADRNR where you will have address street.

Regards,

Prajakta

[former_member199650]

Hi,

Please guide if any option is available.

Thanks and Regards

[Former Member]

Hi Vashishth,

Call FM 'MAM25_ML_030_GETDETAIL' and pass connection object.

You will get the street number and the address of the Connection Object in the 'FUNCLOC_HEADER' parameter.

Hope this helps.

Regards,

Manish

Edited by: Manish Bisht on Jun 22, 2009 12:14 PM

[Former Member]

Hi

I assume you're talking about the street name lookup.

The streets are in the Regional Structure.

The tables you're looking for are probably ADRSTREET and ADRSTREETT.

The key is the street code and might be stored in the address table ADRC field STREETCODE.

In case the address is not in the regional structure the street name is ADRC-STREET.

Hope that helps

Jürgen

[Former Member · Accepted solution]

Table EHAUISU you will have the connection object number.

Then go to ILOA table give the connection object number in Functional loc. and execute it.

You will get the address number. Then go to ADRC table to know the street name.

You will not find the data in a single table.

If you want to find then go to views

V_EHAU_ADDRNR : IS-U Connection Object: Optimized Access for Address Number "you will find address number for connection object.

V_EHAUADR : You will get street name for connection object.

Please let me know if you want any more details. if have any issues with answer then let me know the exact question for the same.

Thank You.

Regards,

Siva