Updating default value of new column in SAP system

It is not good practice to update default values to a column as this will not be visible directly in the system and will not be picked by CTS. Also, there is no option in the SAP/ABAP environment of adding default values to the table column. If you choose to make the new column have NON-NULL values, you will have to manually update default values and it will take a lot of time to modify the table.  The best way is to choose your default value as spaces, zeroes and so on depending upon the type of column.

Rishi Raj

Updated on 30-Jul-2019 22:30:20

• Related Questions & Answers
• Updating only a single column value in MySQL?
• Adding a new column with the current time as a default value in MySQL?
• Authentication options in SAP HANA while adding new system
• How to modify column default value in MySQL?
• Adding new column after a specific column and defining a default in MySQL?
• Updating boolean value in MySQL?
• Updating Data source of provider by REST API in SAP
• System measurement of SAP HANA system in XML file
• Architecture of SAP HANA system
• How to revert rows to default column value in MySQL?
• Set default value to a JSON type column in MySQL?
• Default value of StringBuilder in C#
• Default value of bool in C#
• Difference between SAP ECC system and SAP BW system?
• Disabling JDBC/ODBC access to SAP HANA system for a new user