"
Etiqueta > database
Supported by

INSERT dbtab ACCEPTING DUPLICATE KEYS

When you try to insert a record with a key which already exists in the table the program dumps. This, in some cases, is not desirable because, even if you don’t care, it forces you to check if the keys already exist before trying to insert then.

But ABAP has a solution for these situations:



INSERT dbtab FROM TABLE itab [ACCEPTING DUPLICATE KEYS].

Don’t worry because this will not violate the first law of thermodynamics: the duplicate records are not inserted. The only difference is that the program will not dump.

Greetings from Abapinho.

GROUP BY in LOOPs on internal tables

We’ve all sorted internal tables to use AT NEW on a LOOP.
But starting from 7.40, we can use GROUP BY on LOOPs.

The ability to group by values based on expressions or even methods is great.

The grouping is done on the first LOOP and can be processed afterwards. Try running the code below and I bet you’ll be as impressed as I was.

Ler o resto do artigo! »

You can save variants in SE16N

And that’s it really. That’s the whole tip right there at the title. This has always been right under your nose but you probably never thought about it: you can save variants in SE16N. And they can even be user-specific. So useful and so little known.

Thank you Sérgio Fraga for the tip.
Thank you Cloudtail for the photo.

Greetings from Abapinho.

SE16H – Aggregate data without using Excel

A long time ago transaction SE17 was used to look at database tables content.
They quickly felt ashamed and decided to improve it, creating SE16.
When ALV was invented, SE16N was released (although until today many people still use SE16, go figure!).

Today I present you SE16H.

Ler o resto do artigo! »


About Abapinho
Abapinho runs on WordPress
Articles (RSS) e Comments (RSS).