Skip to Content
avatar image
-1
Former Member

Submit program returns less number of records

Hi,

I'm using submit program to get ouput and process in my zprogram.

but the submit program returns less records, when compared to running directly the std report. and i'm using same variant and data on the selection screen.

submit program gets 48 record, where as the direct running std programs gets 1000+ records. does anybody know how this is set to return?

here is my code

SET PARAMETER ID 'KOK' FIELD 'WEC0'.
SUBMIT RPSISVG000
USING SELECTION-SET 'QUALITECH'
with  CN_PSPNR IN SO_POSID
      AND RETURN.
COMMIT WORK AND WAIT.

IMPORT I_ACT
  FROM MEMORY ID 'ZCN47N_ACTI'.
Add comment
10|10000 characters needed characters exceeded

  • Not related to your question, but about the presence of COMMIT WORK AND WAIT after the SUBMIT: your commit is probably useless as usually SAP programs do an explicit commit themselves (because SAP often uses update tasks, and it's a good practice to do an explicit commit or rollback in an update report), you shouldn't need to do a commit yourself to commit the updates done in the program. Your commit can't launch the update tasks started from the submitted program. Your commit can just do a database commit. Your commit is just valid to start the update tasks started from your own program.

  • Former Member Sandra Rossi

    thanks sandra.

  • Get RSS Feed

4 Answers

  • Oct 09, 2017 at 06:19 PM

    Debug?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2017 at 06:30 AM

    I do have one doubt: CN_PSPNR look like internal format when SO_POSID look like external format...

    NB: You use a variant in non-system space, so someday some user may (will) change its values... better use a CUS&xxx system (transported) variant or protect it during save.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09, 2017 at 07:59 PM

    Program "RPSISVG000" is a Standard PS-Report and these make use of several Parameters :

    • DB-Profile ...
    • A set of Selection Parameters but also Additional Parameters to be Selected ...
    • Maybe a Default - or UserBased SelectionVariant that is Automatically selected wher running in Dialog?


    I'm aware of a lot of Default Reports in the EAM-Space that use either fixed or initial Dates in Dialog, so that a Background Execution with no regard to these Dates will undoubtfully produce different results ... Maybe the same holds for this Report ...?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Nic, yes initially the DB profile had problem, we did fix it using variant with DB-Profile saved, no idea what external parameters need to be selected. but i did submit using the variant i created just like i ran the std program.
      USINGSELECTION-SET'QUALITECH'
      and there are no dates on the selection screen.

  • Oct 10, 2017 at 08:40 AM

    Debugging will be the best option,check selection parameter/table

    Add comment
    10|10000 characters needed characters exceeded