Model / FI / FAGLFLEXT

FI — Financial Accounting

FAGLFLEXT

44 fields · 6 key · 22 foreign keys · sourced from leanx.eu

General Ledger: Totals — the New G/L (new-GL) flexible totals table, SAP's pre-S/4HANA ancestor of the account/period aggregates a customer would otherwise derive by summarizing ACDOCA. Carries one row per ledger/company code/account/dimension combination with a balance-carryforward bucket plus 16 period buckets, in up to four parallel currencies (transaction, local, group, and a fourth freely-defined currency) and a quantity total. SAP's real table carries a full 16-period array per currency (TSL01-TSL16, HSL01-HSL16, KSL01-KSL16, OSL01-OSL16, MSL01-MSL16) plus 8 OBJNR table-group fields; this definition is scoped to the full key, all organizational/reference fields, and a representative period slice (carryforward + period 01 + period 12 + period 16) per currency/quantity bucket so a crosswalk can resolve the pattern without repeating all 80+ period columns verbatim. An ECC/New-GL customer mirrors this table for period/account balances; an S/4HANA customer derives the equivalent balance from ACDOCA directly.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
ANF keyannus fiscalisFiscal YearGJAHRNUMC 4
TBL_GENtabula genusRecord TypeRRCTYCHAR 1
VRSversioVersionRVERSCHAR 3T894
LBR keyliberLedger in General Ledger AccountingFAGL_RLDNRCHAR 2V_FAGL_T881_DBAL
SOC keycodex societatisCompany CodeBUKRSCHAR 4T001
RAT_NUM keyratio numerusAccount Number — the G/L account this totals row aggregatesRACCTCHAR 10SKB1
ACTIVFI-SL Business TransactionACTI1CHAR 4T022
GENgenusTransaction TypeRMVCTCHAR 3T856
CVM keyclavis monetaeCurrency KeyRTCURCUKY 5
MENmensuraBase Unit of MeasureMEINSUNIT 3
RFRreferentiaReference TransactionAWTYPCHAR 5TTYP
LOGSYSLogical systemLOGSYSCHAR 10TBDLS
SMP_ELMsumptus elementumCost ElementKSTARCHAR 10CSKB
CSMcentrum sumptusCost CenterKOSTLCHAR 10CSKS
CLUcentrum lucriProfit CenterPRCTRCHAR 10CEPC
AFNarea functionisFunctional AreaFKBERCHAR 16TFKB
ANGarea negotiiBusiness AreaGSBERCHAR 4TGSB
AMDarea moderationisControlling AreaKOKRSCHAR 4TKA01
SEGsegmentumSegment for Segmental ReportingFB_SEGMENTCHAR 10FAGL_SEGM
CSM2centrum sumptusSender cost centerSKOSTCHAR 10CSKS
SCS_CLUsocius centrum lucriPartner Profit CenterPPRCTRCHAR 10CEPC
SCS_AFNsocius area functionisPartner Functional AreaSFKBERCHAR 16TFKB
SNG_ANGsocius negotiationis area negotiiTrading partner's business areaPARGBCHAR 4TGSB
SOC_SNGsocietas socius negotiationisCompany ID of trading partnerRASSCCHAR 6T880
SCS_SEGsocius segmentumPartner Segment for Segmental ReportingFB_PSEGMENTCHAR 10FAGL_SEGM
AEQ_MONaequilibrium monetaBalance carried forward in transaction currencyTSLVT12CURR 23,2
TOT_PER_MONsumma totalis periodus monetaTotal of transactions of period 1 in transaction currency (representative of the TSL01-TSL16 period array)TSLXX12CURR 23,2
TOT_PER_MON2summa totalis periodus monetaTotal of transactions of period 12 in transaction currency (representative of the TSL01-TSL16 period array)TSLXX12CURR 23,2
TOT_PER_ANNsumma totalis periodus annusTotal of transactions of period 16 (year-end/adjustment period) in transaction currency (representative of the TSL01-TSL16 period array)TSLXX12CURR 23,2
AEQ_MON2aequilibrium monetaBalance carried forward in local currencyHSLVT12CURR 23,2
TOT_PER_MON3summa totalis periodus monetaTotal of transactions of period 1 in local currency (representative of the HSL01-HSL16 period array)HSLXX12CURR 23,2
TOT_PER_MON4summa totalis periodus monetaTotal of transactions of period 12 in local currency (representative of the HSL01-HSL16 period array)HSLXX12CURR 23,2
TOT_PER_ANN2summa totalis periodus annusTotal of transactions of period 16 (year-end/adjustment period) in local currency (representative of the HSL01-HSL16 period array)HSLXX12CURR 23,2
AEQ_CTS_MONaequilibrium coetus monetaBalance carried forward in group currencyKSLXX12CURR 23,2
TOT_PER_CTSsumma totalis periodus coetusTotal of transactions of period 1 in group currency (representative of the KSL01-KSL16 period array)KSLXX12CURR 23,2
TOT_PER_CTS2summa totalis periodus coetusTotal of transactions of period 12 in group currency (representative of the KSL01-KSL16 period array)KSLXX12CURR 23,2
TOT_PER_ANN3summa totalis periodus annusTotal of transactions of period 16 (year-end/adjustment period) in group currency (representative of the KSL01-KSL16 period array)KSLXX12CURR 23,2
AEQ_MON3aequilibrium monetaBalance carried forward in fourth (freely defined) currencyOSLVT12CURR 23,2
TOT_PER_MON5summa totalis periodus monetaTotal transactions for period 1 in the fourth currency (representative of the OSL01-OSL16 period array)OSLXX12CURR 23,2
AEQ_QNTaequilibrium quantitasBalance carried forward of quantityMSLVT12QUAN 23,3
TOT_PERsumma totalis periodusTotal of the transactions of period 1 in units of measure (representative of the MSL01-MSL16 period array)MSLXX12QUAN 23,3
TOT_PER2summa totalis periodusTotal of the transactions of period 12 in units of measure (representative of the MSL01-MSL16 period array)MSLXX12QUAN 23,3
TMP_FRMtempus formaUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC 15

Foreign keys

FieldCheck tableCheck field
RCLNTT000MANDT
RBUKRST001BUKRS
RLDNRV_FAGL_T881_DBALRLDNR
RVERST894RVERS
ACTIVT022ACTIVITY
RMVCTT856TRTYP
AWTYPTTYPAWTYP
LOGSYSTBDLSLOGSYS
RACCTSKB1SAKNR
COST_ELEMCSKBKSTAR
RCNTRCSKSKOSTL
PRCTRCEPCPRCTR
RFAREATFKBFKBER
RBUSATGSBGSBER
KOKRSTKA01KOKRS
SEGMENTFAGL_SEGMSEGMENT
SCNTRCSKSKOSTL
PPRCTRCEPCPRCTR
SFAREATFKBFKBER
SBUSATGSBGSBER
RASSCT880RCOMP
PSEGMENTFAGL_SEGMSEGMENT

View FAGLFLEXT.yaml in the repository