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 |
Some Realtime Objects on Bdc.
What is an abap dictionary? : abap data dictionary
Define abap/4 layer?
What is the difference b/t Session method and call transaction method ??
1 Answers Campus Interview, ERP Solutions,
what is MSEG,MKPF?
If u r working with call transaction method .any problem occurs error records r stored in BDCMSGCOLL structure.How do u find that an error has occured at a particular point,how can u handle to rectify and process it successfully? If a file has 10000 records where 3 records doent having right format,how do u tackle with this issue either by using call transaction or session method to transfer data perfectly into database table?tell me the steps how to procede?
Why do we need enhancements?
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
what is the impact of issuing of worning message inside the event of start of selection?
What are the data types of the abap/4 layer? : abap data dictionary
What is up-casting and down casting? with example
Explain V2 updates