SAP FTULO Foreign Trade: Work Table for UPLOAD of Foreign Trade Data Table data and field list

FTULO is a standard SAP Table which is used to store Foreign Trade: Work Table for UPLOAD of Foreign Trade Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FTULO table consists of various fields, each holding specific information or linking keys about Foreign Trade: Work Table for UPLOAD of Foreign Trade Data data available in SAP. These include EDI_DOCNUM (IDoc number), EDI_SEGTYP (Segment type), FTLNR (Sequential number for applications in Foreign Trade), LAND1 (Delivering country)... 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. .

FTULO table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FTULO table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EDI_DOCNUMIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
EDI_SEGTYPSegment type EDILSEGTYPCHAR27EDISEGMENTEDILSEGTYPSEG
FTLNRSequential number for applications in Foreign Trade FTLNRNUMC9NUMC09
LAND1Delivering country HLANDCHAR3T005LAND1VAL
FTOBJ_ELE_01Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_02Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_03Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_04Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_05Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_06Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_07Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_08Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_09Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_10Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
FTOBJ_ELE_11Foreign Trade: Upload: Object key element FTOBJ_ELECHAR2CHAR02
EDI_MESTYPMessage Type EDI_MESTYPCHAR30Assigned to domainEDI_MESTYPMES
EDI_IDOCTPBasic type EDI_IDOCTPCHAR30Assigned to domainEDI_IDOCTPIDC
FTDT1Data record for communication and upload in Foreign Trade FTDTACHAR254FTDTA
FTDT2Data record for communication and upload in Foreign Trade FTDTACHAR254FTDTA
FTDT3Data record for communication and upload in Foreign Trade FTDTACHAR254FTDTA
FTDT4Data record for communication and upload in Foreign Trade FTDTACHAR254FTDTA
FTDT5Data record for communication and upload in Foreign Trade FTDTACHAR254FTDTA

Key field Non-key field



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

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

SELECT SINGLE *
FROM FTULO
INTO CORRESPONDING FIELDS OF WA_FTULO
WHERE...

How to access SAP table FTULO

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

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