SAP table ECMCT (SAP Cons.: Totals Table)

SAP table ECMCT has 12 primary key fields being RCLNT,RLDNR,RRCTY,RVERS,RYEAR,ROBJNR,COBJNR,SOBJNR,RTCUR,RUNIT,DRCRK,RPMAX.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
RLDNR Ledger CHAR 2 0 T881 RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 T894 RVERS
RYEAR Fiscal Year NUMC 4 0 GJAHR
ROBJNR Object number for objects (account assignment elements) CHAR 18 0 GOBJNR_R
COBJNR Object number for transaction attributes CHAR 18 0 GOBJNR_C
SOBJNR Object number for partner objects (accnt assignmnt elements) CHAR 18 0 GOBJNR_S
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
RUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
RPMAX Period NUMC 3 0 RPMAX
RCOMP Company CHAR 6 0 T880 RCOMP_D
RDIMEN Dimension CHAR 2 0 TF150 FC_DIMEN
RBUNIT Consolidation Unit CHAR 18 0 TF160 FC_BUNIT
RITCLG Consolidation Chart of Accounts CHAR 2 0 TF120 FC_ITCLG
RITEM Financial Statement Item CHAR 10 0 TF100 FC_ITEM
RBUPTR Partner Unit CHAR 18 0 TF160 FC_BUPTR
RCONGR Consolidation Group CHAR 18 0 TF180 FC_CONGR
ROBUKRS Original company code CHAR 4 0 T001 OBUKR
SITYP Subitem Category CHAR 3 0 TF110 FC_SITYP
SUBIT Subitem CHAR 10 0 TF115 FC_SITEM
PLEVL Posting Level CHAR 2 0 FC_PLEVL
Realtime update
00 Reported data: Entry
01 Adjustments to reported data
02 Reported data: Cons group change
08 Item substitution
0C Adjustment Entry for Universal Document
0T Reported Data: Currency Translation
10 Standardizing entry
12 Standardized data: Cons group change
20 Two-sided elimination entry
21 Reconciliation entry for elimination
22 Two-sided elimination: Cons group change
23 Two-sided elimination: Special logic
24 Two-sided elimination: Cons group change with special logic
30 Consolidation entry
R0 Rolled-up reported data
R1 Rolled-up standardizing entries
R2 Rolled-up elimination entries
R3 Rolled-up consolidation entries
RPFLG Apportionment NUMC 1 0 FC_RPFLG
0 Original record
1 Record for apportionment
RTFLG Currency Translation NUMC 1 0 FC_RTFLG
0 Group value at reference rate
1 Difference between GC value and GC value at reference rate
2 Group value at reference rate - translation difference
3 Diff. GC value/GC ref.rate value - translation difference
4 Group Currency Value at Reference Rate (Line Item)
DOCTY Document Type CHAR 2 0 TF500 FC_DOCTY
YRACQ Year of Acquisition NUMC 4 0 FC_RYACQ
PRACQ Period of Acquisition NUMC 3 0 RPACQ
COICU Investee Unit CHAR 18 0 TF160 FC_COICU
UPDHP Highest update period NUMC 3 0 UPDHP
TSLVT Balance carried forward in transaction currency CURR 23 2 TSLVT9
TSL01 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL02 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL03 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL04 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL05 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL06 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL07 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL08 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL09 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL10 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL11 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL12 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL13 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL14 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL15 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
TSL16 Total of transactions of the period in transaction currency CURR 23 2 TSLXX9
HSLVT Balance carried forward in local currency CURR 23 2 HSLVT9
HSL01 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL02 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL03 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL04 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL05 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL06 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL07 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL08 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL09 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL10 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL11 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL12 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL13 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL14 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL15 Total of transactions of the period in local currency CURR 23 2 HSLXX9
HSL16 Total of transactions of the period in local currency CURR 23 2 HSLXX9
KSLVT Balance carried forward in group currency CURR 23 2 KSLVT9
KSL01 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL02 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL03 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL04 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL05 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL06 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL07 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL08 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL09 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL10 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL11 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL12 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL13 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL14 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL15 Total of transactions of the period in group currency CURR 23 2 KSLXX9
KSL16 Total of transactions of the period in group currency CURR 23 2 KSLXX9
MSLVT Balance carried forward of quantity QUAN 17 3 MSLVT9
MSL01 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL02 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL03 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL04 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL05 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL06 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL07 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL08 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL09 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL10 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL11 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL12 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL13 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL14 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL15 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
MSL16 Total of the transactions of period in units of measure QUAN 17 3 MSLXX9
CSPRED Distribution key for currency amounts CHAR 4 0 T821S CSPRED
QSPRED Distribution key for quantities CHAR 4 0 T821S QSPRED

ECMCT foreign key relationships

Table Field Check Table Check Field
0 ECMCT COICU TF160 Consolidation Units MANDT
0 ECMCT COICU TF160 Consolidation Units DIMEN
0 ECMCT COICU TF160 Consolidation Units BUNIT
1 ECMCT CSPRED T821S Distribution keys MANDT
1 ECMCT CSPRED T821S Distribution keys SPRED
0 ECMCT DOCTY TF500 Document Types MANDT
0 ECMCT DOCTY TF500 Document Types DIMEN
0 ECMCT DOCTY TF500 Document Types DOCTY
1 ECMCT QSPRED T821S Distribution keys MANDT
1 ECMCT QSPRED T821S Distribution keys SPRED
0 ECMCT RBUNIT TF160 Consolidation Units MANDT
0 ECMCT RBUNIT TF160 Consolidation Units DIMEN
0 ECMCT RBUNIT TF160 Consolidation Units BUNIT
1 ECMCT RBUPTR TF160 Consolidation Units MANDT
1 ECMCT RBUPTR TF160 Consolidation Units DIMEN
1 ECMCT RBUPTR TF160 Consolidation Units BUNIT
0 ECMCT RCLNT T000 Clients MANDT
1 ECMCT RCOMP T880 Global Company Data (for KONS Ledger) MANDT
1 ECMCT RCOMP T880 Global Company Data (for KONS Ledger) RCOMP
0 ECMCT RCONGR TF180 Consolidation Groups MANDT
0 ECMCT RCONGR TF180 Consolidation Groups DIMEN
1 ECMCT RDIMEN TF150 Dimensions DIMEN
0 ECMCT RITCLG TF120 Consolidation Charts of Accounts MANDT
0 ECMCT RITCLG TF120 Consolidation Charts of Accounts ITCLG
1 ECMCT RITEM TF100 Financial Statement Items MANDT
1 ECMCT RITEM TF100 Financial Statement Items ITCLG
0 ECMCT RLDNR T881 Ledger Master MANDT
1 ECMCT ROBUKRS T001 Company Codes BUKRS
0 ECMCT RTCUR TCURC Currency Codes MANDT
0 ECMCT RTCUR TCURC Currency Codes WAERS
1 ECMCT RUNIT T006 Units of Measurement MSEHI
0 ECMCT RVERS T894 FI-SL and FI-LC Versions MANDT
0 ECMCT RVERS T894 FI-SL and FI-LC Versions RLDNR
0 ECMCT RVERS T894 FI-SL and FI-LC Versions RVERS
1 ECMCT SITYP TF110 Subitem Categories MANDT
1 ECMCT SITYP TF110 Subitem Categories SITYP
0 ECMCT SUBIT TF115 Subitems MANDT
0 ECMCT SUBIT TF115 Subitems SITYP
0 ECMCT SUBIT TF115 Subitems SITEM