SAP Table
FINSC_LEDGER Universal Journal Entry Ledger
SAP table FINSC_LEDGER has 2 primary key fields being MANDT,RLDNR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
FINSC_LEDGER columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||
| KeyRLDNR | Ledger in General Ledger Accounting | CHAR | 2 | 0 | FINS_LEDGER | ||||||||||||
| LEDGER_TYPE | Ledger Type | CHAR | 1 | 0 | FINS_LEDGER_TYPE | ||||||||||||
|
|||||||||||||||||
| EXT_LEDGER_TYPE | Extension Ledger Type | CHAR | 1 | 0 | FINS_EXT_LEDGER_TYPE | ||||||||||||
|
|||||||||||||||||
| 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 | ||||||||||||
|
|||||||||||||||||
| 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 | ||||||||||||
/ Relationships
FINSC_LEDGER foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| FINSC_LEDGER | ACC_PRINCIPLE | TACC_PRINCIPLE | Accounting Principle | MANDT |
| FINSC_LEDGER | ACC_PRINCIPLE | TACC_PRINCIPLE | Accounting Principle | ACC_PRINCIPLE |
| FINSC_LEDGER | VALUSUBTYP | FINSC_VALUSUBTYP | Valuation View Subtype | VALUSUBTYPE |