1. Home
  2. Resources
  3. SAP Tables
  4. UCM001S - Data Basis of Consolidation: Surrogate ID

SAP Table UCM001S

Data Basis of Consolidation: Surrogate ID

UCM001S (Data Basis of Consolidation: Surrogate ID) 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 UCM001S to other SAP tables.

UCM001S table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SID FIN Master Data: Surrogate ID UG_SID INT4 10 0
DATABASIS Data Basis of Consolidation UC_DATABASIS UCM001C CHAR 2 0

UCM001S foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
UCM001S DATABASIS UCM001S MANDT UCM001C Data Basis of Consolidation MANDT
UCM001S DATABASIS UCM001S DATABASIS UCM001C Data Basis of Consolidation DATABASIS
UCM001S MANDT UCM001S MANDT T000 Clients MANDT