1. Home
  2. Resources
  3. SAP Tables
  4. FAGLFLEXS - Reporting for Table FAGLFLEXT

SAP Table FAGLFLEXS

Reporting for Table FAGLFLEXT

FAGLFLEXS (Reporting for Table FAGLFLEXT) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FAGLFLEXS to other SAP tables.

FAGLFLEXS table fields

Field Data element Checktable Datatype Length Decimals
ID Internal: Node ID SEU_ID NUMC 6 0
VERSN Financial Statement Version VERSN_011 T011 CHAR 4 0
ERGSL Financial Statement Item ERGSL CHAR 10 0
CURTP Currency Type for Sales Segments ALLGCRTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
WAERS Currency Key WAERS CUKY 5 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
SAK_PLUMI Financial Statement Item/Account Number SAK_PLUMI CHAR 11 0
SAKFB_LONG Financial Statement Item/Account No./Functional Area Long SAKFB_LONG CHAR 16 0
KKTPL Group Chart of Accts KKTPL T004 CHAR 4 0
BILKT Group Account Number BILKT SKA1 CHAR 10 0
KTOP2 Chart of Accounts According to Country Legislation KTOP2 T004 CHAR 4 0
ALTKT Alternative account number in company code ALTKT_SKB1 SKA1 CHAR 10 0
RKTPL Chart of Accounts KTOPL T004 CHAR 4 0
ADB_PFROM Period From (Average Daily Balance) ADB_PFROM DATS 8 0
ADB_PTO Period To (Average Daily Balance) ADB_PTO DATS 8 0
RYEAR Fiscal Year GJAHR NUMC 4 0
ACTIV FI-SL Business Transaction ACTI1 CHAR 4 0
RMVCT Transaction Type RMVCT CHAR 3 0
RTCUR Currency Key RTCUR CUKY 5 0
RUNIT Base Unit of Measure MEINS UNIT 3 0
AWTYP Reference Transaction AWTYP CHAR 5 0
RLDNR Ledger in General Ledger Accounting FAGL_RLDNR CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS CHAR 3 0
LOGSYS Logical system LOGSYS CHAR 10 0
RACCT Account Number RACCT CHAR 10 0
COST_ELEM Cost Element KSTAR CHAR 10 0
RBUKRS Company Code BUKRS CHAR 4 0
RCNTR Cost Center KOSTL CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
RFAREA Functional Area FKBER CHAR 16 0
RBUSA Business Area GSBER CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
SCNTR Sender cost center SKOST CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
SFAREA Partner Functional Area SFKBER CHAR 16 0
SBUSA Trading partner's business area PARGB CHAR 4 0
RASSC Company ID of trading partner RASSC CHAR 6 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
POPER Posting period POPER NUMC 3 0
MAXPER Period PERIODE NUMC 3 0
PERIO Period/year JAHRPER NUMC 7 0
WERTB Value: Balance Sheet Accounts RR_WERTB CURR 17 2
WERTE Value: P&L Accounts RR_WERTE CURR 17 2
UMSAV Balance Carryforward RR_UMSAV CURR 17 2
UMSOL Total debit postings RR_UMSOL CURR 17 2
UMHAB Total credit postings RR_UMHAB CURR 17 2
UMPER Period balance RR_UMPER CURR 17 2
KUMSL Accumulated balance RR_KUMSL CURR 17 2
MENGP Quantity for period RR_MENGP QUAN 15 3
MENGK Cumulative quantity RR_MENGK QUAN 15 3
ADB_WERTB Value: Balance Sheet Accounts RR_WERTB CURR 17 2
ADB_WERTE Value: P&L Accounts RR_WERTE CURR 17 2
ADB_KUMSL Average Daily Balance: Cumulated ADB_KUMSL CURR 17 2
ADB_UMPER Average Daily Balance of Period ADB_UMPER CURR 17 2
STAGR Statistical key figure STAGR CHAR 6 0

FAGLFLEXS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FAGLFLEXS ALTKT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FAGLFLEXS ALTKT FAGLFLEXS KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
FAGLFLEXS ALTKT FAGLFLEXS ALTKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
FAGLFLEXS BILKT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FAGLFLEXS BILKT FAGLFLEXS KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
FAGLFLEXS BILKT FAGLFLEXS BILKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
FAGLFLEXS KKTPL SYST MANDT T004 Directory of Charts of Accounts MANDT
FAGLFLEXS KKTPL FAGLFLEXS KKTPL T004 Directory of Charts of Accounts KTOPL
FAGLFLEXS KTOP2 SYST MANDT T004 Directory of Charts of Accounts MANDT
FAGLFLEXS KTOP2 FAGLFLEXS KTOP2 T004 Directory of Charts of Accounts KTOPL
FAGLFLEXS KTOPL FAGLFLEXS KTOPL T004 Directory of Charts of Accounts KTOPL
FAGLFLEXS KTOPL SYST MANDT T004 Directory of Charts of Accounts MANDT
FAGLFLEXS RKTPL SYST MANDT T004 Directory of Charts of Accounts MANDT
FAGLFLEXS RKTPL FAGLFLEXS RKTPL T004 Directory of Charts of Accounts KTOPL
FAGLFLEXS VERSN SYST MANDT T011 Financial Statement Versions MANDT
FAGLFLEXS VERSN FAGLFLEXS VERSN T011 Financial Statement Versions VERSN