How to connect the keys of two tables, which have a continuos difference?
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".
