topic Add zero in Application Development and Automation Discussions

Add zero

Former Member — Fri, 23 Nov 2007 09:57:12 GMT

Hi Experts,

I have one field like MATNR. Its data type is char(18).

Now my problem is I wrote select querry based on matnr. if it is 100 means it didn't retrieve the data from the data base.

So I used to unpack command and adds 15 zero's to matnr and its working fine.

But if the Matnr is 'M-10' means its shows run time error. So how can I add zeros before to the parameter matnr at run time.

Thanks,

Points Assured.

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:00:40 GMT

overlay matnr with '000000000000000000'.

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:00:56 GMT

ALFA ALPHA conversion

CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal

CONVERSION_EXIT_ALPHA_OUTPUT Conversion exit ALPHA, internal->external

Re: Add zero

asik_shameem — Fri, 23 Nov 2007 10:01:30 GMT

use the FM conversion_exit_alpha_input

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:01:43 GMT

Hi,

Use FM CONVERSION_EXIT_MATN1_INPUT & CONVERSION_EXIT_MATN1_OUTPUT on matnr field.

Reward Points if this helps,

Regards,

Satish

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:06:19 GMT

use this fm

CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal

CONVERSION_EXIT_ALPHA_OUTPUT Conversion exit ALPHA, internal->external

hope this helps you

Reward pts if useful..

Sreenivas

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:07:30 GMT

Before the material is passed into the where clause of select

Use the conversion routine conversion_exit_matn1_input or

conversion_exit_matn1_output .

This u can see in the domain of the matnr field type .

apply this .

Regards,

Vijay.

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:14:13 GMT

Hello

Please do this

DATA : L_MATNR(18).

write 'M-10' to L_MATNR right-justified.

overlay L_MATNR with '000000000000000000'. "18 zeros.

L_MATNR will now have data as per your format.

Reward points if useful

Regards

Saket Sharma

Re: Add zero

harimanjesh_an — Fri, 23 Nov 2007 10:24:21 GMT

Hi Jasmine,

Use conversion exits. It will convert ur input data into format that is stored in database.

For example, Matnr = 2340 is stored as 000000000000002340.

So use conversion exit 'CONVERSION_EXIT_MATN1_INTPUT'

check this sample code.....

PARAMETERS : p_matnr TYPE mara-matnr.

DATA : w_matnr TYPE mara-matnr,

t_mara TYPE STANDARD TABLE OF mara.

START-OF-SELECTION.

CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'

EXPORTING

input = p_matnr

IMPORTING

output = w_matnr.

SELECT * FROM mara INTO TABLE t_mara WHERE matnr = w_matnr.

IF sy-subrc = 0 .

WRITE : / sy-dbcnt.

process ur logic.

ENDIF.

Reward me if useful.........

Harimanjesh AN

Re: Add zero

Former Member — Fri, 23 Nov 2007 10:30:01 GMT

Hi Jasmine,

Either u can use FM CONVERSION_EXIT_MATN1_INPUT

CONVERSION_EXIT_MATN1_OUTPUT to convert data in your required format.

or u use

ovelay l_matnr with '000000000000000000'.

write: l_matnr.

If it is usefull pls reward pts.

Regards

Srimanta

Re: Add zero

Former Member — Fri, 23 Nov 2007 11:05:14 GMT

I already checked with CONVERSION_EXIT_ALPHA_INPUT.

But its not working when the material number is m-10 (character means).

Any way thanks for the Effort.

Re: Add zero

Former Member — Wed, 14 Jul 2010 15:27:24 GMT

I have a similar issue. Have you got any solution to this?