Search found 180 matches

by DrSidewalk
Wed Jul 16, 2014 10:22 am
Forum: Basis
Topic: SAP Open SQL message size
Replies: 4
Views: 2830

Re: SAP Open SQL message size

Have mentoned that our Database is Oracle, in my posting. I don't think the version/Release of SAP would make that much difference, but we are SAP_BASIS/SAP_ABAP Release 702. I think the postings by Gothmog will be of some help. Although I keep seeing postings in various places to say that in the la...
by DrSidewalk
Tue Jul 15, 2014 4:28 am
Forum: Basis
Topic: SAP Open SQL message size
Replies: 4
Views: 2830

Re: SAP Open SQL message size

Anyone?.
by DrSidewalk
Mon Jul 14, 2014 7:44 am
Forum: Basis
Topic: SAP Open SQL message size
Replies: 4
Views: 2830

SAP Open SQL message size

Many years back I remember getting our Basis team to extend the size of the SAP SQL statement size. I can't remember whether this was a SAP change or an SAP/Oracle change. I also remember change the number of entries that can appear in the 'FOR ALL ENTRIES IN' clause as well. Again I can't remember ...
by DrSidewalk
Sat Jun 21, 2014 4:37 pm
Forum: General Talks
Topic: A good read...
Replies: 64
Views: 96797

Re: A good read...

Just read all 10 books of the 'Battle Earth' series by Nick S Thomas.
Eagerly awaiting the 11th book. ;)
by DrSidewalk
Thu Jun 19, 2014 5:33 am
Forum: Basis
Topic: Do I have a problem with my index/table?.
Replies: 1
Views: 1807

Do I have a problem with my index/table?.

We are getting an estimated cost against our SQL statement of 16,000+. When I change the line with the BETWEEN statement we get a estimated cost of 3. The line was: WHERE mkpf~budat BETWEEN lv_start_date AND lv_end_date and gives an estimated cost of 16,673 The line was changed to: WHERE mkpf~budat ...
by DrSidewalk
Tue Jun 10, 2014 4:53 am
Forum: ABAP
Topic: Reference table in program from FM
Replies: 2
Views: 1472

Reference table in program from FM

Is it possible to call an FM from a program and have the FM reference table entries from the program without physically passing the table values across. IN my case there could 100,000 so do not want to pass them into the FM?.

Dr Sidewalk
by DrSidewalk
Thu May 22, 2014 6:30 am
Forum: SAP Other
Topic: Find jobs that use a factory calendar
Replies: 3
Views: 2978

Re: Find jobs that use a factory calendar

Anyone?
by DrSidewalk
Tue May 20, 2014 5:54 am
Forum: General Talks
Topic: A good read...
Replies: 64
Views: 96797

Re: A good read...

Read all of Ryk Brown's books. Episode 11 is out in three days (23rd May, 2014).

The Frontier saga's are a very good read.

Dr Sidewalk
by DrSidewalk
Tue May 20, 2014 5:51 am
Forum: SAP Other
Topic: Find jobs that use a factory calendar
Replies: 3
Views: 2978

Find jobs that use a factory calendar

Does anyone know if there's a way to show which Scheduled/reeleased jobs use a Factory calendar.
I can't determine a way to view this in sm37.

Anyone?.

Dr Sidewalk
by DrSidewalk
Thu Mar 20, 2014 7:52 am
Forum: General Talks
Topic: Advice on NAS Air (Cloud) devices...
Replies: 0
Views: 2465

Advice on NAS Air (Cloud) devices...

Guys, I need to get a new device to work as a NAS. I know it's expensive but I would prefer to have a quiet (Fanless) and cold device running using SSD's with an external port to attach a real hard drive for backups, when needed. Would be nice to have one or two spare drive bays to slide SSD's as an...
by DrSidewalk
Thu Mar 20, 2014 7:42 am
Forum: Business Warehouse
Topic: Where do I define the app server used by the meta chain
Replies: 0
Views: 2419

Where do I define the app server used by the meta chain

When setting up a meta chain and associated process chain. Where do identify the app server to use. ] In my case I have a server group defined which contains three app servers and the meta chain should be defined to use this server group and load balance across all three app servers, and, all proces...
by DrSidewalk
Mon Feb 17, 2014 12:18 pm
Forum: Interfaces
Topic: Reverse engineer Sales order to create idoc
Replies: 1
Views: 3994

Reverse engineer Sales order to create idoc

I vaguely remember coming across either a transaction/program to take a range of Sales Orders and reverse engineer them to product an IDOC that can then be processed. Obviously this would be for testing purposes. For the life of me I can't remember what the SAP standard program was called. I know I ...
by DrSidewalk
Wed Jan 22, 2014 6:37 am
Forum: Basis
Topic: Enqueue lock times (history)
Replies: 3
Views: 2879

Re: Enqueue lock times (history)

Zavaros, Does monitoring via that cause severe impact to the overal performance. I thought it did. My understanding that Enqueue logs are kept in buffered tables. I can see when the enqueue is started, but I can't match it with Dequeue's to identify how long the lock was held for, which is what I'm ...
by DrSidewalk
Tue Jan 21, 2014 10:10 am
Forum: Basis
Topic: Enqueue lock times (history)
Replies: 3
Views: 2879

Enqueue lock times (history)

We're looking at a 24/7 process going in as we will soon bring onboard Australia. We beleive that we have certain jobs that may perform table locks rather than record locks, or multiple record locks for long durations of time, with obvious consequences to either Australia's DIalog or overnight proce...
by DrSidewalk
Tue Dec 03, 2013 11:13 am
Forum: Basis
Topic: Is it possible to detect submitted jobs...
Replies: 4
Views: 2626

Re: Is it possible to detect submitted jobs...

What we tend to do at month end is to lock out users from submitting manually submitted jobs, by just not allowing any background work processes to class C jobs (defaul class) and allocate all work processes to class A jobs, being the regularly scheduled jobs. Although this is a sledge hammer approa...