Delta upload via /sapsll/spl_ul01

[Former Member]

When I run this in the foreground you get an Error log for consistency and plausibility check which I then can click on the menu option "Write consistent SPL records to database".

My question is what happens when you automate the jobs. How do these records get written to the database when there is no manual intervention?

How do these get written to the database? Is there another program that needs to run to update the database?

[mouaz_benredjeb]

Hi Christopher,

If you are running the transaction in foreground, system will show up the button ""Write consistent SPL records to database" for you to decide if you want or not to write data to the database.

If you are running the transaction in background (i.e; through a job for instance), then the system will automatically write the data to the database without any intervention from a user.

Above explained logic is written in the ABAP code of the transaction /sapsll/spl_ul01.

A lot of GTS transaction that can be run both in foreground with user intervention and background mode without user intervention behave in the same way.

Regards.

Mouaz BEN REDJEB

[Former Member]

Thanks Mouaz,

That's what I thought but I wanted to be sure. I think I have another issue since the job ran and the log sows the entries that were on the delta file but the there is no record of the changes to those SPL entities.

This was the first time the job ran as a batch job. Last week I had uploaded some delta files manually and when I went in to check I could see the date that I ran the file 4/28.

When I checked today the first file that was uploaded in a batch job, although it was listed in the upload log I did not see any evidence the records were changed. I tried running the same job manually in the foreground and still cannot see any updates to the SPL records listed in the file.

[mouaz_benredjeb]

Few things I think of for you to check:

- I know from experience that nightly run jobs sometimes overlap 2 dates: job starts before midnight and ends after midnight hence some data is posted with a date and other data with another date. Make sure that your job runs totally in the same day scheduling it at 1:00 am for instance

- If you upload twice the same delta file, the system will not update anything as there is no change in the file. Try to manually change something in the XML file to "force" the system to update the SPL records

[Former Member]

I'm not really sure what the issue is. The file from 5/1 we received that had several entries to it was hard to tell if the SPL list got updated I didn't see any changed records, with the 5/1 date on it.

We got a new file yesterday 5/4 which ran overnight and I was able to see the changes in the SPL entries.

Right now I think everything is fine I will monitor for awhile.