Hi,
I have 100 records in a table, how to read every 7Th record
each in that...
Answers were Sorted based on User's Feedback
Answer / vamshi reddy chaduvu
Try this sample code..........
REPORT ZHGSL__TEST.
DATA: IT_KNA1 TYPE STANDARD TABLE OF KNA1,
IT_KNA2 TYPE STANDARD TABLE OF KNA1,
WA_KNA1 LIKE LINE OF IT_KNA1.
DATA: T TYPE I.
SELECT * FROM KNA1 INTO TABLE IT_KNA1 UP TO 100 ROWS.
DO .
T = SY-INDEX * 7.
READ TABLE IT_KNA1 INTO WA_KNA1 INDEX T .
IF SY-SUBRC EQ 0.
APPEND WA_KNA1 TO IT_KNA2.
ELSE.
EXIT.
ENDIF.
ENDDO.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_CALLBACK_PROGRAM = SY-CPROG
I_STRUCTURE_NAME = 'KNA1'
TABLES
T_OUTTAB = IT_KNA2
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
Is This Answer Correct ? | 37 Yes | 1 No |
Answer / bala
LOOP AT IT_KNA1 INTO WA_KNA1.
T = SY-TABIX / 7.
IF T EQ 0.
APPEND WA_KNA1 TO IT_KNA2.
ENDIF.
ENDLOOP.
Is This Answer Correct ? | 7 Yes | 10 No |
What is PS structure
What are the basic components of dialog program?
give examples of pool,cluster tables
what is the difference b/w database and data dictionary?
When to use logical database?
How many lists you can have in a Interactive Report?
why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.
what is text symbol and standard symbol?
Explain the advantage of structures?
hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.
what do u mean by one to one relationship in the database of transparent and many to one relation in pooled table could please tell me the answers i couldnt understand the concepts
how to invoke smart forms from a program ?