Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

after adding fields on KNA1 using append structure, not null dn't work

Former Member
0 Likes
779

Hello, all.

let me ask you something.

after adding fields on standard table 'KNA1' using append structure, not null , default value doesn't work.

when I check table using data object check(utilities > data object > check), the report says like this.

Fld name Position Data Type Length Decimals Not null Default

MANDT 1 VARCHAR2 9 X '000'

KUNNR 2 VARCHAR2 30 X ' '

LAND1 3 VARCHAR2 9 X ' '

ZMBRN 178 VARCHAR2 30 X ' '

ZKUNNR 179 VARCHAR2 30

ZSEQ 180 VARCHAR2 12

fields ZKUNNR, ZSEQ doesn't check not null, default.

Any advice will help.

thank in advance.

1 ACCEPTED SOLUTION
Read only

DirkAltmann
Active Participant
0 Likes
660

Hello,

your field ZMBRN has the flag "not null".

Regards

Dirk

4 REPLIES 4
Read only

DirkAltmann
Active Participant
0 Likes
661

Hello,

your field ZMBRN has the flag "not null".

Regards

Dirk

Read only

0 Likes
660

Using 'initial values' check at SE11, I can explicitly make a filed not null.

but when I use append structure, there is no way for checking 'initial values' check at SE11.

thanks anyway.

Read only

Former Member
0 Likes
660

solved by myself

Read only

0 Likes
660

Can you explain how you solved it? I have a similar problem.

Thanks,

Jerry