SAP table T881 (Ledger Master)

SAP table T881 has 2 primary key fields being MANDT,RLDNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RLDNR Ledger CHAR 2 0 RLDNR
GCURR Currency key of the ledger currency CUKY 5 0 TCURC GCURR
CLASS Ledger class CHAR 1 0 LDCLS
A Direct posting ledger
B Consolidation ledger
C Rollup ledger
TYP Type of ledger (client in which it is to be maintained) CHAR 1 0 LEDGER_TYP
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 CHAR 1 0 TRCUR
LCCUR Store second currency CHAR 1 0 LCCUR
RCCUR Store third currency CHAR 1 0 RCCUR
OCCUR Manage Fourth Currency CHAR 1 0 OCCUR
QUANT Store Quantities CHAR 1 0 QUANT
ATQNT Store additional quantities CHAR 1 0 ATQNT
TAB Totals Table CHAR 30 0 GLTAB
RCOPY Maintenance by Copying Allowed CHAR 1 0 RCOPY
SHKZ Maintain debits/credits indicator CHAR 1 0 SHKZ
GLSIP Write line items CHAR 1 0 GLSIP
VORTRAG Set Up Balance Carryforward CHAR 1 0 VORTR
DLDNR Average balance ledger CHAR 2 0 RLDNR1
XDLDNR Store average in the same ledger CHAR 1 0 XDLDNR
CURT1 Currency type of the local currency (HSL) CHAR 2 0 CURT_HSL
CURT2 Currency type of the group currency (KSL) CHAR 2 0 CURT_KSL
CURT3 Currency Type of Currency 4 CHAR 2 0 CURT_OSL
V2POST Delay the ledger update CHAR 1 0 V2POST
LCTYP Type of consolidation CHAR 1 0 LC_TYP
0 Legal consolidation
1 Business area consolidation
FIX Indicator: Standard ledger CHAR 1 0 G_LD_FIX
POST Postings can be made to ledger CHAR 1 0 G_POST
ROLLUP Rollup allowed to the ledger CHAR 1 0 G_ROLLUP
DEPLD Is the ledger an additional ledger? CHAR 1 0 G_ZUSATZLD
APPL Owner application CHAR 2 0 GLXAPPL
SUBAPPL Subapplication CHAR 3 0 GLXSUBAPPL
KOMP Component CHAR 3 0 GLXKOMP
GZLEDGER Indicator: Ledger cannot be reset (delete) CHAR 1 0 GZLEDGER
EXIT Exit no. (S..: standard exits, U..: user exits) CHAR 3 0 EXIT_NR_LD
KLDNR Export ledger CHAR 2 0 T881 G_KLDNR
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
VALUTYP Valuation NUMC 1 0 G_VALUTYP
GCOMPRESS Summarize data CHAR 1 0 G_COMPRESS
SPLITMETHD Document Splitting Method CHAR 10 0 T8G01 SPLITMETHD
DATE_DET_POPER Date with which the posting period is determined NUMC 1 0 GLX_DATE_FOR_POS
GLFLEX 1-Character Indicator: Type of Ledger CHAR 1 0 FAGL_TYPE_GLFLEX
Not a Ledger in G/L
1 Update Ledger
2 Rollup Ledger
XLEADING Indicator: Leading Ledger CHAR 1 0 FAGL_FLAG_LEADING
ORIENT_LEDGER Reference Ledger for General Ledger Accounting CHAR 2 0 FINSC_LEDGER FAGL_ORIENTATION_LEDGER
AVG_ROLLUP Indicator: Rollup Ledger for Daily Average Balances CHAR 1 0 FAGL_TYPE_AVG_ROLLUP
X Rollup Ledger for Average Daily Balances
XCASH_LEDGER Cash Ledger Indicator CHAR 1 0 FAGL_CASH_LEDGER

T881 foreign key relationships

Table Field Check Table Check Field
0 T881 GCURR TCURC Currency Codes MANDT
0 T881 GCURR TCURC Currency Codes WAERS
1 T881 KLDNR T881 Ledger Master MANDT
0 T881 LOGSYS TBDLS Logical system LOGSYS
1 T881 SPLITMETHD T8G01 Splitting method MANDT
1 T881 SPLITMETHD T8G01 Splitting method SPLITMETHD