T881
Ledger-Stamm
T881 is an SAP database table in S/4HANA. Ledger-Stamm. It contains 42 fields. 19 CDS views read from this table.
CDS Views using this table (19)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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 (42)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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-Stamm
-- 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]
PRIMARY KEY (MANDT, RLDNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA