E070

Transparent Table System Table (transport)
9 Fields 33 CDS Views

Transport system: Headers of requests/tasks

E070 is an SAP database table in S/4HANA. Transport system: Headers of requests/tasks. It contains 9 fields. 33 CDS views read from this table.

CDS Views using this table (33)

ViewTypeJoinVDMDescription
ATOV_CBC_AND_BC_REQUESTS view_entity from All CBC and BC request
ATOV_CMN_DEPENDING_ON_REQUESTS view_entity inner Relevant Information of depending on Requests
ATOV_CMN_EXPORT_REQUEST_STATE view_entity from 3SL Transp. State 4 Export and Import
ATOV_CMN_EXPORT_REQUESTS view from ATO main Requests Information
ATOV_CMN_OPEN_BC_REQUESTS view_entity from ATO: Open BC Requests
ATOV_CMN_REQUEST_BOM view inner BOM of requests exported via CMN Export
ATOV_CMN_REQUESTS_CLIENT view inner CMN Requests with Client and Target
ATOV_OBJECTS_WB_REQUESTS_E071 view from JOIN E071 with Requests
ATOV_OPEN_TASK_OF_REQUEST_E070 view from TASK OF Requests
Atov_Pk_Item_Open_Transport view inner Open transport for key user item
ATOV_PK_ITEM_TRANSPORTS view inner All transports for key user items
Atov_Pk_Package_Conf view left_outer Package Configuration
Atov_Pk_Vh_Assigned_Transp view inner Value Help for assigned transport requests
Atov_Pk_Vh_Open_Requests view from Open Requests
ATOV_REQUEST_OF_TASK_E070 view from Request of Task
ATOV_REQUEST_OF_TASK_E070 view inner Request of Task
ATOV_TASK_AND_REQUEST_E070 view union_all TASK OF Requests
ATOV_TASK_OF_REQUEST_E070 view from TASK OF Requests
CBC_STA_E070 view_entity from
CTSProjects view inner CTS Projects
FAC_UH_MIGRTN_I_TRANSPORT_TASK view_entity from Transport task for selection
FCCX_V_Transports view_entity from Transport of a user
I_FinSubstnValdtnTranspTask view_entity from BASIC FIN Substitution Validation Transp Task
I_FinSubstnValdtnTranspTask view_entity inner BASIC FIN Substitution Validation Transp Task
I_RequestsHeader view from Requests
I_RequestsProject view from Request Project Details
I_TasksHeader view from Tasks
P_RespyMOpenWrkbnTransptReq view from BASIC
P_Sitn2Transport view from BASIC
R_Sitn2TransportRequestTask view from BASIC Transport Request Task Information
SXCO_TR_REQUEST view_entity from XCO Transport: Request
sxco_tr_task view_entity from XCO Transport: Task
sxco_tr_transport view_entity from XCO Transport

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY trkorr TRKORR Request/Task
trfunction TRFUNCTION Type
trstatus TRSTATUS Status
tarsystem TR_TARGET Transport Target
korrdev TRCATEG Category
as4user TR_AS4USER Owner
as4date AS4DATE Date
as4time AS4TIME Time
strkorr STRKORR Parent Request

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Transport system: Headers of requests/tasks
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE E070 (
    TRKORR,      -- Request/Task [TRKORR]
    TRFUNCTION,  -- Type [TRFUNCTION]
    TRSTATUS,    -- Status [TRSTATUS]
    TARSYSTEM,   -- Transport Target [TR_TARGET]
    KORRDEV,     -- Category [TRCATEG]
    AS4USER,     -- Owner [TR_AS4USER]
    AS4DATE,     -- Date [AS4DATE]
    AS4TIME,     -- Time [AS4TIME]
    STRKORR,     -- Parent Request [STRKORR]
    PRIMARY KEY (TRKORR)
);

Learn More