ABAP Routine

Dear All,

I have a scenario in BI to implement ABAP.

Master data table:

GL Account Cost Center

111 ???315*

222 ?????315**

333 ?315*****

As we see that the cost center is stored in strange manner.

Now we have Transaction data coming as below:

Cost center

9993150

8153150

93150

Now as we see the pattern '315' is what we have to focus. For Cost center ???315* matches with the 9993150 and 8153150 so 111 will be picked for these two Transaction CCs. The CC ?315* matches with 93150 so 333 will be picked from master data.

I am not able to conclude how to apply routine here. its complex scenario i know. Not sure if i can use 'Contain Pattern' or what abap statement.

Please suggest.

Zabi