SAP Table FAGLFLEXA
General Ledger: Actual Line Items
FAGLFLEXA (General Ledger: Actual Line Items) 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 FAGLFLEXA to other SAP tables.
FAGLFLEXA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RCLNT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||
|
RYEAR
Fiscal Year
|
GJAHR |
NUMC
|
4 | 0 | ||||||||||||||||||||||||||
|
DOCNR
Accounting Document Number
|
BELNR_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
RLDNR
Ledger in General Ledger Accounting
|
FAGL_RLDNR | V_FAGL_T881_DBAL |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
RBUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
DOCLN
Six-Character Posting Item for Ledger
|
DOCLN6 |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||
|
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 | |||||||||||||||||||||||||
|
RRCTY
Record Type
|
RRCTY |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | |||||||||||||||||||||||||
|
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 | |||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
WSL
Value in Original Transaction Currency (Document Currency)
|
VWCUR12 |
CURR
|
23 | 2 | ||||||||||||||||||||||||||
|
DRCRK
Debit/Credit Indicator
|
SHKZG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
POPER
Posting period
|
POPER |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||
|
RWCUR
Currency key of the original transaction currency
|
RWCUR | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||
|
GJAHR
Fiscal Year
|
GJAHR |
NUMC
|
4 | 0 | ||||||||||||||||||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
BELNR
Accounting Document Number
|
BELNR_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
BUZEI
Number of Line Item Within Accounting Document
|
BUZEI |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||
|
BSCHL
Posting Key
|
BSCHL | TBSL |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
BSTAT
Document Status
|
BSTAT_D |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
LINETYPE
Item category
|
LINETYPE | T8G02 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||
|
XSPLITMOD
Item changed by document splitting
|
XSPLITMOD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
USNAM
User name
|
USNAM | USR02 |
CHAR
|
12 | 0 | |||||||||||||||||||||||||
|
TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||||||||||||||
FAGLFLEXA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| FAGLFLEXA | ACTIV | FAGLFLEXA | ACTIV |
T022
FI-SL Activity: Fixed Data
|
ACTIVITY |
| FAGLFLEXA | AWTYP | FAGLFLEXA | AWTYP |
TTYP
Object Types for Accounting
|
AWTYP |
| FAGLFLEXA | BSCHL | SYST | MANDT |
TBSL
Posting Key
|
MANDT |
| FAGLFLEXA | BSCHL | FAGLFLEXA | BSCHL |
TBSL
Posting Key
|
BSCHL |
| FAGLFLEXA | COST_ELEM | * |
CSKB
Cost Elements (Data Dependent on Controlling Area)
|
DATBI | |
| FAGLFLEXA | COST_ELEM | SYST | MANDT |
CSKB
Cost Elements (Data Dependent on Controlling Area)
|
MANDT |
| FAGLFLEXA | COST_ELEM | FAGLFLEX03_DATA | KOKRS |
CSKB
Cost Elements (Data Dependent on Controlling Area)
|
KOKRS |
| FAGLFLEXA | COST_ELEM | FAGLFLEXA | COST_ELEM |
CSKB
Cost Elements (Data Dependent on Controlling Area)
|
KSTAR |
| FAGLFLEXA | KOKRS | SYST | MANDT |
TKA01
Controlling Areas
|
MANDT |
| FAGLFLEXA | KOKRS | FAGLFLEXA | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| FAGLFLEXA | LINETYPE | FAGLFLEXA | LINETYPE |
T8G02
Item categories
|
LINETYPE |
| FAGLFLEXA | LOGSYS | FAGLFLEXA | LOGSYS |
TBDLS
Logical system
|
LOGSYS |
| FAGLFLEXA | PPRCTR | SYST | MANDT |
CEPC
Profit Center Master Data Table
|
MANDT |
| FAGLFLEXA | PPRCTR | FAGLFLEXA | PPRCTR |
CEPC
Profit Center Master Data Table
|
PRCTR |
| FAGLFLEXA | PPRCTR | * |
CEPC
Profit Center Master Data Table
|
DATBI | |
| FAGLFLEXA | PPRCTR | * |
CEPC
Profit Center Master Data Table
|
KOKRS | |
| FAGLFLEXA | PRCTR | * |
CEPC
Profit Center Master Data Table
|
DATBI | |
| FAGLFLEXA | PRCTR | FAGLFLEXA | KOKRS |
CEPC
Profit Center Master Data Table
|
KOKRS |
| FAGLFLEXA | PRCTR | SYST | MANDT |
CEPC
Profit Center Master Data Table
|
MANDT |
| FAGLFLEXA | PRCTR | FAGLFLEXA | PRCTR |
CEPC
Profit Center Master Data Table
|
PRCTR |
| FAGLFLEXA | PSEGMENT | SYST | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| FAGLFLEXA | PSEGMENT | FAGLFLEXA | PSEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| FAGLFLEXA | RACCT | SYST | MANDT |
SKB1
G/L account master (company code)
|
MANDT |
| FAGLFLEXA | RACCT | FAGLFLEX03_KEY | RBUKRS |
SKB1
G/L account master (company code)
|
BUKRS |
| FAGLFLEXA | RACCT | FAGLFLEXA | RACCT |
SKB1
G/L account master (company code)
|
SAKNR |
| FAGLFLEXA | RASSC | SYST | MANDT |
T880
Global Company Data (for KONS Ledger)
|
MANDT |
| FAGLFLEXA | RASSC | FAGLFLEXA | RASSC |
T880
Global Company Data (for KONS Ledger)
|
RCOMP |
| FAGLFLEXA | RBUKRS | SYST | MANDT |
T001
Company Codes
|
MANDT |
| FAGLFLEXA | RBUKRS | FAGLFLEXA | RBUKRS |
T001
Company Codes
|
BUKRS |
| FAGLFLEXA | RBUSA | SYST | MANDT |
TGSB
Business Areas
|
MANDT |
| FAGLFLEXA | RBUSA | FAGLFLEXA | RBUSA |
TGSB
Business Areas
|
GSBER |
| FAGLFLEXA | RCLNT | FAGLFLEXA | RCLNT |
T000
Clients
|
MANDT |
| FAGLFLEXA | RCNTR | SYST | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| FAGLFLEXA | RCNTR | FAGLFLEXA | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| FAGLFLEXA | RCNTR | FAGLFLEXA | RCNTR |
CSKS
Cost Center Master Data
|
KOSTL |
| FAGLFLEXA | RCNTR | * |
CSKS
Cost Center Master Data
|
DATBI | |
| FAGLFLEXA | RFAREA | SYST | MANDT |
TFKB
Functional areas
|
MANDT |
| FAGLFLEXA | RFAREA | FAGLFLEXA | RFAREA |
TFKB
Functional areas
|
FKBER |
| FAGLFLEXA | RLDNR | SYST | MANDT |
V_FAGL_T881_DBAL
Generated Table for View
|
MANDT |
| FAGLFLEXA | RLDNR | FAGLFLEXA | RLDNR |
V_FAGL_T881_DBAL
Generated Table for View
|
RLDNR |
| FAGLFLEXA | RMVCT | FAGLFLEXA | RMVCT |
T856
Transaction Types
|
TRTYP |
| FAGLFLEXA | RMVCT | SYST | MANDT |
T856
Transaction Types
|
MANDT |
| FAGLFLEXA | RVERS | SYST | MANDT |
T894
FI-SL and FI-LC Versions
|
MANDT |
| FAGLFLEXA | RVERS | T881 | RLDNR |
T894
FI-SL and FI-LC Versions
|
RLDNR |
| FAGLFLEXA | RVERS | FAGLFLEXA | RVERS |
T894
FI-SL and FI-LC Versions
|
RVERS |
| FAGLFLEXA | RWCUR | FAGLFLEXA | RWCUR |
TCURC
Currency Codes
|
WAERS |
| FAGLFLEXA | RWCUR | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| FAGLFLEXA | SBUSA | SYST | MANDT |
TGSB
Business Areas
|
MANDT |
| FAGLFLEXA | SBUSA | FAGLFLEXA | SBUSA |
TGSB
Business Areas
|
GSBER |
| FAGLFLEXA | SCNTR | SYST | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| FAGLFLEXA | SCNTR | * |
CSKS
Cost Center Master Data
|
KOKRS | |
| FAGLFLEXA | SCNTR | FAGLFLEXA | SCNTR |
CSKS
Cost Center Master Data
|
KOSTL |
| FAGLFLEXA | SCNTR | * |
CSKS
Cost Center Master Data
|
DATBI | |
| FAGLFLEXA | SEGMENT | SYST | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| FAGLFLEXA | SEGMENT | FAGLFLEXA | SEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| FAGLFLEXA | SFAREA | SYST | MANDT |
TFKB
Functional areas
|
MANDT |
| FAGLFLEXA | SFAREA | FAGLFLEXA | SFAREA |
TFKB
Functional areas
|
FKBER |
| FAGLFLEXA | USNAM | SYST | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| FAGLFLEXA | USNAM | FAGLFLEXA | USNAM |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |