T881

Transparent Table Customizing (protected)
43 Fields 19 CDS Views

Ledger Master

T881 is an SAP database table in S/4HANA. Ledger Master. It contains 43 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
FGL_GLT3_CUR view inner Currency Handling (Source ACDOCA)
FGL_MIG_3_CUR view inner GL Delta Entries - Currency Handling (Source GLT3)
Fisvd_Ldcmp_T881 view inner Currencies for company Code and ledger
FJV_T881_CONV view left_outer JVA - Currency conversion
I_CnsldtnLedger view from BASIC Consolidation Ledger
I_FundsMgmtLedger view from BASIC Funds Management Ledger
JV_JVSO1_COMB view inner Combined view of ledgers 4A/4C on JVSO1
JV_JVSO2_COMB view inner Combined view of ledgers 4B/4D on JVSO2
JV_JVTO1_ACDOCA_4A_4C_SWITCH view inner JVTO1-like view on ACDOCA w/ JV ledgers
JV_JVTO1_ACDOCA_CFW_PREP view inner JVTO1-like ACDOCA view for CFW amnts PR
JV_JVTO1_T8JTPM_COMB view inner Combined view for JVTO1 and T8JTPM
JV_JVTO1_T8JTPM_COMB_4A_4C view inner Combined view for JVTO1 and T8JTPM
JV_JVTO1_T8JTPM_JV view inner Combined view for JVTO1 and T8JTPM
JV_JVTO2_COMB view inner Combined view of ledgers 4B/4D on JVSO2
P_PlanData_RT_01 view left_outer COMPOSITE
P_RealTimeRptdFinData_01 view inner COMPOSITE
P_RepFinData_RT_Aggr_02 view inner COMPOSITE
P_ReportedFinancialData_RT_01 view inner COMPOSITE
P_RFD_RT_AGGR_simple_02 view inner COMPOSITE

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rldnr RLDNR Ledger
gcurr GCURR Ledger curr.
class LDCLS Ledger class
typ LEDGER_TYP Ledger type
trcur TRCUR Transaction currency
lccur LCCUR Second currency
rccur RCCUR Third Currency
occur OCCUR Fourth Currency
quant QUANT Store Quant.
atqnt ATQNT Store add.qty
tab GLTAB Totals Table
rcopy RCOPY Copying Allowed
shkz SHKZ Debit/Credit
glsip GLSIP Store line items
vortrag VORTR Bal.Carried Fwd
dldnr RLDNR1 Av.bal.ledger
xdldnr XDLDNR Average
curt1 CURT_HSL LC curr.type
curt2 CURT_KSL GC curr.type
curt3 CURT_OSL Currency Type
v2post V2POST Delay update
lctyp LC_TYP Type of cons.
fix G_LD_FIX Standard ledger
post G_POST Post to ledger
rollup G_ROLLUP Rollup allwd
depld G_ZUSATZLD Add. ledger
appl GLXAPPL Application
subappl GLXSUBAPPL Subapplication
komp GLXKOMP Component
gzledger GZLEDGER Productive
exit EXIT_NR_LD Exit no.
kldnr G_KLDNR Export ledger
logsys LOGSYS Logical system
valutyp G_VALUTYP Valuation
gcompress G_COMPRESS Summarize
splitmethd SPLITMETHD Method
date_det_poper GLX_DATE_FOR_POS Date of update
glflex FAGL_TYPE_GLFLEX GL Type
xleading FAGL_FLAG_LEADING Leading Ledger
orient_ledger FAGL_ORIENTATION_LEDGER Reference Ledger
avg_rollup FAGL_TYPE_AVG_ROLLUP Average Ledger
xcash_ledger FAGL_CASH_LEDGER Cash 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.

-- Ledger Master
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T881 (
    MANDT,           -- Client [MANDT]
    RLDNR,           -- Ledger [RLDNR]
    GCURR,           -- Ledger curr. [GCURR]
    CLASS,           -- Ledger class [LDCLS]
    TYP,             -- Ledger type [LEDGER_TYP]
    TRCUR,           -- Transaction currency [TRCUR]
    LCCUR,           -- Second currency [LCCUR]
    RCCUR,           -- Third Currency [RCCUR]
    OCCUR,           -- Fourth Currency [OCCUR]
    QUANT,           -- Store Quant. [QUANT]
    ATQNT,           -- Store add.qty [ATQNT]
    TAB,             -- Totals Table [GLTAB]
    RCOPY,           -- Copying Allowed [RCOPY]
    SHKZ,            -- Debit/Credit [SHKZ]
    GLSIP,           -- Store line items [GLSIP]
    VORTRAG,         -- Bal.Carried Fwd [VORTR]
    DLDNR,           -- Av.bal.ledger [RLDNR1]
    XDLDNR,          -- Average [XDLDNR]
    CURT1,           -- LC curr.type [CURT_HSL]
    CURT2,           -- GC curr.type [CURT_KSL]
    CURT3,           -- Currency Type [CURT_OSL]
    V2POST,          -- Delay update [V2POST]
    LCTYP,           -- Type of cons. [LC_TYP]
    FIX,             -- Standard ledger [G_LD_FIX]
    POST,            -- Post to ledger [G_POST]
    ROLLUP,          -- Rollup allwd [G_ROLLUP]
    DEPLD,           -- Add. ledger [G_ZUSATZLD]
    APPL,            -- Application [GLXAPPL]
    SUBAPPL,         -- Subapplication [GLXSUBAPPL]
    KOMP,            -- Component [GLXKOMP]
    GZLEDGER,        -- Productive [GZLEDGER]
    EXIT,            -- Exit no. [EXIT_NR_LD]
    KLDNR,           -- Export ledger [G_KLDNR]
    LOGSYS,          -- Logical system [LOGSYS]
    VALUTYP,         -- Valuation [G_VALUTYP]
    GCOMPRESS,       -- Summarize [G_COMPRESS]
    SPLITMETHD,      -- Method [SPLITMETHD]
    DATE_DET_POPER,  -- Date of update [GLX_DATE_FOR_POS]
    GLFLEX,          -- GL Type [FAGL_TYPE_GLFLEX]
    XLEADING,        -- Leading Ledger [FAGL_FLAG_LEADING]
    ORIENT_LEDGER,   -- Reference Ledger [FAGL_ORIENTATION_LEDGER]
    AVG_ROLLUP,      -- Average Ledger [FAGL_TYPE_AVG_ROLLUP]
    XCASH_LEDGER,    -- Cash Ledger [FAGL_CASH_LEDGER]
    PRIMARY KEY (MANDT, RLDNR)
);

Learn More