I have a scenario in BI to implement ABAP.
Master data table:
GL Account Cost Center
As we see that the cost center is stored in strange manner.
Now we have Transaction data coming as below:
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.