Contents

Summarize existing text modules

Select a client for which the text modules best matches all clients.

For this client, change the client to '000' in the GENERAL COMPANY PARAMETERS and set the existing text modules to client '000'.

update firma_t set mandant_txt = '000' where mandant = 'ABC'
update txtko_t set mandant = '000' where mandant = 'ABC';
update txtpo_t set mandant = '000' where mandant = 'ABC';
update txtvar_t set mandant = '000' where mandant = 'ABC';
update txtvarparam_t set mandant = '000' where mandant = 'ABC';
update txtmandant_t set mandant = '000' where mandant = 'ABC'

Limit clients in the text modules

The text modules that should not be available to all clients must now be assigned to the individual clients. In the text modules, the client must therefore be set from 000 to the respective authorized client.

Customize client text modules in company parameters for all clients and delete old text modules

In all clients in the GENERAL COMPANY PARAMETERS, set the text module client to client '000' and delete old existing text modules that are no longer required:

update firma_t set mandant_txt = '000' where mandant_txt <> '000'

delete from txtko_t where mandant <> '000';
delete from txtpo_t where mandant <> '000';
delete from txtvar_t where mandant <> '000';
delete from txtvarparm_t where mandant <> '000';

Delete any remaining text modules via script

delete from txtko_t where mandant <> '000';

delete from txtpo_t where mandant <> '000';

delete from txtvar_t where mandant <> '000';

delete from txtvarparm_t where mandant <> '000';