Interested to Buy Any Domain ? << Click Here >> for more details...
how to combine the transparent table with cluster table.
- 1 Answers
- 4257 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
How to eliminate duplicate entries in internal tables? : abap data dictionary
What are advantages and disadvantages of logical data base
What is alv programming in abap?
Difference between open sql and native sql? : abap data dictionary
how to capture the errors in bdc Call transaction method?
How we can give authorization on the fields of table control in a dialog-programming?
How are the function code handles in flow logic?
What is the disadvantage of using exec sql statement in abap?
What is the difference between commit-work and rollback-work tasks?
How do you delete duplicate records from internal table?
Can we include customizing include or an append structure with pooled or cluster tables?
What are extracts?
What are match codes? describe?
What is an interactive report? What is the obvious difference of such report compared with classical type reports?
Explain how do you use structures in the abap programs?
