SWXTRAREQUEST SAP (Travel Request) Table details

Dictionary Type: Table
Description: Travel Request




ABAP Code to SELECT data from SWXTRAREQUEST
Related tables to SWXTRAREQUEST
Access table SWXTRAREQUEST




Table field list including key, data, relationships and ABAP select examples

SWXTRAREQUEST is a standard SAP Table which is used to store Travel Request data and is available within R/3 SAP systems depending on the version and release level.

The SWXTRAREQUEST table consists of various fields, each holding specific information or linking keys about Travel Request data available in SAP. These include FORMNUMBER (Number of Leave Request), APPROVDATE (Date), APPROVBY (Approver), CREATEDATE (Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP SWXTRAREQUEST table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient SWX_CLIENTCLNT3Assigned to domainMANDT
FORMNUMBERNumber of Leave Request SWX_FNUMBNUMC10NUM10SWFH_SWX_FNUMB
APPROVDATEDate SWX_DATEDATS8SYDATS
APPROVBYApprover SWX_APPROVCHAR12SYCHAR12
CREATEDATEDate SWX_DATEDATS8SYDATS
CREATEDBYApplicant SWX_ORDBYCHAR12SYCHAR12
OUTWARDDATEDate SWX_DATEDATS8SYDATS
RETURNDATEDate SWX_DATEDATS8SYDATS
CITYFROMDeparture city S_FROM_CITCHAR20Assigned to domainS_CITY
CITYTOArrival city S_TO_CITYCHAR20Assigned to domainS_CITY
PROCSTATEProcessing status SWX_PROCSTCHAR1SWX_PROCST
CONNIDOUTFlight Connection Number S_CONN_IDNUMC4Assigned to domainS_CONN_IDCON
CARRIDOUTAirline Code S_CARR_IDCHAR3Assigned to domainS_CARR_IDCARS_CARRIER_ID
CONNIDINFlight Connection Number S_CONN_IDNUMC4Assigned to domainS_CONN_IDCON
CARRIDINAirline Code S_CARR_IDCHAR3Assigned to domainS_CARR_IDCARS_CARRIER_ID
BOOKSTATEOUTFlight Scenario: Booking Status SWX_BOOKSTATECHAR1SWX_BOOKSTATE
BOOKSTATEINFlight Scenario: Booking Status SWX_BOOKSTATECHAR1SWX_BOOKSTATE
PRICEOUTAirfare S_PRICECURR15(2) S_PRICE
PRICEINAirfare S_PRICECURR15(2) S_PRICE
REQUESTNRNumber of Leave Request SWX_FNUMBNUMC10NUM10SWFH_SWX_FNUMB
CONDITIONSChar255 CHAR255CHAR255CHAR255

Key field Non-key field



How do I retrieve data from SAP table SWXTRAREQUEST using ABAP code

The following ABAP code Example will allow you to do a basic selection on SWXTRAREQUEST to SELECT all data from the table
DATA: WA_SWXTRAREQUEST TYPE SWXTRAREQUEST.

SELECT SINGLE *
FROM SWXTRAREQUEST
INTO CORRESPONDING FIELDS OF WA_SWXTRAREQUEST
WHERE...

How to access SAP table SWXTRAREQUEST

Within an ECC or HANA version of SAP you can also view further information about SWXTRAREQUEST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!