topic Re: Can we write a code in this query. in Application Development and Automation Discussions

Can we write a code in this query.

Former Member — Tue, 11 Nov 2014 08:49:02 GMT

Dear experts,

I would like to map these tables together : LIPS,LIKP,and LTAK.

But in case there are no Transfer order exist , system will respond "No data was selected" (actually , it existed in LIPS and LIKP )

So I would like to know can we write a code or change something in this query so that if it cannot find any Transfer order it still show the data but let the Transfer order field blank .

P/s : I think this question is about coding so I posted it in here ,if it's not correct please move it to suitable group

Thanks and Best Regards,

Huong

Re: Can we write a code in this query.

SimoneMilesi — Tue, 11 Nov 2014 08:52:05 GMT

If you need just TANUM, i suggest you to add LTAK as Additional field and read it in coding part of the query, event "Record elaboration" so you can manage any message you want.

Re: Can we write a code in this query.

Former Member — Tue, 11 Nov 2014 08:58:30 GMT

Hi Simone,

Please advise me about the code.

How is it should be ? I am not an abaper so I cannot write it ?

Thank you so much.

Huong

Re: Can we write a code in this query.

SimoneMilesi — Tue, 11 Nov 2014 09:03:56 GMT

hello,

you can try something like


CLEAR tanum.
SELECT SINGLE tanum INTO tanum FROM ltak WHERE vbeln = likp-vbeln
                                                            AND lgnum = likp-lgnum

Re: Can we write a code in this query.

Former Member — Tue, 11 Nov 2014 09:51:31 GMT

I tried another one and it's ok.Thank you so much for you help.

Re: Can we write a code in this query.

Former Member — Tue, 11 Nov 2014 15:14:53 GMT

Hi Simone,

I thought it worked but it didn't.The Transfer order always show "00000000".

Please check and advise.I also tried with additional table and field.These are the code :

In case of table :

And in case of field :

Re: Can we write a code in this query.

SimoneMilesi — Tue, 11 Nov 2014 15:30:59 GMT

Since TANUM is NUMC, if you do not have a record in LTAK, 000000 is correct.

Anyway, try to move your coding in

Re: Can we write a code in this query.

Former Member — Tue, 11 Nov 2014 15:50:51 GMT

Dear Simone,

The issue is that when we have the TO number but system still show "0000000".

And could you please advise me about the code :

I move it into code field but nothing happen.I still got the error.What should I do now ?

Could you please show it step by step .Thank you so much.