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
MANDT Client	MANDT	T000	CLNT	3
SID FIN Master Data: Surrogate ID	UG_SID		INT4	10
DATABASIS Data Basis of Consolidation	UC_DATABASIS	UCM001C	CHAR	2

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