![sap hana studio null handling sap hana studio null handling](https://www.kodyaz.com/images/sap-abap/sap-hana-database-table-details.png)
Today in this blog, I will explain how to use a feature in Join called Auto filling, to fill the gap on how to handle empty and null values moving forward for further processing. How can we know that we have null values present in the input or result? How can these empty and null values affect my configuration result and how can we handle it? These are several questions which pop to my mind when I do join function configuration in PaPM. In SAP PaPM, a cell can have an initial value if it was assigned with an empty record.
![sap hana studio null handling sap hana studio null handling](https://1.bp.blogspot.com/-HmtZnAmBRuE/YZyymGlMVSI/AAAAAAAAUxI/aGMP0krll70qxW_iHl0kbbRHG_1FDwA0gCLcBGAsYHQ/s982/sap_hana_studio_install_03.png)
![sap hana studio null handling sap hana studio null handling](https://blogs.sap.com/wp-content/uploads/2017/10/step8.png)
Initial (‘ ‘) does contain a value and so occupies memory.This can be achieved if a field was not assigned with values initially. Null (?) does not have any value and does not occupy memory.In SAP PaPM, both Null and Initial are represented by an empty cell for characteristic and “0” for the key figure, respectively.Īs defined in PaPM Application Help Join function section, the modeler or user must take care of these values when processing input data in Join because the response of the two values are different: SAP Profitability and Performance Management (PaPM) Join Function is referred to as a processing function that is used to combine two or more inputs, either data source function such as model table or other processing functions such as allocation and calculation, to form an enriched result based on the settings configured on the function.ĭuring data preparation or checking of results, there are two common data values which I encounter namely, Null and Initial.