Overview
The ATT supports SAP versions 3.0d and up, including ECC 6 and ECC 7.
The ATT solution includes an ABAP/4 function module that is Remote Function Call (RFC) supported as illustrated in the diagram. This function module retrieves the requested data from the SAP Fixed Assets module or the SAP Plant Maintenance module (for plant equipment).
Diagram
The diagram below displays the components involved in the communication between SAP R/3 and the ATT software.
Details
Extracting Asset Information
Assets or Equipment may be down loaded in subsets.Three selection criteria are used to select the desired subset.These criteria are determined at installation time and stored in a configuration file. Any three of company code, class, location, plant, and cost centre may be configured as the available criteria, in any desired order.
Multiple subsets may be selected for separate sequential ranges of criteria. The down loaded data is then checked for records that contain duplicate identifier field values. If bar code labels are the host’s inventory numbers then ATT checks for records that contain duplicate inventory numbers to ensure each item scan will relate to only one record. The same check is performed if bar codes are the host’s asset/equipment numbers.
Updating SAP
The ATT updates SAP asset or equipment information by calling a TIG International ABAP/4 function module that utilises a BDC session to update each asset or equipment, one by one, as shown in the diagram to the right.
Each asset or equipment will invoke a new BDC session. Any assets or equipment that fail to update will be listed at the conclusion of the update session.
Fixed Assets are updated using SAP transaction AS02.
Supported Fields
The function module will retrieve the following data from tables within SAP R/3:| Field | Length | Description |
|---|---|---|
| BUKRS | 4 | Company Code |
| ANLN1 | 12 | Main Asset/Equipment Number |
| ANLN2 | 4 | Asset/Equipment sub-number |
| BDATU | 8 | Date validity ends |
| TXA50 | 50 | Name of asset |
| INVNR | 25 | Inventory number |
| KOSTL | 10 | Cost Centre |
| WERKS | 4 | Plant |
| ANLKL | 8 | Asset class |
| AM_SERNR | 18 | Serial number |
| RAUMNR | 8 | Room |
| STORT | 10 | Asset location |
| DET_LOC | 40 | Detailed Location |
| IVDAT | 8 | Last inventory date |
| INV_TIME | 6 | Last inventory time |
| KOSTLV | 10 | Cost centre responsible for asset |
| INVZU | 15 | Supplementary inventory specific |
| COUNTED | 1 | Counted |
| ORD44 | 4 | Evaluation group 4 |
| ORDTX | 30 | Evaluation group short description. |
| EQUNR | 18 | Equipment number |
| EQU_CAT | 8 | Equipment category |
| TPLNR | 30 | Functional location |
| OBJID | 10 | Costing number (Work Centre) |
| STATUS | 4 | Status |
| MAIN_TXT | 50 | Main text |
| INT_ORD | 12 | Internal Order |
| USER_NAME | 64 | User Name |
| MULTI | 1 | Multi |
| CONT_ID | 5 | Controller ID |
| SPARE2 | 5 | Spare 2 |
| SPARE3 | 10 | Spare 3 |
| SPARE4 | 10 | Spare 4 |
| SPARE5 | 10 | Spare 5 |
| LICENSEPLT | 20 | Licence plate number |
| SPARE7 | 20 | SPARE 7 |
| SPARE8 | 20 | SPARE 8 |
| SUBLOCTXT | 30 | Sub Location Text |
| SPARE10 | 50 | Spare 10 |