Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
AB
Contributor

Purpose


The purpose of this little series of blog posts is to provide an orientation to working with equipment addresses in customer developed programs. In prior blog posts, we looked at how addresses are managed. Now in this blog post, we look at how to read equipment addresses.

This is the third blog post in the series, which has the following structure.

  1. Equipment Address Management - introduction

  2. Equipment Address Management - a closer look

  3. Equipment Address Management - reading and searching for addresses

  4. Equipment Address Management - creating Equipment with an address

  5. Equipment Address Management - creating an address for equipment


On y va!

Reading an address


Once you have an address number, reading an address is quite straightforward. We will start assuming you have the address number, and explore further below how we might start if we don't have the number.

The approach to reading is as follows:
data selection type addr1_sel.
data result type addr1_val.

selection-addrnumber = '1212345678' . " Your address number

* Get the address and load into management tables
call function 'ADDR_GET'
exporting address_selection = selection
importing address_value = result
exceptions others = 0.

* Do something with the information

* Clear the local memory
call function 'ADDR_MEMORY_CLEAR'
exceptions others = 0 .

Note well the clearing of the memory of address management at the end. Ensures the state of address memory is completely reset.

If you need to read many addresses, then exchange ADDR_GET with ADDR_GET_ARRAY. As above, don't forget to clear the local memory.
call function 'ADDR_GET_ARRAY'
..
call function 'ADDR_MEMORY_CLEAR'

Finding the address number via equipment


If you have the equipment number, but don't have the address number, then the database view EQUI_ADDR is your friend. The view will provide you the address number and some address details also.
DATABASE VIEW EQUI_ADDR

This view is provides a selection across tables EQUZ, ILOA and ADRC .

If you only need the details that this view provides, it is a lighter approach than going via business address services.

Finding the equipment address over Business Address Services


If you have the equipment number, but don't have the address number, then you can alternatively determine the address number over the Business Address Services address where used.
DATABASE TABLE ADRV

SELECT * FROM ADRV
WHERE APPL_TABLE = 'EQUI'
AND APPL_FIELD = 'EQUNR'
AND APPL_KEY = <CLIENT> + <EQUIPMENT NUMBER WITH LEADING ZEROS>

I don't recommend this approach - it results in a full table scan of the address where used table ADRV. In productive systems, this table can be very large.  The usage in ADRV should match up with the details provided by EQUI_ADDR.

Who is using an address?


If you have an address number, and would like to know whether it is shared between equipment, functional locations or indeed other business objects, then the address where used of Business Address Services is again helpful.
DATABASE TABLE ADRV

SELECT * FROM ADRV
WHERE ADDRNUMBER = 'ADDRESS NUMBER'

This will provide you the details of all objects using the address.

Search for equipment using address details


You have some address details and you wish to find the equipment. Often a sufficient approach is to use the database view EQUI_ADDR. The view starts with ADRC and then joins to ILOA to EQUZ to reach the equipment.
DATABASE VIEW EQUI_ADDR

Searching for addresses using address details


If you need to search addresses, then the search function of Business Address Services may well be useful. It provides more details of the address than the view EQUI_ADDR provides.
data selection type addr1_find.
data results type standard table of addr1_val.
data groups type standard table of adagroups.

" Search for addresses in Riverstone NSW
selection-city1 = 'Riverstone'.
selection-region = 'NSW'.

" To restrict to addresses used in PM, insert
" group = 'PM01' into groups

CALL FUNCTION 'ADDR_SEARCH'
importing
SEARCH_FOR = selection
tables
ADDRESS_GROUPS = groups
SEARCH_RESULT = results
exceptions
...

 

Summary


Phew! Lots of little snippets of code - more like a cook-book to look up than a novel to read!

From this third blog post, you should now have a better understanding of how to read and search for addresses of equipment, either using Business Application Services or via equipment specific application tables.

In the next and final blog post, we will look at what we can do to create and maintain addresses of equipment from customer developed programs.

Till then.