SAP table AFWCH_FL (AFWCH: Filter List)

SAP table AFWCH_FL has 2 primary key fields being MANDT,FLID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FLID Filter: Name CHAR 8 0 AFWCH_FLID
FLTYP Filter Category CHAR 2 0 AFWCH_FLTYP
Dynamic Selections (AND Link)
CX Filter Group (OR Link)
PH Filter for Portfolio Hierarchies
RMBID Analysis Structure CHAR 4 0 JBRRMBBF JBRRMBID
FIELDNAME Characteristic CHAR 30 0 * JBRMERKML
HVARIANTE Characteristics Hierarchy CHAR 3 0 JBRMRKHIER
HNODID Hierarchy node number NUMC 8 0 CFHIKEY
AUTGR Authorization Group CHAR 4 0 * TV_AUTGR
CRUSER Created By CHAR 12 0 USR02 AFW_CRUSER
CRTSTP Time Stamp NUMC 14 0 AFW_TIMESTP
UPUSER Last Changed By CHAR 12 0 * AFW_UPUSER
UPTSTP Time Stamp NUMC 14 0 AFW_TIMESTP
SICHTID View of an Analysis Structure CHAR 3 0 * JBRSICHTID
STATUS_ICON Icons for Displaying the Status of the Filter CHAR 4 0 AFWCH_FL_ICON
@02@ Filter with Transport of Incorrect Definitions
@12@ Filter with Test Selections
@2W@ Definitin of filter was reset
@4G@ Filter Based on Current Definition
TESTMODUS Status of Filter CHAR 1 0 AFWCH_STATUS
Filter is consistent
I Filter is inconsistent (incorrect transport)
T Filter with Test Selections
REF_FLID Filter: Name CHAR 8 0 * AFWCH_FLID
TRKORR Request/Task CHAR 20 0 * TRKORR

AFWCH_FL foreign key relationships

Table Field Check Table Check Field
0 AFWCH_FL CRUSER USR02 Logon Data (Kernel-Side Use) BNAME
1 AFWCH_FL MANDT T000 Clients MANDT