SAP table UCMV01S (SEM-BCS: Special Versions: Surrogate ID)

SAP table UCMV01S has 2 primary key fields being MANDT,SID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SID FIN Master Data: Surrogate ID INT4 10 0 * UG_SID
SVERSIONTYPE SEM-BCS: Field Type of Special Version CHAR 2 0 UC_SVERSIONTYPE
05 Balance Carryforward
07 Period Initialization
10 Data Collection
20 Copy Task
25 Reconciliation of Elimination Data
35 Manual Posting
40 Currency Translation
45 Capitalization and Valuation Allowances
50 Consolidation Group Changes
55 Interunit Elimination
60 Elimination of IU Profit/Loss in Transferred Inventory
65 Elimination of IU Profit/Loss in Transferred Assets
70 Consolidation of Investments
73 Posting of Group Shares
75 Reclassification
80 Allocation
85 Validation
90 Custom Task
A0 Attributes
D3 Inventory Data
D4 Supplier Data
D5 Investment Data
D6 Equity
DD Assets/Liabilities
DE Noncurrent Assets
H0 Hierarchy Structure
I0 Accounting Object
OC Organizational Change
T0 Tax Rates
V0 Validity
X0 Exchange rates
SVERSION Special Version CHAR 3 0 UCMV01C UC_SVERSION

UCMV01S foreign key relationships

Table Field Check Table Check Field
0 UCMV01S MANDT T000 Clients MANDT
1 UCMV01S SVERSION UCMV01C SEM-BCS: Special Versions MANDT
1 UCMV01S SVERSION UCMV01C SEM-BCS: Special Versions SVERSIONTYPE