Problem with a select

[Former Member]

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.

[Former Member]

Hi,

It means the selected data is coming in the workarea.

Reward if useful.

Regards,

Shilpi

[Former Member]

This *BSEG is the workarea of type BSEG.

That is also the reason why SINGLE is used

Regards

Nishant

[former_member873340]

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

[Former Member]

Hi,

It means the selected data is coming in the workarea.

Reward if useful.

Regards,

Shilpi

[Former Member]

Thanks all!!!!

[Former Member]

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.

[former_member656234]

Hi,

you can use

SELECT SINGLE * FROM KNA1

INTO KNA1

WHERE KUNNR = ...

cya,

dimas

[former_member656234]

Hi,

I meant

SELECT SINGLE * FROM KNA1

INTO KNA1

WHERE KUNNR = BSEG-FILKD.

cya,

dimas

[Former Member]

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

[former_member656234]

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

cya,

dimas

[former_member656234]

sorry...

I assumed that you defined KNA1 with

TABLES KNA1.

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

cya,

Dimas.

[Former Member]

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

[former_member656234]

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