A very strange SQL requirement

[ekekakos]

Hello, we have the following 2 tables: ZEK_SBOOK & ZEK_SCARR with the following data:

CARRID	FLDATE	NAME	SEATS
AA	30.05.2024	ELIAS	5
AB	30.05.2024	MARIA	2
AA	31.05.2024	JOHN	3

CARRID	AIR_NAME
AA	AIRLINE1
AB	AIRLINE2
AF	AIRLINE3
BE	AIRLINE4

What the customer is asking is to have the following ALV.

CARRID	FLDATE	NAME
AA	30.05.2024	ELIAS
AB	30.05.2024	MARIA
AF	30.05.2024
BE	30.05.2024
AA	31.05.2024	JOHN
AB	31.05.2024
AF	31.05.2024
BE	31.05.2024

In a few words they want to have all airlines for each date with the data of the table ZEK_SBOOK having or not.

Is it possible to do it in a query?

Thanks

Elias

[Sandra_Rossi]

ABAP SQL probably not, but I think that it's possible for native SQL (HANA or other database), I already saw same kind of SQL questions in Stack Overflow, also I'm sure it's possible with HANA SQLScript (it's a programming language so anything is possible).

[flachlaender]

Are you sure your requirement is correct?

There is no AF or BE flight on 30.05.2024, so what is the logic a line for these show up in the ALV? Just because another airline has a flight on that day?

[ekekakos]

Imagine that these airlines are werks and the customer wants to know which have movements and which haven't. And this must be per day. This customer has this in his old system and he want it in SAP. I told you strange requirement.

[flachlaender]

According to the data in ZEK_SBOOK there is no movement of AR or BE on 30.05.24.

And: No, there is no SQL statement which invents data which is not in the table.

For hallucinating data I am afraid you have to use a LLM.