06-10-2017 8:31 AM
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,
06-10-2017 9:07 AM
Do you need the theoretical possible material numbers, or the materials that exist in database table MARA?
06-10-2017 10:15 AM
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".
06-12-2017 7:36 AM
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.