Skip to Content

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

26
Show 135
* Please Login or Register to Comment on or Follow discussions.
avatar image
Feb 09 at 07:17 AM edited Feb 09 at 07:23 AM
2.2k

And here's a pooled table

And a table cluster

pooled-table.jpg (106.3 kB)
table-cluster.jpg (167.6 kB)
9 Share

Ha Ha Ha. So mean. The same happens when someone asks "What is Plant?"

1 Share

Finally, for HANA afficianados, here are some column store tables.

column-store.jpg (249.8 kB)
17 Share
Matthew Billingham
Feb 09 at 03:19 PM

Brilliant.

0 Share

This just made my Sunday evening. Thanks!

0 Share

Internal table

inside-cromarty.jpg (141.0 kB)
15 Share

And hash table. :)

table.jpg (60.8 kB)
18 Share

A sore ted table?Image result for sore teddy table

4 Share

Very subtle! :)

0 Share

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)

builder.jpg (7.3 kB)
agent.jpg (4.8 kB)
2 Share

Umm, your image names are a bit of a giveaway :-)

3 Share

Yeah, I kind of noticed that, but thanks for giving clues to anybody else Mike. :-)

1 Share

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

puzzle-1.jpg (437.0 kB)
puzzle-2.jpg (48.4 kB)
2 Share
Matthew Billingham
Feb 09 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.

0 Share

I see nested tables but drawing blanks with the first one...

2 Share

Yep. Nested table. At a stretch - Sorted.

2 Share
Matthew Billingham
Feb 09 at 10:34 PM

shadow table

4 Share

Jurgen has it. Comes up mostly in upgrades.

1 Share

Well, it was an 'ASHed table. But shadow table is better and Jelana nailed the Hashed Table.

1 Share
Matthew Billingham
Feb 10 at 01:36 AM

I still see all the earlier pictures.

1 Share

Dooooo iiiiiiit!

I so would like to see that in a 'real' answer. Brilliant selection of graphics, by the way.

3 Share

I know Matthew Billingham should totally do this! Please???

1 Share

Image result for waiter

For Sue's game....
1 Share

Oh that's a tough one.

That's a wait step.

Yeah, I know that's the wrong answer. ¯\_(ツ)_/¯

0 Share

Haha, well, of course you would interpret it related to your field of specialization! ;)

0 Share

Hint: One type of these is

Image result for application

egilz.jpeg (16.4 kB)
2 Share

Haha, it's a server. :)

2 Share
Jelena Perfiljeva
Feb 10 at 01:36 AM

Ding ding ding!

1 Share

This is what I don't use.

scn.jpg (39.6 kB)
1 Share
Jelena Perfiljeva
Feb 10 at 01:38 AM
Eclipse! Yeah, me neither if I can avoid it. ;)
1 Share

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... ;-)

2 Share
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.

1 Share

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. :-(

1 Share

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.

3 Share

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.

0 Share

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).

0 Share

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! :)

0 Share

Just for Mike Pokraka (since you always have to ask for it in the Q&A)

some-picture.jpg (5.3 kB)
3 Share

n=1 branch of a binary search tree?

1 Share

Looking for the log, aren't you?

2 Share

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...

0 Share

Oh yes we will!

1 Share

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.

1 Share
Matthew Billingham
Feb 12 at 05:44 AM

Just a (bad?) guess - COLLECT

While searching for the answer, I figured there is a transaction code called AMEN!

2 Share

Correct. A collect is a short prayer in Anglican/Catholic/Orthodox (and probably other) churches.

1 Share

OK, this one might be slightly oblique:

Hint: It has nothing to do with clocks or time.

0 Share

Is it a circular reference?

0 Share
Matthew Billingham
Feb 12 at 09:14 PM

Interesting train of thought, but no it's more concrete (or wood?) than that.

0 Share

looks like ASAP

1 Share

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.

0 Share

"Time chairing"? :)

0 Share

Some kind of SAP R/3 allegory? Looks impressive but made of wood and will wear off by 2025? :)

1 Share

No, more "technical" than that...

There, I've given it away.

0 Share

Is it related to this:

002.jpg (153.4 kB)
1 Share

I've been trying to figure out what that is supposed to mean ... stumped!

0 Share

I could be wrong, but I think that is a pointer.

Veselina Peykova ?

2 Share
Show more comments

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 ;-)

0 Share

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.

0 Share

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.

0 Share

What happens when you log in to their system the first time and find this?

0 Share

Balls on the glass? Sorry, drawing blanks here...

0 Share

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.

1 Share

Someone already 'broke'???

That's the best pool-playing thing I can come up with.

1 Share

So, what's this

puzzle-3.jpg (153.5 kB)
3 Share

