2008 Jan 20 1:28 PM
Dear Exprts,I
n a flat file 10,000 records are there, in this each session having 1000 records? How to Process those? Can we run in one job schedule?
Thanx in Advance.
Program your BDC such a way that.
For every 1000 records, have a new session.
Loop at your main internal table (Table with 10,000 records),
Build a another internal table with 1000 records (We call it as ITAB2).
If SY-Tabix eq 1000 or
SY-Tabix eq 2000 or
Sy-tabix eq 3000.....goes on till 10000.
Open Group, Create a new session.
Insert your 1000 records from ITAB2.
Close Group.
Refresh ITAB2. clear ITAB2.
endif.
Endloop.
Hope this helps.
Vinodh Balakrishnan
2008 Jan 20 2:53 PM
Program your BDC such a way that.
For every 1000 records, have a new session.
Loop at your main internal table (Table with 10,000 records),
Build a another internal table with 1000 records (We call it as ITAB2).
If SY-Tabix eq 1000 or
SY-Tabix eq 2000 or
Sy-tabix eq 3000.....goes on till 10000.
Open Group, Create a new session.
Insert your 1000 records from ITAB2.
Close Group.
Refresh ITAB2. clear ITAB2.
endif.
Endloop.
Hope this helps.
Vinodh Balakrishnan
2008 Jan 21 5:19 AM
hgi,
yes For every 1000 records, have a new session.
Loop at your main internal table (Table with 10,000 records),
Build a another internal table with 1000 records (We call it as ITAB2).
reward if helpfull
pankaj
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |