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.
ECMCT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RCLNT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||||||||||
|
RLDNR
Ledger
|
RLDNR | T881 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||||||
|
RRCTY
Record Type
|
RRCTY |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
RPFLG
Apportionment
|
FC_RPFLG |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
RTFLG
Currency translation
|
FC_RTFLG |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
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 | RCLNT |
T821S
Distribution keys
|
MANDT |
| ECMCT | CSPRED | ECMCT | CSPRED |
T821S
Distribution keys
|
SPRED |
| 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 | RCLNT |
T821S
Distribution keys
|
MANDT |
| ECMCT | QSPRED | ECMCT | QSPRED |
T821S
Distribution keys
|
SPRED |
| ECMCT | RBUNIT | ECMCT | RCLNT |
TF160
Consolidation Units
|
MANDT |
| ECMCT | RBUNIT | ECMCT | RDIMEN |
TF160
Consolidation Units
|
DIMEN |
| 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 | RCLNT |
T880
Global Company Data (for KONS Ledger)
|
MANDT |
| ECMCT | RCOMP | ECMCT | RCOMP |
T880
Global Company Data (for KONS Ledger)
|
RCOMP |
| ECMCT | RCONGR | ECMCT | RCONGR |
TF180
Consolidation Groups
|
CONGR |
| ECMCT | RCONGR | ECMCT | RCLNT |
TF180
Consolidation Groups
|
MANDT |
| 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 | RCLNT |
TF120
Consolidation Charts of Accounts
|
MANDT |
| ECMCT | RITCLG | ECMCT | RITCLG |
TF120
Consolidation Charts of Accounts
|
ITCLG |
| ECMCT | RITEM | ECMCT | RITEM |
TF100
Financial Statement Items
|
ITEM |
| ECMCT | RITEM | ECMCT | RCLNT |
TF100
Financial Statement Items
|
MANDT |
| ECMCT | RITEM | ECMCT | RITCLG |
TF100
Financial Statement Items
|
ITCLG |
| ECMCT | RLDNR | ECMCT | RCLNT |
T881
Ledger Master
|
MANDT |
| ECMCT | RLDNR | ECMCT | RLDNR |
T881
Ledger Master
|
RLDNR |
| ECMCT | ROBUKRS | ECMCT | RCLNT |
T001
Company Codes
|
MANDT |
| ECMCT | ROBUKRS | ECMCT | ROBUKRS |
T001
Company Codes
|
BUKRS |
| ECMCT | RTCUR | ECMCT | RCLNT |
TCURC
Currency Codes
|
MANDT |
| ECMCT | RTCUR | ECMCT | RTCUR |
TCURC
Currency Codes
|
WAERS |
| ECMCT | RUNIT | ECMCT | RCLNT |
T006
Units of Measurement
|
MANDT |
| ECMCT | RUNIT | ECMCT | RUNIT |
T006
Units of Measurement
|
MSEHI |
| ECMCT | RVERS | ECMCT | RLDNR |
T894
FI-SL and FI-LC Versions
|
RLDNR |
| ECMCT | RVERS | ECMCT | RVERS |
T894
FI-SL and FI-LC Versions
|
RVERS |
| 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 | RCLNT |
TF115
Subitems
|
MANDT |
| ECMCT | SUBIT | ECMCT | SITYP |
TF115
Subitems
|
SITYP |
| ECMCT | ZZCRGRP | ECMCT | ZZCRGRP |
T151
Customers: Customer Groups
|
KDGRP |
| ECMCT | ZZCRGRP | SYST | MANDT |
T151
Customers: Customer Groups
|
MANDT |
| 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 |