Versions Compared

Version Old Version 1 New Version 2
Changes made by

ProNovia

ProNovia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

<REFMAT(...)> with parameters allows accessing data from a reference material using the handler REFMAT:MMS. See REFMAT:MMS Access to data of a reference material for a general definition of "reference material".
In parentheses following parameters separated by ; must be specified:

For material master tables

For characteristic values

1. table name

1. CLAS

2. field name

2. characteristic name

3. additional key values
The material number is evaluated using the definitions or by enhancement. Here additional keys for accessing the corresponding table can be specified, multiple values separated by /.
This keys are optional, see REFMAT:MMS for how the keys are evaluated if not specified. The material number
Used in a value group * as key is supported:
If in a value group for a value to be set access to REFMAT is made and for a key value of this access * is specified, then this key value will be replaced by the corresponding key of the value group.

3. class type
This parameter is optional, default value is 001.

...

  • <REFMAT(MARA;LABOR)>
    • The laboratory/office from the basic view of the reference material is used.
  • <REFMAT(MARC;DISPO)>
    • The MRP controller from the plant view of the reference material is used. This from the same plant as the processed plant of the active material (see notes in REFMAT:MMS).
  • <REFMAT(MARC;DISPO;3300)>
    • The MRP controller from the plant view of plant 3300 from the reference material is used.
  • <REFMAT(MVKE;PRODH;/)>

    • The product hierarchy of the sales view is read. For the key (sales organization and distribution channel) the same value as used in the actual value group will be used, which is the sales view currently created or maintained

      .

      Image Removed

      *Use of wild card character **
      When REFMAT is used in a value group in field "Set Value", then for the field name the wild card character * can be used. Details see Fieldnames with wild card *.

      Image Removed

      It should be noted that due to the different requirements, the parameters and their sequence in the special value <REFMAT (...)> and the handler REFMAT: MMS in the filter are different

      .