topic Re: Sql query bsis bseg help in Application Development and Automation Discussions

Sql query bsis bseg help

former_member772856 — Thu, 21 Oct 2021 09:37:56 GMT

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

Re: Sql query bsis bseg help

former_member763929 — Thu, 21 Oct 2021 09:38:03 GMT

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.

Re: Sql query bsis bseg help

RaymondGiuseppi — Thu, 21 Oct 2021 15:28:05 GMT

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

Re: Sql query bsis bseg help

retired_member — Thu, 21 Oct 2021 16:26:27 GMT

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