topic Re: Problem when trying to insert matnr in flat table in Application Development and Automation Discussions

Problem when trying to insert matnr in flat table

Former Member — Thu, 20 Aug 2009 15:00:04 GMT

Hi,

I have a S600 table which is part of LIS.. iam trying to insert past records.. but the field matnr alwasy is recorded without zeros (eg. 900 instead of 000000000000000900)... i trying with CONVERSION_EXIT_ALPHA_INPUT function just before the insert from itab the field have 000000000000000900 but after the insert the field in S600 have 900

Any clues please

Best regards

Juan

Re: Problem when trying to insert matnr in flat table

Former Member — Thu, 20 Aug 2009 15:09:42 GMT

Hi,

Are you just viewing records in table S600?

When it will be displayed without ZEROs?

While extracting, in result internal table, it will be with ZEROs. While display it may change through Conversion Exit specified in its Domain.

Check out & reply.

Yours,

R.Nagarajan.

We Can

Re: Problem when trying to insert matnr in flat table

Former Member — Thu, 20 Aug 2009 15:21:42 GMT

Hi,

Thans for the reply....

When I see with SE16 no zeros in the records that i inserted... with zeros in data that system insert in delivery date event... any way when i check with mcsi no name in material only the 900 this is cause in the field its recorded as 900

Best regards

Juan

Re: Problem when trying to insert matnr in flat table

Former Member — Fri, 21 Aug 2009 03:56:28 GMT

Hi Juan Carl,

ideally to add leading zeros Fm 'CONVERSION_EXIT_ALPHA_INPUT' is used but since you said its not working in your case .

You can try out Concatenate Stament .

You can add leading Zeros to the number :

concatenate l_zero l_num into l_withzero .

You can also use Move statement if you know the size of input integer .

Declare a variable(i_max) of size greater then the input variable(i_input) and then use move statement .

Move i_input to i_max .

This will also add zeros to your integer .

You can also refer to the following link it wil surely help you since there are so many possibilities :

hope it works for you .

Thanks and Regards.

Aditi Wason