material number suffix

[Former Member]

hi gurus ,

i have a join which fetches material number but i also want those material numbers with suffixes attached to it e.g thersa

material 100678 ,100678T ,100678UYT ,

my select query should return all three material

so what should be the where condition for my join

[Former Member]

hi gurus ,

i have a join which fetches material number but i also want those material numbers with suffixes attached to it e.g thersa

material 100678 ,100678T ,100678UYT ,

my select query should return all three material

so what should be the where condition for my join

[Former Member]

You can use LIKE option in where condition.

where matnr like '100678%'.