SAP ABAP Table CRM_MDM_SITE (MDM site attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ WEC-APP-PCT (Application Component) Web Channel Product Catalog
     ⤷ CRM_DATAEXCHANGE_MDM_PRODUCT (Package) Product Data Exchange to MDM

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRM_MDM_SITE	Table Relationship Diagram
Short Description	MDM site attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SITE_ID	☑	SMO_SITEID	SMO_SITEID	CHAR	32	0	Site ID	*
3	SITETYPEID	☐	SMW1STID	SMW1STID	CHAR	32	0	Site Type ID	*
4	REPOSITORY_NAME	☐	MDM_GX_REPOSITORY_CODE	MDM_GX_RPY_CODE	CHAR	128	0	Name (Code) of MDM Repository
5	FTP_SERVER	☐	MDM_GX_RPY_FTP_SERVER	MDM_GX_RPY_FTP_SERVER	CHAR	255	0	Address of FTP Server
6	MDM_ROOT	☐	MDM_GX_RPY_MDM_ROOT	MDM_GX_RPY_MDM_ROOT	CHAR	128	0	MDM Root for Repository on FTP server
7	MDCLIENT_CODE	☐	MDM_GX_RPY_CLIENTCODE		CHAR	10	0	Client Code in MDM Repository
8	FTPUSER	☐	CRMT_MDM_RFCUSER	CRMT_MDM_RFCUSER	CHAR	12	0	Explicit user ID
9	PASSWORD	☐	CRMT_MDM_PWORD	CRMT_MDM_PWORD	CHAR	32	0	Password - not stored in DB
10	PWDACTIVE	☐	CRMT_MDM_PWD_ACTIVE	CRMT_MDM_PWD_ACTIVE	CHAR	1	0	FTP user password filled

History

Last changed by/on	SAP	20130604
SAP Release Created in	701