topic Re: Transport Request in Application Development and Automation Discussions

Transport Request

Former Member — Wed, 11 May 2016 05:32:34 GMT

I have requirement that on the basis of TR Number An ALV Report will Call before import that TR Number . My requirment that user will enter TR Number in Seelction Screen an alv report will cal in which all deatails will show regarding that TR number but my problem is that this is require before TR import in STMS ,Because without import TR in STMS no values enter in table E070 and E070T. an i am fetching data from these tables . but it not possilble without import that TR , if any solution of this please suggest .

Re: Transport Request

pranay570708 — Wed, 11 May 2016 05:57:12 GMT

Hi Deepak,

You can make use of E071 table. Pass request number in TRKORR field, it will give you TR details. But, you have to pass the TR number of DEV/correction object

For example:

DEVK925206 USER 05.05.2016 TR details

- DEVK925207 USER 05.05.2016 Development/Correction

Pass DEVK925207 in table as input.

Re: Transport Request

Former Member — Wed, 11 May 2016 06:14:45 GMT

Data is not entering in any standard table without importing TR.But is shows in STMS_import Queue.

Re: Transport Request

RaymondGiuseppi — Wed, 11 May 2016 06:31:00 GMT

Did you try to read data from original system of the transport route thru some RFC call.

Start with FM TMS_MGR_READ_TRANSPORT_QUEUE to get the import queue entries and then look for some RFC enabled FM starting with TMS or TR or even generic FM like RFC_READ_TABLE.

Regards,

Raymond

Re: Transport Request

pranay570708 — Wed, 11 May 2016 06:55:07 GMT

Did you check E071 table? Because i can see entries in that for Development/Correction TR number before import.

Re: Transport Request

Former Member — Wed, 11 May 2016 09:14:35 GMT

how can we use TMS_MGR_READ_TRANSPORT_QUEUE to get data from STMS import in internal table to show get data.

Re: Transport Request

Former Member — Thu, 12 May 2016 03:48:43 GMT

GV_SYS ='SED'.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION GV_SYS

EXPORTING

query_table = 'E070'

* DELIMITER = ' '

* NO_DATA = ' '

* ROWSKIPS = 0

* ROWCOUNT = 0

tables

OPTIONS = OPTIONS

fields = FIELDS

data = GT_E070

EXCEPTIONS

TABLE_NOT_AVAILABLE = 1

TABLE_WITHOUT_DATA = 2

OPTION_NOT_VALID = 3

FIELD_NOT_VALID = 4

NOT_AUTHORIZED = 5

DATA_BUFFER_EXCEEDED = 6

OTHERS = 7

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

GIVING ERROR WITH SY-SUBRC = 7.

Re: Transport Request

Former Member — Thu, 12 May 2016 05:32:38 GMT

RFC_READ_TABLE fetching all entries of table where clause is not working. please help

Re: Transport Request

sanjaybit — Sat, 14 May 2016 18:41:49 GMT

Hello Deepak,

Pls check the database view TMSBUFFER.

Thanks,

Sanjay

Re: Transport Request

Sandra_Rossi — Sun, 15 May 2016 07:42:08 GMT

Did you search TMS_MGR_READ_TRANSPORT_QUEUE in the forum?

Re: Transport Request

Former Member — Mon, 16 May 2016 07:20:06 GMT

RFC_READ_TABLE not fetching all entries of table of destination define as per below mention when testing in quality server(SQP).

GV_SYS ='SED'.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION GV_SYS

This is fetching all entries from SQP not from SED.Please help.

Re: Transport Request

Sandra_Rossi — Mon, 16 May 2016 07:38:36 GMT

Did you search TMS_MGR_READ_TRANSPORT_QUEUE in the forum? Did you try anything?

Re: Transport Request

Former Member — Mon, 16 May 2016 08:45:42 GMT

HOW TO IMPLEMENT TMS_MGR_READ_TRANSPORT_QUEUE

SYNTAX TO USE PLEASE HELP.

Re: Transport Request

Former Member — Mon, 16 May 2016 09:24:11 GMT

TMS_MGR_READ_TRANSPORT_QUEUE is working properly but how can i get AS4DATE which is the date of transaction request creation that not shows in STMS_import.

Re: Transport Request

Sandra_Rossi — Mon, 16 May 2016 09:59:35 GMT

Okay, seemed not to be an issue to make TMS_MGR_READ_TRANSPORT_QUEUE work, at last!

So now, you're looking for the creation date of transport requests, and maybe you want other data. Either you import them, or you read them in the original system (for instance, you may use hese RFC-enabled function modules: TR_READ_COMM, TR_EXT_GET_REQUESTS)

Re: Transport Request

Former Member — Mon, 16 May 2016 10:19:17 GMT

i had already used RFC_Read_table but not working .

Re: Transport Request

Sandra_Rossi — Mon, 16 May 2016 13:13:15 GMT

I never told you of using RFC_READ_TABLE. Anyway, I see your previous attempt of using RFC_READ_TABLE, of course it won't work as you do, if I'm not wrong (is "SED" really an existing RFC destination in your system?). So I think you should either ask a confirmed ABAPer in your team, or take the time to read the ABAP documentation, or blogs about RFC. If then you have other questions, I advise you to first search the forum, then create a new thread, by using a meaningful title (for instance, "transport request" is not sufficient here, you should have better said "how to get transport requests from the import queue").

Re: Transport Request

Former Member — Tue, 17 May 2016 04:08:25 GMT

Thanks sir , my Requirements now complete thanks to all.