FINSC_LD_CMP

Transparent Table Customizing Table
39 Fields 115 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. 115 CDS views read from this table.

CDS Views using this table (115)

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
FARR_LCC_JournalEntryItem view_entity inner Revenue Accounting-ACDOCA View for LCC
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_LD_CMP view from All valid item of table finsc_ld_cmp
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_lib_n_gl view_entity inner FGLV_LIB_N_GL: GL Line Item Browser
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)
finoc_package_bal_pc view_entity inner Organizational Change: Packaging BAL_PC
Fins_acdoca_lines_base view inner Base view for number of document items
fins_cnv_rec_clr_aa view_entity inner LCC: Select cleared journal entries
fins_cnv_rec_clr_bc_aa view_entity inner LCC: Select of cleared JE before LCC
fins_cnv_rec_clr_bc_naa view_entity inner LCC: Select of cleared JE before LCC
fins_cnv_rec_clr_naa view_entity inner LCC: Select cleared journal entries
fins_cnv_rec_si_1 view inner LCC: Selection of split line items
fins_cnv_rec_uj_1 view inner LCC: Selection of UJ line items
FINS_GL_DOCUMENT_ALL_AMOUNTS view inner
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 inner Deviating assignment company/ledger/accounting principle
Fins_Rev_Rec_Acdoca_Balance view inner Acdoca balance for introducing a new accounting principle
Fins_Rev_Rec_Cons_Check_View view inner Consistency check of ACDOCA items
FINS_REV_REC_COS_ACT_DIST_REF view 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 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 inner Actuals for data with CO objects
FINS_REV_REC_DATA_VIEW1_BASE view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW1A_BASE view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2_BASE view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2C view inner Contract data of trans. based rev.recog. cumulative process.
FINS_REV_REC_DATA_VIEW3_BASE view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWA_BASE view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWD view inner Data of trans. based revenue recog. for cumulative process.
FINS_REV_REC_OTHER_VIEW_BASE view inner Other data for cumulative process.
FINS_REV_REC_OTHER_VIEW1A_BASE view inner Other data for cumulative process.
FINS_REV_REC_TOTAL_REVENUE view inner Total revenue
Fins_Rev_Rec_uprctr_View view 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_01 view inner GL Line Item (Leading ledger + other)
fiscds_gllit_04 view inner GL Line Item (all Ledger)
fiscds_gllit_05 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 from BASIC Additional Currency Roles for Company Code
I_AdditionalCurrencyRoles view union_all BASIC Additional Currency Roles for Company Code
I_CorrespncAddlCurrencyRole view from BASIC Additional Currency Role for Correspondence
I_FiscalCalYearPeriodForLedger view inner BASIC Fiscal Year Period for Ledger
I_FiscalYearForLedger view inner BASIC Fiscal Year for Ledger
I_FiscalYearPeriodForLedger view 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_ACMTrdgContrFinDoc view inner BASIC
P_Buk4rldnr view inner BASIC Company Codes for Ledger
P_CoCodeLedgerValnCrcyRole view from 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_LDCMP view from BASIC
P_Materialledger_Relvt_Curtp view from BASIC
P_ValuationHistoryLogBalances view inner BASIC
P_ValuationHistoryLogDocuments view inner BASIC
P_ValuationViewByDeprArea view inner BASIC
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