Skip to Content
-2

String between two patterns

Jun 10, 2017 at 07:31 AM

70

avatar image

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,

untitled.png (17.8 kB)
10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sandra Rossi Jun 10, 2017 at 09:15 AM
0

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".

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Jun 12, 2017 at 06:36 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded