topic Create View by using the Cluster table and Transparent table in Application Development and Automation Discussions

Create View by using the Cluster table and Transparent table

former_member541575 — Mon, 08 Nov 2010 09:45:44 GMT

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

Re: Create View by using the Cluster table and Transparent table

andreas_mann3 — Mon, 08 Nov 2010 10:06:15 GMT

use logical database SDF (goto se36)

grx

Re: Create View by using the Cluster table and Transparent table

JoffyJohn — Mon, 08 Nov 2010 10:10:58 GMT

use FOR all entries instead of join..

Re: Create View by using the Cluster table and Transparent table

Former Member — Mon, 08 Nov 2010 10:15:12 GMT

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