SAP Table ECMCT

SAP Cons.: Totals Table

ECMCT (SAP Cons.: Totals Table) 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 ECMCT to other SAP tables.

Source: ECMCT (SAP Cons.: Totals Table)

ECMCT table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS T894 CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
ROBJNR Object number for objects (account assignment elements) GOBJNR_R CHAR 18 0
COBJNR Object number for transaction attributes GOBJNR_C CHAR 18 0
SOBJNR Object number for partner objects (accnt assignmnt elements) GOBJNR_S CHAR 18 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
RPMAX Period RPMAX NUMC 3 0
RCOMP Company RCOMP_D T880 CHAR 6 0
RDIMEN Dimension FC_DIMEN TF150 CHAR 2 0
RBUNIT Consolidation unit FC_BUNIT TF160 CHAR 18 0
RITCLG Consolidation chart of accounts FC_ITCLG TF120 CHAR 2 0
RITEM Financial statement item FC_ITEM TF100 CHAR 10 0
RBUPTR Partner unit FC_BUPTR TF160 CHAR 18 0
RCONGR Consolidation group FC_CONGR TF180 CHAR 18 0
ROBUKRS Original company code OBUKR T001 CHAR 4 0
SITYP Subitem category FC_SITYP TF110 CHAR 3 0
SUBIT Subitem FC_SITEM TF115 CHAR 10 0
PLEVL Posting level FC_PLEVL CHAR 2 0
NULL Realtime update
00 Reported data: Entry
01 Adjustments to reported data
02 Reported data: Cons group change
08 Item substitution
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 FC_RPFLG NUMC 1 0
0 Original record
1 Record for apportionment
RTFLG Currency translation FC_RTFLG NUMC 1 0
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
DOCTY Document type FC_DOCTY TF500 CHAR 2 0
YRACQ Year of acquisition FC_RYACQ NUMC 4 0
PRACQ Period of Acquisition RPACQ NUMC 3 0
COICU Investee unit FC_COICU TF160 CHAR 18 0
UPDHP Highest update period UPDHP NUMC 3 0
TSLVT Balance carried forward in transaction currency TSLVT9 CURR 17 2
TSL01 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL02 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL03 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL04 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL05 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL06 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL07 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL08 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL09 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL10 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL11 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL12 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL13 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL14 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL15 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL16 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
HSLVT Balance carried forward in local currency HSLVT9 CURR 17 2
HSL01 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL02 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL03 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL04 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL05 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL06 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL07 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL08 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL09 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL10 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL11 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL12 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL13 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL14 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL15 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL16 Total of transactions of the period in local currency HSLXX9 CURR 17 2
KSLVT Balance carried forward in group currency KSLVT9 CURR 17 2
KSL01 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL02 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL03 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL04 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL05 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL06 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL07 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL08 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL09 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL10 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL11 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL12 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL13 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL14 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL15 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL16 Total of transactions of the period in group currency KSLXX9 CURR 17 2
MSLVT Balance carried forward of quantity MSLVT9 QUAN 17 3
MSL01 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL02 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL03 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL04 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL05 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL06 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL07 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL08 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL09 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL10 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL11 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL12 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL13 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL14 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL15 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
MSL16 Total of the transactions of period in units of measure MSLXX9 QUAN 17 3
CSPRED Distribution key for currency amounts CSPRED T821S CHAR 4 0
QSPRED Distribution key for quantities QSPRED T821S CHAR 4 0

