Hi coding Experts,
I am a BW consultant.
I need a code for lookup to check the material numbers(0material) containing in base table /bic/zmat.
Where the values are described below:
For each value from flat file, it should look for corresponding value in base table and pick that value and populate in 0material.
Values from flatfile (infoobject 0material): Values in the table /BIC/ZMAT. 00.11.22.33 --> HBL00.11.22.33 90123456 --> 90123456 91122334 --> HBL91122334
Illustration: I have value 00.11.22.33 in flatfile. I have to look for HBL00.11.22.33 in /bic/zmat.
How can I do that?
Thanks in advance