Hi All,
We have a query that links WLK1-FILIA with MARC-WERKS.
Example: FILIA = 0001 links with WERKS = 0001 FILIA = 1004 links with WERKS = 1004
But as we undergone business process change the value of WLK1-FILIA changed. It is now like this 'Z' + MARC-WERKS.
Example: FILIA = Z0001 need to link with WERKS = 0001 FILIA = Z1004 need to link with WERKS = 1004
Now, the challenge is how do I link the two fields with minimal changes. Can I use Table View to transform the value of FILIA and chop off the leading 'Z'?
Please help.
Thanks,
Sid