Mapping Table for Employees (bcmtc1114m000)

Use this session to specify unique codes for Employees. Also the start day of employment should be specified for each employee.

Preparation

Before you can use this session, employee codes from MANMAN/HP should be loaded into this table. It is not possible to create employee codes in this session manually.

Execution

Always mandatory because duplicates are not allowed.

Process logic

There are four sources in MANMAN/HP that are used to fill the mapping table. These sources are:

  • MANDB.WCFIL (Work Center/Employee Master File)
  • MANDB.IM (Item Master File)
  • FINDB.SALMAS (Sales Agent Master File)
  • PURDB.PRAFIL (Purchase Requisition Approvers)

- MANDB.WCFIL is the normal employee table in MANMAN/HP

- MANDB.IM is needed for the Buyer field in ERP LN 6.1.

- FINDB.SALMAS is needed for the Employee field in ERP LN 6.1.

- PURDB.PRAFIL is needed for the Approver field in ERP LN 6.1.

Next to that a backflush employee is created during migration. This is done based on a parameter in the Conversion Parameters for Manufacturing (bcmti1100s000) session. The option “Generate Defaults” will generate a default value for the field ERP LN 6.1 Employee.The default value for this field is based on the first six characters of the MANMAN/HP field. Note: if the source field contains the character “ | ” or “ ‘ ”, then this character is replaced by “ - ”.

The option "Validate" will check if all mandatory fields are filled and if no duplicates exists on field ERP LN 6.1 Employee. It will create a report when errors are detected.

MANMAN Origin

MANMAN Origin

Allowed values

  • Employee (bcmtc.mori.wcfil)
  • Sales Agent (bcmtc.mori.salmas)
  • Buyer / Planner (bcmtc.mori.im)
  • Approver (bcmtc.mori.approver)
  • Not Applicable (bcmtc.mori.not.appl)

- Employee -> This value is used for fields that are derived from table MANDB.WCFIL (Work Center/Employee Master File) in MANMAN/HP.

- Sales Agent -> This value is used for fields that are derived from table FINDB.SALMAS (Sales Agent Master File) in MANMAN/HP.

- Buyer -> This value is used for fields that are derived from table MANDB.IM (Item Master File) in MANMAN/HP.

- Not Applicable -> This value is used for fields that are derived from table bcmti100.

Default value

- Employee (bcmtc.mori.wcfil)

MANMAN Employee

Employee

Default value

Loaded from MANMAN/HP. Depending on the origin the value is loaded from:

  • Table MANDB.WCFIL, field WC,
  • Table FINDB.SALMAS, field SALNUM
  • Table MANDB.IM, field BCODE
  • Table PURDB.PRAFIL, field PRALOGN
  • Table bcmti100, field bcmti100.bfem
ERP LN 6.1 Employee

ERP LN 6.1

Allowed values

Any alpha-numeric string with length up to six characters. The field must be filled and must be unique.

Default value

The default value for this field is based on the first six characters of the MANMAN/HP field.

Note: If the source field contains the character “ | ” or “ ‘ ”, then this character is replaced by “ - ”. The option "Validate" will check if all mandatory fields are filled and if no duplicates exists on field ERP LN 6.1 Late Payment Surcharge (bcmtc111.bcrs). It will create a report when errors are detected.
ERP LN 6.1 Start Date of Employment

Start Date of Employment . Any date is allowed.

Default value

The default value for this field is 03-Jan-1970