Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Create View by using the Cluster table and Transparent table

former_member541575
Participant

‎2010 Nov 08 9:45 AM

0 Likes
1,325

Hi

When i want to create a View on BSIS, BKPF, BSEG. During activation, this is throwing a error "BSEG is not Transparent table"

then i found BSEG is a Cluster Table/Pool Table. and Join can only be make on Transparent table.Please let me know how i can create view on BSIS, BKPF, BSEG OR there is some other way to fetch the data from these 3 tables.

Regards

Atul

Hi

When i want to create a View on BSIS, BKPF, BSEG. During activation, this is throwing a error "BSEG is not Transparent table"

then i found BSEG is a Cluster Table/Pool Table. and Join can only be make on Transparent table.Please let me know how i can create view on BSIS, BKPF, BSEG OR there is some other way to fetch the data from these 3 tables.

Regards

Atul

Reply
3 REPLIES 3
Read only

andreas_mann3
Active Contributor

‎2010 Nov 08 10:06 AM

0 Likes
864

use logical database SDF (goto se36)

grx

A.

Read only

JoffyJohn
Active Contributor

‎2010 Nov 08 10:10 AM

0 Likes
864

use FOR all entries instead of join..

Read only

Former Member

‎2010 Nov 08 10:15 AM

0 Likes
864

Hi Mishra,

You cannot create view for Transparent table & Cluster table.View basically transparent to transparent only recomended.if u want access to bseg table performence wise affect ur program,

For GL transactions : BSIS,BSAS Table having all fields. apart from this if its required access BSEG,U have to go BSIS-BELNR,BSIS-GJAHR, OR BSAS-GJAHR,BSAS-GJAHR to BSEG-BELNR,BSEG-GJAHR.

Rgds,

RAJ.A