Interested to Buy Any Domain ? << Click Here >> for more details...
when you are using 2 internal table in program, you have
decided to use for all entries statement to retrieve data
but unfortunately there are no records in the first internal
table. What will be the result? (2nd internal table contains
records).
- 2 Answers
- 5149 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin gautam
If the first itab[] is initial, then it will select all the rows of the table because we are comparing two tables with where condition.
There are two important tips:
1. Declare all primary keys of your database table in your select statement. It ensures that you have no duplicates in you hit list
2. Check that the table used in the "For all entries" statement is not empty. This avoids executing the select statement if no result is expected.
Please refer the following example code:
IF LT_OBJNR[] IS NOT INITIAL.
SELECT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
KSTAR
HRKFT
VRGNG
VBUND
PARGB
BEKNZ
TWAER
into table LT_WKG
FROM COSP
FOR ALL ENTRIES IN LT_OBJNR
WHERE OBJNR = LT_OBJNR-OBJNR.
ENDIF.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a modification assistant?
What is a table attribute?
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
Explain the advantage of structures?
How can we create callable modules of program code within one abap/4 program?
what precautions or prerequisites do you follow to update a record into database table and how
Advantages and disadvantages of different types of bdc's?
What functions does a data dictionary perform? : abap data dictionary
How do you read files from the presentation server ? : abap bdc
Explain data dictionary in abap?
Define alv programming in abap?
Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.
What are the two ways for restricting the value range for a domain ?
What is the disadvantage of a call by reference?
What will you code in start-of-selection & end-of-selecton & why?
