MDSUB - Master Data Substitutions

Master Data Substitutions information is stored in SAP table MDSUB.
It is part of development package VDM_MD_SUBSTN in software component CA-EPT-SUB. This development package consists of objects that can be grouped under "Virtual Data Model for MD Substitution - Substitution".

Fields for table MDSUB

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
UUID	Substitution UUID	X	MD_SUBSTN_UUID	RAW	16
OBJECT_TYPE	SAP Object Type		SBO_BO_TYPE	CHAR	60	SBO_I_BOTYPE
.INCLUDE	IDENTIFIER			MDSUBSTN_S_IDENTIFIER	0
OBJECT	Source Object in the Substitution		MD_OBJECT	CHAR	80
SUBSTITUTE	Target Object in the Substitution		MD_SUBSTITUTE	CHAR	80
.INCLUDE	ATTRIBUTES			MDSUBSTN_S_ATTRIBUTES	0
CONTEXT_TYPE1	SAP Object Type		SBO_BO_TYPE	CHAR	60	SBO_I_BOTYPE
CONTEXT1	Context Object		MD_SUBSTN_CONTEXT_OBJECT	CHAR	80
CONTEXT_TYPE2	SAP Object Type		SBO_BO_TYPE	CHAR	60	SBO_I_BOTYPE
CONTEXT2	Context Object		MD_SUBSTN_CONTEXT_OBJECT	CHAR	80
GROUP_NAME	Group Name		MD_SUBSTN_GROUP_NAME	CHAR	40	*
VERSION	Substitution Version		MD_SUBSTN_VERSION	INT4	4
SET_ID	Substitute: Set of Objects		MD_SUBSTN_SET_ID	CHAR	40
IS_EXIT	Stops Further Substitution in the Chain		MD_SUBSTN_IS_EXIT	CHAR	2
IS_LEAD	Substitution Lead Indicator		MD_SUBSTN_IS_LEAD	CHAR	2
SEQUENCE	Order of Substitutions in the Chain		MD_SUBSTN_SEQUENCE	INT2	2
NUMERATOR	Quantity Conversion: Numerator		MD_SUBSTN_NUMERATOR	INT2	2
DENOMINATOR	Quantity Conversion: Denominator		MD_SUBSTN_DENOMINATOR	INT2	2
PERCENT	Percentage Value		MD_SUBSTN_PERCENT	DEC	3
VALID_FROM	Valid From		MD_SUBSTN_VALID_FROM	DEC	8
VALID_TO	Valid To		MD_SUBSTN_VALID_TO	DEC	8
TIME_ZONE	Time Zone		MD_SUBSTN_TIME_ZONE	CHAR	12	*
REASON	Reason		MD_SUBSTN_REASON	CHAR	40	*
STATUS	Substitution Status		MD_SUBSTN_STATUS	CHAR	2
.INCLUDE	APPLICATION			MDSUBSTN_S_APPLICATION	0
IS_ATP_PROD	aATP Relevant		MD_SUBSTN_IS_ATP_PRODUCT	CHAR	2
IS_ATP_PLANT	aATP Plant		MD_SUBSTN_IS_ATP_PLANT	CHAR	2
IS_ESPP	eSPP Relevant		MD_SUBSTN_IS_ESPP	CHAR	2
IS_ATP_SLOC	aATP Storage Location		MD_SUBSTN_IS_ATP_SLOC	CHAR	2
IS_ATP_MRP_AREA	aATP MRP Area		MD_SUBSTN_IS_ATP_MRP_AREA	CHAR	2
.INCLUDE	ADMIN			MDSUBSTN_S_ADMIN	0
CREATED_BY	Created By User		VDM_CREATEDBYUSERID	CHAR	24	*
CREATED_AT	Substitution Creation Date		MD_SUBSTN_CREATED_AT	DEC	11
LAST_CHANGED_BY	Last Changed By User		VDM_LASTCHANGEDBYUSERID	CHAR	24	*
LAST_CHANGED_AT	Substitution Last Changed Date		MD_SUBSTN_CHANGED_AT	DEC	11