Download System Table Information from M3 to an External POS System

This document explains how you download system table information from M3 to an external point of sales (POS) system.

Note that this instruction only describes the manual flow for basic data download.


Basic system table information is transferred to the OPTRFI (triggered files) and OPTRML (triggered files mailing list) files in M3. Information is prepared in these files that enables the POS system to retrieve the system table information.

The POS system retrieves the downloaded table information and any modification made to basic data in M3 is passed on to the POS system.

When basic data is exported from M3 to the external POS system, it is available in the OPTRFI file. For each record, an action code indicates the source file (the item master file MITMAS or the customer file OCUSMA, for example) and the record information is stored in a data field.

Each record in the OPTRFI file has an associated mailing list in the OPTRML file. This is a list of shops to which each record must be sent.

Before you start

A shop must be created in 'Shop. Open' (OPS500) and the 'POS system interface' field must be selected in (OPS500/G).

Follow these steps

  1. Start 'POS Table. Transfer' (OPS619/B).

  2. Specify a report version identity of your choice in the 'Report version' field. Select Create to display the E panel.

    Report versions are stored under an identity of your choice in a separate file containing sets of selections and sorting parameters for created reports.

  3. On the E panel, specify a warehouse (=shop).

    If no warehouse is specified, system table information will be exported to all POS-interfaced shops.

  4. Enter selections for constant value and key value. Press Enter to display the B panel.

    All M3 system tables are stored in the CSYTAB file. The constant value is used to identify the table to which a CSYTAB record belongs. For example, CSYTAB records with the 'ITGR' constant value refer to the item group table defined in 'Item Group. Open' (CRS025). The key value corresponds to the data entered in M3. For example, the key values in the item group table correspond to the item group identities entered in (CRS025).

  5. On the B panel, select your report version and select option 9=Run to perform the download.

    The OPTRFI and OPTRML files are updated and the information is ready to be retrieved by the POS system. The action code is 'RTVTAB'.

Related topics