The tear of a SAP Basis admin confronted with a legacy system?

3 Share

..or a broken website

0 Share

OMG Steffi Warnecke LOL!

0 Share

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.

2 Share

"I have an urgent client requirement for ay-bee-ay-pee developer" [click]

2 Share

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.

3 Share

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.

1 Share

SAP on the web? haha

2 Share

It's SAP, but it's gooey.

SAPGui.

4 Share

Brilliant! GUI pecan buns will never be the same to me. :)

scn.jpg (27.5 kB)
1 Share
Show more comments

Same with "sequel" that is in other countries pronounced as letters S-Q-L.

1 Share

Oh. Not squirrel then... ;-)

1 Share

The answer to your question translated into my language is:

001.jpg (9.6 kB)
0 Share

But what is it?

0 Share

Сап (pronounced as [sap]) is the wooden handle of an instrument like claw-hammer, spade, mattock.

3 Share

Veselina Peykova, I was actually thinking of 'sap' (honestly) but in our country, they are mostly made to beat the heck out of people.

Image result for sap weapon

1 Share

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 :)

0 Share

I know them as blackjacks.

0 Share

Another one. Small clue: a component of Netweaver.

puzzle-1.jpg (103.9 kB)
1 Share

a SAW backwards
--> WAS, aka Web Application Server

3 Share

You got it.

1 Share

Fairly simple, I think.

puzzle2.jpg (51.1 kB)
0 Share
Matthew Billingham
Feb 14 at 10:50 PM

SLD ? Missing the UFOs to be a LMDB.

0 Share

No. Nothing to do with that-

0 Share
Matthew Billingham
Feb 15 at 09:06 AM

A heat map?

0 Share

It's a star schema.

Schema - a representation of a plan or theory in the form of an outline or model.

1 Share

Oh, I thought about "universe". Isn't that some kind of thingy for analysis or something?

2 Share

Does no-one know what a Hertzsprung–Russell diagram is?

0 Share

Yes, you do! :D

1 Share

Yep we use universes in Analytics - Semantic layer and stuff.

0 Share

Just need to get this one out of the way.

puzzle-3.jpg (59.0 kB)
0 Share

There are bagels somewhere in SAP? 8-[ ]

0 Share

ABagel/4 I don't think so.

0 Share

Rolls? :D

0 Share

ARoll/4 I don't think so! :-D

0 Share
Matthew Billingham
Feb 15 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!

1 Share
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. :)

1 Share

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.

2 Share

Good thing there is no British Organization of Original Billboard Sellers... Okay, I'll see myself out now. :)

0 Share

Go to Newcastle and tha' can have a stottie cake (pronounced kayeck) lass.

Why use one word when you have hundreds of regional variations.

1 Share

pop is easy -- the bubbles , the sound they make when you take the cap off ;)

0 Share

An easy one for functional folks:

simage.jpg (93.8 kB)
0 Share

*Are* there functional folks here?

<crickets>

3 Share

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.

1 Share
Veselina Peykova
Feb 15 at 04:29 PM

you mean a raise (race) exception during runtime?

1 Share

I meant something usually less disastrous, but I really dislike troubleshooting it.

0 Share

So... you dislike debugging Usain Bolt???

1 Share
Show more comments

Some kind of a track? I'm only "techno-functional" though. :)

1 Share

The result of it can be used for tracking in the sense of reporting, but it is not a track...

0 Share

My word, so many unhip people here. Never heard of Agile and "sprints"!?

(Yes, I know that's not the answer).

3 Share

You are right, it is not related to Agile, it is not trendy at all, you can encounter it also in very old systems.

0 Share

ok, just cannot stop laughing. Here I got one which I did not see

What's that?

unbenannt.jpg (13.9 kB)
4 Share

Table extension ��

3 Share

Hi Hendrik,

Got it:-)

1 Share

Dang, I was going to suggest table join :-)

1 Share

Structure :

s.jpg (39.9 kB)
2 Share

Maybe it can be defined as "meshed internal table" ?

1 Share

I don't know the answer to this one but it looks like it belongs in this discussion

table-thingy.jpg (87.9 kB)
0 Share

Cluster Tables?

0 Share

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. :)

0 Share

Actually I think it’s more of a deep, nested, boxed structure table

0 Share

Clue: usually not the best choice.

puzzle.jpg (236.6 kB)
1 Share

(NW) Gateway?

0 Share

That's not it.

0 Share

Since the Display says "Entrance" this can't be a "UserExit", right :) ?

1 Share

No.

It's for all entries.

5 Share
Matthew Billingham
Feb 18 at 12:43 AM

OH SNAP

0 Share
10 |10000 characters needed characters left characters exceeded