Symptom
Format of downloaded file from the app "IAM Information System" tab "Business Role - Restriction" has changed. Multiple restriction values are now displayed as separate records .
Environment
SAP S/4HANA Cloud Public Edition 2602
Cause
The changes to the download functionality were implemented to address inconsistencies and ensure alignment with UX guidelines.
The previous table and download format did not adhere to database normalization principles.
The format was updated to comply with the first normal form (1NF), which organizes data into individual rows rather than combining multiple values into a single column.
Resolution
To achieve the previous representation, convert the Excel file using formulas such as `TEXTJOIN`.
Refer to the Microsoft Support documentation for detailed guidance on using the TEXTJOIN function: Microsoft Support.
Keywords
IAM information system, restriction value, separate rows, format, export , KBA , BC-SRV-APS-IAM , Identity and Access Management , Problem
SAP Knowledge Base Article - Public