Can we write inner join between transparent table and
cluster table? If both having common fields?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / suryakanta
I think, Rakesh Akula had given the Exact answers to the
given questions.
Is This Answer Correct ? | 8 Yes | 0 No |
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 |
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 |
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 |
What is the Tcode for System Dump?
Can a filed occur in several field groups?
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
What is an interface? In what scenario we use interface? What is the difference between abstract class and interface?
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
what is difference b/w like and type statements?give example? when to use like and when to use type?
how to Implemented a BAPI to upload Payroll summary information into SAP R/3 system
IF I SAVE A TRANSACTIONAL DATA TABLE IN APPL0 INSTEAD OF APPL1 DURING TECHNICAL SETTINGS OF A NEW TABLE WHTHER IT WILL CREATE ANY PROBLEM OR IT WILL WORK SMOOTHLY???
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
can please tell me the differences b/w bapi & bdc?
Can you print decimals in type n? What is difference between float and packed data type?
what are the events triggered in report?which tigers first?