Model / FI / FAGLFLEXA

FI — Financial Accounting

FAGLFLEXA

47 fields · 6 key · 26 foreign keys · sourced from leanx.eu

General Ledger: Actual Line Items — the New G/L (new-GL) flexible line-item table, SAP's pre-S/4HANA ancestor of ACDOCA. Where S/4HANA writes every FI+CO+AA line to the single Universal Journal (ACDOCA), an ECC/New-GL customer writes the equivalent actual line item here, one row per ledger per document per line, split by dimension (profit center, segment, functional area, business area). A customer running classic ECC mirrors this table; a customer on S/4HANA mirrors ACDOCA — the model must read both to cover the FI lane across a customer's install base.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
ANF keyannus fiscalisFiscal YearGJAHRNUMC 4
NDO keynumerus documentiAccounting Document NumberBELNR_DCHAR 10
LBR keyliberLedger in General Ledger AccountingFAGL_RLDNRCHAR 2V_FAGL_T881_DBAL
SOC keycodex societatisCompany CodeBUKRSCHAR 4T001
INS_POS_LBR keyinscriptio positio liberSix-Character Posting Item for LedgerDOCLN6CHAR 6
TBL_GENtabula genusRecord TypeRRCTYCHAR 1
VRSversioVersionRVERSCHAR 3T894
ACTIVFI-SL Business TransactionACTI1CHAR 4T022
GENgenusTransaction TypeRMVCTCHAR 3T856
CVMclavis monetaeCurrency KeyRTCURCUKY 5
CVM_MONclavis monetae monetaCurrency key of the original transaction currencyRWCURCUKY 5TCURC
MENmensuraBase Unit of MeasureMEINSUNIT 3
RFRreferentiaReference TransactionAWTYPCHAR 5TTYP
LOGSYSLogical systemLOGSYSCHAR 10TBDLS
RAT_NUM_EPHratio numerus ephemerisAccount Number — the G/L account this journal line posted toRACCTCHAR 10SKB1
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
VAL_MONvalor monetaValue in Transaction CurrencyVTCUR12CURR 23,2
VAL_MON2valor monetaValue in Local CurrencyVLCUR12CURR 23,2
VAL_CTS_MONvalor coetus monetaValue in Group CurrencyVGCUR12CURR 23,2
VAL_MON3valor monetaValue in Another CurrencyVOCUR12CURR 23,2
QNTquantitasQuantityQUAN1_12QUAN 23,3
VAL_MON_DOCvalor moneta documentumValue in Original Transaction Currency (Document Currency)VWCUR12CURR 23,2
DBT_CRD_IDXdebitum creditum indexDebit/Credit IndicatorSHKZGCHAR 1
INS_PERinscriptio periodusPosting periodPOPERNUMC 3
ANF2annus fiscalisFiscal YearGJAHRNUMC 4
DIN_DOCdies inscriptionis documentumPosting Date in the DocumentBUDATDATS 8
NDO2numerus documentiAccounting Document NumberBELNR_DCHAR 10
NUM_POS_DOCnumerus positio documentumNumber of Line Item Within Accounting DocumentBUZEINUMC 3
INS_CLVinscriptio clavisPosting KeyBSCHLCHAR 2TBSL
DOC_STAdocumentum statusDocument StatusBSTAT_DCHAR 1
POS_CTGpositio categoriaItem categoryLINETYPECHAR 5T8G02
POS_MUT_DOCpositio mutatus documentumItem changed by document splittingXSPLITMODCHAR 1
USR_NOMusor nomenUser nameUSNAMCHAR 12USR02
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
RWCURTCURCWAERS
AWTYPTTYPAWTYP
LOGSYSTBDLSLOGSYS
RACCTSKB1SAKNR
COST_ELEMCSKBKSTAR
RCNTRCSKSKOSTL
PRCTRCEPCPRCTR
RFAREATFKBFKBER
RBUSATGSBGSBER
KOKRSTKA01KOKRS
SEGMENTFAGL_SEGMSEGMENT
SCNTRCSKSKOSTL
PPRCTRCEPCPRCTR
SFAREATFKBFKBER
SBUSATGSBGSBER
RASSCT880RCOMP
PSEGMENTFAGL_SEGMSEGMENT
BSCHLTBSLBSCHL
LINETYPET8G02LINETYPE
USNAMUSR02BNAME

View FAGLFLEXA.yaml in the repository