Export Data from System Table CSYTAB

The CSYTAB table is used by several programs with data used for different purposes. Each program has a 'Constant value', which defines the records in CSYTAB that belong to which program. For instance, constant value SMCD is used for the salesperson program in 'Salesperson. Open' (CRS100). The constant value is not visible in M3, so it is difficult to know which programs use constant values.

CSYTAB also have fields for division or language code. Depending on the table, these two fields are either:
  • Not used, or always blank. Constant value SMCD, used by (CRS100) uses neither division nor language.
  • Mandatory, or never blank. Constant value FATP, used by 'FA Type. Open' (FAS075) always requires a division.
  • Optional, which means can either be blank or contain a value. Constant value TEDL, used by 'Delivery Term. Open' (CRS065) can both have a blank or a specified language code.

CSYTAB also stores information in the 'Parameter' field, where several different data fields are stored together as one text string. As some of the programs using CSYTAB can have different variations in different countries, the 'Parameter' field can contain different kinds of data for the same constant value.

Because of these characteristics, exporting and importing data from CSYTAB can be complex. Program 'CSYTAB. Export' (CMS240) has been created to be able to export data from CSYTAB in a simpler manner.

Limitation

Not all constant values found in CSYTAB have been enabled to be exported through (CMS240). Some of the records are not intended for export and import, or have not yet been enabled.

Follow these steps

  1. On (CMS240/B), view the records for a 'Constant value'. It is possible to browse on 'Constant value' to see available constant values. You can also open the related program that is using the constant value through F18='Open'.
    Note: It is possible to define a sorting order for the browse window that sorts on programs instead. This is done through 'Object' CMM240 and 'Table' CMM24010 in 'Sorting Order in Browse Window. Open' (MNS180). See Create Sorting Order Displayed in Browse Windows.
  2. To export CSYTAB data, use F17='Export' which takes you to the export panel (CMS240/H). Depending on the type of constant value, 'Division' and 'Language' fields are visible.
  3. Select 'Keep selected divisions(s)' if division from the source should be imported. If 'Keep selected divisions(s)' is not selected, the user's division is used when importing and it is only possible to export one division at a time.
  4. The exported file can be located by opening 'Configuration Data Jobs. Open' (MNS200). Use sorting order 4, then specify the file name and start date. Use alternative 20='Display XML file' to download the XML file as a compressed zip file.

If the 'Auth indivd pgm' parameter in System Settings. Open (MNS090) is set to 1-'Individual browse program', you must authorized the user to the program where the data for the constant value is defined to access and export the information. For example, the user is authorized to function (CRS100) to access data with constant value 'SMCD'.

Related topics