regarding first 12 digits

[Former Member]

hey guys,

I want to compare JANCODE 12 digits from table mara

but i could not check..how to do this.i tried like this

but not working

ZTEMPJAN = p_ltab_jan+0(12).

SELECT SINGLE MATNR INTO P_MATNR FROM MARA

WHERE EAN11+0(12) = ZTEMPJAN.

In EAN11 i have to take first 12digits and want to compare with ZTEMPJAN and take MATNR.

how to do this.

ambichan.

[Former Member]

hey guys,

I want to compare JANCODE 12 digits from table mara

but i could not check..how to do this.i tried like this

but not working

ZTEMPJAN = p_ltab_jan+0(12).

SELECT SINGLE MATNR INTO P_MATNR FROM MARA

WHERE EAN11+0(12) = ZTEMPJAN.

In EAN11 i have to take first 12digits and want to compare with ZTEMPJAN and take MATNR.

how to do this.

ambichan.

[Former Member]

Hi

You cannot use WHERE EAN11+0(12) = ZTEMPJAN.

ZTEMPJAN = p_ltab_jan+0(12).

CONCATENATE ZTEMPJAN '%' INTO ZTEMPJAN .

SELECT SINGLE MATNR INTO P_MATNR FROM MARA

WHERE EAN11+0(12) LIKE ZTEMPJAN.

But it will select first MARA entry where first 12 chars matches p_ltab_jan+0(12).

Cheers.

EAN11 matches

[andreas_mann3]

Hi Sanijay,

i think you mean :

SELECT SINGLE MATNR INTO P_MATNR FROM MARA

WHERE <b>EAN11</b> LIKE ZTEMPJAN.

Andreas

[Former Member]

Hi Andreas ,

Thanks . that was a typo.

Cheers .