SAP ABAP Table CRMT_BUS_FRG0040 (CRM BP Fragment Structure of the Sales Classification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_FRG0040 (Package) CRM BP Sales Classification

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUS_FRG0040	Table Relationship Diagram
Short Description	CRM BP Fragment Structure of the Sales Classification

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	IS_COMPETITOR	☐	CRMT_BU_IS_COMPETITOR	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is competitor
2	IS_PROSPECT	☐	CRMT_BU_IS_PROSPECT	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is a prospect
3	IS_CONSUMER	☐	CRMT_BU_IS_CONSUMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is consumer
4	IS_CUSTOMER	☐	CRMT_BU_IS_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is customer
5	CUSTOMER_SINCE	☐	CRMT_CUSTOMER_SINCE	DATUM	DATS	8	0	Customer Since Date
6	IS_COD_CUSTOMER	☐	CRMT_BU_IS_COD_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is cash on delivery customer
7	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	CRMC_INDUSTRY
8	IS_RENTED	☐	CRMT_BU_IS_RENTED	CRM_BOOLEAN	CHAR	1	0	Indicator: Rented Address
9	ACCOUNT_GROUP	☐	CRMT_BU_ACCOUNT_GROUP	CRM_BU_ACCOUNT_GROUP	CHAR	4	0	R/3 Account Group	CRMC_T077D
10	NIELSEN_ID	☐	CRMT_BU_NIELSEN_ID	CRM_BU_NIELSEN_ID	CHAR	2	0	Nielsen ID	CRMC_NIELSEN
11	CLASSIFIC	☐	CRMT_BU_CUST_CLASSIFIC	CRM_BU_CUST_CLASSIFIC	CHAR	2	0	Customer Classification	CRMC_CLASSIF
12	ATTRIBUTE	☐	CRMT_BU_KATR1	CRM_BU_KATR1	CHAR	2	0	Attribute 1	CRMC_ATTR01
13	ATTRIB_2	☐	CRMT_BU_KATR2	CRM_BU_KATR2	CHAR	2	0	Attribute 2	CRMC_ATTR02
14	ATTRIB_3	☐	CRMT_BU_KATR3	CRM_BU_KATR3	CHAR	2	0	Attribute 3	CRMC_ATTR03
15	ATTRIB_4	☐	CRMT_BU_KATR4	CRM_BU_KATR4	CHAR	2	0	Attribute 4	CRMC_ATTR04
16	ATTRIB_5	☐	CRMT_BU_KATR5	CRM_BU_KATR5	CHAR	2	0	Attribute 5	CRMC_ATTR05
17	ATTRIB_6	☐	CRMT_BU_KATR6	CRM_BU_KATR6	CHAR	3	0	Attribute 6	CRMC_ATTR06
18	ATTRIB_7	☐	CRMT_BU_KATR7	CRM_BU_KATR7	CHAR	3	0	Attribute 7	CRMC_ATTR07
19	ATTRIB_8	☐	CRMT_BU_KATR8	CRM_BU_KATR8	CHAR	3	0	Attribute 8	CRMC_ATTR08
20	ATTRIB_9	☐	CRMT_BU_KATR9	CRM_BU_KATR9	CHAR	3	0	Attribute 9	CRMC_ATTR09
21	ATTRIB_10	☐	CRMT_BU_KATR10	CRM_BU_KATR10	CHAR	3	0	Attribute 10	CRMC_ATTR10

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUS_FRG0040	ACCOUNT_GROUP	CRMC_T077D	ACCOUNT_GROUP	REF	C	CN
2	CRMT_BUS_FRG0040	ATTRIBUTE	CRMC_ATTR01	ATTRIBUTE	REF	C	CN
3	CRMT_BUS_FRG0040	ATTRIB_10	CRMC_ATTR10	ATTRIB_10	REF	C	CN
4	CRMT_BUS_FRG0040	ATTRIB_2	CRMC_ATTR02	ATTRIB_2	REF	C	CN
5	CRMT_BUS_FRG0040	ATTRIB_3	CRMC_ATTR03	ATTRIB_3	REF	C	CN
6	CRMT_BUS_FRG0040	ATTRIB_4	CRMC_ATTR04	ATTRIB_4	REF	C	CN
7	CRMT_BUS_FRG0040	ATTRIB_5	CRMC_ATTR05	ATTRIB_5	REF	C	CN
8	CRMT_BUS_FRG0040	ATTRIB_6	CRMC_ATTR06	ATTRIB_6	REF	C	CN
9	CRMT_BUS_FRG0040	ATTRIB_7	CRMC_ATTR07	ATTRIB_7	REF	C	CN
10	CRMT_BUS_FRG0040	ATTRIB_8	CRMC_ATTR08	ATTRIB_8	REF	C	CN
11	CRMT_BUS_FRG0040	ATTRIB_9	CRMC_ATTR09	ATTRIB_9	REF	C	CN
12	CRMT_BUS_FRG0040	CLASSIFIC	CRMC_CLASSIF	CLASSIFIC	REF	C	CN
13	CRMT_BUS_FRG0040	INDUSTRY	CRMC_INDUSTRY	INDUSTRY	REF	C	CN
14	CRMT_BUS_FRG0040	NIELSEN_ID	CRMC_NIELSEN	NIELSEN_ID	REF	C	CN

History

Last changed by/on	SAP	20041011
SAP Release Created in