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 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||
| LINETYPE | Item category | LINETYPE | T8G02 | CHAR | 5 | 0 | ||||||||||||||||||||||||
| XSPLITMOD | Item changed by document splitting | XSPLITMOD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| 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 | 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 | COST_ELEM | * | CSKB | Cost Elements (Data Dependent on Controlling Area) | DATBI | |
| 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 | * | CEPC | Profit Center Master Data Table | DATBI | |
| FAGLFLEXA | PPRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| FAGLFLEXA | PPRCTR | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| FAGLFLEXA | PPRCTR | FAGLFLEXA | PPRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| 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 | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| 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 | FAGLFLEXA | RASSC | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| FAGLFLEXA | RASSC | SYST | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
| 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 | SYST | MANDT | T856 | Transaction Types | MANDT |
| FAGLFLEXA | RMVCT | FAGLFLEXA | RMVCT | T856 | Transaction Types | TRTYP |
| 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 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| FAGLFLEXA | RWCUR | FAGLFLEXA | RWCUR | TCURC | Currency Codes | WAERS |
| FAGLFLEXA | SBUSA | SYST | MANDT | TGSB | Business Areas | MANDT |
| FAGLFLEXA | SBUSA | FAGLFLEXA | SBUSA | TGSB | Business Areas | GSBER |
| FAGLFLEXA | SCNTR | FAGLFLEXA | SCNTR | CSKS | Cost Center Master Data | KOSTL |
| FAGLFLEXA | SCNTR | * | CSKS | Cost Center Master Data | DATBI | |
| FAGLFLEXA | SCNTR | SYST | MANDT | CSKS | Cost Center Master Data | MANDT |
| FAGLFLEXA | SCNTR | * | CSKS | Cost Center Master Data | KOKRS | |
| FAGLFLEXA | SEGMENT | FAGLFLEXA | SEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |
| FAGLFLEXA | SEGMENT | SYST | MANDT | FAGL_SEGM | Master Data for Segments | MANDT |
| 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 |
