InfoSet Query displaying multiple characteristics

[former_member601006]

Hi

I am trying to display multiple characteristics of my Equipment master. I can display only one characteristic and the second characteristic is display on 2nd row instead of a 2nd column.

Note: The reason I am using infoset query because I am also display some additional fields from Partner Tables (name, address, phone etc). Therefore can't use standard equipment report.

How can I create a infoset report to display two columns, one for each characteristic Value?

For Example:

Vehicle is created as Equipment, which has characteristics Vehicle_Color and Vehicle_Type.

I would like to display report like below

Equipment number | Vehicle_Colour | Vehicle_Type

12345678 |White | Sedan

But I am currently getting only one column to display but two rows one for each characteristic

Equipment number | Characteristic Value

12345678 |White

12345678 |Sedan

Please help,..Thanks in advance

[Former Member]

Hi

You can use standard report IH08 and in the report you can choose Settings --> Show/Hide Classification to display the classes you want in the report.

Hope this helps.

Best Regards

Sathees Gopalan

[former_member601006]

Hi Actually I can't use the standard report. because I need to display information from mutiple tables. In addition to the standatd equipment fields and characteristics I need to show Custodian (partner) name, city, state, telephone number etc.

This is I create infoset query using logical data base EQI . but i am having trouble showing more than one characteristic vales as output on seperate columns.

[former_member601006]

Thanks for your replies.

Before I was using the logical database in my infoset. but now I am thinking of using tables instead.

Actually I am trying to extract data from equipment Master. Our fleet vehicles are created as Equipment with characteristic, Equipment is linked to partner (personnel number).

So i need a report which can provide me the following information.

-Equipment Master Fields: (From Table EQUI) I am OK with this.

-Fleet Fields: (From Table Fleet) I am OK with this.

-Characteristic: (From Table INOB, AUSP ?) Not sure, please guide

-Partner Field:(From Table IHPA) But from this table I can't get the name, address of the partner, which are

stored in table pa0002. how can I make a connection?

Please guide me how could I setup a query to get partner name, address etc.

Cheers