cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Standard Datasource Enhancement code select times.

02-28-2025 3:30 AM
WANGWU Explorer
1174 views 4 comments
0 Likes
SAP Managed Tags
Labels
Datasource
Subscribe

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 ?  

0 Likes

Accepted Solutions (0)

Answers (3)

Answers (3)

TanweerZaki
Discoverer
0 Likes

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.

yogeswara_adapa
Explorer
0 Likes

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.

yogeswara_adapa
Explorer
0 Likes

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.

WANGWU
Explorer
0 Likes
Hi, in SAP BW/4 system , no infopackage of datasource any more. Only DTP and transformation. So, if there are 10 packages of DTP, select run 10 times ?