Skip to Content
0
Former Member
May 17, 2010 at 10:26 AM

Routine (to look values from /bic/zmat table)

106 Views

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