Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

View, Clustur & Pooled Table

Former Member
0 Kudos

Hi,

I have few questions on the above topics.

How can we retreive data from View , Clustur & Pooled Table using Select statements.

If possible can you explain me with an example.

what kind of data can we retreive from them . for example BSEC - how can we use it .

Thank you in advance.

Ry

6 REPLIES 6

Former Member
0 Kudos

hi,

You can access them using SELECT statements, you CAN NOT use joins though.

For example, BSEG is a cluster table.

report znave_0003 .

data: ibseg type table of bseg with header line.

parameters: p_bukrs type bseg-bukrs.

select * into table ibseg from bseg

up to 100 rows

where bukrs = p_bukrs.

loop at ibseg.

write:/ ibseg-bukrs, ibseg-belnr.

endloop.

to retrieve the data from a view....

Declare the internal table with the type of View.

Data : itab type table of zview001.

or write select query as

select * from zview001 into corresponding fields of itab.

Also you can uncheck the Unicode checks active (checkbox) in the program attributes.

{When you check that unicode checkbox, you should use an internal table without a header line. Instead you should declare a work area)

Hope it helps...

~~Guduri

0 Kudos

Hi Naveen,

Thank you for the reply , why is BSEG clustered table i mean what was the purpose just to have a clear picture, and what are the tables they have and how can i create a cluster , Please let me know .

Thank you.

Ry

0 Kudos

roby,

check this below link

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

bottom of this link u will find the info what ever u r looking for..

~~Guduri

0 Kudos

Thank you Naveen, Can we access this BSEG table from outside SAP system in EDI terminology , as this is a cluster table .

Let me know ,

Regards,

Ry

0 Kudos

Sorry Roby,

I don't have the idea about it...

~~Guduri

0 Kudos

Great Naveen , Anyways .Thank you very much for your reply . Let me know if you get any inputs on BSEG .