Interested to Buy Any Domain ? << Click Here >> for more details...
how to combine the transparent table with cluster table.
- 1 Answers
- 3555 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 many secondary indexes can we create in a table?
In events, start-of-selection is a default event. When we have to use this event explicitly? Why?
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
How will you define posting procedures?
Explain Catch Command in ABAP?
In which cluster time results are stored? : abap hr
How do you document abap/4 programs? Do you use program documentation menu option?
How to select valid lines for secondary list?
How do you display a data in a detail list?
how do you transport lsmw data from one system to another?
What are different data types in abap/4?
What are the uses of table pool or table cluster.
What is sap script? Describe its components.
In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?
In which particular scenario we use sorted table and which particular scenario we use standard table?
