SAP table FINSC_LEDGER (Universal Journal Entry Ledger)

SAP table FINSC_LEDGER has 2 primary key fields being MANDT,RLDNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
RLDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
LEDGER_TYPE Ledger Type CHAR 1 0 FINS_LEDGER_TYPE
Standard Ledger
A Extension Ledger
EXT_LEDGER_TYPE Extension Ledger Type CHAR 1 0 FINS_EXT_LEDGER_TYPE
Standard journal entries
P Line items with technical numbers / no deletion possible
S Line items with technical numbers / deletion possible
V Journal entries for valuation differences
APPL Owner application CHAR 2 0 GLXAPPL
SUBAPPL Subapplication CHAR 3 0 GLXSUBAPPL
XLEADING Indicator: Leading Ledger CHAR 1 0 FAGL_FLAG_LEADING
CORE Underlying Ledger of an Extension Ledger CHAR 2 0 FINS_CORE_LEDGER
VALUTYP Valuation View CHAR 1 0 FINS_VALUTYP_CHAR
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
3 Segmentation Valuation
VALUSUBTYP Subtype of Valuation View (for Transfer Prices) CHAR 2 0 FINSC_VALUSUBTYP FINS_VALUSUBTYP
MAN_POST_NOT_ALLWD Manual Postings Not Allowed To Ledger CHAR 1 0 FINS_MANUAL_POST_NOT_ALLOWED
ACC_PRINCIPLE Corporate Accounting Principle CHAR 4 0 TACC_PRINCIPLE ACC_PRINCIPLE_LEDGER
FALLBACK_LEDGER Fallback Ledger CHAR 2 0 FINS_FALLBACK_LEDGER
TECH_LEDGER Technical ledger CHAR 2 0 FINS_TECHNICAL_LEDGER
XCASH_LEDGER Cash Ledger Indicator CHAR 1 0 FAGL_CASH_LEDGER

FINSC_LEDGER foreign key relationships

Table Field Check Table Check Field
0 FINSC_LEDGER ACC_PRINCIPLE TACC_PRINCIPLE Accounting Principle MANDT
0 FINSC_LEDGER ACC_PRINCIPLE TACC_PRINCIPLE Accounting Principle ACC_PRINCIPLE
1 FINSC_LEDGER VALUSUBTYP FINSC_VALUSUBTYP Valuation View Subtype VALUSUBTYPE