FINSC_LD_CMP

Transparent Table Customizing Table
39 Fields 107 CDS Views

CompCode-Dependent Settings for Univ. Journal Entry Ledger

FINSC_LD_CMP is an SAP database table in S/4HANA. CompCode-Dependent Settings for Univ. Journal Entry Ledger. It contains 39 fields. 107 CDS views read from this table.

CDS Views using this table (107)

ViewTypeJoinVDMDescription
ACE_ACCOUNT_PRINCIPLE_LEDGER view inner Accrual Account Principle and Ledger
ARO_DDL_SortedListProvPlan view inner ARO SortedListProvision On KeyDate(Plan)
CLOSING_OPERATIONS_GR_IR_ITEMS view inner GR/IR Items in BSEG Format
FAA_CFG_AFABER view inner Intern: Representative Ledger fuer AfA-Bereiche
FAA_CFG_CMP_DA view inner Configuration of Depreciation Areas after REDESIGN
FAA_CFG_CMP_LEDGER view inner Configuration Data of CompCodes and Ledger
FAA_CFG_DEPR_AREA view inner Configuration of Depr.Area
FAA_CFG_LEDGER view from Configuration of Ledger, Account. Principle and Ledgergroup
FAA_CFG_VIRTUAL_AREA view inner Semantics of Virtual Depreciation Area
FAA_SDM_BALANCE01 view from Asset balance cube 01
FAA_SDM_BALANCE01 view union_all Asset balance cube 01
FAA_UPA_MIG_DI_BALANCE01 view_entity from DOC_IT balance layer 01
FAA_UPA_MIG_DI_BALANCE01 view_entity union_all DOC_IT balance layer 01
Fac_Opp_Cds_Ppv view from CDS View For PPV value help on Overview page
Fac_opp_cds_ppv_related_cocd view from CDS View For PPV related CompCode
Fac_Opp_Cds_T001b view left_outer CDS View For T001B
Fac_Opp_Cds_T001b_In_Cocd view inner CDS View For T001B
Fac_Opp_Cds_To_Account view inner CDS View for MPP To Account
Fac_Ppv_Cds_Ppv view from CDS View For PPV value help on Overview page
Fac_Ppv_Cds_Ppv_Ref view from CDS View for PPV reference in PPV Complete
Fac_ppv_cds_ppv_related_cocd view from CDS View For PPV related CompCode
Fac_Ppv_Cds_Ppvitem view inner CDS View For PPV Item Overview page
FARR_JournalEntryItem view_entity inner Revenue Accounting-ACDOCA Extended View
FCML_FIND_MLDOC_WRONG_BUDAT_V view inner CDS View to detect wrong BUDAT in MLDOC
FCML_MLDOC_EMPTY_BUDAT_DDL view inner CDS View to detect empty BUDAT in MLDOC
FCO_MIG_CUR view inner CO Delta Entries - Currency Handling (src. COEP+COSP+COSS)
FGL_BCF_BS view inner Balance Carry Forward: Balance Sheet
FGL_BCF_LD_CMP view from All valid item of table finsc_ld_cmp
FGL_BCF_PL view inner Balance Carry Forward: Profit and Loss
FGL_BCF_RUN_INFO view left_outer Balance Carry Forward: Run Information
FGL_GLSI_ACD view inner View of G/L-entities on ACDOCA - generated.
FGL_MIG_0_CUR view inner GL Delta Entries - Currency Handling (Source GLT0)
FGL_MIG_3_CUR view inner GL Delta Entries - Currency Handling (Source GLT3)
Fins_acdoca_lines_base view_entity inner Base view for number of document items
fins_gl_doc_all_amnts_tax view inner Amounts per curr type of a G/L document bsd on tax attr
FINS_GL_DOCUMENT_ALL_AMOUNTS view inner Amounts per Currency Type of a G/L Document
FINS_GL_DOCUMENT_AMT_AWITEM view inner Get Amounts from all ledgers via DOCLN
FINS_GL_DOCUMENT_AMT_DOCLN view inner Get Amounts from all ledgers via DOCLN
fins_ic_acd_1 view inner IC: Selection of UJ line items
fins_ic_spl_1 view inner IC: Selection of split line items
fins_rev_Rec_acc_pri_ldr_dev view_entity inner Deviating assignment company/ledger/accounting principle
Fins_Rev_Rec_Acc_Pri_View view_entity from Accounting Principles for transaction based revenue recogn.
Fins_Rev_Rec_Acdoca_Balance view_entity inner Acdoca balance for introducing a new accounting principle
Fins_Rev_Rec_Cons_Check_View view_entity inner Consistency check of ACDOCA items
FINS_REV_REC_COS_ACT_DIST_REF view_entity inner Distinct AWREF for data with CO objects
FINS_REV_REC_COS_ACT_VIEWA_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COS_ACTUAL_VIEWMT view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW1_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW1A_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW2_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW3_BAS view_entity inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW4_BAS view_entity inner Actuals for data with CO objects
fins_rev_rec_data_del_contr view_entity inner Clearing postings of deleted contracts
FINS_REV_REC_DATA_VIEW1_BASE view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW1A_BASE view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2_BASE view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2C view_entity inner Contract data of trans. based rev.recog. cumulative process.
FINS_REV_REC_DATA_VIEW3_BASE view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWA_BASE view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWD view_entity inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_OTHER_VIEW_BASE view_entity inner Other data for cumulative process.
FINS_REV_REC_OTHER_VIEW1A_BASE view_entity inner Other data for cumulative process.
FINS_REV_REC_TOTAL_REVENUE view_entity inner Total revenue
Fins_Rev_Rec_uprctr_View view_entity inner pernr - origin prctr
fins_sif_bkpf_missing_ledger view inner Document posted specific to ledger group with missing Ledger
FINS_T001A view from Compatibility view for table T001A
FINSCDS_F4_LDKOKRS view inner Value help view: Ledger for Controlling Area
fiscds_buk_attr view inner Attributes for Company Codes/Ledger
fiscds_buk4rldnr view inner F4 Help: Company Codes for Ledger
fiscds_gllit_04 view inner GL Line Item (all Ledger)
Fiscds_Ld_Cmp_All view from FISVD_LD_CMP_ALL
Fisvd_Ld_Cmp view inner F4 Help: Ledger and Company
Fisvd_Ld_Cmp_Rep view from ledger company customizing with reporting ledger
FJV_MIG_CUR view inner JVA-Totals with currency mapping (JVTO1)
FJV_MIG_PACKAGE view inner JV Delta Entries - Migration Packages
Fml_Relind view from ML Relevant Indicators
Fml_Relind_Bwkey view from ML Relevant Indicators per Bwkey
I_AdditionalCurrencyRoles view_entity from BASIC Additional Currency Roles for Company Code
I_AdditionalCurrencyRoles view_entity union_all BASIC Additional Currency Roles for Company Code
I_CorrespncAddlCurrencyRole view from BASIC Additional Currency Role for Correspondence
I_FiscalCalYearPeriodForLedger view_entity inner BASIC Fiscal Year Period for Ledger
I_FiscalYearForLedger view_entity inner BASIC Fiscal Year for Ledger
I_FiscalYearPeriodForLedger view_entity inner BASIC Fiscal Year Period for Ledger
I_LedgerCompanyCodeCrcyRoles view from BASIC Currency Roles for Ledger
IC_ReconciliationLedger view from IC: Determine Reconciliation Ledger
IC_SelectUJLineItems view inner IC: Selection of UJ line items
P_Acdoca_As_Coep view inner BASIC P_ACDOCA_AS_COEP
P_Buk4rldnr view_entity inner BASIC Company Codes for Ledger
P_CoCodeLedgerValnCrcyRole view from BASIC Company code ledger valuation currencyrole
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 Amounts per Currency Type of a G/L Document
P_LDCMP view from BASIC Settings for Ledger and Company Code
P_ValuationHistoryLogBalances view inner BASIC Log for valuation history of the balances
P_ValuationHistoryLogDocuments view inner BASIC Log for valuation history of the documents
P_ValuationViewByDeprArea view inner BASIC Depreciation Area - Valuation View determination
R_PaymentCurrencyRole view from BASIC Payment Currency Roles
v_acdoct_per_view view inner Period sums of ACDOCA without period block
V_COSP_LVP_2_VIEW view inner COSP totals: all currencies/valuations - 1
V_COSP_PER_2_VIEW view inner COSP totals: all currencies/valuations - 2
V_Cosp_R_8_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part 8
V_COSS_LVP_2_VIEW view inner COSS totals: all currencies/valuations - 1
V_COSS_PER_2_VIEW view inner COSS totals: all currencies/valuations - 2
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSS4W09_2_VIEW view inner COSS for WRTTP=09 - part 2
V_COSX_LVP_2_VIEW view inner COSX totals: all currencies/valuations - 1
v_ml_invacc_l2_view view inner Inventory stock - accounts

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rldnr fins_ledger Ledger
KEY bukrs bukrs Company Code
curtph fins_curtype_h CrcyType Crcy 1
mlrelindh fins_ml_cur_ind_h ML Relevant (H)
curtpk fins_curtype_k CrcyType Crcy 2
curposk fins_cur_pos_k Curr Pos K
mlrelindk fins_ml_cur_ind_k ML Relevant (K)
curtpo fins_curtype_o FreeDef Crcy 1
curposo fins_cur_pos_o Curr Pos O
mlrelindo fins_ml_cur_ind_o ML Relevant (O)
curtpv fins_curtype_v FreeDef Crcy 2
curposv fins_cur_pos_v Curr Pos V
mlrelindv fins_ml_cur_ind_v ML Relevant (V)
curtpb fins_curtype_b FreeDef Crcy 3
curposb fins_cur_pos_b Curr Pos B
mlrelindb fins_ml_cur_ind_b ML Relevant (B)
curtpc fins_curtype_c FreeDef Crcy 4
curposc fins_cur_pos_c Curr Pos CSL
mlrelindc fins_ml_cur_ind_c ML Relevant (C)
curtpd fins_curtype_d FreeDef Crcy 5
curposd fins_cur_pos_d Curr Pos DSL
mlrelindd fins_ml_cur_ind_d ML Relevant (D)
curtpe fins_curtype_e FreeDef Crcy 6
curpose fins_cur_pos_e Curr Pos ESL
mlrelinde fins_ml_cur_ind_e ML Relevant (E)
curtpf fins_curtype_f FreeDef Crcy 7
curposf fins_cur_pos_f Curr Pos F
mlrelindf fins_ml_cur_ind_f ML Relevant (F)
curtpg fins_curtype_g FreeDef Crcy 8
curposg fins_cur_pos_g Curr Pos GSL
mlrelindg fins_ml_cur_ind_g ML Relevant (G)
periv periv FY Variant
parglaccts fins_parallel_glacct Parallel GL Accts
opvar opvar Pstg Per.Var.
toyear fagl_toyear To Fiscal Year
write_docnr_ld fins_write_docnr_ld Seq. Doc. Number
acc_principle acc_principle_ld_cmp AP Ledger/CoCode
functional_currency finsc_functional_curtype Functional Currency

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.

