FINS_CNV_LCC_JE

Transparent Table Application Table
14 Fields 6 CDS Views

Local Currency Conversion: Configuration Change for JE

FINS_CNV_LCC_JE is an SAP database table in S/4HANA. Local Currency Conversion: Configuration Change for JE. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
fins_cnv_check_rd_account view from Currency Conversion: Check account
fins_cnv_rec_bcbs_nri view_entity inner LCC: Select non-relevant clearings
fins_cnv_rec_bcbs_ri view_entity inner LCC: Select all relevant cleared items
fins_cnv_rec_clr_ri view inner LCC: Select all relevant cleared JE
fins_cnv_rec_octp view inner LCC: Get docs for reconciliation of OCTP
fins_cnv_rec_si_ri view inner LCC: Selection of LCC relevant items

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY context_guid CNV_MBT_COT_CONTEXT_GUID Context GUID
KEY rldnr FINS_LEDGER Ledger
KEY bukrs BUKRS Company Code
KEY curtp FINS_CURTYPE Curr./Val. Type
currency_from FINS_CNV_CURRENCY_FROM From currency
currency_to FINS_CNV_CURRENCY_TO To currency
currency_columns FINS_CNV_CURRENCY_COLUMN Column of Currency
curpos FINS_CUR_POS Curr Position
current_year FINS_CNV_CURRENT_YEAR Current Year
timestamp TIMESTAMP Time Stamp
productive FINS_CNV_PRODUCTIVE Productive
completed_at TIMESTAMP Time Stamp
completed_by UNAME User Name

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.

-- Local Currency Conversion: Configuration Change for JE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_CNV_LCC_JE (
    MANDT,             -- Client [MANDT]
    CONTEXT_GUID,      -- Context GUID [CNV_MBT_COT_CONTEXT_GUID]
    RLDNR,             -- Ledger [FINS_LEDGER]
    BUKRS,             -- Company Code [BUKRS]
    CURTP,             -- Curr./Val. Type [FINS_CURTYPE]
    CURRENCY_FROM,     -- From currency [FINS_CNV_CURRENCY_FROM]
    CURRENCY_TO,       -- To currency [FINS_CNV_CURRENCY_TO]
    CURRENCY_COLUMNS,  -- Column of Currency [FINS_CNV_CURRENCY_COLUMN]
    CURPOS,            -- Curr Position [FINS_CUR_POS]
    CURRENT_YEAR,      -- Current Year [FINS_CNV_CURRENT_YEAR]
    TIMESTAMP,         -- Time Stamp [TIMESTAMP]
    PRODUCTIVE,        -- Productive [FINS_CNV_PRODUCTIVE]
    COMPLETED_AT,      -- Time Stamp [TIMESTAMP]
    COMPLETED_BY,      -- User Name [UNAME]
    PRIMARY KEY (MANDT, CONTEXT_GUID, RLDNR, BUKRS, CURTP)
);

Learn More