Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Symptom


Indicator that NOT NULL IS forced for this field

* When the table is initially created, the SE14 database object shows all columns as no null. Once the table is populated

Environment

  • SAP release independent
  • NetWeaver AS ABAP

Resolution

This is normal behavior of SAP DDIC tools.

  1. if I add a newnot null field. This does not propagate to the SE14 database object as not null.
  2. To bring the database object back in sync, requires that the table be converted in SE14.
  3. Once this is done, all the columns will be not null again.
  4. So in your current state, new fields on inserted rows will be not null but to retroactively bring the database object
    back in sync, you will need to execute the conversion in se14.
  5. With some include strucutres on the table. When performing this action is not possible set default value manually, system will try to do so
    automatically.
  6. If the table is empty, does not contain entries, system will successed.
  7. However table contains data, system cannot do that as there is some NULL values for these columns on the database.
  8. So it is necessary to use SE14 tool to force conversion and update NULL values for Initial values. After that system will reconstruct this table and
    flag it as NOT NULL.

To adjust this table and force NOT NULL flag you can proceed as
indicated below:

 - SE14
 - Table Name
 - Extras -> Force Conversion

It should convert whole table and force NOT NULL flag for new fields

  • No labels