Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Views & joining same table twice?

Hi,

I am running into this problem and I am stuck.

Short story:

I need to join two views into one view,

or include one view into another containing base tables,

or join the same table twice using, maybe, and alias.

Long story:

I have to create a view which joins vendor number and name with manufacturer number and name. All this through views and no coding.

There already exists a working view containing the vendor info and manufacturer number.

Z_VENDOR_VIEW

Tables:

MARA

LFA1

MARC

MAKT

EINA

Using the manufacturer number (MFRNR) from the above, I want to fetch the name from LFA1-NAME1.

The problem is that LFA1-NAME1 is already used in the above view as the vendor name with the join condition EINA and LFA1.

The end result should display: vendor_# vendor_name manufacturer_# manufacturer_name.

Thanks,

Former Member
Not what you were looking for? View more on this topic or Ask a question