Skip to Content

Slow Insertion of Data

Hi ,

I have created a ZBAPI for .net Base Program to push data into SAP Table. Other Vendor use my ZBAPI for data pushing, after some records, take a long time to append rest record or data.

As per vendor, the told that some issues in USER Authorization and network issues. So Can you guide me what is the problem.

ZBAPI Program as following.

*"----------------------------------------------------------------------

*"*"Local Interface:

*" EXPORTING

*" VALUE(RETURN) TYPE BAPIRET2

*" TABLES

*" ZBAPIXXX STRUCTURE ZBAPIXXX

*"----------------------------------------------------------------------

*-- Created by Ram Shanker for Store data from CMS Databse .

*-- Modify Data from Structure

MODIFY ztxxxx FROM TABLE zbapixxx.

*-- Commit data after

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.

*If Data not saved then store a error message and return with BAPIRET2 Table

IF sy-subrc NE 0.

CLEAR message.

message-msgty = 'E'.

message-msgid = 'ZXX'.

message-msgno = '999'.

message-msgv1 = sy-subrc.

PERFORM set_return_message USING message

CHANGING return.

IF 1 = 2.

MESSAGE e999(zsd).

ENDIF.

ENDIF.

CHECK return IS INITIAL.

Thanks!

Ram Shanker

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on May 21, 2013 at 10:54 AM

    Hi Ram,

    if the size category for your table is not set adequately and/or the table statistics are not up-tp-date, the database may need too much time.

    Check with your basis people.

    Regards

    Clemens

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2013 at 11:24 AM

    One little detail, probably not the reason for slowing down the updates, but.....

    I think you should check the sy-subrc after the modify statement and depending on the result call commit or not.

    When you say: "after some records, take a long time to append rest record or data"

    What is some records (about) and how big is the rest ? How many rows ?

    You also said there might be some issues in USER Authorization and network issues.

    That is your answer right there, unless you concluded that these are not the reason for slowing down. Did you ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2013 at 11:43 AM

    Hi Ram,

    Try to insert data via abap program and check for the performance first then after go for the external system....might be the issue related interface or buffering.

    Avirat

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 22, 2013 at 05:15 AM

    Ram Shanker wrote:


    after some records, take a long time to append rest record or data.

    *-- Modify Data from Structure

    MODIFY ztxxxx FROM TABLE zbapixxx.

    your statement is to modify the whole table at once...
    so not sure when you say after some records , i guess the whole data will be populated at once 😕

    If you meant that if they pass less records it takes less time and when a large no. of records in the table are passed it takes more time , then it can very well be a network congestion issue when passing huge amounts of data..... (As you mentioned that internally you passed 13k records it worked perfectly, so i am hoping the technical settings/ size category is set adequately for your Ztable).

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Manoj,

      Actually I have created a ZBAPI to Vendor for push Vendor data into Our SAP Table. They are saying that "

      As per my knowledge when we are updating the sap database it is allow approx, 100 to 150 records very fast afterwords it is getting very slow and take lot of time. "

      So, what to do for this problem and what is the parameter for testing / track this issue.

      Thanks!

      Ram Shanker

  • Posted on May 22, 2013 at 05:35 AM

    Hi,

    if you use an Oracle database check that :

    trans. DB02OLD (or DB02 for old system) --> button Detailed Analysis --> in object name enter your table* (with the star)

    you will find all the table / index

    choose your index (select it)

    --> menu Goto --> Detailled analysis --> menu Analyse Index --> Storage quality

    (you will have a pop-up ... ) enter

    That will give you a percentage of storage quality, if the value is less than 90%, it's not really good, if the value is less than 70% it's bad.

    second point, (with your administrator, if you are little affraid), go to SE38, program RSANAORA (always if you run Oracle)

    select INDEX

    Object : enter your Table~index (example T001W~0 for primary index of table T001W), select ALTER INDEX REBUILD ONLINE

    Before launching that, if it's a big table of SAP, schedule it at a free moment of charge. (I always launch it during the day, but sometimes, admin doesn't like that)

    (to know witch index is affected by your program, you could make a trace : ST05)

    Regards

    Fred

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Frederic,

      Thanks for your reply and in my company using DB2 databse. Our vendor which push data into SAP Table using BAPI, saying that some issue in SAP Side like user authorizations and some other constraints thats why our program unable to push data or slow after some records.

      So, Please guide me how to solve this issue.

      Thanks!

      Ram Shanker

  • Posted on May 24, 2013 at 08:52 AM

    Hi All,

    Thanks, Finally I have told to vendor to check their program because I dont think that Issue in SAP Side. Now I have closed this issue.

    Ram Shanker

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.