Can we write inner join between transparent table and cluster table? If both

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

Can we write inner join between transparent table and
cluster table? If both having common fields?

Question Posted / bahuddin302

8 Answers
24820 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / shilpa.p

No it is not possible to write inner join to trasperant
table and cluster table.system will generate an error wen
ever u try to join the table.

Is This Answer Correct ?

36 Yes

0 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / vineet kumar

We can only use inner join in Transparent table not in pool
or Cluster Table.

Is This Answer Correct ?

21 Yes

3 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / suryakanta

I think, Rakesh Akula had given the Exact answers to the
given questions.

Is This Answer Correct ?

8 Yes

0 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / abhijeet

no we can't

Is This Answer Correct ?

4 Yes

1 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / murali i

we can maintain the innerjoin between two transparent table
take an example is vbak and vbap but we can't maintain the
innerjoin betwenn one transparenttable and one
clustertable take an example is bkpf and bseg

Is This Answer Correct ?

2 Yes

1 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / manoranjan

No, wecan't.
1. We can use inner join conditions between two or more
transparent tables.
2. Join conditions can be used in between two pooled tables.

3. But Join conditions can't be used in between two cluster
tables.

Regards,
Manoranjan.

Is This Answer Correct ?

2 Yes

2 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / loremious ipsumus

so, what can we do?

Is This Answer Correct ?

3 Yes

3 No

Can we write inner join between transparent table and cluster table? If both having common fields..

Answer / rakesh akula

ABAP developers should not bother about the cluster and
pool tables becoz we ABAPiers are mostly concerned with
TRANSparent tables as it holds application data which is
much more important to run a organization.

IF ur interested then go for R & D by joining SAPLABS there
you get a better exposure to do this things..

Best of luck . anyways don't try to use joins between
altogether different tables it won't work.

Is This Answer Correct ?

6 Yes

9 No

Post New Answer