SAP Table

T881 Ledger Master

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

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

/ Fields

T881 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyRLDNR Ledger CHAR 2 0 RLDNR
GCURR Currency key of the ledger currency CUKY 5 0 TCURC GCURR
CLASS Ledger class CHAR 1 0 LDCLS
TYP Type of ledger (client in which it is to be maintained) CHAR 1 0 LEDGER_TYP
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
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
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
XCASH_LEDGER Cash Ledger Indicator CHAR 1 0 FAGL_CASH_LEDGER
/ Relationships

T881 foreign keys.

Table Field Check Table Description Check Field
T881 GCURR TCURC Currency Codes MANDT
T881 GCURR TCURC Currency Codes WAERS
T881 KLDNR T881 Ledger Master MANDT
T881 LOGSYS TBDLS Logical system LOGSYS
T881 SPLITMETHD T8G01 Splitting method MANDT
T881 SPLITMETHD T8G01 Splitting method SPLITMETHD
Back to SAP tables