topic Re: ABAP PROBLEM!! in Application Development and Automation Discussions

ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 16:37:38 GMT

I am reading a table from a database into an internal table.

one of the fields in this table is MATNR and is displayed as ****( 4 to 8 character digit). I am comparing it agnist an other internal table field matnr which is '000000000000*****) 18 char field.

my problem is when i compare these fields they do not match because of the extra zero.

i.e 12345 <> 000000000000012345

how can i change the program to mach these fields..

Re: ABAP PROBLEM!!

ferry_lianto — Fri, 02 Feb 2007 16:39:03 GMT

Hi,

You can use this FM CONVERSION_EXIT_MATN1_INPUT to add leading zeros for matnr or FM CONVERSION_EXIT_MATN1_OUTPUT to delete leading zeros for matnr.

Then you can compare both fields.

Regards,

Ferry Lianto

Re: ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 16:39:32 GMT

Hi VJ,

Use Conversion exit on MATNR before doing comparision.

For this use FM 'CONVERSION_EXIT_MATN1_INPUT' to add leading zeros and compare this field with inerntal table field.

Thanks,

Vinay

Re: ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 16:40:01 GMT

Hi,

Use function module CONVERSION_EXIT_ALPHA_INPUT. And pass the material no to it before comapiring.

This will solve your problem.

Reward points if helpful answer.

Ashvender

Message was edited by:

Ashvender Kumar

Re: ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 16:42:30 GMT

Hi,

You can also use use SHIFT for the field MATNR which has the format "000000000000******".

Example

DATA: V_MATNR TYPE MATNR VALUE '000000000TEST'.

SHIFT V_MATNR LEFT DELETING LEADING '0'.

Thanks,

Naren

Re: ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 16:56:55 GMT

Hi,

this should solve your problem.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = V_MATNR

IMPORTING

OUTPUT = V_MATNR.

Regards

Vara

Re: ABAP PROBLEM!!

Former Member — Fri, 02 Feb 2007 17:26:53 GMT

HI,

simple code...

<b>LOOP AT ITAB.

UNPACK ITAB-MATNR TO ITAB-MATNR.

MODIFY ITAB TRANSPORTING MATNR.

ENDLOOP.</b>

now u can compare...

or u can use those conversion exits also.

<b>LOOP AT ITAB.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = ITAB-MATNR

IMPORTING

output = ITAB-MATNR.

MODIFY ITAB TRANSPORTING MATNR.

ENDLOOP.</b>

now itab-matnr has also..000000000001234 = 0000000000001234 ( table field)

Regards

SAB

Re: ABAP PROBLEM!!

Former Member — Thu, 29 Nov 2007 16:11:47 GMT

"UNPACK ITAB-MATNR TO ITAB-MATNR" is the fast method rather then calling FM each time thru the loop.