Field Descriptions in the IDT

[former_member196240]

Hello,

Is there a way to get the field description in IDT 4.1? Currently my universe is incorporated with SAP ECC tables like MARA,MARC etc from the SQL.

But the fields like MATNR,MMSTA does not come up with the description. The user is writing a WEBi report on top of this universe but having hard time in pulling the fields into report, because its coming up with technical name only not with descrption.

Any help would be great.

thanks,

Vinay

[Former Member]

Are you Using data servies for pulling fields from R/3 to BO?

[former_member196240]

Hi Amardip - Yes, I am using BODS to populate SAP ECC tables to SQL and then pulling the tables in the Universe.

thanks,

Vinay

[Former Member]

Then you can change names of target fields in query transform in data Services.

OR

You can add field description in IDT.

So when user move mouse on that fields in query browser of webi report ,he can view field decription.

[former_member196240]

Currently am bringing almost all the fields of MARA/MARC/MDMA/MKVE.. Imagine the effort that is going to take to change the descriptions for the 100+ fields.

[Former Member]

It is the best practice.

Otherwise use second option.

[former_member196240]

Either of the ways, the manual effort is huge.