Skip to Content
Author's profile photo Martin Grob

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.

A.png

Now add a filter on OBJVERS = A and DEFTP = REP.

B.png

The field MAPNAME now shows the technical name of the query.

C.png

Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi  Grob

           it's very useful to identify the query item belong to which query! 

      Regards,

      dragon

      Author's profile photo Former Member
      Former Member

      Helpful INFO , Thanks For sharing

      Author's profile photo Former Member
      Former Member

      Hi Martin,

      Really useful document. It is very useful when we are transporting multiple queries in one transport.

      Thanks,

      Purushotham.

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Thanks for your comments I hope it's useful

      Author's profile photo Former Member
      Former Member

      Thanks for document

      regards

      Raj

      Author's profile photo Former Member
      Former Member

      Good Information.

      Regards,

      Sushant

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Short and sweet with helpful information martin....

      Regards,

      SM

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one 🙂 useful info....Thanks Martin.

      Regards

      Krishna Chaitanya

      Author's profile photo Srinu S
      Srinu S

      Useful document shared. thanks for sharing. 🙂

      Author's profile photo Former Member
      Former Member

      very useful information

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      thanks!

      Author's profile photo Vikrant Mohite
      Vikrant Mohite

      Thanks for sharing Martin.

      Author's profile photo Former Member
      Former Member

      Useful...thank u for sharing ur knowledge

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      you're welcome

      Author's profile photo Abdullah Qureshi
      Abdullah Qureshi

      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

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      yes you are right it can also show different objects other then REP

      Author's profile photo Former Member
      Former Member

      Informative document ..thanks for sharing

      Author's profile photo anirban mukhopadhyay
      anirban mukhopadhyay

      Splendid piece of information Grob. Very Helpful. 🙂

      Anirban

      Author's profile photo Former Member
      Former Member

      Excellent article! Thanks for sharing!

      Author's profile photo Yugandher Yadav
      Yugandher Yadav

      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.

      Author's profile photo M Tibollo
      M Tibollo

      you can use transaction RSRTQ for this.

      M.