Transport Request

[former_member184495]

hi,

which table stores the details of a transport request (SE09)

cheers,

Aditya.

[Former Member]

E070 ..E071.. DETAILS you could see at E0*

hope this helps you

thomas

[andreas_mann3]

good morning brother Thomas.

Andreas

[Former Member]

Hi aditya,

1. E07* (E ZERO SEVEN *)

2. These are generally the main tables.

E070 Change & Transport System: Header of Requests/Tasks

E070A Change & Transport System: Attributes of a Request

E071 Change & Transport System: Object Entries of Requests/Tasks

regards,

amti m.

[Former Member]

These data could be found in the table E071. You can try this out.

[Laxmana_Appana_]

Hi,

Tables : E070, E070C, E07T.

<b>check the below select statement which is used in SE09

transaction :</b>

SELECT e070_{trkorr e070}trfunction e070_{trstatus e070}tarsystem

e070_{korrdev e070}as4user e070_{as4date e070}as4time

e070_{strkorr e070c}client e070c_{tarclient e07t}as4text

INTO TABLE x_request

FROM ( e070 LEFT JOIN e070c ON e070_{trkorr = e070c}trkorr )

LEFT JOIN e07t ON e070_{trkorr = e07t}trkorr

WHERE e070~trkorr IN s_trkorr

AND e070~trfunction IN s_trfun

AND e070~trstatus IN s_trstat

AND e070~tarsystem IN s_tarsys

AND e070~as4user IN s_as4usr

AND e070~as4date IN s_as4dt

AND e070~korrdev IN s_korr .

Regards

Appana

[former_member184495]

answered