topic Re: Unicode error in Application Development and Automation Discussions

Unicode error

Former Member — Wed, 23 Jan 2008 19:01:03 GMT

Hi All,

I am getting an error in upgradation.

The error is

"The column name "RLDNR" has two meanings . ."

The code is like this.

types: begin of t_fmifiit,

FMBELNR TYPE FMIFIIT-FMBELNR,

fikrs type fmifiit-fikrs,

fmbuzei type fmifiit-fmbuzei,

btart type fmifiit-btart,

rldnr type fmifiit-rldnr,

GJAHR TYPE FMIFIIT-GJAHR,

stunr type fmifiit-stunr,

FONDS TYPE FMIFIIT-FONDS,

HKONT TYPE FMIFIIT-HKONT,

TRBTR TYPE FMIFIIT-TRBTR,

KNBELNR TYPE FMIFIIT-KNBELNR,

KNBUZEI TYPE FMIFIIT-KNBUZEI,

ZHLDT TYPE FMIFIIT-ZHLDT,

WRTTP TYPE FMIFIIT-WRTTP,

end of t_fmifiit.

DATA I_FMIFIIT TYPE STANDARD TABLE OF T_FMIFIIT WITH HEADER LINE.

SELECT FMBELNR

fmifiit~fikrs

fmbuzei

btart

rldnr

fmifiit~GJAHR

stunr

FONDS

HKONT

TRBTR

KNBELNR

KNBUZEI

ZHLDT

WRTTP

INTO TABLE I_FMIFIIT

FROM FMIFIIT

inner join bkpf

on fmifiit_{bukrs = bkpf}bukrs and

fmifiit_{knbelnr = bkpf}belnr

WHERE fmifiit~FONDS LIKE C_FONDS

AND fmifiit~WRTTP IN (C_54,C_66)

AND fmifiit~HKONT in s_hkont

AND bkpf~bukrs = c_copa

and bkpf~cpudt BETWEEN P_PRUNDT AND P_CRUNDT.

Please help me to solve this issue.

Thanks,

Naveen

Re: Unicode error

Former Member — Wed, 23 Jan 2008 19:11:45 GMT

Hi,

The error means that RLDNR field is both the tables you ate trying to join.

Use fmifiit_{RLDNR or BKPF}RLDNR instead of RLDNR.

Thanks,

Vamshi

Re: Unicode error

Former Member — Wed, 23 Jan 2008 19:12:33 GMT

I think it's saying that RLDNR is a field in both FMIFIIT and BKPF. You need to qualify it in the field list. What release are you on?

Rob

Re: Unicode error

Former Member — Wed, 23 Jan 2008 19:22:38 GMT

Hi Vamshi,

Thanks for replying. I replaced with fmifiit~RLDNR. It is working.

Rob: I am using ECC 6.0. Upgraded from 4.6c to ECC 6.0

Thanks,

Naveen

Re: Unicode error

Former Member — Wed, 23 Jan 2008 19:30:53 GMT

RLDNR was added to BKPF in this upgrade, so it has nothing to do with Unicode.

Rob