software, software.sap

Technical SAP Cutover Steps

Here are some of the significant cutover steps for SAP go live.

System integrity:

  • Ensure that packages in dev / QA / live are identical
  • Ensure that E-Mails can be sent from the live system

Transport paths:

  • Ensure that “Transport of Copy” requests can be carried between dev – live systems
  • Ensure that requests in QA STMS can be forwarded to the live system
  • Ensure that workbench / customizing requests can be sent between dev – QA – live

Transport execution:

  • Transport external requests to the live system
  • Transport requests of all finished developments to the live system by selecting original requests & a transport of copies request containing everything
  • Ensure that all requests imported to QA are imported to the live system as well. TPALOG table + Excel VLOOKUP will help.

Soft config:

  • Definition of SM59 connections
  • Definition of SOAMANAGER connections
  • Definition of Z* number ranges in SNRO
  • Customizing of technical Z* tables
  • Ensure SCAL definitions & future maintenance
  • Define jobs

Workflow configuration:

  • Setting up WF-BATCH
  • Workflow configuration in SWU3
  • Ensure that Z* tasks are classified as general task (PFTC_DIS)
  • Execute SWU_OBUF and define a job if needed
  • If you use deadline monitoring, define  job for RSWWDHEX
Standard
life, philosophy

Expanding The Mind

framework01

When you make an observation, it leaves a mark in your mind. This is called a memory. Memories can be mental or emotional.

Memories cost time. Since time is a scarce resource, it would be wise to make meaningful and useful memories.


framework02

When you make multiple observations, you end up carrying multiple memories.


framework03

The mind typically processes the memories and builds a pattern. This pattern is called an opinion.

The mind likes economy. Instead of keeping all the memories, it is easier to keep an opinion. Therefore; memories can be forgotten, but opinions tend to linger.


framework04

When you have multiple opinions, the mind processes them and builds a macro pattern. This pattern is called a mindset.

Because the mind likes economy, it starts to automatically catch & process & evaluate the inputs based on the mindset. That’s where illusionary concepts are born; such as selective perception and stereotyping.


framework05

If you have only one mindset, you can understand and process only a small percentage of the phenomenon existing in the world. Fanatics are typical examples.

When someone shares an advice or opinion, question his/her mind span.

When you judge or conclude about something, question your own mind span.


framework06

If you take your time to make further observations in an emphatic, flexible and open minded approach, your mind can build more patterns. This will enable you to have a broader range of mindsets.

Observing foreign cultures, experimenting out of the comfort zone, facing fears and listening to alternative / opposing sources are typical examples of such expansions.


framework07

A broader range of mindsets can cover a larger percentage of the phenomenon in the world. You end up understanding the world more accurately and holistically.

You might also become more mature and understanding because you start seeing the mechanism behind things much better.


framework08

Coverage of multiple mindsets would obviously be deeper than the coverage of a single mindset.

Someone with a larger mind span will probably make more accurate conclusions and decisions.


framework09c

Mind is not the last stop. Meditation can help you go beyond the mind, understand that you are not your mind, and see things more clearly.

Standard
software, software.apple

Why I Prefer Evernote

I am asked frequently why I picked Evernote over its competitors. Here are my subjective reasons in alphabetical order.

AppleScript support. With very little programming knowledge, anyone can use AppleScript to automate Evernote tasks. I wrote scripts to pull Jira data into Evernote, create tag matrix notes, determine notes I modified today and many more; which definitely make my digital life much easier.

Content. Evernote can contain a virtually unlimited amount of text, images and file attachments. It is also possible to create tables, checklists, etc. It can also clip Web pages to create new notes.

Cross-platform. If I switch to another OS someday, I don’t have to worry about accessing my notes.

E-Mail. Evernote gives me a free E-Mail address. Any mail I send there turns into a note. Very good functionality to feed 3rd party app content into Evernote, or maintain an Inbox Zero.

Flexibility. Evernote provides a flexible system including notebooks & tags, which can match any workstyle. In my current personal system; I have distinct notebooks for active, deferred, idle tasks and templates. I put two tags to each note: One tag determines the priority (K1, K2, K3, K4) and another tag determines the scope (dev, music, writing, etc).

Reliability. Evernote application worked fine so far, and the company is unlikely to go out of business any time soon.

Search. Evernote provides a very powerful search tool to query notes. I can search notes over notebooks, tags, keywords, modification dates, file attachments, checklists, etc. Search queries can be saved and re-called any time needed.

Siri. I can dictate new notes over Siri. Very useful when I get new ideas while driving.

Standard
music, music.bass, music.guitar

How I Got Rid of Pedalboard Noise

I had a terrible and constant low frequency whistle noise coming out of my bass pedalboard; even if the guitar is completely turned down. I solved my problem by plugging individual power adapters into problematic pedals.

Detecting the Source of the Noise

Rig hum can have many reasons. Three most significant reasons are; guitar pickup hum, ground loops and power issues.

My bass has split coil pickups, so guitar pickups couldn’t be the source of the noise. Besides; the hum was still there even when I turned the guitar down. So, the bass wasn’t guilty.

Ground loop could have been the reason; however, the hum started after I added some new pedals (not before).

Therefore, I suspected that there was a power issue. The fact that my pedals wouldn’t start up before blinking on and off for a while reinforced that idea.

Detecting Guilty Pedals

For this test, I removed each and every pedal from my pedalboard, and plugged my guitar in directly. No noise / hum at all. Good.

Afterwards, I started adding pedals one by one. Eventually, I discovered that 3 EHX pedals were the source of the hum: Pitch Fork, SuperEgo and Freeze.

