Hi experts,
For example, the datasource 2LIS_03_BF had added a new field F1
and in the cmod , the code using "select" like "select ... into .... from EKKN for all entries in E_D_DATA.... ".
IF 2LIS_03_BF extracted 10000 records with full extraction one time ,
my question is how many times the "select" occured ? 10000 times too ?
Request clarification before answering.
in RSA3, you can see the package size and package count. So Open cursor and corresponding select is executed one time for each package count.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yeah. You did not mention which BW version in your question initially, so I gave with infopackage example.
Yeah even if it is BW4HANA DTP it works the same. For each package select statement hits database just once.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Select statement hits database once per one package. For example total records extracted are 100000, and package size is 10000 then in total select is going to run 10 times.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.