Interview questions concerning table types
So some chap just asked what the difference is between a transparent table and pool table. So tempted to answer
Transparent table
Pool table
135 Comments
-
Feb 09, 2018 at 07:20 AM
And here's a pooled table
And a table cluster
-
Feb 09, 2018 at 07:20 AM
Ha Ha Ha. So mean. The same happens when someone asks "What is Plant?"
-
Feb 09, 2018 at 07:22 AM
Finally, for HANA afficianados, here are some column store tables.
-
Feb 09, 2018 at 03:19 PM
Brilliant.
-
Feb 11, 2018 at 10:51 PM
This just made my Sunday evening. Thanks!
-
-
Feb 09, 2018 at 11:34 AM
Internal table
-
Feb 09, 2018 at 10:25 PM
And hash table. :)
-
Former MemberFeb 16, 2018 at 03:56 AMA sore ted table?
-
Feb 16, 2018 at 07:12 PM
Very subtle! :)
-
-
-
-
Feb 09, 2018 at 02:14 PM
New game!!!! Put in a picture that might be something you use in SAP. Then others can guess what you're talking about.
1.
2.
Dang, could only do two images (THIS TIME)
-
Feb 09, 2018 at 04:08 PM
Umm, your image names are a bit of a giveaway :-)
-
Feb 09, 2018 at 09:26 PM
Yeah, I kind of noticed that, but thanks for giving clues to anybody else Mike. :-)
-
-
Feb 09, 2018 at 06:52 PM
Some of my previous images I'm sure I've uploaded have gone awol.. at least I can't see them. But just in case they've really gone, here are some puzzles for you to figure out
and
-
Feb 09, 2018 at 09:28 PM
I'm gonna go with Joins, and even if I am wrong, that's what I see, so that's OKAY.
-
Feb 09, 2018 at 10:27 PM
I see nested tables but drawing blanks with the first one...
-
Feb 10, 2018 at 06:49 AM
Yep. Nested table. At a stretch - Sorted.
-
-
Feb 09, 2018 at 10:34 PM
shadow table
-
Feb 10, 2018 at 01:35 AM
Jurgen has it. Comes up mostly in upgrades.
-
Feb 10, 2018 at 06:48 AM
Well, it was an 'ASHed table. But shadow table is better and Jelana nailed the Hashed Table.
-
-
-
Feb 10, 2018 at 01:36 AM
I still see all the earlier pictures.
-
-
-
Feb 09, 2018 at 03:17 PM
Dooooo iiiiiiit!
I so would like to see that in a 'real' answer. Brilliant selection of graphics, by the way.
-
Feb 09, 2018 at 03:43 PM
I know Matthew Billingham should totally do this! Please???
-
-
Feb 09, 2018 at 03:24 PM
For Sue's game....
-
Feb 09, 2018 at 03:30 PM
Oh that's a tough one.
That's a wait step.
Yeah, I know that's the wrong answer. ¯\_(ツ)_/¯
-
Feb 09, 2018 at 03:32 PM
Haha, well, of course you would interpret it related to your field of specialization! ;)
-
Feb 09, 2018 at 04:14 PM
Hint: One type of these is
-
-
Feb 09, 2018 at 10:28 PM
Haha, it's a server. :)
-
Feb 10, 2018 at 01:36 AM
Ding ding ding!
-
-
-
Feb 09, 2018 at 10:34 PM
This is what I don't use.
-
Feb 10, 2018 at 01:38 AMEclipse! Yeah, me neither if I can avoid it. ;)
-
Feb 10, 2018 at 06:52 AM
I've got used to it. I have a bit of a flaky network at home sometimes - I have powerline adaptors connecting the various parts of my home to the router. For some reason, when I use a VPN - and I use 3 different ones - everynow and then I lose internet connectivity entirely, and have to reset the adaptor.
Anyway, when using eclipse, I just get a timeout. When reconnection is made, I can continue where I left off. SAPGui just crashes and throws you out, cruelly leaving your session logged in, but no way to access it.
Mind you I also have to use it for HANA development, AMDP etc. Resistance is futile... ;-)
-
Feb 12, 2018 at 03:40 PM
SAPGui just crashes and throws you out, cruelly leaving your session logged in, but no way to access it.
This is one for "things SAP could fix" list that has been bugging me since forever. "You have another session open." Oh yeah? Where is it? How can I get to it? You threw me out and now you're asking stupid questions! Just let me back in for cripes sake.
-
Feb 12, 2018 at 05:42 PM
I though maybe if I set an external breakpoint and had a web dynpro, I could call the web dynpro and it would stop in debugger if my network had glitched enough to kill SAPGui.
Doesn't work. :-(
-
-
-
-
Feb 10, 2018 at 10:27 AM
It's worth the learning curve. I recently worked on an eclipse-less system and it was really awful having to write out stuff and refactor by hand. Can't stand working in the GUI anymore, I only use it for Web Dynpro these days.
-
Feb 12, 2018 at 03:45 PM
It might as well be true but we don't have it and I just don't see a very compelling reason to push for it TBH. I don't even mind the old editor in its simplicity. But it's just the matter of preference, I wouldn't try to convince anyone otherwise.
-
Feb 13, 2018 at 12:22 PM
I will admit it needs a better understanding of ABAP to use properly, and some people prefer a clickety-click interface to remembering the syntax of a class definition. So it's whatever works for you.
Refactoring is a VERY compelling reason, so if you rework a lot of old code do give it a try.
Want to turn a block of code into a new method? Select it -> extract method. It even works out what should be importing/changing parameters and what to declare locally.
Rename a method or an importing parameter? No problem, it will change your method code and all it's callers (up to 50 of them).-
Feb 14, 2018 at 06:31 PM
Refactoring, haha, OMG! Unless it can completely rewrite the programs it's not an issue at the moment. The other day was looking at CONCATENATE 'something' lt_table INTO ... and lt_table is a header line! Why does this even compile? Changing methods ROFL... Thanks for the giggles, Mike! :)
-
-
-
-
-
Feb 10, 2018 at 01:13 PM
Just for Mike Pokraka (since you always have to ask for it in the Q&A)
-
Feb 10, 2018 at 01:15 PM
n=1 branch of a binary search tree?
-
Feb 12, 2018 at 02:46 AM
Looking for the log, aren't you?
-
Feb 12, 2018 at 01:48 PM
Ding ding ding! Winner! I'm always surprised how often we (OK, Mike Pokraka !) have to ask for the technical log files in the Q/A. I think we should just paste that pic in our responses...
-
Feb 12, 2018 at 03:47 PM
Oh yes we will!
-
-
-
-
Feb 11, 2018 at 09:40 AM
Might be a bit tricky this one. What ABAP command is this?
Deus cui omne cor patet et omnis voluntas loquitur: et quem nullum latet secretum: purifica per infusionem sancti spiritus cogitationes cordis nostri: ut te perfecte diligere et digne laudare mereamur, per dominum nostrum iesum christum filium tuum qui tecum vivit et regnat in unitate eiusdem spiritus sancti deus, per omnia secula seculorum. Amen.
-
Feb 12, 2018 at 05:44 AM
Just a (bad?) guess - COLLECT
While searching for the answer, I figured there is a transaction code called AMEN!
-
Feb 12, 2018 at 07:39 AM
Correct. A collect is a short prayer in Anglican/Catholic/Orthodox (and probably other) churches.
-
-
-
Feb 12, 2018 at 08:25 PM
OK, this one might be slightly oblique:
Hint: It has nothing to do with clocks or time.
-
Feb 12, 2018 at 08:35 PM
Is it a circular reference?
-
Feb 12, 2018 at 09:14 PM
Interesting train of thought, but no it's more concrete (or wood?) than that.
-
-
Feb 12, 2018 at 10:17 PM
looks like ASAP
-
Feb 13, 2018 at 07:21 AM
Haha, you've make a good point :-)
No it's more closely related to Susan Keohan's earlier contribution. Or rather a more specific type thereof.
-
-
Feb 13, 2018 at 12:13 PM
"Time chairing"? :)
-
Feb 13, 2018 at 03:32 PM
Some kind of SAP R/3 allegory? Looks impressive but made of wood and will wear off by 2025? :)
-
Feb 13, 2018 at 05:43 PM
No, more "technical" than that...
There, I've given it away.
-
Feb 13, 2018 at 05:49 PM
Is it related to this:
-
Feb 13, 2018 at 10:23 PM
I've been trying to figure out what that is supposed to mean ... stumped!
-
Feb 13, 2018 at 10:30 PM
I could be wrong, but I think that is a pointer.
-
-
-
-
-
Feb 15, 2018 at 03:48 PM
Hi Mike,
Your picture disappeared but I am still hoping for the answer - my guess would be 'chronological log' but then you'd said it had nothing to do with clocks or time, so I'm stumped (aha ha ha, see what I did there)
But don't worry about the picture, I'm sure it will come back ;-)
-
Feb 15, 2018 at 03:53 PM
Actually that’s an even better answer :-)
I had technical log in mind. I thought the hint to your log pic and the “technical” comment would do it, but it was a bit out of the box.
-
Feb 15, 2018 at 04:12 PM
We like 'out of the box' thinking! And I just scored a 'B' on the buzzword bingo sheet!
Now that I look back, yeah, I should have picked up on your 'technical' comment.
-
-
-
-
Feb 12, 2018 at 08:43 PM
What happens when you log in to their system the first time and find this?
-
Feb 13, 2018 at 03:35 PM
Balls on the glass? Sorry, drawing blanks here...
-
Feb 13, 2018 at 05:45 PM
Hah, I see what you did there!
Been racking my brains on this one too, but there's no such thing as transparent pool table in SAP.
-
-
Feb 13, 2018 at 05:32 PM
Someone already 'broke'???
That's the best pool-playing thing I can come up with.
-
-
Feb 13, 2018 at 05:42 AM
So, what's this
-
Feb 13, 2018 at 11:59 AM
The tear of a SAP Basis admin confronted with a legacy system?
-
Feb 13, 2018 at 01:14 PM
..or a broken website
-
Feb 13, 2018 at 05:33 PM
OMG Steffi Warnecke LOL!
-
-
Feb 13, 2018 at 01:46 PM
When I get a call from a headhunter and they refer to it as THAT, I immediately either (1) hang up (2) have fun messing with them from then on.
-
Feb 13, 2018 at 03:31 PM
"I have an urgent client requirement for ay-bee-ay-pee developer" [click]
-
Feb 13, 2018 at 04:33 PM
Ding ding ding!!!!
When they ask you if you are familiar with (note image above).....ease into a conversation about your background in forestry and/or the study of ancient insects you found trapped and perfectly preserved for all these many years.
-
-
Feb 13, 2018 at 05:30 PM
Back when I worked with mainframes, we used CICS. This side of the pond known as Kicks (as in "System Programmers do it for CICS"); t'other side it was always see-eye-see-ess. Does the same relate to SAP? I here Ess-Ay-Pee as often as SAP.
By the way, SAP is only half the answer. There's more to it.
-
Feb 13, 2018 at 07:06 PM
SAP on the web? haha
-
Feb 14, 2018 at 07:56 AM
It's SAP, but it's gooey.
SAPGui.
-
Feb 14, 2018 at 06:38 PM
Brilliant! GUI pecan buns will never be the same to me. :)
-
-
-
Feb 14, 2018 at 06:35 PM
Same with "sequel" that is in other countries pronounced as letters S-Q-L.
-
Feb 14, 2018 at 07:46 PM
Oh. Not squirrel then... ;-)
-
-
-
-
Feb 13, 2018 at 05:13 PM
The answer to your question translated into my language is:
-
Feb 14, 2018 at 07:59 AM
But what is it?
-
Feb 14, 2018 at 08:21 AM
Сап (pronounced as [sap]) is the wooden handle of an instrument like claw-hammer, spade, mattock.
-
Feb 15, 2018 at 03:52 PM
Veselina Peykova, I was actually thinking of 'sap' (honestly) but in our country, they are mostly made to beat the heck out of people.
-
Feb 15, 2018 at 04:00 PM
I am almost certain that the Bulgarian "сап" can be used to beat the heck out of people, too... in some versions - from a safer distance :)
-
Feb 16, 2018 at 09:16 AM
I know them as blackjacks.
-
-
-
-
-
-
Feb 14, 2018 at 07:59 AM
Another one. Small clue: a component of Netweaver.
-
Former MemberFeb 15, 2018 at 09:29 AM
a SAW backwards
--> WAS, aka Web Application Server-
Feb 15, 2018 at 01:23 PM
You got it.
-
-
-
Feb 14, 2018 at 07:53 PM
Fairly simple, I think.
-
Former MemberFeb 14, 2018 at 10:50 PM
SLD ? Missing the UFOs to be a LMDB.
-
Feb 15, 2018 at 06:06 AM
No. Nothing to do with that-
-
-
Feb 15, 2018 at 09:06 AM
A heat map?
-
Feb 15, 2018 at 10:37 AM
It's a star schema.
Schema - a representation of a plan or theory in the form of an outline or model.
-
Feb 15, 2018 at 12:26 PM
Oh, I thought about "universe". Isn't that some kind of thingy for analysis or something?
-
Feb 15, 2018 at 01:23 PM
Does no-one know what a Hertzsprung–Russell diagram is?
-
Feb 15, 2018 at 01:34 PM
Yes, you do! :D
-
-
Feb 15, 2018 at 07:02 PM
Yep we use universes in Analytics - Semantic layer and stuff.
-
-
-
-
Feb 14, 2018 at 07:56 PM
Just need to get this one out of the way.
-
Feb 14, 2018 at 10:23 PM
There are bagels somewhere in SAP? 8-[ ]
-
Feb 15, 2018 at 06:06 AM
ABagel/4 I don't think so.
-
-
Feb 15, 2018 at 12:27 PM
Rolls? :D
-
Feb 15, 2018 at 01:24 PM
ARoll/4 I don't think so! :-D
-
-
Feb 15, 2018 at 01:26 PM
Matthew, you GAVE that one to me!
https://en.wikipedia.org/wiki/Bread_roll
ABAP/4
Thank you for making my morning - every one of you!
-
Feb 15, 2018 at 04:23 PM
In Ireland and parts of England, a soft roll is called a bap.
Wow. Do people just come up with these words at random? "Hey, look at this roll / bun! - No! We're not going to call it that! We are calling it a... uhm... a BAP! Yes, that's what we're calling it and the rest of you just buzz off!"
I thought that Midwestern "pop" vs "soda" (for non-alcoholic sparkling beverage) was odd enough but England just takes it to the whole other level. :)
-
Feb 15, 2018 at 05:03 PM
And you think that’s weird? Brits don’t stop there. The professional body for cosmetic plastic surgeons in this country is called the British Association of Aesthetic Plastic Surgeons, or BAAPS for short. I’ll leave it to the reader fo figure out the link with baps (hint: slang term). You couldn’t make it up.
-
Feb 16, 2018 at 07:17 PM
Good thing there is no British Organization of Original Billboard Sellers... Okay, I'll see myself out now. :)
-
-
Feb 15, 2018 at 05:44 PM
Go to Newcastle and tha' can have a stottie cake (pronounced kayeck) lass.
Why use one word when you have hundreds of regional variations.
-
Feb 15, 2018 at 07:03 PM
pop is easy -- the bubbles , the sound they make when you take the cap off ;)
-
-
-
-
Feb 15, 2018 at 01:24 PM
An easy one for functional folks:
-
Feb 15, 2018 at 03:53 PM
*Are* there functional folks here?
<crickets>
-
Feb 15, 2018 at 04:17 PM
In the current discussion there are at least 3 functional consultants (I think) and probably a few more working in techno-functional roles.
But maybe technical people have heard of this one too because they were asked asked to help with troubleshooting.
-
Feb 15, 2018 at 04:29 PM
you mean a raise (race) exception during runtime?
-
Feb 15, 2018 at 05:59 PM
I meant something usually less disastrous, but I really dislike troubleshooting it.
-
Feb 15, 2018 at 06:06 PM
So... you dislike debugging Usain Bolt???
-
-
-
-
-
Feb 15, 2018 at 04:24 PM
Some kind of a track? I'm only "techno-functional" though. :)
-
Feb 15, 2018 at 06:04 PM
The result of it can be used for tracking in the sense of reporting, but it is not a track...
-
-
Feb 15, 2018 at 05:47 PM
My word, so many unhip people here. Never heard of Agile and "sprints"!?
(Yes, I know that's not the answer).
-
Feb 15, 2018 at 06:20 PM
You are right, it is not related to Agile, it is not trendy at all, you can encounter it also in very old systems.
-
-
-
Feb 15, 2018 at 08:29 PM
ok, just cannot stop laughing. Here I got one which I did not see
What's that?
-
Feb 15, 2018 at 11:12 PM
Table extension ��
-
Feb 16, 2018 at 08:49 AM
Hi Hendrik,
Got it:-)
-
Feb 16, 2018 at 08:57 AM
Dang, I was going to suggest table join :-)
-
-
-
-
Feb 16, 2018 at 12:34 AM
Structure :
-
Feb 16, 2018 at 09:02 AM
Maybe it can be defined as "meshed internal table" ?
-
Feb 16, 2018 at 09:06 AM
I don't know the answer to this one but it looks like it belongs in this discussion
-
Feb 16, 2018 at 10:08 AM
Cluster Tables?
-
Feb 16, 2018 at 07:12 PM
This looks like an R/3 allegory: some modules fit together well, some have stuff sticking out. And a hole is where Enterprise Services were supposed to come in. :)
-
Feb 19, 2018 at 09:20 AM
Actually I think it’s more of a deep, nested, boxed structure table
-
-
Feb 16, 2018 at 09:24 AM
Clue: usually not the best choice.
-
Feb 16, 2018 at 12:48 PM
(NW) Gateway?
-
Feb 16, 2018 at 12:51 PM
That's not it.
-
Feb 16, 2018 at 01:37 PM
Since the Display says "Entrance" this can't be a "UserExit", right :) ?
-
Feb 17, 2018 at 08:51 PM
No.
It's for all entries.
-
Feb 18, 2018 at 12:43 AM
OH SNAP
-
-
-
-
-
