How can I use '*' in a select operation on a database?

[yalcin_mete]

Hi Masters,

I have multiple AUFNRs. I want to perform a join operation on the CDHDR table as *AUFNR* in the SELECT operation.

Method one: 
I am not allowed to concat multiple expressions.

Second method: 
LIKE does not work for multiple data.

How can I solve this situation? 

Thanks

[Ryan-Crosby]

You should be able to use the order values directly in your query of CDHDR instead of LIKE.

[yalcin_mete]

Hi @Ryan-Crosby 

AUFNRs are returned as 3006597 (7 characters) in SAP PP module.
CDHDR keeps it in a different way in database. Users cannot know this shape.

Note: I wanted to write in the comment section but the page gives an error so I had to write in the "answer" section. I apologize for that.

,

[Ryan-Crosby]

I'd look into using some of the functions/class APIs for reading change documents then instead of doing it directly with SQL.