Transport Request

[Former Member]

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 .

[pranay570708]

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.

[Former Member]

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

[pranay570708]

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

[RaymondGiuseppi]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Sandra_Rossi]

Did you search TMS_MGR_READ_TRANSPORT_QUEUE in the forum?

[sanjaybit]

Hello Deepak,

Pls check the database view TMSBUFFER.

Thanks,

Sanjay

[Former Member]

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.

[Sandra_Rossi]

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

[Former Member]

HOW TO IMPLEMENT  TMS_MGR_READ_TRANSPORT_QUEUE 

SYNTAX TO USE PLEASE HELP.

[Former Member]

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.

[Sandra_Rossi]

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)

[Former Member]

i had already used  RFC_Read_table  but not working .

[Sandra_Rossi]

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").

[Former Member]

Thanks sir , my Requirements now complete  thanks to all.