FINSC_LEDGER table in SAP ERP or S/4HANA stores Universal Journal Entry Ledger data. There are total 14 fields in FINSC_LEDGER table. The Universal Journal Entry Ledger table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FINSC_LEDGER table. It is in Unified Journal Entry – Customizing (FINS_ACDOC_CUST) ABAP package and is part of the General Ledger Accounting (FI-GL) module.
SAP FINSC_LEDGER Table Fields
Following is the list of fields that are available in SAP FINSC_LEDGER table. The primary key fields of Universal Journal Entry Ledger table in SAP are MANDT (Client), RLDNR (Ledger in General Ledger Accounting).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT(3) | |
| RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR(2) | |
| LEDGER_TYPE | Ledger Type | FINS_LEDGER_TYPE | CHAR(1) | |
| EXT_LEDGER_TYPE | Extension Ledger Type | FINS_EXT_LEDGER_TYPE | CHAR(1) | |
| APPL | Owner application | GLXAPPL | CHAR(2) | |
| SUBAPPL | Subapplication | GLXSUBAPPL | CHAR(3) | |
| XLEADING | Indicator: Leading Ledger | FAGL_FLAG_LEADING | CHAR(1) | |
| CORE | Underlying Ledger of an Extension Ledger | FINS_CORE_LEDGER | CHAR(2) | |
| VALUTYP | Valuation View | FINS_VALUTYP_CHAR | CHAR(1) | |
| VALUSUBTYP | Subtype of Valuation View (for Transfer Prices) | FINS_VALUSUBTYP | FINSC_VALUSUBTYP | CHAR(2) |
| MAN_POST_NOT_ALLWD | Manual Postings Not Allowed To Ledger | FINS_MANUAL_POST_NOT_ALLOWED | CHAR(1) | |
| ACC_PRINCIPLE | Corporate Accounting Principle | ACC_PRINCIPLE_LEDGER | TACC_PRINCIPLE | CHAR(4) |
| FALLBACK_LEDGER | Fallback Ledger | FINS_FALLBACK_LEDGER | CHAR(2) | |
| XCASH_LEDGER | Cash Ledger Indicator | FAGL_CASH_LEDGER | CHAR(1) |
