SAP Table FAGLFLEXR

Virtual Reporting Table (Report Writer) for STAGR

FAGLFLEXR (Virtual Reporting Table (Report Writer) for STAGR) 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 FAGLFLEXR to other SAP tables.

Source: FAGLFLEXR (Virtual Reporting Table (Report Writer) for STAGR)

FAGLFLEXR table fields

Field Data element Checktable Datatype Length Decimals
RYEAR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
ACTIV FI-SL Business Transaction ACTI1 T022 CHAR 4 0
RMVCT Transaction Type RMVCT T856 CHAR 3 0
RTCUR Currency Key RTCUR CUKY 5 0
RUNIT Base Unit of Measure MEINS UNIT 3 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
RLDNR Ledger in General Ledger Accounting FAGL_RLDNR V_FAGL_T881_DBAL 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 T894 CHAR 3 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
RACCT Account Number RACCT SKB1 CHAR 10 0
COST_ELEM Cost Element KSTAR CSKB CHAR 10 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
RCNTR Cost Center KOSTL CSKS CHAR 10 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
RFAREA Functional Area FKBER TFKB CHAR 16 0
RBUSA Business Area GSBER TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT FAGL_SEGM CHAR 10 0
SCNTR Sender cost center SKOST CSKS CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CEPC CHAR 10 0
SFAREA Partner Functional Area SFKBER TFKB CHAR 16 0
SBUSA Trading partner's business area PARGB TGSB CHAR 4 0
RASSC Company ID of trading partner RASSC T880 CHAR 6 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT FAGL_SEGM CHAR 10 0
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
TSL Value in Transaction Currency VTCUR12 CURR 23 2
HSL Value in Local Currency VLCUR12 CURR 23 2
KSL Value in Group Currency VGCUR12 CURR 23 2
OSL Value in Another Currency VOCUR12 CURR 23 2
MSL Quantity QUAN1_12 QUAN 23 3
SSME Quantity RSSME QUAN 15 3
STAGR Statistical key figure STAGR CHAR 6 0

FAGLFLEXR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FAGLFLEXR ACTIV FAGLFLEXR ACTIV T022 FI-SL Activity: Fixed Data ACTIVITY
FAGLFLEXR AWTYP FAGLFLEXR AWTYP TTYP Object Types for Accounting AWTYP
FAGLFLEXR COST_ELEM SYST MANDT CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
FAGLFLEXR COST_ELEM FAGLFLEX03_DATA KOKRS CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
FAGLFLEXR COST_ELEM FAGLFLEXR COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
FAGLFLEXR COST_ELEM * CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
FAGLFLEXR KOKRS SYST MANDT TKA01 Controlling Areas MANDT
FAGLFLEXR KOKRS FAGLFLEXR KOKRS TKA01 Controlling Areas KOKRS
FAGLFLEXR LOGSYS FAGLFLEXR LOGSYS TBDLS Logical system LOGSYS
FAGLFLEXR PPRCTR FAGLFLEXR PPRCTR CEPC Profit Center Master Data Table PRCTR
FAGLFLEXR PPRCTR SYST MANDT CEPC Profit Center Master Data Table MANDT
FAGLFLEXR PPRCTR * CEPC Profit Center Master Data Table DATBI
FAGLFLEXR PPRCTR * CEPC Profit Center Master Data Table KOKRS
FAGLFLEXR PRCTR SYST MANDT CEPC Profit Center Master Data Table MANDT
FAGLFLEXR PRCTR FAGLFLEXR PRCTR CEPC Profit Center Master Data Table PRCTR
FAGLFLEXR PRCTR * CEPC Profit Center Master Data Table DATBI
FAGLFLEXR PRCTR FAGLFLEXR KOKRS CEPC Profit Center Master Data Table KOKRS
FAGLFLEXR PSEGMENT FAGLFLEXR PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
FAGLFLEXR PSEGMENT SYST MANDT FAGL_SEGM Master Data for Segments MANDT
FAGLFLEXR RACCT SYST MANDT SKB1 G/L account master (company code) MANDT
FAGLFLEXR RACCT FAGLFLEX03_KEY RBUKRS SKB1 G/L account master (company code) BUKRS
FAGLFLEXR RACCT FAGLFLEXR RACCT SKB1 G/L account master (company code) SAKNR
FAGLFLEXR RASSC FAGLFLEXR RASSC T880 Global Company Data (for KONS Ledger) RCOMP
FAGLFLEXR RASSC SYST MANDT T880 Global Company Data (for KONS Ledger) MANDT
FAGLFLEXR RBUKRS FAGLFLEXR RBUKRS T001 Company Codes BUKRS
FAGLFLEXR RBUKRS SYST MANDT T001 Company Codes MANDT
FAGLFLEXR RBUSA SYST MANDT TGSB Business Areas MANDT
FAGLFLEXR RBUSA FAGLFLEXR RBUSA TGSB Business Areas GSBER
FAGLFLEXR RCNTR SYST MANDT CSKS Cost Center Master Data MANDT
FAGLFLEXR RCNTR FAGLFLEXR KOKRS CSKS Cost Center Master Data KOKRS
FAGLFLEXR RCNTR FAGLFLEXR RCNTR CSKS Cost Center Master Data KOSTL
FAGLFLEXR RCNTR * CSKS Cost Center Master Data DATBI
FAGLFLEXR RFAREA FAGLFLEXR RFAREA TFKB Functional areas FKBER
FAGLFLEXR RFAREA SYST MANDT TFKB Functional areas MANDT
FAGLFLEXR RLDNR SYST MANDT V_FAGL_T881_DBAL Generated Table for View MANDT
FAGLFLEXR RLDNR FAGLFLEXR RLDNR V_FAGL_T881_DBAL Generated Table for View RLDNR
FAGLFLEXR RMVCT FAGLFLEXR RMVCT T856 Transaction Types TRTYP
FAGLFLEXR RMVCT SYST MANDT T856 Transaction Types MANDT
FAGLFLEXR RVERS SYST MANDT T894 FI-SL and FI-LC Versions MANDT
FAGLFLEXR RVERS T881 RLDNR T894 FI-SL and FI-LC Versions RLDNR
FAGLFLEXR RVERS FAGLFLEXR RVERS T894 FI-SL and FI-LC Versions RVERS
FAGLFLEXR SBUSA FAGLFLEXR SBUSA TGSB Business Areas GSBER
FAGLFLEXR SBUSA SYST MANDT TGSB Business Areas MANDT
FAGLFLEXR SCNTR FAGLFLEXR SCNTR CSKS Cost Center Master Data KOSTL
FAGLFLEXR SCNTR SYST MANDT CSKS Cost Center Master Data MANDT
FAGLFLEXR SCNTR * CSKS Cost Center Master Data KOKRS
FAGLFLEXR SCNTR * CSKS Cost Center Master Data DATBI
FAGLFLEXR SEGMENT FAGLFLEXR SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
FAGLFLEXR SEGMENT SYST MANDT FAGL_SEGM Master Data for Segments MANDT
FAGLFLEXR SFAREA FAGLFLEXR SFAREA TFKB Functional areas FKBER
FAGLFLEXR SFAREA SYST MANDT TFKB Functional areas MANDT