topic Re: Regarding Select data from *BSEG in Application Development and Automation Discussions

Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 10:30:15 GMT

Hi Experts,

I am studying the logic of an ABAP in which data has been fetched by a select statement like this

SELECT * FROM *BSEG

When i double clicked on *BSEG, system says *BSEG does not exist. Also, there is no table as *BSEG in ABAP dictionary.

Please let me know what does *BSEG signifies and what it is ?

Thanks in advance,

Akash Sawant

Re: Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 10:33:25 GMT

Hi,

*Bseg will be used by SAP standard program. it denoted the old value of BSEG table.

in our coding we cant use *BSEG. use BSEG

Regards,

Niyaz

Re: Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 10:41:37 GMT

Hi Niyaz,

Thanks for quick reply. Can you please ellaborate what does this *BSEG means and when it should be used as i am not aware with it.

I saw it used in the custom ABAP.

Thanks,

Akash

Re: Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 10:48:20 GMT

Hi Akash,

If you declare *BSEG means its acts as a structure for the corresponding DB table.

Check this sample code,

tables : mara, *mara.

DATA : ITAB LIKE TABLE OF *MARA WITH HEADER LINE.

SELECT * FROM *MARA INTO TABLE ITAB.

LOOP AT ITAB.
WRITE : ITAB-MATNR.
ENDLOOP.

Thanks,

reward If Helpful.

Re: Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 10:58:15 GMT

<b>The real reason of * infront of the table is to open up a new workarea and during R/2 hard time, we use it to let us allow reading the same table</b>

<b>select * from bseg.

...

select * from *bseg

where ...

...

endselect.

...

endselect</b>

Re: Regarding Select data from *BSEG

Former Member — Fri, 12 Oct 2007 11:19:37 GMT

Hi Viji,

Sorry, i didn't get you. If *mara is acting as a structure for table mara then how could we use select statement over it for data fetch. Please explain.

And, what's the need of declaring *mara ?

Thanks,

Akash