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

Published on 14-Dec-2017 05:14:28

• 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
• Architecture of SAP HANA system
• System measurement of SAP HANA system in XML file
• Default value of StringBuilder in C#
• Default value of bool in C#
• How to revert rows to default column value in MySQL?
• Set default value to a JSON type column in MySQL?
• Difference between SAP ECC system and SAP BW system?
• Disabling JDBC/ODBC access to SAP HANA system for a new user