SAP ABAP Table CRMS_MKTHV_MC_ORG (CRM Marketing: Marketing Prospect Organization Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTHV_MC (Package) CRM Marketing: Marketing Contact - High Volume

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTHV_MC_ORG	Table Relationship Diagram
Short Description	CRM Marketing: Marketing Prospect Organization Data

Delivery and Maintenance

Pool/cluster
Delivery Class
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	COMPANY_ID	☐	CRMT_MKTHV_MC_COMP_ID	BU_PARTNER	CHAR	10	0	Company ID	*
2	COMPANY_TITLE	☐	CRMT_MKTHV_MC_COMP_TITLE	AD_TITLE	CHAR	4	0	Company Title	TSAD3
3	COMPANY_NAME	☐	CRMT_MKTHV_MC_COMP_NAME	BU_NAME	CHAR	40	0	Company Name
4	COMP_LEGAL_FORM	☐	CRMT_MKTHV_MC_COMP_LEGENTY	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
5	COMP_TELNR_LONG	☐	CRMT_MKTHV_MC_COMP_TELNR	CHAR30	CHAR	30	0	Company First Telephone No.: Dialling code+Number
6	COMP_FAXNR_LONG	☐	CRMT_MKTHV_MC_COMP_FXNRLNG	CHAR30	CHAR	30	0	Company Fax Number: Dialling Code+Number+Extension
7	COMPANY_URL	☐	CRMT_MKTHV_MC_COMP_URISCR	AD_URISCR	CHAR	132	0	Company URI, e.g. Homepage or ftp Address
8	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	T005
9	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	T005S
10	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
11	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
12	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
13	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
14	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
15	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address
16	PROSP_FUN_NAME	☐	CRMT_MKTHV_MC_COMP_FNCTN	TEXT40	CHAR	40	0	Function Name of Partner
17	PROSPECT_FUN_KEY	☐	CRMT_MKTHV_MC_COMP_PAFKT	BU_PAFKT	CHAR	4	0	Function of Partner	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTHV_MC_ORG	COMPANY_COUNTRY	T005	LAND1	REF	1	CN
2	CRMS_MKTHV_MC_ORG	COMPANY_REGION	T005S	BLAND	REF	C	CN
3	CRMS_MKTHV_MC_ORG	COMPANY_TITLE	TSAD3	TITLE	REF	1	CN
4	CRMS_MKTHV_MC_ORG	COMP_LEGAL_FORM	TB019	LEGAL_ENTY	KEY	1	CN

History

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