Adding new field to a table

[Former Member]

Hi,

I have a transparent table which has two structures with several fields each of them, I added a new field to the the table outside of the structures.

So now the table looks like this:

Table Z....

Structure 1

KeyField1

KeyField2

Structure 2

Field1

Field2

NewField

Because this table already has records some of these will have blanks in the new field.

When I go to TCODE se16 or SE16n and I tried to bring all the records where the new field is equal blank or initial the result is 0 (zero) but this is not true, there are several records where the new field is blank.

Same behavior if i added the new field inside of structure2.

If I bring records for any other field it works properly when I search field = blank or initial in SE16 or SE16n.

Any clue about what can cause this behavior?

Regards,

Eduardo Campos

[Former Member]

Hi,

I have a transparent table which has two structures with several fields each of them, I added a new field to the the table outside of the structures.

So now the table looks like this:

Table Z....

Structure 1

KeyField1

KeyField2

Structure 2

Field1

Field2

NewField

Because this table already has records some of these will have blanks in the new field.

When I go to TCODE se16 or SE16n and I tried to bring all the records where the new field is equal blank or initial the result is 0 (zero) but this is not true, there are several records where the new field is blank.

Same behavior if i added the new field inside of structure2.

If I bring records for any other field it works properly when I search field = blank or initial in SE16 or SE16n.

Any clue about what can cause this behavior?

Regards,

Eduardo Campos

[Former Member]

Hola Edurado,

Have you tried adjusting the Z Table using SE14,

give it a try and then revert

Thanks

Sri

[Former Member]

Yes I tried, but still the same behavior after adjusted it

[Former Member]

I'm not sure about this one...but did you check the initial values checkbox? If not try that, and activate the table.

[Former Member]

Eduardo,

Davel is right, just tick the checkbox 'Initial Values'. If you don't tick it, it will take NULL values which are different from initial values. After you tick it, readjust the table, and then check with the relevant initial value of the field based on its data type ie (space for CHAR, 0 for NUM)

Regards,

Diwakar

[Former Member]

Thaks Davel,

This solved the issue.

[Former Member]

hai,

The new fields will be added by using DataStructures concept in ABAP.

so you better to use Data Structures concept to add new field.

thaks,

G.PavanKumar