# SAP Transport Request Tables: E070, E071, E07T and Related Fields > Source: https://netray.co/tools/sap-transport-request-tables-e070-e071-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Key fields of the SAP transport tables E070, E07T, E071, E071K, E070C and TADIR, with the TRFUNCTION and TRSTATUS values and the joins to report on transports. ## Category sap ## Erp SAP NetWeaver / Basis ## Audience - SAP Basis administrator - ABAP developer - Release manager ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Field or value **Key:** field **Type:** text #### Meaning **Key:** meaning **Type:** text #### Example value **Key:** example **Type:** text #### Typical join or use **Key:** join **Type:** text **Rows:** **Table:** E070 **Field:** TRKORR **Meaning:** Request or task number (header key) **Example:** DEVK900123 **Join:** Key to E07T, E071, E071K, E070C **Table:** E070 **Field:** TRFUNCTION **Meaning:** Type of request or task (domain TRFUNCTION) **Example:** K **Join:** Filter K and W for requests, S, Q, R, X for tasks **Table:** E070 **Field:** TRSTATUS **Meaning:** Status of request or task (domain TRSTATUS) **Example:** R **Join:** Filter D for open work, R for released **Table:** E070 **Field:** TARSYSTEM **Meaning:** Transport target of the request (system, or system.client with extended transport control) **Example:** QAS **Join:** Group open requests by route **Table:** E070 **Field:** KORRDEV **Meaning:** Request category: SYST (workbench) or CUST (customizing) **Example:** SYST **Join:** Split workbench and customizing counts **Table:** E070 **Field:** AS4USER **Meaning:** Owner of the request or task **Example:** JSMITH **Join:** USR02 or USER_ADDR on BNAME **Table:** E070 **Field:** AS4DATE / AS4TIME **Meaning:** Date and time of last change (release date once released) **Example:** 20261020 / 143005 **Join:** Date range filter for release reports **Table:** E070 **Field:** STRKORR **Meaning:** Higher-level request: filled on a task, holds its parent request **Example:** DEVK900120 **Join:** E070 task.STRKORR = E070 request.TRKORR **Table:** E07T **Field:** TRKORR + LANGU **Meaning:** Key of the short text table **Example:** DEVK900123 / E **Join:** E070.TRKORR = E07T.TRKORR and LANGU = sy-langu **Table:** E07T **Field:** AS4TEXT **Meaning:** Short description of the request or task **Example:** MM: new release strategy **Join:** Search requests by description text **Table:** E071 **Field:** TRKORR + AS4POS **Meaning:** Object list entry key (request or task plus line number) **Example:** DEVK900121 / 000001 **Join:** E070.TRKORR = E071.TRKORR **Table:** E071 **Field:** PGMID **Meaning:** Program ID: R3TR (whole object), LIMU (sub-object), CORR or R3OB **Example:** R3TR **Join:** With OBJECT and OBJ_NAME matches TADIR for R3TR entries **Table:** E071 **Field:** OBJECT **Meaning:** Object type **Example:** PROG, CLAS, TABL, TABU, LIMU METH **Join:** TADIR.OBJECT **Table:** E071 **Field:** OBJ_NAME **Meaning:** Object name **Example:** ZMM_RELEASE_REPORT **Join:** TADIR.OBJ_NAME **Table:** E071 **Field:** OBJFUNC **Meaning:** Object function: blank (normal), K (entries with keys in E071K), D (delete) and others **Example:** K **Join:** OBJFUNC = K means read E071K for the keys **Table:** E071 **Field:** LOCKFLAG **Meaning:** Lock status of the object in the request **Example:** 2 **Join:** Find objects still locked in open tasks **Table:** E071K **Field:** TRKORR, PGMID, OBJECT, OBJNAME, AS4POS **Meaning:** Key entries for table content objects (TABU, VDAT, CDAT); OBJNAME is the underlying table **Example:** DEVK900200, R3TR, TABU, T001W **Join:** E071 on TRKORR, E071.OBJECT = MASTERTYPE and E071.OBJ_NAME = MASTERNAME **Table:** E071K **Field:** MASTERTYPE / MASTERNAME **Meaning:** Type and name of the parent object the key belongs to (table or view) **Example:** TABU / T001W **Join:** Tie key lines back to the E071 object **Table:** E071K **Field:** TABKEY **Meaning:** Table key of the transported entry, starting with the client for client-dependent tables; may end in * as a generic key **Example:** 1001000 (client 100, plant 1000) **Join:** Which rows of a customizing table a request moves **Table:** E070C **Field:** CLIENT / TARCLIENT **Meaning:** Source client of the request and target client **Example:** 100 / 200 **Join:** E070.TRKORR = E070C.TRKORR **Table:** E070A **Field:** TRKORR + ATTRIBUTE + REFERENCE **Meaning:** Request attributes such as CTS project assignment **Example:** SAP_CTS_PROJECT **Join:** Report requests by project **Table:** TADIR **Field:** PGMID, OBJECT, OBJ_NAME **Meaning:** Repository directory key for every repository object **Example:** R3TR, PROG, ZMM_RELEASE_REPORT **Join:** E071 R3TR entries **Table:** TADIR **Field:** DEVCLASS **Meaning:** Package of the object **Example:** ZMM **Join:** TDEVC for the transport layer of the package **Table:** TADIR **Field:** SRCSYSTEM **Meaning:** Original system of the object **Example:** DEV **Join:** Find objects whose original is not the development system **Table:** TADIR **Field:** AUTHOR **Meaning:** Person responsible for the object **Example:** JSMITH **Join:** Ownership reports **Table:** TRNSPACE **Field:** NAMESPACE **Meaning:** Registered namespaces in the system (for /XYZ/ objects) **Example:** /ACME/ **Join:** Check a namespace is modifiable before import or development **Table:** TPALOG **Field:** TRKORR **Meaning:** tp import history and status per request and target system **Example:** DEVK900123 **Join:** Check SE11 on your release for the remaining columns **Table:** Domain TRFUNCTION **Field:** K / W / T / C **Meaning:** K workbench request, W customizing request, T transport of copies, C relocation of objects without package change **Example:** K **Join:** E070.TRFUNCTION **Table:** Domain TRFUNCTION **Field:** O / E / M **Meaning:** O relocation with package change, E relocation of complete package, M client transport request **Example:** O **Join:** E070.TRFUNCTION **Table:** Domain TRFUNCTION **Field:** S / R / Q / X **Meaning:** Tasks: S development or correction, R repair, Q customizing task, X unclassified task **Example:** S **Join:** E070.TRFUNCTION on rows with STRKORR filled **Table:** Domain TRSTATUS **Field:** D / L / O / R / N **Meaning:** D modifiable, L modifiable and protected, O release started, R released, N released with import protection for repaired objects **Example:** D **Join:** E070.TRSTATUS **Notes:** Requests and tasks both live in E070. A task has STRKORR set to its parent request; a request has STRKORR empty. Objects are recorded on the task, so to list every object of a request join E070 (tasks with STRKORR = request) to E071, and also read E071 for the request itself, which holds the objects after release. Join E070 to E07T on TRKORR and LANGU. Domain fixed values can be checked in SE11 for domains TRFUNCTION and TRSTATUS. ## Content **Intro:** This reference lists the key fields of the SAP transport tables E070 (header), E07T (description), E071 (object list), E071K (table keys), E070C (clients) and TADIR (repository directory), plus the fixed values of TRFUNCTION and TRSTATUS. Use it to write SE16N selections or ABAP and SQL reports on transports in any NetWeaver AS ABAP or S/4HANA system. **Sections:** #### How the transport tables fit together **Body:** E070 is the header: one row per request and one per task, keyed by TRKORR. A task points to its request through STRKORR. E07T holds the short text per language. E071 holds the object list: each line is a PGMID, OBJECT and OBJ_NAME, for example R3TR PROG ZREPORT or LIMU METH for a single class method. When the object is table content (R3TR TABU, VDAT, CDAT) the line has OBJFUNC K and the actual keys sit in E071K with TABKEY. E070C stores source and target client. TADIR is not a transport table but is where you go from an object to its package (DEVCLASS) and original system (SRCSYSTEM). #### Worked example: all objects of released workbench requests last month **Body:** In SE16N or a query, select E070 with TRFUNCTION = K, TRSTATUS = R and AS4DATE in the month. Join E07T on TRKORR with LANGU = E for the description. For the objects, select E071 where TRKORR is either the request or any task whose STRKORR equals the request. Add TADIR on PGMID, OBJECT and OBJ_NAME to show the package. For customizing requests (TRFUNCTION = W) also read E071K to see which table rows were moved. The result is a release note: request, owner, description, object type and name, package. **Bullets:** - Open requests by owner: E070 TRSTATUS = D and STRKORR empty, group by AS4USER - Who changed an object: E071 by OBJ_NAME, then E070 for owner and date - Rows moved for a table: E071K by MASTERNAME = table name #### Gotchas **Body:** Objects are recorded on tasks, and on release they are merged to the request, so counting only the request rows before release gives zero objects. TRFUNCTION values differ for tasks and requests, so always filter both TRFUNCTION and STRKORR. TARSYSTEM can hold a system plus client (QAS.100) when extended transport control is active. AS4DATE is the last change date, which becomes the release date once the request is released. E071K TABKEY can contain generic keys with an asterisk. And table names stay stable across releases, but field lists of TPALOG and attribute tables vary, so check SE11 before coding against them. **Cta:** If you want your team to ask your SAP system who changed what and when, in plain English on your own servers, we can build that over these same tables. **Faq:** #### Which SAP table stores transport request objects? **Answer:** E071 stores the object list of each request and task, with PGMID, OBJECT and OBJ_NAME per line. For table content objects with OBJFUNC K, the individual keys of the transported rows are in E071K. Join both to E070 on TRKORR to get owner, type and status. #### Which SAP table stores the transport request description? **Answer:** E07T stores the short text of requests and tasks in the field AS4TEXT, keyed by TRKORR and LANGU. Join it to E070 on TRKORR and the logon language to show descriptions in a request list. #### How do I find the tasks of a transport request? **Answer:** Select E070 where STRKORR equals the request number. Each row returned is a task, with TRFUNCTION S, Q, R or X and its own owner in AS4USER. The request row itself has STRKORR empty. #### What do the TRSTATUS values D, L, O, R and N mean? **Answer:** D is modifiable, L is modifiable and protected, O means release has started, R means released and N means released with import protection for repaired objects. Check the fixed values of domain TRSTATUS in SE11 on your release to confirm. ## Search terms sap transport request table, sap table for transport request objects, sap table for transport request description, sap transport table fields, transport request table in sap, sap table for transports, e070 e071 join, trfunction values --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json