Interested to Buy Any Domain ? << Click Here >> for more details...
how to combine the transparent table with cluster table.
- 1 Answers
- 4132 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 different kinds of lock modes?
What is a multiple line field?
Specify the types of data dictionary objects.
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'
What is the function of the transport system and workbench organiser?
What is your approach for writing a bdc program? : abap bdc
What is meant by search help? : sap abap data dictionary
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
Explain how to Handle the internal tables in ABAP?
What are the different window types in sapscript?
What are the two methods for modifying sap standard tables?
Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?
how to genernate 21 sencondary index
Which bdc you prefer? : abap bdc
How to convert normal function module to bapi?
