SQVI not showing info form other tables

[bogie]

Hi,

I am creating a query in SQVI that I will export to a spreadsheet.  I am using fields from the AUFK table and I am wanting to add "Equipment Number" and "Description of Technical Object" to the report.  However, when i try it gives me the "Fields from parallel tables within a line" error.

It seems i've gotten this to work previously.

Any help would be appreciated.

[JL23]

which tables did you join? or do you use a logical database?

[bogie]

Im using Logical Database: AFI

The EQ and Desc of TO are in table EQUI

I brought up both tables in the Join Table quickview and they didn't appear to be joined, but im sure they are somehow right?

[JL23]

Not sure what exactly you mean, you may have to add a screenshot or try to describe in more detail what you did

Meanwhile I move this discussion to the ABAP forum, as it is not really a MM application topic.

[bogie]

Thanks for your patience Jurgen,

I am simply in SQVI.  I have just selected "create" in the quickview.  That gives me my fields list and allows me to export to excel.

On the left had side of the screen i see the Data Source Hierarchy.  Listed are about  20 tables where I can pull in fields for my list.

I want to Export the following:

Order, Maintenance Account Type, User Status, Actual Start Date, Main Work Center for Maintenance Tasks, Description, Quantity, Plant, Priority, scheduling type, release, Equipment Number, From table AUFK.

I also want to bring in Description of Technical object from table EQUI

When I select fields from the EQUI table, it gives me the error i mentioned above.

I pulled both tables up in the JOIN quickview and they do not have a relationship.

[JL23]

can you describe this sentence in more detail, as this is the one where I already struggled initially: I pulled both tables up in the JOIN quickview and they do not have a relationship.

this is what I get and where I see both tables AUFK and EQUI in the Logical database.

How do you get the view from your screen shot?

[bogie]

If you go to SQVI  -> Create ->

In the Datasource drop down, select "Table Join".

Keep it in "Basic Mode"

This is ordinarily for a Join, however, I used it to test relationships between two tables.

Select the "Add Table" and add AUFK and EQUI.

Once they are both visible, you can hit the "Join Conditions" button and it will tell you that "No relationship found"

That's where my problem is, those tables are linked somehow, because I add equipment to each work order and need to export a spreadsheet showing this.

Let me know if this clears up the confusion.

[Former Member]

Hi,

There is no field join proposed by system automatically between tables AUFK and EQUI.

But, look for field name- OBJNR and you will have to manually join this field in both AUFK and EQUI.

This will let you proceed further with the query creation.

Let me know how you go on with this.

Regards,

Shilpa

[bogie]

Shilpa,

I read in another thread that those two, although they have the same name, are referring to different objects.

[Former Member]

It has worked for me in the past joining AUFK and EQUI with OBJNR.. Once I joined, on checking the 'Check link condition' was correct.

It might be worth giving it a try before you waive it off.

Thanks,

Shilpa

[bogie]

I swore i had tried that before, but sitting here for hours and hours, obviously i missed something.

Thanks

[Former Member]

Excellent! Thats what I said- Try it before you waive off my answer 😉 I was double sure it will work!;-)

[JL23]

What you explained is all standard for a join, but where is your logical database AFI here?

In the data source drop down , I can either select join or logical data base, not both.

[bogie]

Now that I have that done....its asking me to choose a layout.  There are none listed.  How do i create a layout to select here?