topic Re: regarding first 12 digits in Application Development and Automation Discussions

regarding first 12 digits

Former Member — Mon, 12 Sep 2005 11:25:04 GMT

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 — Mon, 12 Sep 2005 11:31:39 GMT

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 — Mon, 12 Sep 2005 12:35:34 GMT

Hi Sanijay,

i think you mean :

SELECT SINGLE MATNR INTO P_MATNR FROM MARA

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

Andreas

Former Member — Mon, 12 Sep 2005 12:41:49 GMT

Hi Andreas ,

Thanks . that was a typo.

Cheers .