When I power any of those pedals individually via my Joyo Power Supply 2, they add up a little hum. Powering all of them end up producing a powerful hum.

Solving the Problem

I figured out that there was nothing wrong with the pedals. The only problem was; the power supply didn’t agree with the power demands of the pedals.

I disconnected those pedals from the power supply completely, and powered them through their original individual power adapters.

Wham! The hum disappeared. My rig went dead silent.

I figured that I needed a larger multi outlet for my pedalboard now; but it is a small price to pay for rig silence.

Using batteries instead of power adapters is also an agreeable solution, but I don’t want to worry about batteries going dead in the middle of some gig.

Standard
software, software.apple

How To Merge GMail’s Important Folder into Apple Inbox

There is an annoying problem experieced by Apple Mail users with GMail accounts.

GMail creates a virtual mailbox called “Important”, which displays your seemingly important mails. That’s all good and fine until you attempt to access GMail over Apple Mail application on your Mac.

What happens is, the e-mails in your “Important” folder don’t show up in the inbox of Apple Mail. You see them via GMail Web, but not in Apple Mail. Considering that those are actually important E-Mails, the problem is pretty frustrating.

I have constructed a workaround for this annoying problem, which might help others out there.

First; go to your GMail settings, go to the tab “Labels” and ensure that your “Important” folder is enabled via IMAP.

Screen Shot 2017-11-29 at 17.06.05

After this step, Apple Mail will start showing up your “Important” folder. You can see the mails by accessing that separate folder.

Screen Shot 2017-11-29 at 17.06.51

However, the “Important” mails still won’t show up in your inbox. To work around this problem; go to the menu Mailbox – New Smart Mailbox and include your inbox + the “Important” folder.

Screen Shot 2017-11-29 at 17.08.35

Voila! From now on; you will click the smart mailbox to see all of your E-Mails.

Screen Shot 2017-11-29 at 17.09.19.png

If there is a direct way to merge all mails into the inbox, please let us know in the comments.

Standard
life

Why I Post in English

This became one of the frequently asked questions. I would like to share some of the reasons why I prefer to post in English.

Why English?

English is regarded as the world’s universal language. A post targeting the global audience needs to be in English; which is the case for most of my posts.

I happen to have a global audience. Due to my technical articles and latest globally published book, I have a considerable amount of international followers which obviously don’t speak Turkish.

Looking at my closer circle; I have foreign relatives and friends as well.

  • My aunt is married to a Swiss man, so that part of the family speaks English & German only.
  • I also lived in Germany for a year, my German friends don’t speak Turkish either.
  • I also happen to have foreign friends in Turkey.
  • A large percentage of my Turkish friends speak English anyway.

Those are some of the reasons motivating me to prefer English over Turkish when posting something online.

When Turkish?

I am aware that not every Turkish citizen speaks English, and my posts might not be understood by some.

If a post is related to Turkey only, I choose to write in Turkish. Or; if I’m writing about a topic covered by global writers but lacks Turkish sources, I choose to write in Turkish as well. Typical examples can be found among my technical books and articles.

Conclusion

The inducements for posting in English mostly outweigh the inducements for posting in Turkish. That’s why I pick English as the default language.

I don’t have the time to translate every post to English, Turkish and German. However, online translation tools are getting better every day; so I’m counting on them.

Standard
software, software.sap

ABAP: UNION DISTINCT vs ALL

As many of you already know, ABAP supports the UNION command now. UNION is an SQL command to combine the results of two separate queries into one dataset.

Here is a sample dataset from the imaginary database table Z1:

ID
TEXT
001
One
002
Two

And here is a sample dataset from another imaginary database table Z2:

CODE
NAME
002
Two
016
Sixteen
019
Nineteen

Before the UNION command existed, we had to run two distinct queries to combine this data into a single internal table.

SELECT
    id AS key,
    text AS value
  FROM z1
  INTO TABLE @DATA(lt_itab).

SELECT
    code AS key,
    name AS value
  FROM z2
  APPENDING CORRESPONDING FIELDS OF @lt_itab.

Now, UNION allows us to merge those queries.

SELECT
      id AS key,
      text AS value
    FROM z1
  UNION
      code AS key,
      name AS value
    FROM z2
  INTO TABLE @DATA(lt_itab).

Here is the catch: If we execute the UNION query above, we get the following resultset:

KEY
VALUE
001
One
002
Two
016
Sixteen
019
Nineteen

Did you notice that record “002” appears only once? In spite of its existence in both of Z1 & Z2, the resultset included a singular “002” entry.

That’s the catch with UNION queries. They can be executed with two logical approaches to handle duplicate records.

UNION DISTINCT is the default mode, and it will eliminate duplicate records from the second query. That’s similar to the logic of SELECT DISTINCT or FOR ALL ENTRIES. That’s why “002” from the second table was missing in the resultset.

UNION ALL needs to be specified explicitly, and it tolerates duplicates from the second query. So, let’s modify our sample query accordingly.

SELECT
      id AS key,
      text AS value
    FROM z1
  UNION ALL
      code AS key,
      name AS value
    FROM z2
  INTO TABLE @DATA(lt_itab).

This time, our recordset will include duplicate records from Z2.

KEY
VALUE
001
One
002
Two
002
Two
016
Sixteen
019
Nineteen

Each approach has its time and place. If I am looking for a unique list of values, such as the combined list of tax numbers of clients & vendors, I would go for UNION DISTINCT. However; if I am querying transactions, such as BSIS / BSAS, I would go for UNION ALL because I probably wouldn’t want to miss any line items.

Standard