Ansicht
Dokumentation

RC1TCG11_02 - Filling Customizing Table for Table-Based Value Assignment

BAL Application Log Documentation   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Purpose

This program creates entries in the table TCG11_VAI (EHS: Table-Based Value Assignment of Specifications). The entries in this table control the table-based value assignment of specifications, that is, they control in which value assignment types you can assign values to which characteristics and other data in value assignment tables, and how the data is displayed in the value assignment tables.

Integration

You can call this program in the IMG activity Set Up Table-Based Value Assignment. In this IMG activity you can also check and change the generated table entries.

Prerequisites

• You are authorized to change specification value assignments (authorization object C_SHES_TVH).

• Table TCG11_VAI is not being processed by any other application because a lock is set for this table when this program is started.

Features

You can use the program to fill the table initially and to update the table entries because the program does not delete or change any existing entries. If you have added a characteristics to the the class of a value assignment type in the classification system, for example, the next time you run this program, it creates a data record for this characteristic, that is, it creates a new row for this characteristic in table TCG11_VAI.

Notes:

• The system assigns sequential numbers to the column numbers and positions in the data records for the value assignment types. As a result, the data record for a new characteristic is assigned the highest column number and position when the program is run again, which means that it appears in last position at the end of the value assignment table, even if you inserted the characteristic at another position in the class when you defined it in the classification system.

• If you have deleted the data record for a characteristic manually from the table TCG11_VAI for a value assignment type, but this characteristic is still assigned to the class for the value assignment type in the classification system, the data record for the characteristic is created again in table TCG11_VAI when you run this program.

The program creates entries in the table TCG11_VAI for all value assignment types you selected. Data records for these value assignment types are created as follows:

• If you have entered a specification type in the selection screen, it is assigned to the data records to be created. The settings then only apply for the table-based value assignment of specifications of this specification type. If you have not entered a specification type, the system creates data records without assigning a specification type. The system takes these settings into account if you assign values in a specification of a certain specification type for a value assignment type for which no data record exists in which the specification type was specified explicitly.

Example:

For the value assignment type Density, data records were created for the characteristics A, B, and C to which the specification type Real substance was assigned. In addition, data records were created for the same value assignment type for the characteristics A, C, and D to which no specification type was assigned. If you want to assign a value to the density of a real substance, columns appear in the value assignment table for the characteristics A, B, and C. When you assign values to the density of a specification of another specification type, columns appear for the characteristics A, C, and D.

If you want to create entries for several specification types, run this program a number of times and specify one of the required specification types each time.

• The system creates a data record for each standard object of the value assignment instance that you selected on the selection screen. This means, for example, that if you set the Sort Sequence indicator, the system creates corresponding data records for all value assignment types and thus displays the sort sequence of the value assignment instances in the value assignment table. If you also select the Editable indicator, you can change the sort sequence in the value assignment table.

If you do not create a data record for a standard object of the value assignment instance, but you want to include this object later in the value assignment table, you can do this by running this program again and setting the indicator for the required standard object of the value assignment instance.

For more information about the fields Additional Information 1-5, see the C1B40001 documentation.

• The system creates a data record for each characteristic that was defined in the classification system for the class of the value assignment type. The following applies here:

• The column position is numbered sequentially and chosen so that the sequence of the characteristic columns in the value assignment table corresponds to the sequence of the characteristics in the class.

• The column width for characteristics is set to the length of the language-dependent characteristic description. This means the program sets the column width specifically for each language.

• The Standard Sort Field indicator is set for the first characteristic of the value assignment type with a single value assigned.

• The Editable indicator is set for the characteristics that were defined as editable in the classification system.

• The Required Entry Field indicator is set for the characteristics that were defined in the classification system as requiring an entry.

• You can specify for individual value assignment types whether the assigned phrase-enabled characteristics (data type CHAR) appear as the phrase text, phrase code, phrase code and text in the table-based value assignment. Phrase text is set by default. The settings selected here for the phrase representation apply to all phrase-enabled characteristics of the value assignment type.

You can configure the phrase representation for the individual characteristics of a value assignment type in the activity Set Up Table-Based Value Assignment of the Customizing activity Set Up Table-Based Value Assignment.

If Phrase Code or Phrase Code and Text is selected for a characteristic but a phrase code does not exist for the assigned phrase, only the phrase text is displayed.

• If you have entered a user-defined text type on the selection screen, the system creates a data record for this user-defined text type and assigns the column width to it that you entered on the selection screen. If you have not entered a user-defined text type, no data record is created for user-defined texts.

If you want to enter user-defined texts of several user-defined text types in the value assignment types in the value assignment table, you must create an entry for each user-defined text type. To do so, run this program a number of times and specify one of the required user-defined text types each time.

• The system creates a data record for displaying the usage of the value assignment type. If you have entered a function module on the selection screen, by means of which the usage data is displayed, the system assigns it to the data record. The function module C107VAT_USAGE_STRDOUT is delivered with the standard system; it outputs the values of the usage (rating, validity area category, and validity area) in combination.

In the table-based value assignment, each data record, that is each line in the table TCG11_VAI, corresponds to a column in the value assignment table. This program numbers the objects within a value assignment type in such a way that the columns in the value assignment table are structured in the following sequence:

1. Standard objects of the value assignment instance
2. Characteristics
3. User-defined text of the specified user-defined text type
4. Usage

Output

After the program has been run, a message informs you how many data records were inserted. If an error occurs, an error message is displayed and the program is terminated if necessary.

Activities

We recommend that you create a variant and run the program in the background.

rdisp/max_wprun_time - Maximum work process run time   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 10378 Date: 20240601 Time: 060116     sap01-206 ( 210 ms )