ECMCT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ECMCT COICU ECMCT RCLNT TF160 Consolidation Units MANDT
ECMCT COICU ECMCT RDIMEN TF160 Consolidation Units DIMEN
ECMCT COICU ECMCT COICU TF160 Consolidation Units BUNIT
ECMCT CSPRED ECMCT CSPRED T821S Distribution keys SPRED
ECMCT CSPRED ECMCT RCLNT T821S Distribution keys MANDT
ECMCT DOCTY ECMCT RCLNT TF500 Document Types MANDT
ECMCT DOCTY ECMCT RDIMEN TF500 Document Types DIMEN
ECMCT DOCTY ECMCT DOCTY TF500 Document Types DOCTY
ECMCT QSPRED ECMCT QSPRED T821S Distribution keys SPRED
ECMCT QSPRED ECMCT RCLNT T821S Distribution keys MANDT
ECMCT RBUNIT ECMCT RDIMEN TF160 Consolidation Units DIMEN
ECMCT RBUNIT ECMCT RCLNT TF160 Consolidation Units MANDT
ECMCT RBUNIT ECMCT RBUNIT TF160 Consolidation Units BUNIT
ECMCT RBUPTR ECMCT RCLNT TF160 Consolidation Units MANDT
ECMCT RBUPTR ECMCT RDIMEN TF160 Consolidation Units DIMEN
ECMCT RBUPTR ECMCT RBUPTR TF160 Consolidation Units BUNIT
ECMCT RCLNT ECMCT RCLNT T000 Clients MANDT
ECMCT RCOMP ECMCT RCOMP T880 Global Company Data (for KONS Ledger) RCOMP
ECMCT RCOMP ECMCT RCLNT T880 Global Company Data (for KONS Ledger) MANDT
ECMCT RCONGR ECMCT RCLNT TF180 Consolidation Groups MANDT
ECMCT RCONGR ECMCT RCONGR TF180 Consolidation Groups CONGR
ECMCT RCONGR ECMCT RDIMEN TF180 Consolidation Groups DIMEN
ECMCT RDIMEN ECMCT RCLNT TF150 Dimensions MANDT
ECMCT RDIMEN ECMCT RDIMEN TF150 Dimensions DIMEN
ECMCT RITCLG ECMCT RITCLG TF120 Consolidation Charts of Accounts ITCLG
ECMCT RITCLG ECMCT RCLNT TF120 Consolidation Charts of Accounts MANDT
ECMCT RITEM ECMCT RITEM TF100 Financial Statement Items ITEM
ECMCT RITEM ECMCT RITCLG TF100 Financial Statement Items ITCLG
ECMCT RITEM ECMCT RCLNT TF100 Financial Statement Items MANDT
ECMCT RLDNR ECMCT RLDNR T881 Ledger Master RLDNR
ECMCT RLDNR ECMCT RCLNT T881 Ledger Master MANDT
ECMCT ROBUKRS ECMCT ROBUKRS T001 Company Codes BUKRS
ECMCT ROBUKRS ECMCT RCLNT T001 Company Codes MANDT
ECMCT RTCUR ECMCT RTCUR TCURC Currency Codes WAERS
ECMCT RTCUR ECMCT RCLNT TCURC Currency Codes MANDT
ECMCT RUNIT ECMCT RCLNT T006 Units of Measurement MANDT
ECMCT RUNIT ECMCT RUNIT T006 Units of Measurement MSEHI
ECMCT RVERS ECMCT RVERS T894 FI-SL and FI-LC Versions RVERS
ECMCT RVERS ECMCT RLDNR T894 FI-SL and FI-LC Versions RLDNR
ECMCT RVERS ECMCT RCLNT T894 FI-SL and FI-LC Versions MANDT
ECMCT SITYP ECMCT RCLNT TF110 Subitem Categories MANDT
ECMCT SITYP ECMCT SITYP TF110 Subitem Categories SITYP
ECMCT SUBIT ECMCT SUBIT TF115 Subitems SITEM
ECMCT SUBIT ECMCT SITYP TF115 Subitems SITYP
ECMCT SUBIT ECMCT RCLNT TF115 Subitems MANDT
ECMCT ZZCRGRP SYST MANDT T151 Customers: Customer Groups MANDT
ECMCT ZZCRGRP ECMCT ZZCRGRP T151 Customers: Customer Groups KDGRP
ECMCT ZZPRGRP ECMCT ZZPRGRP TF580 Product Groups PRGRP
ECMCT ZZPRGRP SYST MANDT TF580 Product Groups MANDT
ECMCT ZZVTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
ECMCT ZZVTWEG ECMCT ZZVTWEG TVTW Organizational Unit: Distribution Channels VTWEG