How to find the technical name of the #SAP #BW query in a transport
Introduction
Facing the issue that on finding out what query is in this transport happens quite often. Unfortunately it is not that straight
forward showing the technical name of the query within a transport request.
Find the technical name of the query
Analyzing RSZELTDIR table to quickly solve this.
Copy/Paste all query elements on the transport with Ctrl-Y and paste it in ELTUID of table RSZELTDIR.
Now add a filter on OBJVERS = A and DEFTP = REP.
The field MAPNAME now shows the technical name of the query.
Hi Grob
it's very useful to identify the query item belong to which query!
Regards,
dragon
Helpful INFO , Thanks For sharing
Hi Martin,
Really useful document. It is very useful when we are transporting multiple queries in one transport.
Thanks,
Purushotham.
Thanks for your comments I hope it's useful
Thanks for document
regards
Raj
Good Information.
Regards,
Sushant
Short and sweet with helpful information martin....
Regards,
SM
Good one 🙂 useful info....Thanks Martin.
Regards
Krishna Chaitanya
Useful document shared. thanks for sharing. 🙂
very useful information
thanks!
Thanks for sharing Martin.
Useful...thank u for sharing ur knowledge
you're welcome
Great piece of Information Martin..
Also it shows many things in DEFTP(Definition type of an element), if we have other query elements of them also it will show.
1. SOB Filters
2. VAR Variable
3. STR Structure
4. SEL Restricted KF
5. CKF Calculated KF
6. FML Formula
Regards,
Abdullah
yes you are right it can also show different objects other then REP
Informative document ..thanks for sharing
Splendid piece of information Grob. Very Helpful. 🙂
Anirban
Excellent article! Thanks for sharing!
Very good article Martin.
It would also ease the life of developer to address clients, if we have any table in which we get the Rows and Columns directly.
you can use transaction RSRTQ for this.
M.
Great job !