Sql query bsis bseg help

[former_member772856]

hi,

I have a table woth 3 fileds:

BUKRS, GJAHR, BUZEI

from table BSIS.

And i need to create a sql query to get:

MATNR, EBELN, EBELP

for each line in the table i have (bukrs, gjahr, buzei)

from table BSEG.

Thanks in advance

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[RaymondGiuseppi]

You have the primary keys to BSEG, where are you stuck (SELECT ?)

[retired_member]

A case for a join with FROM @itab

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abapselect_itab.htm