SAP Table FAGLFLEXR (Virtual Reporting Table (Report Writer) for STAGR)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RYEAR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||||||||||||
| POPER | Posting period | NUMC | 3 | 0 | POPER | ||||||||||||
| DRCRK | Debit/Credit Indicator | CHAR | 1 | 0 | SHKZG |
|
|||||||||||
| ACTIV | FI-SL Business Transaction | CHAR | 4 | 0 | T022 | ACTI1 | |||||||||||
| RMVCT | Transaction type | CHAR | 3 | 0 | T856 | RMVCT | |||||||||||
| RTCUR | Currency Key | CUKY | 5 | 0 | * | RTCUR | |||||||||||
| RUNIT | Base Unit of Measure | UNIT | 3 | 0 | * | MEINS | |||||||||||
| AWTYP | Reference procedure | CHAR | 5 | 0 | TTYP | AWTYP | |||||||||||
| RLDNR | Ledger in General Ledger Accounting | CHAR | 2 | 0 | V_FAGL_T881_DBAL | FAGL_RLDNR | |||||||||||
| RRCTY | Record Type | CHAR | 1 | 0 | RRCTY |
|
|||||||||||
| RVERS | Version | CHAR | 3 | 0 | T894 | RVERS | |||||||||||
| LOGSYS | Logical system | CHAR | 10 | 0 | TBDLS | LOGSYS | |||||||||||
| RACCT | Account Number | CHAR | 10 | 0 | SKB1 | RACCT | |||||||||||
| COST_ELEM | Cost Element | CHAR | 10 | 0 | CSKB | KSTAR | |||||||||||
| RBUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||
| RCNTR | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |||||||||||
| PRCTR | Profit Center | CHAR | 10 | 0 | CEPC | PRCTR | |||||||||||
| RFAREA | Functional Area | CHAR | 16 | 0 | TFKB | FKBER | |||||||||||
| RBUSA | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |||||||||||
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||||
| SEGMENT | Segment for Segmental Reporting | CHAR | 10 | 0 | FAGL_SEGM | FB_SEGMENT | |||||||||||
| SCNTR | Sender cost center | CHAR | 10 | 0 | CSKS | SKOST | |||||||||||
| PPRCTR | Partner Profit Center | CHAR | 10 | 0 | CEPC | PPRCTR | |||||||||||
| SFAREA | Partner Functional Area | CHAR | 16 | 0 | TFKB | SFKBER | |||||||||||
| SBUSA | Trading partner's business area | CHAR | 4 | 0 | TGSB | PARGB | |||||||||||
| RASSC | Company ID of Trading Partner | CHAR | 6 | 0 | T880 | RASSC | |||||||||||
| PSEGMENT | Partner Segment for Segmental Reporting | CHAR | 10 | 0 | FAGL_SEGM | FB_PSEGMENT | |||||||||||
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||||||||||||
| TSL | Value in Transaction Currency | CURR | 23 | 2 | VTCUR12 | ||||||||||||
| HSL | Value in Local Currency | CURR | 23 | 2 | VLCUR12 | ||||||||||||
| KSL | Value in Group Currency | CURR | 23 | 2 | VGCUR12 | ||||||||||||
| OSL | Value in Another Currency | CURR | 23 | 2 | VOCUR12 | ||||||||||||
| MSL | Quantity | QUAN | 23 | 3 | QUAN1_12 | ||||||||||||
| SSME | Quantity | QUAN | 15 | 3 | RSSME | ||||||||||||
| STAGR | Statistical key figure | CHAR | 6 | 0 | STAGR |
FAGLFLEXR foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FAGLFLEXR | AWTYP | TTYP | Object Types for Accounting | AWTYP |
| 1 FAGLFLEXR | COST_ELEM | CSKB | Cost Elements (Data Dependent on Controlling Area) | MANDT |
| 1 FAGLFLEXR | COST_ELEM | CSKB | Cost Elements (Data Dependent on Controlling Area) | KOKRS |
| 1 FAGLFLEXR | COST_ELEM | CSKB | Cost Elements (Data Dependent on Controlling Area) | KSTAR |
| 1 FAGLFLEXR | COST_ELEM | CSKB | Cost Elements (Data Dependent on Controlling Area) | DATBI |
| 0 FAGLFLEXR | KOKRS | TKA01 | Controlling Areas | MANDT |
| 1 FAGLFLEXR | LOGSYS | TBDLS | Logical system | LOGSYS |
| 0 FAGLFLEXR | PPRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| 0 FAGLFLEXR | PPRCTR | CEPC | Profit Center Master Data Table | DATBI |
| 0 FAGLFLEXR | PPRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| 1 FAGLFLEXR | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| 1 FAGLFLEXR | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| 1 FAGLFLEXR | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| 0 FAGLFLEXR | PSEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |
| 1 FAGLFLEXR | RACCT | SKB1 | G/L account master (company code) | MANDT |
| 1 FAGLFLEXR | RACCT | SKB1 | G/L account master (company code) | BUKRS |
| 0 FAGLFLEXR | RASSC | T880 | Global Company Data (for KONS Ledger) | MANDT |
| 0 FAGLFLEXR | RASSC | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| 1 FAGLFLEXR | RBUKRS | T001 | Company Codes | BUKRS |
| 0 FAGLFLEXR | RBUSA | TGSB | Business Areas | MANDT |
| 0 FAGLFLEXR | RBUSA | TGSB | Business Areas | GSBER |
| 1 FAGLFLEXR | RCNTR | CSKS | Cost Center Master Record | MANDT |
| 1 FAGLFLEXR | RCNTR | CSKS | Cost Center Master Record | KOKRS |
| 1 FAGLFLEXR | RCNTR | CSKS | Cost Center Master Record | KOSTL |
| 1 FAGLFLEXR | RCNTR | CSKS | Cost Center Master Record | DATBI |
| 0 FAGLFLEXR | RFAREA | TFKB | Functional areas | FKBER |
| 1 FAGLFLEXR | RMVCT | T856 | Transaction Types | MANDT |
| 1 FAGLFLEXR | RMVCT | T856 | Transaction Types | TRTYP |
| 0 FAGLFLEXR | RVERS | T894 | FI-SL and FI-LC Versions | MANDT |
| 0 FAGLFLEXR | RVERS | T894 | FI-SL and FI-LC Versions | RLDNR |
| 0 FAGLFLEXR | RVERS | T894 | FI-SL and FI-LC Versions | RVERS |
| 1 FAGLFLEXR | SBUSA | TGSB | Business Areas | MANDT |
| 1 FAGLFLEXR | SBUSA | TGSB | Business Areas | GSBER |
| 0 FAGLFLEXR | SCNTR | CSKS | Cost Center Master Record | MANDT |
| 0 FAGLFLEXR | SCNTR | CSKS | Cost Center Master Record | KOKRS |
| 0 FAGLFLEXR | SCNTR | CSKS | Cost Center Master Record | KOSTL |
| 0 FAGLFLEXR | SCNTR | CSKS | Cost Center Master Record | DATBI |
| 1 FAGLFLEXR | SEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |
| 0 FAGLFLEXR | SFAREA | TFKB | Functional areas | FKBER |