Suppose, you have already loaded data into your DataStore object (advanced) and want to add new elements (InfoObjects or fields). You may know the remodeling toolbox that is available through the SAP BW/4HANA cockpit, which allows you to manually define rules for replacement of existing data, or for deriving new values. In addition, an expert can now define a rule using JSON. This rule is then applied to the existing data by a remodeling job.
The following use cases apply:
Fill with constants and fields of local table
Fill with fields from at least one other table
Remodeling with JSON is integrated into the Remodeling dialog box. You choose the Field by JSON option and enter your JSON code which must include the type of field derivation, such as formula or attribute, followed by details. In addition to defining a rule, other functions are available for validation, formatting, and for data preview.
In a JSON based rule, you can use the permitted SQL functions listed in the documentation which is a subset of the SQL functions available in SAP HANA.
Note that the system does not check whether the data types of the result of the formula match the data type of the field during the definition and check. As a user, you have to check this yourself.
References
For more details refer to following sources: