topic Re: String between two patterns in Application Development and Automation Discussions

String between two patterns

Former Member — Sat, 10 Jun 2017 07:31:33 GMT

Hi All,

We have a table where there are two columns called material_from and material_to. Here ‘Z’ stands for alphanumeric character.

I need to get the key fields for a material if the material is in between material_from and material_to.

For example: if the material code is 23030232A6 then I need to get the key field as 0002 and 3.

Please help.

regards,

Re: String between two patterns

larshp — Sat, 10 Jun 2017 08:07:48 GMT

Do you need the theoretical possible material numbers, or the materials that exist in database table MARA?

Re: String between two patterns

Sandra_Rossi — Sat, 10 Jun 2017 09:15:05 GMT

It sounds like a very basic question. Use "LOOP AT table WHERE material_from <= material AND material_to >= material" or "SELECT key FROM table WHERE material_from <= material AND material_to >= material" to answer your question "how to know if material is in between material_from and material_to".

Re: String between two patterns

RaymondGiuseppi — Mon, 12 Jun 2017 06:36:18 GMT

Could you first check for activation of any conversion-exit for material number in your current system, if yes convert the material id to check to external format before writing the very simple LOOP AT WHERE statement.