topic Re: after adding fields on KNA1 using append structure, not null dn't work in Application Development and Automation Discussions

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

Former Member — Tue, 18 Jan 2011 03:27:45 GMT

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.

DirkAltmann — Tue, 18 Jan 2011 12:54:46 GMT

Hello,

your field ZMBRN has the flag "not null".

Regards

Dirk

Former Member — Wed, 19 Jan 2011 02:05:11 GMT

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.

Former Member — Wed, 19 Jan 2011 02:08:16 GMT

solved by myself

Former Member — Thu, 05 May 2011 14:11:04 GMT

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

Thanks,

Jerry