-- CompCode-Dependent Settings for Univ. Journal Entry Ledger
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_LD_CMP (
    MANDT,                -- Client [mandt]
    RLDNR,                -- Ledger [fins_ledger]
    BUKRS,                -- Company Code [bukrs]
    CURTPH,               -- CrcyType Crcy 1 [fins_curtype_h]
    MLRELINDH,            -- ML Relevant (H) [fins_ml_cur_ind_h]
    CURTPK,               -- CrcyType Crcy 2 [fins_curtype_k]
    CURPOSK,              -- Curr Pos K [fins_cur_pos_k]
    MLRELINDK,            -- ML Relevant (K) [fins_ml_cur_ind_k]
    CURTPO,               -- FreeDef Crcy 1 [fins_curtype_o]
    CURPOSO,              -- Curr Pos O [fins_cur_pos_o]
    MLRELINDO,            -- ML Relevant (O) [fins_ml_cur_ind_o]
    CURTPV,               -- FreeDef Crcy 2 [fins_curtype_v]
    CURPOSV,              -- Curr Pos V [fins_cur_pos_v]
    MLRELINDV,            -- ML Relevant (V) [fins_ml_cur_ind_v]
    CURTPB,               -- FreeDef Crcy 3 [fins_curtype_b]
    CURPOSB,              -- Curr Pos B [fins_cur_pos_b]
    MLRELINDB,            -- ML Relevant (B) [fins_ml_cur_ind_b]
    CURTPC,               -- FreeDef Crcy 4 [fins_curtype_c]
    CURPOSC,              -- Curr Pos CSL [fins_cur_pos_c]
    MLRELINDC,            -- ML Relevant (C) [fins_ml_cur_ind_c]
    CURTPD,               -- FreeDef Crcy 5 [fins_curtype_d]
    CURPOSD,              -- Curr Pos DSL [fins_cur_pos_d]
    MLRELINDD,            -- ML Relevant (D) [fins_ml_cur_ind_d]
    CURTPE,               -- FreeDef Crcy 6 [fins_curtype_e]
    CURPOSE,              -- Curr Pos ESL [fins_cur_pos_e]
    MLRELINDE,            -- ML Relevant (E) [fins_ml_cur_ind_e]
    CURTPF,               -- FreeDef Crcy 7 [fins_curtype_f]
    CURPOSF,              -- Curr Pos F [fins_cur_pos_f]
    MLRELINDF,            -- ML Relevant (F) [fins_ml_cur_ind_f]
    CURTPG,               -- FreeDef Crcy 8 [fins_curtype_g]
    CURPOSG,              -- Curr Pos GSL [fins_cur_pos_g]
    MLRELINDG,            -- ML Relevant (G) [fins_ml_cur_ind_g]
    PERIV,                -- FY Variant [periv]
    PARGLACCTS,           -- Parallel GL Accts [fins_parallel_glacct]
    OPVAR,                -- Pstg Per.Var. [opvar]
    TOYEAR,               -- To Fiscal Year [fagl_toyear]
    WRITE_DOCNR_LD,       -- Seq. Doc. Number [fins_write_docnr_ld]
    ACC_PRINCIPLE,        -- AP Ledger/CoCode [acc_principle_ld_cmp]
    FUNCTIONAL_CURRENCY,  -- Functional Currency [finsc_functional_curtype]
    PRIMARY KEY (MANDT, RLDNR, BUKRS)
);

Learn More