give me a code which should validate in sap datasphere to concatenate 01 to the FSCL_YR AND FSCL_MNT based on below example for example, if we have 202405 year month in table, then 20240501 and then add month which will be 20240601

In SAP Datasphere (formerly known as SAP Data Warehouse Cloud), you can use SQL-like expressions in calculated fields to manipulate and format your data. Based on your requirement to concatenate "01" to the year and month values and generate a date-like value, you can use the following example to create a calculated field. Assuming you have a table that includes a column `FSCL_YR` (Fiscal Year) and a column `FSCL_MNT` (Fiscal Month), here’s how you can concatenate "01" to create the desired output: ### SQL Expression Example ```sql -- Assuming your table name is "your_table_name" SELECT FSCL_YR, FSCL_MNT, CONCAT(CONCAT(CAST(FSCL_YR AS VARCHAR), RIGHT(CONCAT('0', CAST(FSCL_MNT AS VARCHAR)), 2)), '01') AS DATE1, DATEADD(MONTH, 1, CONCAT(CONCAT(CAST(FSCL_YR AS VARCHAR), RIGHT(CONCAT('0', CAST(FSCL_MNT AS VARCHAR)), 2)), '01')) AS DATE2 FROM your_table_name ``` ### Explanation 1. **Concatenation**: - `CAST(FSCL_YR AS VARCHAR)` converts the fiscal year to a string. - `RIGHT(CONCAT('0', CAST(FSCL_MNT AS VARCHAR)), 2)` ensures that the month is always two digits (e.g., "04" instead of "4"). - The concatenation of `FSCL_YR`, `FSCL_MNT`, and "01" forms a string in the format `YYYYMMDD`. 2. **Date Calculation**: - `DATEADD(MONTH, 1, ...)` adds one month to the constructed date. ### Result - **DATE1** will give you the result for the current year and month with "01" added (e.g., for `FSCL_YR` = 2024, `FSCL_MNT` = 05, it gives `20240501`). - **DATE2** will return the first day of the next month (e.g., for `FSCL_YR` = 2024, `FSCL_MNT` = 05, it gives `20240601`). ### Note - Adjust the field names based on your actual data structure. - Ensure that your environment supports the SQL syntax used in this example.