SAP table FAGLFLEXA (General Ledger: Actual Line Items)

SAP table FAGLFLEXA has 6 primary key fields being RCLNT,RYEAR,DOCNR,RLDNR,RBUKRS,DOCLN.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
RYEAR Fiscal Year NUMC 4 0 GJAHR
DOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
RLDNR Ledger in General Ledger Accounting CHAR 2 0 V_FAGL_T881_DBAL FAGL_RLDNR
RBUKRS Company Code CHAR 4 0 T001 BUKRS
DOCLN Six-Character Posting Item for Ledger CHAR 6 0 DOCLN6
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
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
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
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
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
WSL Value in Original Transaction Currency (Document Currency) CURR 23 2 VWCUR12
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
POPER Posting period NUMC 3 0 POPER
RWCUR Currency key of the original transaction currency CUKY 5 0 TCURC RWCUR
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
BSTAT Document Status CHAR 1 0 BSTAT_D
LINETYPE Item Category CHAR 5 0 T8G02 LINETYPE
XSPLITMOD Item Changed by Document Splitting CHAR 1 0 XSPLITMOD
USNAM User Name CHAR 12 0 USR02 USNAM
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

FAGLFLEXA foreign key relationships

Table Field Check Table Check Field
0 FAGLFLEXA AWTYP TTYP Object Types for Accounting AWTYP
1 FAGLFLEXA BSCHL TBSL Posting Key MANDT
1 FAGLFLEXA BSCHL TBSL Posting Key BSCHL
0 FAGLFLEXA COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
0 FAGLFLEXA COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
0 FAGLFLEXA COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
0 FAGLFLEXA COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
1 FAGLFLEXA KOKRS TKA01 Controlling Areas MANDT
0 FAGLFLEXA LINETYPE T8G02 Item categories LINETYPE
1 FAGLFLEXA LOGSYS TBDLS Logical system LOGSYS
0 FAGLFLEXA PPRCTR CEPC Profit Center Master Data Table PRCTR
0 FAGLFLEXA PPRCTR CEPC Profit Center Master Data Table DATBI
0 FAGLFLEXA PPRCTR CEPC Profit Center Master Data Table KOKRS
1 FAGLFLEXA PRCTR CEPC Profit Center Master Data Table PRCTR
1 FAGLFLEXA PRCTR CEPC Profit Center Master Data Table DATBI
1 FAGLFLEXA PRCTR CEPC Profit Center Master Data Table KOKRS
0 FAGLFLEXA PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FAGLFLEXA RACCT SKB1 G/L account master (company code) MANDT
1 FAGLFLEXA RACCT SKB1 G/L account master (company code) BUKRS
0 FAGLFLEXA RASSC T880 Global Company Data (for KONS Ledger) MANDT
0 FAGLFLEXA RASSC T880 Global Company Data (for KONS Ledger) RCOMP
1 FAGLFLEXA RBUKRS T001 Company Codes BUKRS
0 FAGLFLEXA RBUSA TGSB Business Areas MANDT
0 FAGLFLEXA RBUSA TGSB Business Areas GSBER
1 FAGLFLEXA RCLNT T000 Clients MANDT
0 FAGLFLEXA RCNTR CSKS Cost Center Master Record MANDT
0 FAGLFLEXA RCNTR CSKS Cost Center Master Record KOKRS
0 FAGLFLEXA RCNTR CSKS Cost Center Master Record DATBI
1 FAGLFLEXA RFAREA TFKB Functional areas FKBER
0 FAGLFLEXA RMVCT T856 Transaction Types MANDT
0 FAGLFLEXA RMVCT T856 Transaction Types TRTYP
1 FAGLFLEXA RVERS T894 FI-SL and FI-LC Versions MANDT
1 FAGLFLEXA RVERS T894 FI-SL and FI-LC Versions RLDNR
1 FAGLFLEXA RVERS T894 FI-SL and FI-LC Versions RVERS
0 FAGLFLEXA RWCUR TCURC Currency Codes MANDT
0 FAGLFLEXA RWCUR TCURC Currency Codes WAERS
1 FAGLFLEXA SBUSA TGSB Business Areas MANDT
1 FAGLFLEXA SBUSA TGSB Business Areas GSBER
0 FAGLFLEXA SCNTR CSKS Cost Center Master Record MANDT
0 FAGLFLEXA SCNTR CSKS Cost Center Master Record KOKRS
0 FAGLFLEXA SCNTR CSKS Cost Center Master Record DATBI
1 FAGLFLEXA SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 FAGLFLEXA SFAREA TFKB Functional areas FKBER
1 FAGLFLEXA USNAM USR02 Logon Data (Kernel-Side Use) BNAME