Join BSEG, BKPF, EKBE and EKPO

[henry_M]

Hello, I am working on a sql S/4 HANA db.

Anyone has an idea how to join the tables BSEG, BKPF with EKBE and EKPO. 

Thank you.

[RaymondGiuseppi]

EKBE contains primary keys of the other tables, where are you stuck?

[Cocquerel]

There are several standard CDS view involving those 4 tables.
You can run statement like this one to identify them

SELECT TOP 10
    "DEPENDENT_SCHEMA_NAME",
    "DEPENDENT_OBJECT_NAME",
    "DEPENDENT_OBJECT_TYPE",
    STRING_AGG("BASE_OBJECT_NAME",    ', ' ORDER BY "BASE_OBJECT_NAME" ) "TABLES"
FROM (SELECT
        DISTINCT "BASE_SCHEMA_NAME",
        "BASE_OBJECT_NAME",
        "BASE_OBJECT_TYPE",
        "DEPENDENT_DATABASE_NAME",
        "DEPENDENT_SCHEMA_NAME",
        "DEPENDENT_OBJECT_NAME",
        "DEPENDENT_OBJECT_TYPE",
        1 "COUNTER"
       FROM "SYS"."OBJECT_DEPENDENCIES"
       WHERE "BASE_OBJECT_TYPE" = 'TABLE'
       AND "BASE_OBJECT_NAME" IN ('BSEG', 'BKPF', 'EKBE', 'EKPO'))
GROUP BY "DEPENDENT_SCHEMA_NAME",
    "DEPENDENT_OBJECT_NAME",
    "DEPENDENT_OBJECT_TYPE"
ORDER BY SUM("COUNTER") DESC

[henry_M]

thank you for your reply. I ran the query, but my system does not have any standard views including these tables. Is it possible to share how the views, including these tables were created ? Thanks.

[Cocquerel]

do you get result when you query the view "SYS"."OBJECT_DEPENDENCIES" without filter ? If no, you are missing some system privileges.

[henry_M]

yes i got a result, but it did not show me any views with more than one table. i only got e.g. a view where table EKPO was used, then another view where the table EKBE was used, etc.

[Cocquerel]

I'm surprised. your S/4HANA version is maybe very old.