Personal Insights
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
Michael
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.
Record Key = Name + 99
One character = F for food
Four characters = CRT for create
Date to remember = Start of blueberry season in Michigan
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!
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:
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!