cancel
Showing results for 
Search instead for 
Did you mean: 

Adding a text column to a condition table to fill free text

florianbus
Contributor
0 Kudos

Hi everyone,

how can I add new column to a condition table where I can enter free text for a record?

Example is the material substitution.

I have a condition table KOTD901 and want to add a free text field that can be maintained during creation of a condition record using VB11.

Thank you!

Florian

Accepted Solutions (1)

Accepted Solutions (1)

former_member208991
Participant
0 Kudos

Hi Florian,

You can add this field to the condition table in customizing.

For this, you must field include this field in the field catalog, then add it to the the table used in the relevant access sequence.

Please let me know if you need any more details.

Regards

Nikhilesh

florianbus
Contributor
0 Kudos

Hi Nikhilesh,

so far I was able to create a data type and assigned it to structure KOMPDZ.

Now I also created the condition table but the text field has to be filled for each entry. How can I change it to just be an optional field?

Thank you!

Florian

florianbus
Contributor
0 Kudos

Hi Nikhilesh,

another question.

How can I make sure, that it's not possible to enter the same line twice (one with text and one without)?

Example as it works now:

entered Material______Text________Material

123 4711

123 Mattext 4711

Example as it should work (only one line for combination of entered Material and Material should be allowed):

entered Material______Text________Material

123 4711

or

123 Mattext 4711

Thank you!

Florian

former_member208991
Participant
0 Kudos

Hi Florian,

This is the catch here.

Since this field is part of the Condition Table, it is used to search for condition records. If you leave this field blank, then there could be performance problems during the search.

So a simple option would be to enter a "." in this field.

I can't think of any other way.

Regards

Nikhilesh

former_member208991
Participant
0 Kudos

Hi Florian,

If you mark the other fields in this table as key field, then the system will not allow you to enter duplicate values in these fields. You can leave this field as non-key, and also mark it as a footer field.

Regards

Nikhilesh

Answers (0)