AFILT SAP (Structure of selection filter and display) Structure details
Description: Structure of selection filter and display
Structure field list including key, data, relationships and ABAP select examples
AFILT 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 "Structure of selection filter and display" 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_AFILT TYPE AFILT.
The AFILT table consists of various fields, each holding specific information or linking keys about Structure of selection filter and display data available in SAP. These include AVPEB (Planned independent requirement selection), AANGB (Selection of quotations), AKDAU (Selection of sales documents), ALIEF (Selection of deliveries).. 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 AFILT 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 |
AFIBZ | Name of display filter | FILBZ | CHAR | 8 | CHAR8 | ||||
AVPEB | Planned independent requirement selection | AVPEB | CHAR | 1 | ANZMOD | ||||
AANGB | Selection of quotations | AANGB | CHAR | 1 | ANZMOD | ||||
AKDAU | Selection of sales documents | ALKDA | CHAR | 1 | ANZMOD | ||||
ALIEF | Selection of deliveries | ALIEF | CHAR | 1 | ANZMOD | ||||
ASKBD | Selection of dependent requirements | ASKBD | CHAR | 1 | ANZMOD | ||||
AMRES | Selection of manual reservations | AIRES | CHAR | 1 | ANZMOD | ||||
ALBED | Selection of subcontractor requirements of material provided | ALBED | CHAR | 1 | ANZMOD | ||||
AARES | Selection of dependent reservations | AARES | CHAR | 1 | ANZMOD | ||||
AAPLF | Selection of delivery schedules for planned orders | AAPLF | CHAR | 1 | ANZMOD | ||||
AABES | Selection of delivery schedules for stock transfer orders | AABES | CHAR | 1 | ANZMOD | ||||
AABAN | Sel. of delivery schedules for stock transfer requisitions | AABAN | CHAR | 1 | ANZMOD | ||||
AALPE | Sel. of delivery schedules for stock transfer schedule lines | AALPE | CHAR | 1 | ANZMOD | ||||
AURES | Stock transfer reservation selection | AURES | CHAR | 1 | ANZMOD | ||||
AFERT | Selection of production orders | AFERT | CHAR | 1 | ANZMOD | ||||
APLAF | Selection of planned orders | APLAF | CHAR | 1 | ANZMOD | ||||
ABEST | Selection of purchase orders | ABEST | CHAR | 1 | ANZMOD | ||||
ABANF | Selection of Purchase Requisitions | ABANF | CHAR | 1 | ANZMOD | ||||
ALPET | Selection of schedule lines | ALPET | CHAR | 1 | ANZMOD | ||||
AAVIS | Selection of shipping notifications | AAVIS | CHAR | 1 | ANZMOD | ||||
AQMPR | Selection of QM inspection lots | AQMPR | CHAR | 1 | ANZMOD | ||||
SWEAB | Sel. plant segment | SWEAB | CHAR | 1 | XFELD | ||||
SKDAB | Selection customer segments | SKDAB | CHAR | 1 | XFELD | ||||
SPRAB | Selection project segments | SPRAB | CHAR | 1 | XFELD | ||||
SBRAB | Gross segment selection | SBRAB | CHAR | 1 | XFELD | ||||
SDIFE | Selection of direct production/direct procurement segments | SDIFE | CHAR | 1 | XFELD | ||||
SLAGO | Selection of storage location segments | SLAGO | CHAR | 1 | XFELD | ||||
SLOHN | Subcontracting segment selection | SLOHB | CHAR | 1 | XFELD | ||||
SVORP | Planning segment selection | SVORP | CHAR | 1 | XFELD | ||||
SVDIR | Selection of segments for plng direct production/procurement | SVDIR | CHAR | 1 | XFELD | ||||
SDFIX | Selection of firmed procurement proposals | SDFIX | CHAR | 1 | XFELD | ||||
DTALL | Display without time limit | MD_DTALL | CHAR | 1 | XFELD | ||||
DTAPP | Horizon can be selected by user | MD_DTAPP | CHAR | 1 | XFELD | ||||
DTCUS | Horizon using default value in Customizing | MD_DTCUS | CHAR | 1 | XFELD | ||||
STADT | Start date of previous period | MD_STOPT | CHAR | 1 | MD_STOPT | ||||
SSPAN | Time interval before todays date | MD_SSPAN | INT4 | 10 | INT4 | ||||
ENDDT | Last date of subsequent period | MD_ENDDT | CHAR | 1 | MD_ENDDT | ||||
ESPAN | Period After Today's Date | MD_ESPAN | INT4 | 10 | INT4 | ||||
ADATV | Start date for display horizon | DTANF | DATS | 8 | DATS | ||||
ADATB | End date of display horizon | DTEND | DATS | 8 | DATS | ||||
DZALL | Additional selections: none | MD_DZALL | CHAR | 1 | XFELD | ||||
DZAPP | Define additional selections in the application | MD_DZAPP | CHAR | 1 | XFELD | ||||
DZCUS | Define additional selections in Customizing | MD_DZCUS | CHAR | 1 | XFELD | ||||
KUNNR | Customer key | MD_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | DEBI |
LIFNR | Vendor Key | MD_LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED |
WRK02 | Supplying or receiving plant | MD_WRK02 | CHAR | 4 | Assigned to domain | WERKS | |||
LGORT | Storage location | MD_LGORT | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
VERID | Production version | MD_VERID | CHAR | 4 | Assigned to domain | VERID | VER |
Key field | Non-key field |
How do I retrieve data from SAP structure AFILT using ABAP code?
As AFILT 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 AFILT as there is no data to select.How to access SAP table AFILT
Within an ECC or HANA version of SAP you can also view further information about AFILT 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