topic Re: Problem with a select in Application Development and Automation Discussions

Problem with a select

Former Member — Tue, 30 Oct 2007 11:57:41 GMT

Hi, I'm looking a source code of abap report and I found that:

SELECT SINGLE * FROM *KNA1

WHERE KUNNR = *BSEG-FILKD

what does it means? The * before the name of the table

Thanks.

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 12:00:24 GMT

This *BSEG is the workarea of type BSEG.

That is also the reason why SINGLE is used

Regards

Nishant

Re: Problem with a select

former_member873340 — Tue, 30 Oct 2007 12:04:36 GMT

Hi Dani,

means that all the fields from the table table KNA1 wil be selected into the work area of KNA1.

KNA1 must have been declared as

Tables : KNA1. in the declaration part.

This declaration creates a automatic workarea of the same type as KNA1.

Do you have any other clarification please feel free to ask.

Regards

Gowri

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 12:07:12 GMT

Hi,

It means the selected data is coming in the workarea.

Reward if useful.

Regards,

Shilpi

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 12:16:29 GMT

Thanks all!!!!

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 14:19:31 GMT

I'm upgrading 4.5 to 6.0 ECC version and doesn't work if I use the same statement. Someone knows if I have to change anything? Thank you all.

Re: Problem with a select

former_member656234 — Tue, 30 Oct 2007 14:29:40 GMT

Hi,

you can use

SELECT SINGLE * FROM KNA1

INTO KNA1

WHERE KUNNR = ...

cya,

dimas

Re: Problem with a select

former_member656234 — Tue, 30 Oct 2007 14:30:39 GMT

Hi,

I meant

SELECT SINGLE * FROM KNA1

INTO KNA1

WHERE KUNNR = BSEG-FILKD.

cya,

dimas

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 15:27:58 GMT

With INTO KNA1, do you want to say INTO a work area?

Re: Problem with a select

former_member656234 — Tue, 30 Oct 2007 15:30:38 GMT

yes... select single just return one row form your table... is the same when you use select... endselect.

cya,

dimas

Re: Problem with a select

former_member656234 — Tue, 30 Oct 2007 15:40:29 GMT

sorry...

I assumed that you defined KNA1 with

TABLES KNA1.

but you're right, it's into a working area

cya,

Dimas.

Re: Problem with a select

Former Member — Tue, 30 Oct 2007 15:53:10 GMT

But, do you know why *kna1 gives error when changing from version 4.5 to 6.0 ECC?

Re: Problem with a select

former_member656234 — Tue, 30 Oct 2007 15:54:36 GMT

I don't know why... but sicerely I always use the long way ^_