SAP table FAGLSKF (General Ledger: Statistical Key Figures (Current Values))
SAP table FAGLSKF has 4 primary key fields being RCLNT,STAGR,RECID,DATE_FROM.
Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RCLNT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||
STAGR | Statistical key figure | CHAR | 6 | 0 | TKA03 | STAGR | |||||||||||
RECID | GUID in 'CHAR' format with upper-/lowercase (!) | CHAR | 22 | 0 | GUID_22 | ||||||||||||
DATE_FROM | Valid From | DATS | 8 | 0 | FAGL_DATAB | ||||||||||||
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 | |||||||||||
ACTIV | FI-SL Business Transaction | CHAR | 4 | 0 | T022 | ACTI1 | |||||||||||
OBART | Object Type | CHAR | 2 | 0 | TBO00 | J_OBART | |||||||||||
RUNIT | Unit of measure | UNIT | 3 | 0 | RUNIT | ||||||||||||
LOGSYS | Logical system | CHAR | 10 | 0 | TBDLS | LOGSYS | |||||||||||
RRCTY | Record Type | CHAR | 1 | 0 | RRCTY |
|
|||||||||||
RVERS | Version | CHAR | 3 | 0 | T894 | RVERS | |||||||||||
MSL | Quantity | QUAN | 23 | 3 | FAGL_QUANTITY | ||||||||||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP |
FAGLSKF foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 FAGLSKF | KOKRS | TKA01 | Controlling Areas | MANDT |
1 FAGLSKF | LOGSYS | TBDLS | Logical system | LOGSYS |
0 FAGLSKF | OBART | TBO00 | Object type control parameters | OBART |
1 FAGLSKF | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
1 FAGLSKF | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
1 FAGLSKF | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
0 FAGLSKF | RBUKRS | T001 | Company Codes | BUKRS |
1 FAGLSKF | RBUSA | TGSB | Business Areas | MANDT |
1 FAGLSKF | RBUSA | TGSB | Business Areas | GSBER |
0 FAGLSKF | RCNTR | CSKS | Cost Center Master Record | MANDT |
0 FAGLSKF | RCNTR | CSKS | Cost Center Master Record | KOKRS |
0 FAGLSKF | RCNTR | CSKS | Cost Center Master Record | KOSTL |
0 FAGLSKF | RCNTR | CSKS | Cost Center Master Record | DATBI |
1 FAGLSKF | RFAREA | TFKB | Functional areas | FKBER |
0 FAGLSKF | RVERS | T894 | FI-SL and FI-LC Versions | MANDT |
0 FAGLSKF | RVERS | T894 | FI-SL and FI-LC Versions | RLDNR |
0 FAGLSKF | RVERS | T894 | FI-SL and FI-LC Versions | RVERS |
1 FAGLSKF | SEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |
0 FAGLSKF | STAGR | TKA03 | Statistical key figures | MANDT |
0 FAGLSKF | STAGR | TKA03 | Statistical key figures | KOKRS |