SAP Table T881

Ledger Master

T881 (Ledger Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T881 to other SAP tables.

T881 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RLDNR Ledger RLDNR CHAR 2 0
GCURR Currency key of the ledger currency GCURR TCURC CUKY 5 0
CLASS Ledger class LDCLS CHAR 1 0
A Direct posting ledger
B Consolidation ledger
C Rollup ledger
TYP Type of ledger (client in which it is to be maintained) LEDGER_TYP CHAR 1 0
0 Ledger can only be posted in original client
1 Ledger can only be posted in FI-SL client
2 Ledger can be posted in both clients
TRCUR Store transaction currency TRCUR CHAR 1 0
X Yes
NULL No
LCCUR Store second currency LCCUR CHAR 1 0
X Yes
NULL No
RCCUR Store third currency RCCUR CHAR 1 0
X Yes
NULL No
OCCUR Manage fourth currency OCCUR CHAR 1 0
X Yes
NULL No
QUANT Store quantities QUANT CHAR 1 0
X Yes
NULL No
ATQNT Store additional quantities ATQNT CHAR 1 0
X Yes
NULL No
TAB Totals Table GLTAB CHAR 30 0
RCOPY Maintenance by Copying Allowed RCOPY CHAR 1 0
X Yes
NULL No
SHKZ Maintain debits/credits indicator SHKZ CHAR 1 0
X Yes
NULL No
GLSIP Write line items GLSIP CHAR 1 0
X Yes
NULL No
VORTRAG Set up balance carry forward VORTR CHAR 1 0
X Yes
NULL No
DLDNR Average balance ledger RLDNR1 CHAR 2 0
XDLDNR Store average in the same ledger XDLDNR CHAR 1 0
X Yes
NULL No
CURT1 Currency type of the local currency (HSL) CURT_HSL CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURT2 Currency type of the group currency (KSL) CURT_KSL CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURT3 Currency type of currency 4 CURT_OSL CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
V2POST Delay the ledger update V2POST CHAR 1 0
LCTYP Type of consolidation LC_TYP CHAR 1 0
0 Legal consolidation
1 Business area consolidation
FIX Indicator: Standard ledger G_LD_FIX CHAR 1 0
X Yes
NULL No
POST Postings can be made to ledger G_POST CHAR 1 0
X Yes
NULL No
ROLLUP Rollup allowed to the ledger G_ROLLUP CHAR 1 0
X Yes
NULL No
DEPLD Is the ledger an additional ledger? G_ZUSATZLD CHAR 1 0
X Yes
NULL No
APPL Owner application GLXAPPL CHAR 2 0
SUBAPPL Subapplication GLXSUBAPPL CHAR 3 0
KOMP Component GLXKOMP CHAR 3 0
GZLEDGER Indicator: Ledger cannot be reset (delete) GZLEDGER CHAR 1 0
X Yes
NULL No
EXIT Exit no. (S..: standard exits, U..: user exits) EXIT_NR_LD CHAR 3 0
KLDNR Export ledger G_KLDNR T881 CHAR 2 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
VALUTYP Valuation G_VALUTYP NUMC 1 0
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
5 Parallel Cost of Goods Manufactured 1
6 Parallel Cost of Goods Manufactured 2
7 Parallel Cost of Goods Manufactured 3
GCOMPRESS Summarize data G_COMPRESS CHAR 1 0
X Yes
NULL No
SPLITMETHD Document Splitting Method SPLITMETHD T8G01 CHAR 10 0
DATE_DET_POPER Date with which the posting period is determined GLX_DATE_FOR_POS NUMC 1 0
0 Posting date
1 Value date
GLFLEX 1-Character Indicator: Type of Ledger FAGL_TYPE_GLFLEX CHAR 1 0
NULL Not a Ledger in G/L
1 Update Ledger
2 Rollup Ledger
XLEADING Indicator: Leading Ledger FAGL_FLAG_LEADING CHAR 1 0
X Yes
NULL No
ORIENT_LEDGER Reference Ledger for General Ledger Accounting FAGL_ORIENTATION_LEDGER V_FAGL_T881_DB CHAR 2 0
AVG_ROLLUP Indicator: Rollup Ledger for Daily Average Balances FAGL_TYPE_AVG_ROLLUP CHAR 1 0
X Rollup Ledger for Average Daily Balances
XCASH_LEDGER Cash Ledger Indicator FAGL_CASH_LEDGER CHAR 1 0
X TRUE
NULL FALSE

T881 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T881 GCURR T881 GCURR TCURC Currency Codes WAERS
T881 GCURR T881 MANDT TCURC Currency Codes MANDT
T881 KLDNR T881 KLDNR T881 Ledger Master RLDNR
T881 KLDNR T881 MANDT T881 Ledger Master MANDT
T881 LOGSYS T881 LOGSYS TBDLS Logical system LOGSYS
T881 MANDT T881 MANDT T000 Clients MANDT
T881 ORIENT_LEDGER T881 MANDT V_FAGL_T881_DB Generated Table for View MANDT
T881 ORIENT_LEDGER T881 ORIENT_LEDGER V_FAGL_T881_DB Generated Table for View RLDNR
T881 SPLITMETHD T881 MANDT T8G01 Splitting method MANDT
T881 SPLITMETHD T881 SPLITMETHD T8G01 Splitting method SPLITMETHD