Copy Company Data (tccom0214m000)

This session is one step in the procedure to copy company data. Refer to To copy a multicompany structure for details.

Use this session to correct the company numbers and/or the enterprise-unit codes in the company-data export files before you import the export files in the database tables of the target companies.

LN changes the specified source-company numbers in the target-company numbers and the specified source enterprise-unit codes in the target enterprise-unit codes in those database-table fields in which the company- number domain (tcncmp) and the enterprise-unit domains (tcemm.grid and tgbrg.unit) occur.

You can run this session multiple times. For example, you can first run the session to change the company numbers, and then run the session again to change some or all of the enterprise unit codes.

To replace company numbers

Replacing company numbers is mandatory.

If you copy a structure of multiple companies:

  1. Create the dumps using the Create Sequential Dump of Table (ttaad4226m000) session. As directory for the table files you enter <directory>/#COMP# in the Directory for Table Files field. Subdirectories are created for each company specified in the company range.
  2. Specify <directory>/#COMP# in the Directory for Table Files of the Copy Company Data (tccom0214m000) session. This session is used to process all the files in the subdirectories where the files in subdir 1711 are the pre-dumps of company 1711 etc. The files in the 1711 subdir must end with 1711.S. Else, they are skipped.

To replace enterprise units

You must only replace enterprise unit codes if the following conditions are both true:

  • The source companies and the target companies use the same central company.
  • The enterprise units in the target companies are linked to different financial companies than the enterprise units in the source companies.
Note: Not the company's, but the user's package combination determines the data to be copied.

Field Information

Specify Field Separator

Specify the field separator that is used in the sequential files that contain the exported data of the current company: this is the same separator as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.

The field separator can be one of the following:

  • A pipe (|)
  • A caret followed by one uppercase alphabetic character, for example, ^A, ^B, and so on.
Directory for Table Files

The directory where the sequential files of the current company are stored. This is the same directory as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.

Companies to Copy

Select this check box to replace the source-company numbers in the company-data export files by the target-company numbers.

If you only want to change the enterprise unit codes in the company-data export files, you must clear this check box.

Companies to Copy

Enter the source company numbers and the corresponding target company numbers by which they must be replaced. If you copy a number of companies that form a structure, you must specify all the company numbers of that structure.

The following rules apply:

  • You can specify the company numbers in any order.
  • The source company number and the target company number are separated by a greater-than symbol (>) only. For example: enter 400>600 if the source company is 400 and the target company is 600.
  • The source company > target company number combinations are separated by a semicolon (;).
  • Do not include spaces.

Be careful when typing the input values for this field. Source company numbers for which you do not specify a target company number in this field are not changed. This may be very wrong because, after loading the sequential files, the target multicompany structure will contain references to the source companies.

Example

A multicompany structure, consisting of companies 400, 401, 402 and 403, is copied as follows:

  • Company 400 to company 600
  • Company 401 to company 601
  • Company 402 to company 602
  • Company 403 to company 603

You must enter 400>600;401>601;402>602;403>603 to correct the company numbers in the sequential files.

Enterprise Units to Copy

Select this check box to replace the source enterprise unit codes in the company-data export files by the target enterprise unit codes.

You must only change enterprise unit codes if the following conditions are both true:

  • The source companies and the target companies use the same central company.
  • The enterprise units in the target companies are linked to different financial companies than the enterprise units in the source companies.

If you only want to correct the company numbers in the company-data export files, you must clear this check box.

Enterprise Units to Copy

Enter the source enterprise unit codes with the corresponding target enterprise unit codes.

The following rules apply:

  • You can specify the enterprise unit codes in any order.
  • The source enterprise unit code and the target enterprise unit code are separated by a greater-than symbol (>).
  • The source enterprise unit code>target enterprise unit code combinations are separated by a semicolon (;).
  • The enterprise unit codes can consist of up to six characters. Longer codes are truncated on the right. For example, EU001235 results in EU0012.
  • LN changes all lowercase letters to uppercase.
  • Do not include spaces.

Note

The target enterprise unit codes must be present in the central company.

Example

The following replacements must be made in the company-data export files:

  • Enterprise unit code EUL2F2 must be replaced by EUZ2F2
  • Enterprise unit code EUL3F2 must be replaced by EUZ3F2
  • Enterprise unit code EUL3F4 must be replaced by EUZ3F4

You must enter EUL2F2>EUZ2F2;EUL3F2>EUZ3F2;EUL3F4>EUZ3F4 to correct the enterprise unit codes in the sequential files.

Related topics