Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Field Names in SAP query Output

benjamin_allsopp
Active Participant
0 Kudos
2,729

Hi There,

I'm currently in an implementation project and I've written quite a few queries (SQ01) in order to extract information with a view to inputting it into a different SAP system using LSMW. Because this is large quantities of fields it'd be helpful if I could use the Auto Field Mapping Function in the mapping process, in order to do this the field headings need to be the technical names of the fields.

My question is, how can I make the output of the SAP queries columns the technical name of the field as opposed to the description? e.g. I want to see 'MATNR' as opposed to 'Material'.

I know that I can do this with individual fields within the info-set by changing the header but I need to be able to do this on mass to be of any use to me.

Thanks in advance.

1 ACCEPTED SOLUTION

benjamin_allsopp
Active Participant
1,380

Never mind I  found a workaround some time ago.

Editing the titles manually within SAP query layout design.

It's a bit of a long winded approach when there's a lot of columns but I suppose when first making queries it's all part and parcel of the process.

2 REPLIES 2

benjamin_allsopp
Active Participant
1,381

Never mind I  found a workaround some time ago.

Editing the titles manually within SAP query layout design.

It's a bit of a long winded approach when there's a lot of columns but I suppose when first making queries it's all part and parcel of the process.

Giovanni--
Explorer
0 Kudos
1,143

Hello,

I've exactly the same need, I need technical names in query columns showed in SQ01. When there are many fields in query output, it's difficult to distinguish among different fields. Is there away to achieve this without changing manually the description of the column, field by field?  Thanks in advance.