Skip to Content
Personal Insights
Author's profile photo Michael Keller

fantasy database table

Dear community, do you know the PICO-8? It’s a fantasy video game console (virtual machine). I’ve played with it a little bit because I found the idea very creative: A restricted, virtual hardware on which you can develop games in the LUA programming language. You have to find smart solutions to many challenges. All of this with a very small tool box. What else? Developers love challenges 🙂

Somehow I came up with the idea of a “fantasy database table” from the PICO-8 and its possibilities. That may be because I’m not a game developer but a developer for SAP ERP systems 😉

This database table has a limited number of fields with typical data elements that an ABAP developer encounters every day. The idea is to fill this database table with records by the members of the SAP community via comments to this blog. Everyone can leave his virtual fingerprint, so to speak. Build your own record by choosing the field contents, which for example have a special meaning to you. Here is the simple design of the fantasy database table.

database table design

And here’s the record I want to store:

  • MKE8525“: my first username in a SAP ERP system (4.6c)
  • “9”: I had once a lot of fun with the purchase order item type “D” (EKKO-PSTYP)
  • 23: there was a movie that impressed me a lot in the late 90s
  • “CREA”: because EDIT and SHOW fit in this field, CREATE not
  • “20210504”: Star Wars day is coming
  • “stay hungry, stay foolish”: without comment

Hope to see more from you, dear community 🙂


Best regards, have fun and please stay healthy



P.S.: Interested in a hand-picked round-up of the best ABAP development links every week? Check ABAP Weekly.

P.S.S.: Tired of reading blogs? Check SAP Online Track on YouTube.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Michelle Crapo
      Michelle Crapo
      • Record Key MICHELLE99
      • One Character F 
      • Two Numeric Charters 10
      • Four Characters CRT
      • Date to remember 20200715
      • Message to publish: Blueberry season starts in Michigan.  Need to start freezing 10 pounds.

      Record Key = Name + 99

      One character = F for food

      Four characters = CRT for create

      Date to remember = Start of blueberry season in Michigan


      Author's profile photo Michael Keller
      Michael Keller
      Blog Post Author

      Hey Michelle, nice message! After I've harvested strawberries, juneberries and cherries, it's now also time for blueberries. Have a good time during the harvest!

      Author's profile photo Lars Breddemann
      Lars Breddemann

      The Pico-8 is awesome!

      I was absolutely blown away by the super-cool idea to actually store the programs for it in the picture files that represent the "console cartridges". You download this picture and you got the program - just like old-times when disk-swapping was the way to get to new software.

      Knowing that there are more nerds with interests like this in the SCN community doesn't make it less nerdy but definitively more "homely" 🙂

      So, I also add a record to this funny table:

      • HANAHERO“: SAP had a "hall of fame" going to motivate folks to share their knowledge in its internal discussion forums. The whole thing was themed on comic book super-heroes, thus the name "HANA HERO". I always thought know-how sharing will eventually be a non-zero-sum game (i.e. everyone will be better off, even if I give but don't receive so much), so my participation in those forums got me this rank.
      • ;: this popular delimiter interpunction sign that gets so little use outside of IT and that can produce so much headache with so little effort (even and especially when it's not even there)
      • 76: feels like the best year of the '70s to me ...
      • CASE: Neuromancer fans will know this one
      • 20191015: I registered my company Data Process Insights
      • It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t so.": this quote proved true many times. 


      Author's profile photo Michael Keller
      Michael Keller
      Blog Post Author

      Regarding Pico-8: For me, computer games are a form of art. One of my most important books that I read again and again is "The Art of Point-and-Click Adventure Games". I have a lot of respect for the work of game developers. With the Pico-8 you can at least develop small games yourself. It's also good to show children in principle how to develop computer games. So that's a great thing overall.

      Regarding HANAHERO: I really like gamification based community approaches. In addition, I fully agree: sharing knowledge is an important thing!