BAPI Extract row counts issue

ram1899 · Post by **ram1899** » Thu May 03, 2007 3:18 pm

We are extracting data from SAP R/3 system and loading into DB2 database using BAPI Extract. We are having problem with BAPI extract row limitations. Looks like BAPI is limiting the result set automatically to 100 rows. Job is working fine with fewer records( <100). When ever my BAPI extract job is having more data ,it is taking only first 100 rows from SAP. For example in the given job statistics shows BAPI extract extracted 8515 records, but really it extracted only 100 records. Job is real simple and there is no constraints in the transformation area.
This is really show stopper and we need immediate assistance.

Here is my environment.

Datastage Server 7.5.2
R3PACK 5.2 1
Ascential Client 7.5.2
AIX 5.3.0.0
SAP R/3 PACK IDOC, BAPI and ABAP extract.
SAP R/3 4.7 unicode
SAP GUI 640
MQ 7.5.2
Database server DB2 OS/390 8.1.0

Thank you for all your support in advance. Any help is really appreciated.

Edwink · Post by **Edwink** » Fri May 04, 2007 1:24 pm

are you using the userdefined query or using inbuilt procedures.?

ram1899 · Post by **ram1899** » Mon May 07, 2007 11:28 am

I am using in bulit procedures..

Edwink · Post by **Edwink** » Mon May 07, 2007 11:41 am

BAPI is nothing, but type of stored procedure.. it is called as function in SAP...in that procedure there might be any constraints...so have check in the BAPI