Search found 180 matches

by DrSidewalk
Thu Oct 09, 2014 4:52 am
Forum: Basis
Topic: Show jobs in SM37 that make use of a calendar?
Replies: 1
Views: 1953

Show jobs in SM37 that make use of a calendar?

In SM36 we can create a batch job that makes use of calendar (Factory), but once done we can not report on it via SM37. In fact there seems no way to display batch jobs that use any calendar. I'm sure it can be done by extracting data from one of the TB* tables, but we really should not have to reso...
by DrSidewalk
Thu Sep 25, 2014 10:04 am
Forum: General Talks
Topic: When are we going to see a SAP CPS forum?.
Replies: 1
Views: 11026

When are we going to see a SAP CPS forum?.

When are we going to see an SAP CPS (Central process scheduling)?. I know that the tool is rumoured to be renamed soon to BPA (Business Process analystics), I believe. Would be nice to see it in here. I for one can answer, and probably raise some questions. ;) Leave it with the Admins... Dr Sidewalk
by DrSidewalk
Thu Sep 25, 2014 9:58 am
Forum: General Talks
Topic: Agency Trick
Replies: 12
Views: 19961

Re: Agency Trick

Yes, many a time I have had another agent try and put me forward for a role that I had been told (by another agent) that I had been put forward to. The problem is that the agent hangs onto your CV until the very last moment, so other agents may check and come back to say that customer does not have ...
by DrSidewalk
Thu Sep 25, 2014 9:54 am
Forum: General Talks
Topic: A good read...
Replies: 64
Views: 96798

Re: A good read...

Found another good sci-fi source. That's the 'Empire's corps' by Christopher Nuttall.
I'm only on book two, but I have found them hard to put down. ;)

Dr Sidewalk
by DrSidewalk
Thu Sep 25, 2014 9:09 am
Forum: Basis
Topic: Where to obtain a list of maintenance jobs per environment.
Replies: 1
Views: 2216

Where to obtain a list of maintenance jobs per environment.

There are SAP standard jobs (often found in STANDRDS tab in SM36) and then there are maintenance jobs which do other tasks. The Standard jobs often feed in to statistics for ST04 etc, whereas maintenance jobs tend to clean up things and leave the sytsem effecient. These maintenance differ per enviro...
by DrSidewalk
Wed Sep 03, 2014 9:41 am
Forum: ABAP
Topic: Buisness graphics dynamic PIE chart event id
Replies: 1
Views: 1726

Re: Buisness graphics dynamic PIE chart event id

Silly question, but did you look at the example ABAP programs?. I don't have access at this point in time, but I know these samples exist.
It's always best to see a working example of one, then you can look at the code and hey presto.

Dr Sidewalk
by DrSidewalk
Wed Sep 03, 2014 6:40 am
Forum: ABAP
Topic: Insert into table from another table...
Replies: 2
Views: 1995

Insert into table from another table...

I know that I can extract records from one transparent table into an internal table, and then insert the records from the internal table into another transparent table, but, that takes time, and uses a lot of memory if the itab is huge. With Native SQL (Oracle) it's possible to use an SQL statement ...
by DrSidewalk
Wed Sep 03, 2014 6:31 am
Forum: General Talks
Topic: Cordova
Replies: 1
Views: 4462

Cordova

Wow, it was interesting to read about Cordova. At first I thought it was actually an SAP product but then realised it was actually Phone Gap renamed. Adobe used to own Phone Gap which is a cross platform code generator whereby you could create a product and it would then produce the code on the vari...
by DrSidewalk
Wed Sep 03, 2014 6:24 am
Forum: General Talks
Topic: Soccer - Sorry guys
Replies: 5
Views: 5993

Re: Soccer - Sorry guys

That's all over with now, the new premiershhip season has started in the UK now. Football is life and all that. Up the blues.

Dr Sidewalk.
by DrSidewalk
Wed Sep 03, 2014 6:20 am
Forum: General Talks
Topic: Printing
Replies: 3
Views: 6195

Re: Printing

Talking of printing. Yesterday I read about a mobile laser printer that starts printing as soon as send it, but makes its way to you desk (being mobile) and delivers it to you. Interesting logistics involved there, but I guess if they can have driverless cars, then why not mobile printers. I we had ...
by DrSidewalk
Wed Sep 03, 2014 6:17 am
Forum: General Talks
Topic: A good read...
Replies: 64
Views: 96798

Another Sci-fi writer found...

I have just finished the 7th book in the AMP series of books, written by Stephen Arseneault. Really enjoyed them, and looking forward to the 8th book, due out very soon. I'm also awaiting on the next Fontiers saga book by Ryk Brown. It was due out in August but has been put back to September. Anothe...
by DrSidewalk
Wed Jul 30, 2014 6:53 am
Forum: Basis
Topic: Issue with Native SQL.
Replies: 8
Views: 4054

Re: Issue with Native SQL.

okay, changed 'GE' to '>=' although I'm sure 'GE' would be accepted in Oracle. Still getting a 911 error though. So it still believes there's a special character somewhere. In SQLPLUS it would have informed me of exactly which character in the SQL statement caused grief, but I just get a single mess...
by DrSidewalk
Wed Jul 30, 2014 5:57 am
Forum: Basis
Topic: Secondary index madness.
Replies: 2
Views: 2020

Re: Secondary index madness.

It's Oracle we have as a database, can provide version, but will be pretty recently updated. The explain path shows the same index being used for both SQL statements, the one where "BUDAT >=" and the 2nd statement where "BUDAT BETWEEN a AND b". Very odd. As the 2nd SQL statement is slightly better i...
by DrSidewalk
Wed Jul 30, 2014 5:52 am
Forum: Basis
Topic: Issue with Native SQL.
Replies: 8
Views: 4054

Issue with Native SQL.

I am extracting a huge amount of records into an itab, changing a few things around and then posting them into a temporary Z transparent table. This process is taking a long time for a number of reasons, the access path used against the two tables, the number of records returned, and the record leng...
by DrSidewalk
Wed Jul 16, 2014 10:30 am
Forum: Basis
Topic: Secondary index madness.
Replies: 2
Views: 2020

Secondary index madness.

There's a secondarty index on MKPF names BUD. It has the MANDT, BUDAT and MBLNR fields as keys. In one of our really old programs we are access this table with a WHERE clause like so. WHERE budat >= l_start_date. Now, I have run a quick SQL query beforehand to return the maximum date in the table an...