SAP FTPRE Foreign Trade: Selection fields in Preference Table data and field list

FTPRE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Foreign Trade: Selection fields in Preference" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FTPRE TYPE FTPRE.

The FTPRE table consists of various fields, each holding specific information or linking keys about Foreign Trade: Selection fields in Preference data available in SAP. These include PRENE_T (Foreign Trade: PRE: Vendor Declaration: ALV), GZOLX_T (Foreign Trade: PRE: Vendor Declaration: ALV), P_BETOL (Tolerance days purchase order), P_EULIF (Indicator 'Only dun EU vendors')... 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. .

FTPRE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTPRE structure 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 FTPRE 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
P_SIMULIndicator simulated run P_SIMULCHAR1XFELD
PRENE_TForeign Trade: PRE: Vendor Declaration: ALV PRENE_KTXTCHAR60DDTEXT
GZOLX_TForeign Trade: PRE: Vendor Declaration: ALV GZOLX_KTXTCHAR30TEXT30
P_BETOLTolerance days purchase order P_BETOL_DAYSDEC3MHNTGBTO
P_EULIFIndicator 'Only dun EU vendors' P_EUCHAR1XFELD
P_ANSCHPrint letter P_ANSCHCHAR1XFELD
P_MAHNEPrint dunning letter indicator P_MAHNECHAR1XFELD
P_MAXMAMaximum dunning level P_MAXMANUMC1NUMC1
P_ANTXTRequest text P_MTXT1CHAR70TDOBNAME
P_MATXTText container for dunning text P_MATXTCHAR70TDOBNAME
P_SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
P_SHOWLIndicator list display P_SHOWLCHAR1XFELD
P_PREISBottom price for materials P_PREISCURR11(2) WERT11V
P_WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
P_BETPRPO tolerance check active P_BETOL_CHECKCHAR1XFELD
P_DRUCKCheckbox XFELDCHAR1XFELD
P_DOCSPOutput language for vendor declaration P_DOCSPCHAR1XFELD
P_NEWPGIndicator separate long-term vendor declara. for each mat. P_NEWPGCHAR1XFELD
P_EKVERAggregate indicator P_EKVERCHAR1XFELD
P_DPATHDirectory for form letter data P_PATHCHAR128LOCALFILE
P_POPUPIndicator selection window for print preview P_POPUPCHAR1XFELD
P_NOPREIndicator: Do not print preference zones on list P_NOPRECHAR1XFELD
P_OUTPTForeign Trade: PRE: Output types P_OUTPTCHAR1XFELD
P_LIEFForeign Trade: Preference: Request vendor declaration? P_LIEFCHAR1XFELD
P_CHKFKMaterials from billing documents P_CHKFKCHAR1XFELD
P_MATNR_PREForeign Trade: Preference Handling: Alternative: Mat. no. MATNR_PRECHAR18Assigned to domainMATN1MATNRMAPMAT1
P_ESOKZIndicator: Select Types of Purchasing Info Records P_ESOKZCHAR1XFELD
P_EKNORForeign Trade: Purchasing info record type P_EKTYPCHAR1XFELDEKN
P_EKKONForeign Trade: Purchasing info record type: Consignment P_EKKONCHAR1XFELDEKK
P_EKLOBForeign Trade: Purchase info record type: Subcontracting P_EKLOBCHAR1XFELDEKL
P_EKPIPForeign Trade: Purchasing info record type: Pipeline P_EKPIPCHAR1XFELDEKI
P_USEPRInd.: Auto. Determ. of Long-Term Vendor Decl. Validity Date P_USEPRCHAR1XFELD
P_ZONESIndicator: Print Preference Zone Comments P_ZONESCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure FTPRE using ABAP code?

As FTPRE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTPRE as there is no data to select.

How to access SAP table FTPRE

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

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