Cannot modify Item

[Former Member]

Hi,

when I modify an Item in "Item master data" appears the message:

"Cannot insert the value NULL into column ItemCode in table  .....AITM. Column does not allow nulls: INSERT FAILS ".

The SAP version is 8.82 PL7.

Any solutions?

Thanks

Marco

[KennedyT21 · Accepted solution]

HI Marco Gazzato

746615  - Cannot insert the value NULL into column 'ACRD' ; column does not allow nulls (ACRD)

According to this note.

check with the following query

Select * from CUFD where TableID in ('oitm','aitm') order by FieldID

Solution

To identify if your DB is affected, please run the below SELECT query:

Select * from CUFD where TableID in ('oitm','aitm') order by FieldID

Compare the SizeID and EditSize columns where FieldID is same in two tables.

If there are differences, please contact Support Center.

***Change table name 'oitm','aitm' to the required one.

Regards

Kennedy

[Former Member]

HI Marco Gazzato,

    Check have you used any UDF in this master with some selection criteria in this.

    Remove you existing history from display settings screen (log message).

Regards,

Venki .A