FINSC_FX_PL_GL

Transparent Table Customizing Table
7 Fields 1 CDS Views

Profit and Loss GL accounts for Foreign Currency postings

FINSC_FX_PL_GL is an SAP database table in S/4HANA. Profit and Loss GL accounts for Foreign Currency postings. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrgnCrcyValnPrftAndLossAccts view from BASIC Foreign currency valuation P&L GL Accts

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY acc_principle accounting_principle Accounting Principle
KEY chrt_accts ktopl Chart of Accts
fx_realized_gain fx_realized_gain FX Gain Realized
fx_realized_loss fx_realized_loss FX Loss Realized
fx_unrealized_gain fx_unrealized_gain FX Gain Unrealized
fx_unrealized_loss fx_unrealized_loss FX Loss Unrealized

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.

-- Profit and Loss GL accounts for Foreign Currency postings
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_FX_PL_GL (
    CLIENT,              -- Client [mandt]
    ACC_PRINCIPLE,       -- Accounting Principle [accounting_principle]
    CHRT_ACCTS,          -- Chart of Accts [ktopl]
    FX_REALIZED_GAIN,    -- FX Gain Realized [fx_realized_gain]
    FX_REALIZED_LOSS,    -- FX Loss Realized [fx_realized_loss]
    FX_UNREALIZED_GAIN,  -- FX Gain Unrealized [fx_unrealized_gain]
    FX_UNREALIZED_LOSS,  -- FX Loss Unrealized [fx_unrealized_loss]
    PRIMARY KEY (CLIENT, ACC_PRINCIPLE, CHRT_ACCTS)
);

Learn More