FTSEL SAP (Selection Indicator Work Area for Reporting in FT) Structure details
Description: Selection Indicator Work Area for Reporting in FT
Structure field list including key, data, relationships and ABAP select examples
FTSEL 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 "Selection Indicator Work Area for Reporting in FT" 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_FTSEL TYPE FTSEL.
The FTSEL table consists of various fields, each holding specific information or linking keys about Selection Indicator Work Area for Reporting in FT data available in SAP. These include KWLDI (SLS: Create key words: List output?), DEL_DATA (Foreign trade: Legal control - SLS - Delete old data), CHECK_CORE (Check for different control reasons), SLDKZ (Deletion indicator for entry in sanctioned party list).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FTSEL structure 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 |
KWLDI | SLS: Create key words: List output? | KWLDI | CHAR | 1 | XFELD | ||||
DEL_DATA | Foreign trade: Legal control - SLS - Delete old data | DEL_DATA | CHAR | 1 | XFELD | ||||
CHECK_CORE | Check for different control reasons | CHECK_CORE | CHAR | 1 | XFELD | ||||
SLDKZ | Deletion indicator for entry in sanctioned party list | SLDKZ | CHAR | 1 | XFELD | ||||
SHOW_TEXT | Indicator: Determines whether texts for data will be read | SHOW_TEXT | CHAR | 1 | XFELD | ||||
P_PRZAB | Open value in percent for license for legal control | P_PRZAB | DEC | 5(2) | PRZ32 | ||||
P_ANZTG | Number of days until validity end of export license | P_ANZTG | NUMC | 3 | NUM03 | ||||
CHECK_ANZ | Foreign Trade: Legal Control: SLS: Number of Checks | CHECK_ANZ | NUMC | 12 | CHECK_ANZ | ||||
CHECK_PER | Foreign Trade: Legal Control: SLS: Checking Time | CHECK_PER | NUMC | 12 | CHECK_PER | ||||
P_AUFTR | Document type 'sales doc' for Reporting in Foreign Trade | P_AUFTR | CHAR | 1 | XFELD | ||||
P_LIEFR | Document type 'delivery doc.' for Reporting in Foreign Trade | P_LIEFR | CHAR | 1 | XFELD | ||||
GKEYW | Foreign Trade: Legal Control: SLS: Determine key words | GKEYW | CHAR | 1 | XFELD | ||||
P_KUM | Leg. Contrl: Bureau of Exp. Administr. diskette: Aggr. data | P_KUM | CHAR | 1 | XFELD | ||||
P_FILE | Leg. Contrl: Bureau of Exp. Administr. diskette: Create file | P_FILE | CHAR | 1 | XFELD | ||||
LIFTYP | BAFA (German Federal Export Office) diskette: Document type | LIFTYP | CHAR | 1 | CHAR1 | ||||
DISP_ALL | FT: Legal Control: Display Variant (Detail in dialog box) | DISP_ALL | CHAR | 1 | XFELD | ||||
SHOW_MSG | Indicator if system shall display processing step | SHOW_MSG | CHAR | 1 | XFELD | ||||
VAR_CON | Foreign Trade: Legal Control: Tree variant | VAR_CON | CHAR | 14 | Assigned to domain | VARIANT | VCN | ||
P_GEGRU | Legal Regulation for Legal Control | P_GEGRU | CHAR | 1 | CHAR1 | ||||
P_GEART | License type | P_GEART | CHAR | 1 | CHAR1 | ||||
P_ALAND | Departure country (country from which the goods are sent) | P_ALAND | CHAR | 1 | CHAR1 | ||||
P_EXLND | Destination Country of Export Transaction for Legal Control | P_EXLND | CHAR | 1 | CHAR1 | ||||
P_PRKLAS | Legal Control: Product Classification Check | P_PRKLAS | CHAR | 1 | CHAR1 | ||||
P_LAKLAS | Legal Control: Country Classification | P_LAKLAS | CHAR | 1 | CHAR1 | ||||
P_FORMR | Name of FORM routine for user-defined function | P_FORMR | CHAR | 1 | CHAR1 | ||||
P_LGRUP | Country Grouping for Export Control | P_LGRUP | CHAR | 1 | CHAR1 | ||||
P_ALNUM | Export Control Class according the Legal Reg. for Legal Ctrl | P_ALNUM | CHAR | 1 | CHAR1 | ||||
P_EMBGR | Grouping for Legal Control | P_EMBGR | CHAR | 1 | CHAR1 | ||||
P_LANDEX | Legal Control: Existence Check for Countries | P_LANDEX | CHAR | 1 | CHAR1 | ||||
P_WRKLND | Countries of All Plants | P_WRKLND | CHAR | 1 | CHAR1 | ||||
P_LICENS | License for Product Classification | P_LICENS | CHAR | 1 | CHAR1 | ||||
P_BEZEI | Descriptions in Language of Declaration | P_BEZEI | CHAR | 1 | CHAR1 | ||||
P_BELTYP | Document types | P_BELTYP | CHAR | 1 | CHAR1 | ||||
P_POSTYP | Item categories | P_POSTYP | CHAR | 1 | CHAR1 | ||||
P_ALNEMB | Combination: Export Control Class / Grouping | P_ALNEMB | CHAR | 1 | CHAR1 | ||||
P_DISC | Foreign Trade: Create Diskette | DISC | CHAR | 1 | XFELD | ||||
CHECK_KOLI | Checkbox: Check only ... | CHECK_KOLI | CHAR | 1 | XFELD | ||||
CHECK_KOMA | Checkbox: Check only ... | CHECK_KOMA | CHAR | 1 | XFELD | ||||
CHECK_VEMA | Checkbox: Check only ... | CHECK_VEMA | CHAR | 1 | XFELD | ||||
CHECK_KOKU | Checkbox: Check foreign trade data only | CHECK_KOKU | CHAR | 1 | XFELD | ||||
PRINT_RED | Indicates whether the log displays errors only | PRINT_RED | CHAR | 1 | XFELD | ||||
CHECK_AGRE | Check for payment guarantee procedure only | CHECK_AGRE | CHAR | 1 | XFELD | ||||
CHECK_LECO | Check for legal control only | CHECK_LECO | CHAR | 1 | XFELD | ||||
CHECK_VERW | Civilian or military use | CHECK_VERW | CHAR | 1 | XFELD | ||||
CHECK_LCOM | Foreign Trade: Consistency Reports:Add.Check-Exempt.Certif. | CHECK_LCOM | CHAR | 1 | XFELD | ||||
SALES_VIEW | Sales view | SALES_VIEW | CHAR | 1 | XFELD | ||||
PURCH_VIEW | Purchasing view for incompletion reporting in foreign trade | PURCH_VIEW | CHAR | 1 | XFELD | ||||
MTEXT | Foreign trade: Display material description | MAT_TXT | CHAR | 1 | XFELD | ||||
KOLKZ | Foreign trade: Import/Export - Consistency reports | KOLKZ | CHAR | 1 | XFELD | ||||
FIGEL | Foreign trade: Ind. f. displaying invoices transferred to FI | FIGEL | CHAR | 1 | XFELD | ||||
LAND_STAWN | Foreign Trade: MMM: Country of Commodity Code/Import Code No | LAND_STAWN | CHAR | 3 | T005 | LAND1 | LND | ||
WERKS_STAWN | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ALL_WERKS | Foreign Trade: MMM: Indicator, change material in all plants | ALL_WERKS | CHAR | 1 | XFELD | ||||
DISPLAY_LIST | Foreign Trade: MMM: Indicator, if list display | DISPLAY_LIST | CHAR | 1 | XFELD | ||||
CHECK_REORG | Checkbox: Reorganization Incompleteness | CHECK_REORG | CHAR | 1 | XFELD | ||||
P_QUARTAL | Foreign trade: Decl. to auth. - Decl.period for BAFA disk. | P_QUARTAL | CHAR | 3 | CHAR3 | ||||
HLAND | Country of destination of material | BESTILAND | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
P_GESAMT_VIEW | FT: Declara. to auth.: Goods catalog: Overall view | P_GESAMT_VIEW | CHAR | 1 | CHAR1 | ||||
P_VERKAUF_VIEW | FT: Declara. to Auth.: Goods Catalog: Sales View | P_VERKAUF_VIEW | CHAR | 1 | CHAR1 | ||||
P_EINKAUF_VIEW | Foreign Trade: Declarations: Goods catalog: Purchasing view | P_EINKAUF_VIEW | CHAR | 1 | CHAR1 | ||||
P_SORT_STAWN | FT: Declara. to Auth.: Goods Catalog: STAWN Sorting | P_SORT_STAWN | CHAR | 1 | CHAR1 | ||||
P_SORT_MATNR | FT: Declara. to Auth.: Goods catalog: MATNO sorting | P_SORT_MATNR | CHAR | 1 | CHAR1 | ||||
P_SORT_MATXT | FT: Declara. to Auth.: Goods Catalogue: MATXT sorting | P_SORT_MATXT | CHAR | 1 | CHAR1 | ||||
P_COMPNR | Company Number for Mineral Oil Products Declaration | COMPNR | CHAR | 4 | CHAR4 | ||||
P_ANZTE | Number of days until presentation date of financial document | P_ANZTE | NUMC | 3 | NUM03 | ||||
P_ANZTF | Number of days until validity end of financial document | P_ANZTF | NUMC | 3 | NUM03 | ||||
P_ANZTS | Number of days until latest shipping date from financ.doc. | P_ANZTS | NUMC | 3 | NUM03 | ||||
VARIANT_LOC | Foreign Trade: Documentary Payments: Tree variant | VAR_LOC | CHAR | 14 | Assigned to domain | VARIANT | VCN | ||
UV_STATSYS | Indicator: Select docs w/ incompletion status set by system | UV_STATSYS | CHAR | 1 | XFELD | ||||
UV_STATMAN | Indicator: Select docs with manually set incompletion status | UV_STATMAN | CHAR | 1 | XFELD | ||||
UV_CHECK | Incompletion: Indicator for check | UV_CHECK | CHAR | 1 | XFELD | ||||
P_SIMUL | Indicator simulated run | P_SIMUL | CHAR | 1 | XFELD | ||||
PRENE_T | Foreign Trade: PRE: Vendor Declaration: ALV | PRENE_KTXT | CHAR | 60 | DDTEXT | ||||
GZOLX_T | Foreign Trade: PRE: Vendor Declaration: ALV | GZOLX_KTXT | CHAR | 30 | TEXT30 | ||||
P_BETOL | Tolerance days purchase order | P_BETOL_DAYS | DEC | 3 | MHNTG | BTO | |||
P_EULIF | Indicator 'Only dun EU vendors' | P_EU | CHAR | 1 | XFELD | ||||
P_ANSCH | Print letter | P_ANSCH | CHAR | 1 | XFELD | ||||
P_MAHNE | Print dunning letter indicator | P_MAHNE | CHAR | 1 | XFELD | ||||
P_MAXMA | Maximum dunning level | P_MAXMA | NUMC | 1 | NUMC1 | ||||
P_ANTXT | Request text | P_MTXT1 | CHAR | 70 | TDOBNAME | ||||
P_MATXT | Text container for dunning text | P_MATXT | CHAR | 70 | TDOBNAME | ||||
P_SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
P_SHOWL | Indicator list display | P_SHOWL | CHAR | 1 | XFELD | ||||
P_PREIS | Bottom price for materials | P_PREIS | CURR | 11(2) | WERT11V | ||||
P_WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
P_BETPR | PO tolerance check active | P_BETOL_CHECK | CHAR | 1 | XFELD | ||||
P_DRUCK | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
P_DOCSP | Output language for vendor declaration | P_DOCSP | CHAR | 1 | XFELD | ||||
P_NEWPG | Indicator separate long-term vendor declara. for each mat. | P_NEWPG | CHAR | 1 | XFELD | ||||
P_EKVER | Aggregate indicator | P_EKVER | CHAR | 1 | XFELD | ||||
P_DPATH | Directory for form letter data | P_PATH | CHAR | 128 | LOCALFILE | ||||
P_POPUP | Indicator selection window for print preview | P_POPUP | CHAR | 1 | XFELD | ||||
P_NOPRE | Indicator: Do not print preference zones on list | P_NOPRE | CHAR | 1 | XFELD | ||||
P_OUTPT | Foreign Trade: PRE: Output types | P_OUTPT | CHAR | 1 | XFELD | ||||
P_LIEF | Foreign Trade: Preference: Request vendor declaration? | P_LIEF | CHAR | 1 | XFELD | ||||
P_CHKFK | Materials from billing documents | P_CHKFK | CHAR | 1 | XFELD | ||||
P_MATNR_PRE | Foreign Trade: Preference Handling: Alternative: Mat. no. | MATNR_PRE | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAP | MAT1 |
P_ESOKZ | Indicator: Select Types of Purchasing Info Records | P_ESOKZ | CHAR | 1 | XFELD | ||||
P_EKNOR | Foreign Trade: Purchasing info record type | P_EKTYP | CHAR | 1 | XFELD | EKN | |||
P_EKKON | Foreign Trade: Purchasing info record type: Consignment | P_EKKON | CHAR | 1 | XFELD | EKK | |||
P_EKLOB | Foreign Trade: Purchase info record type: Subcontracting | P_EKLOB | CHAR | 1 | XFELD | EKL | |||
P_EKPIP | Foreign Trade: Purchasing info record type: Pipeline | P_EKPIP | CHAR | 1 | XFELD | EKI | |||
P_USEPR | Ind.: Auto. Determ. of Long-Term Vendor Decl. Validity Date | P_USEPR | CHAR | 1 | XFELD | ||||
P_ZONES | Indicator: Print Preference Zone Comments | P_ZONES | CHAR | 1 | XFELD | ||||
EXMENGE | Exported qty, for which the restitution will be applied for | EXMENGE | QUAN | 15(3) | MENG15 | ||||
EXGEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
P_ALTER_STAWN | Foreign Trade: Service: Alternative Commodity Code | P_ALTER_STAWN | CHAR | 1 | CHAR1 | ||||
P_ALTER_TXT | Foreign Trade: Service: Additional Description | P_ALTER_TXT | CHAR | 1 | CHAR1 | ||||
P_LAENGE | Length of commodity code / code number for foreign trade | LASTW | NUMC | 2 | LASTW | ||||
C_CASE | Foreign Trade: Service: Upper/Lower Case | C_CASE | CHAR | 1 | CHAR1 | ||||
C_ZOLLTXT | Foreign Trade: Service: Additinal Customs Description | C_ZOLLTXT | CHAR | 1 | CHAR1 | ||||
C_BMEON | Foreign Trade: Service: Special Unit of Measure only | C_BMEON | CHAR | 1 | CHAR1 | ||||
DDTEXT | Description with lenght of 80 | BEZEI80 | CHAR | 80 | BEZEI80 | ||||
TEXT_40 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
VAR_LIGHTS | Variant for selection with traffic lights | VAR_LIGHTS | CHAR | 14 | RALDB_VARI | ||||
VAR_REPORT | Variant for starting a report | VAR_REPORT | CHAR | 14 | RALDB_VARI | ||||
S_HEFEL_KOPF | Header fields | HEFEL_KOPF | CHAR | 30 | Assigned to domain | FDNAME | |||
S_HEFEL_POS | Item fields | HEFEL_POS | CHAR | 30 | Assigned to domain | FDNAME | |||
PB_PRER | First Processing for Printout | PB_PRER | CHAR | 1 | XFELD | ||||
PB_PRFE | Error Processing for Printing | PB_PRFE | CHAR | 1 | XFELD | ||||
PB_PRWE | Repeat Processing for Printing | PB_PRWE | CHAR | 1 | XFELD | ||||
PB_PRSO | Special Case Processing for Printing | PB_PRSO | CHAR | 1 | XFELD | ||||
PB_COER | Communication First Processing | PB_COER | CHAR | 1 | XFELD | ||||
PB_COFE | Communication Error Processing | PB_COFE | CHAR | 1 | XFELD | ||||
PB_COWE | Communication Repeat Processing | PB_COWE | CHAR | 1 | XFELD | ||||
DR_VAR_NACH | Variant for starting a report | DR_VAR_NACH | CHAR | 14 | RALDB_VARI | ||||
DR_VAR_AUDI | Variant for starting a report | DR_VAR_AUDI | CHAR | 14 | RALDB_VARI | ||||
CHAR_YEAR | Count parameters | NUMC4 | NUMC | 4 | NUMC4 | ||||
CHAR_MONTH | Two digit number | NUMC2 | NUMC | 2 | NUMC2 | ||||
CHAR_DAY | Two digit number | NUMC2 | NUMC | 2 | NUMC2 |
Key field | Non-key field |
How do I retrieve data from SAP structure FTSEL using ABAP code?
As FTSEL 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 FTSEL as there is no data to select.How to access SAP table FTSEL
Within an ECC or HANA version of SAP you can also view further information about FTSEL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects