FINSC_LEDGER

Transparent Table Customizing (protected)
14 Fields 54 CDS Views

Universal Journal Entry Ledger

FINSC_LEDGER is an SAP database table in S/4HANA. Universal Journal Entry Ledger. It contains 14 fields. 54 CDS views read from this table.

CDS Views using this table (54)

ViewTypeJoinVDMDescription
ACE_ACCOUNT_PRINCIPLE_LEDGER view inner Accrual Account Principle and Ledger
ACE_ACEDSOI_ACCTS view left_outer Compatibility view for ACEDSOI_ACCOUNTS
ACE_ACEDSOI_CMPATBL view left_outer Compatibility view for ACEDSOI
CLOSING_OPERATIONS_GR_IR_ITEMS view inner GR/IR Items in BSEG Format
F_Mmim_Acdoca_Ele view inner Read Universal Journal Entry Line Items
FAA_CFG_CMP_LEDGER view inner Configuration Data of CompCodes and Ledger
FCO_COST_RATE_MIG_CLASSIC view inner Activity prices from COST in ACCOSTRATE format
fcov_cost_rate_mig view inner Activity prices in ACCOSTRATE format
FGL_BCF_LD_CMP view inner All valid item of table finsc_ld_cmp
FGL_GLT3_CUR view inner Currency Handling (Source ACDOCA)
FGL_MIG_0_CUR view inner GL Delta Entries - Currency Handling (Source GLT0)
FGL_MIG_ACD view inner View of G/L-entities on ACDOCA - generated.
finoc_naoi_buzei view inner OrgChange: Non-Assigned Open Items 1
fins_gl_doc_all_amnts_tax view inner
FINS_GL_DOCUMENT_ALL_AMOUNTS view inner
FINS_GL_DOCUMENT_AMT_AWITEM view inner Get Amounts from all ledgers via DOCLN
Fins_Rev_Rec_Acc_Pri_View view inner Accounting Principles for transaction based revenue recogn.
fins_rev_Rec_bukrs_acc_prin view inner Company codes and accounting principles
FINS_T001A view inner Compatibility view for table T001A
FINSCDS_F4_LDBUKRS view inner Value help view: Ledger for Company Code
FINSCDS_REPR_RLDNR view union_all Representative Ledger
finsv_unique_cvtyps view inner Unique CVTYPs
Finsvd_F4_Rldnr_For_Simulation view from Value help view: extension ledger for simulation
fiscds_rldnr view from Ledger
Fisvd_Rldnr_Appl1 view from Ledger for applications
Fisvd_Rldnr_Rep view inner ledger with reporting ledgers
FISVD_valid_RLDNR view from Ledger
FJV_MIG_ACD view inner JVA entities on ACDOCA
FJV_MIG_CUR view inner JVA-Totals with currency mapping (JVTO1)
FJV_MIG_PACKAGE view inner JV Delta Entries - Migration Packages
Fml_Relind view inner ML Relevant Indicators
fmlv_ckmlct view inner Replacement object for CKMLCT
fmlv_curtp_ml view inner Select ML relevant currencies
I_AccrItemTypeForLedgerGroup view left_outer BASIC Accrual Item Type for Ledger Group
I_Ledger view from BASIC Ledger
JV_JVSO1_COMB_DOC_BALANCE view right_outer Doc. bal. for 4A/4C view on JVSO1
Mmim_MatDocAccounting view inner Accounting Documents for Material Document
P_ACMTrdgContrFinDoc view inner BASIC
P_FINS_GL_DOC_AMOUNTS_GRIR view_entity inner BASIC Amounts per Currency Type of a G/L Doc.
P_Fins_GL_Document_Amounts view inner BASIC
P_FINS_REPRESENTIVE_LEDGER view union BASIC
P_FixedAssetForLedger view inner BASIC
P_MaterialLedger_Name_Curtp view inner BASIC
P_StkPostgHistAcctg view_entity inner COMPOSITE Stock posting history accounting document
P_StkPostgHistAcctgNoStkQty view_entity inner COMPOSITE Stock posting history acc document with stock quantity 0
P_StkPostgHistBasic view_entity inner COMPOSITE Stock posting history basic view
P_StkPostgHistBasicNoReversal view_entity inner COMPOSITE Stock posting history documents without reversal
V_Cosp_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (primary)
v_cosp_d2_coep_view view inner COSP Difference from Migration as COEP - BSTAT=C
V_Coss_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (secondary)
v_coss_d2_coep_view view inner COSS Difference from Migration as COEP - BSTAT=C
v_glt0_cur_view view inner GLT0 (Currency Ledger Handling)
v_ml_bcf_ol_l1_view view inner LOCAL: Material Ledger BCF for other ledgers
v_ml_total_agg_view view inner LOCAL: Material Ledger Totals

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rldnr fins_ledger Ledger
ledger_type fins_ledger_type Ledger Type
ext_ledger_type fins_ext_ledger_type Extn. Ledger Type
appl glxappl Application
subappl glxsubappl Subapplication
xleading fagl_flag_leading Leading Ledger
core fins_core_ledger Underlying Ledger
valutyp fins_valutyp_char Valuation View
valusubtyp fins_valusubtyp Subtype Val
man_post_not_allwd fins_manual_post_not_allowed Man.Pstgs Not Allwd
acc_principle acc_principle_ledger Corp AccPrinc
fallback_ledger fins_fallback_ledger Fallback Ledger
tech_ledger fins_technical_ledger Technical Ledger

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Universal Journal Entry Ledger
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_LEDGER (
    MANDT,               -- Client [mandt]
    RLDNR,               -- Ledger [fins_ledger]
    LEDGER_TYPE,         -- Ledger Type [fins_ledger_type]
    EXT_LEDGER_TYPE,     -- Extn. Ledger Type [fins_ext_ledger_type]
    APPL,                -- Application [glxappl]
    SUBAPPL,             -- Subapplication [glxsubappl]
    XLEADING,            -- Leading Ledger [fagl_flag_leading]
    CORE,                -- Underlying Ledger [fins_core_ledger]
    VALUTYP,             -- Valuation View [fins_valutyp_char]
    VALUSUBTYP,          -- Subtype Val [fins_valusubtyp]
    MAN_POST_NOT_ALLWD,  -- Man.Pstgs Not Allwd [fins_manual_post_not_allowed]
    ACC_PRINCIPLE,       -- Corp AccPrinc [acc_principle_ledger]
    FALLBACK_LEDGER,     -- Fallback Ledger [fins_fallback_ledger]
    TECH_LEDGER,         -- Technical Ledger [fins_technical_ledger]
    PRIMARY KEY (MANDT, RLDNR)
);

Learn More