Hello,
I have a KEY that I want to use connecting two tables with:
| Table 1 | | | Table2 | |
| Shelf No. | Material | Area | Error Report No. | Description |
| 7894 | fsfdafsdfsd | Sector2 | 11111111 | (9910)7894 |
| 6666 | sdfdsfs | Sector33 | 22222222 | (9910)6666 |
| 1234 | dfsdsfsfs | Sector1 | 33333333 | (9910)1234 |
| 7845 | sdfdsfdd | Sector65 | 4444444 | (9910)7845 |
As you can see I have a Table 1 with Shelf ID and the Location of the shelf. Table2 is an error report. In column "description" we told workers to scan the QR- Code of the specifi shelf, where trouble occurred. Unfortunately the barcode-scanner also always scans the prefix (9910) of the QR-Code as well. So even though incident report of (9910)7845 of table2 is referring to 7845 of table1, I don't get the 2 keys linked with each other.
Now I have problem connecting these two tables with that key. Is there a kind of workaround or "ignoring" the (9910) prefix? Note, that Table2 is a SAP derived table which contains alls sorts of errors reports inside the company and not only shelf related reports. For instance in the "description" field could also be a plain text like "Line34 Malfunction".
Hope someone has a solution for me.
Stay safe!
Thanks in advance.
the Values in "Description"
