topic Re: Re : Error in look up code in Application Development and Automation Discussions

Re : Error in look up code

sri_harsha2 — Tue, 15 Jan 2013 04:50:30 GMT

Hello Gurus,

I have an issue with the code, I wanted to do a look up for the code my requirement is that in order to fill the field called end user I need to do a look up on condition below

if <COPA table>- customer is initial

then fill up the value end user from the field ZZ_LISD from ZGLT( custom table )

if not then fill the value of end user from the field ZZ_KUNE from ZGLT

end user = ZEND

for this requirement I have written the look up code as

IF <COPA>- ZCUST = 'initial' ( throwing error in this line )

select ZZ_LISD

into <COPA>-ZEND

from ZGLT

else

select ZZ_KUNE

into <CO-PA>-ZEND

from ZGLT

this was the code I tried to write for the look up but it was throwing syntax errors. I have declared the fields above the code. I request you know if I am making any mistakes in the code. Thanks in advance.

Thanks,

Re: Re : Error in look up code

Former Member — Tue, 15 Jan 2013 05:19:30 GMT

Checking Whether a Field Symbol is Assigned.

<COPA>

or Check dis Sample Programs given by SAP .

DEMO_FIELD_SYMBOLS_ASSIGN_COMP

DEMO_FIELD_SYMBOLS_ASSIGN_DECI

DEMO_FIELD_SYMBOLS_ASSIGN_ERR

DEMO_FIELD_SYMBOLS_ASSIGN_TYPE

DEMO_FIELD_SYMBOLS_CASTING

DEMO_FIELD_SYMBOLS_CASTING_TYP

DEMO_FIELD_SYMBOLS_DYNAMI_AS_1

DEMO_FIELD_SYMBOLS_DYNAMI_AS_2

DEMO_FIELD_SYMBOLS_DYNAMI_AS_3

DEMO_FIELD_SYMBOLS_STAT_AS_OF2

DEMO_FIELD_SYMBOLS_STAT_AS_OFF

DEMO_FIELD_SYMBOLS_STAT_ASSIGN

DEMO_FIELD_SYMBOLS_STRUCTURE

DEMO_FIELD_SYMBOLS_TYPE

Regard's

Smruti

Re: Re : Error in look up code

former_member491621 — Tue, 15 Jan 2013 06:48:55 GMT

Hi sri,

Please check if the Field symbol <COPA> is of same type of the table COPA or any fully typed structure.

And the syntax is wrong

Try writing it as

IF <COPA>- ZCUST IS INITIAL.

The answers above are based on assumption. Please copy and paste the syntax error you are getting(if possible) and also the declaration part of the field symbol

Hope this helps. Do revert back you require anything

Re: Re : Error in look up code

sri_harsha2 — Mon, 21 Jan 2013 20:36:59 GMT

thank you smruthi and Aniket