Interested to Buy Any Domain ? << Click Here >> for more details...
how to combine the transparent table with cluster table.
- 1 Answers
- 4172 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / debabrata patra
We cant perform joins on cluster tables, so first get the data from cluster table(BSEG) into internal table and use SELECT..with FOR ALL ENTRIES option on transparent table(BKPF).
SELECT * FROM BSEG
INTO TABLE IT_BSEG
WHERE <CONDITION>.
IF IT_BSEG[] IS NOT INITIAL.
SELECT field1, field2 FROM BKPF
INTO TABLE IT_BKPF
FOR ALL ENTRIES IN IT_BSEG
WHERE <CONDITON>.
ENDIF.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the events in abap/4 language? : abap hr
What is an on”*-input filed” statement?
Explain what are the events used in interactive reports?
What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?
Can a filed occur in several field groups?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What are interface/conversion programs in SAP?
Abstract class and interface, multiple inheritance, live example
what is the difference between hashed & sorted internal tables?
Differentiate between table and template ?
How to get that a secondary index is attached to a select query?
What is amdp (abap managed data procedures)?
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
Example of table cluster and cluster tables.
What is a report?
