Hi, I am trying to create report on the combination of EQUI, KSML and AUSP tables, to list out the equipment which meets the selection criteria on characteristics and it's values.
Note: I am not working in ABAP stack, using Native HANA to build this report.
Characteristics values are stored in AUSP table as below,
| Equipment | Equipment type | Characteristic | Characteristic Value |
|---|
| 400010 | Bridge | Char 1 | Char value 1 |
| 400010 | Bridge | Char 2 | Char value 2 |
| 40010 | Bridge | Char 3 | Char Value 3 |
With that, I may not be able to apply selection criteria given to users on Char 1, Char2 and Char 3. This is because the values are stored in one column. I may have to store the data some thing like below to make them into selections for users.
| Equipment | Equipment type | Characteristic 1 | Characteristic 2 | Characteristic 3 |
|---|
| 400010 | Bridge | Char 1 Value | Char 2 value | Char 3 Value |
do you know, if there is any other table which stores the information in this transposed way from AUSP?
if not, I have created to create view to make char 1, char 2, char 3 values in the separate columns, however, where it is not applicable it is updating blank and not coming in one row, which does not look good to users.
This is how I am getting as output of the view,
| Equipment | Equipment type | Characteristic 1 | Characteristic 2 | Characteristic 3 |
|---|
| 400010 | Bridge | Char 1 Value | Blank | Blank |
| 400010 | Bridge | Blank | Char 2 value | Blank |
| 400010 | Bridge | Blank | Blank | Char 3 value |
Can you suggest if there is any better to handle this requirement to get the report out as showing in fig 2, be able to provide the selections for those char1, char 2 and char 3. ?? Please let me know.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.