SAP ABAP Table CRMM_BUT_FRG0041 (Business Partner 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	TRANSP	Transparent table
Transparent table	CRMM_BUT_FRG0041	Table Relationship Diagram
Short Description	Business Partner Sales Classification

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key Structure for Set Type 0040
3	PARTNER_GUID	☑	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	VALID_TO	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	VALID_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	.INCLUDE	☐				0	0	CRM BP Fragment Structure of the Sales Classification
7	IS_COMPETITOR	☐	CRMT_BU_IS_COMPETITOR	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is competitor
8	IS_PROSPECT	☐	CRMT_BU_IS_PROSPECT	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is a prospect
9	IS_CONSUMER	☐	CRMT_BU_IS_CONSUMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is consumer
10	IS_CUSTOMER	☐	CRMT_BU_IS_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is customer
11	CUSTOMER_SINCE	☐	CRMT_CUSTOMER_SINCE	DATUM	DATS	8	0	Customer Since Date
12	IS_COD_CUSTOMER	☐	CRMT_BU_IS_COD_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is cash on delivery customer
13	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	CRMC_INDUSTRY
14	IS_RENTED	☐	CRMT_BU_IS_RENTED	CRM_BOOLEAN	CHAR	1	0	Indicator: Rented Address
15	ACCOUNT_GROUP	☐	CRMT_BU_ACCOUNT_GROUP	CRM_BU_ACCOUNT_GROUP	CHAR	4	0	R/3 Account Group	CRMC_T077D
16	NIELSEN_ID	☐	CRMT_BU_NIELSEN_ID	CRM_BU_NIELSEN_ID	CHAR	2	0	Nielsen ID	CRMC_NIELSEN
17	CLASSIFIC	☐	CRMT_BU_CUST_CLASSIFIC	CRM_BU_CUST_CLASSIFIC	CHAR	2	0	Customer Classification	CRMC_CLASSIF
18	ATTRIBUTE	☐	CRMT_BU_KATR1	CRM_BU_KATR1	CHAR	2	0	Attribute 1	CRMC_ATTR01
19	ATTRIB_2	☐	CRMT_BU_KATR2	CRM_BU_KATR2	CHAR	2	0	Attribute 2	CRMC_ATTR02
20	ATTRIB_3	☐	CRMT_BU_KATR3	CRM_BU_KATR3	CHAR	2	0	Attribute 3	CRMC_ATTR03
21	ATTRIB_4	☐	CRMT_BU_KATR4	CRM_BU_KATR4	CHAR	2	0	Attribute 4	CRMC_ATTR04
22	ATTRIB_5	☐	CRMT_BU_KATR5	CRM_BU_KATR5	CHAR	2	0	Attribute 5	CRMC_ATTR05
23	ATTRIB_6	☐	CRMT_BU_KATR6	CRM_BU_KATR6	CHAR	3	0	Attribute 6	CRMC_ATTR06
24	ATTRIB_7	☐	CRMT_BU_KATR7	CRM_BU_KATR7	CHAR	3	0	Attribute 7	CRMC_ATTR07
25	ATTRIB_8	☐	CRMT_BU_KATR8	CRM_BU_KATR8	CHAR	3	0	Attribute 8	CRMC_ATTR08
26	ATTRIB_9	☐	CRMT_BU_KATR9	CRM_BU_KATR9	CHAR	3	0	Attribute 9	CRMC_ATTR09
27	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	CRMM_BUT_FRG0041	ACCOUNT_GROUP	CRMC_T077D	ACCOUNT_GROUP	REF	C	CN
2	CRMM_BUT_FRG0041	ATTRIBUTE	CRMC_ATTR01	ATTRIBUTE	REF	C	CN
3	CRMM_BUT_FRG0041	ATTRIB_10	CRMC_ATTR10	ATTRIB_10	REF	C	CN
4	CRMM_BUT_FRG0041	ATTRIB_2	CRMC_ATTR02	ATTRIB_2	REF	C	CN
5	CRMM_BUT_FRG0041	ATTRIB_3	CRMC_ATTR03	ATTRIB_3	REF	C	CN
6	CRMM_BUT_FRG0041	ATTRIB_4	CRMC_ATTR04	ATTRIB_4	REF	C	CN
7	CRMM_BUT_FRG0041	ATTRIB_5	CRMC_ATTR05	ATTRIB_5	REF	C	CN
8	CRMM_BUT_FRG0041	ATTRIB_6	CRMC_ATTR06	ATTRIB_6	REF	C	CN
9	CRMM_BUT_FRG0041	ATTRIB_7	CRMC_ATTR07	ATTRIB_7	REF	C	CN
10	CRMM_BUT_FRG0041	ATTRIB_8	CRMC_ATTR08	ATTRIB_8	REF	C	CN
11	CRMM_BUT_FRG0041	ATTRIB_9	CRMC_ATTR09	ATTRIB_9	REF	C	CN
12	CRMM_BUT_FRG0041	CLASSIFIC	CRMC_CLASSIF	CLASSIFIC	REF	C	CN
13	CRMM_BUT_FRG0041	CLIENT	T000	MANDT	KEY	1	CN
14	CRMM_BUT_FRG0041	INDUSTRY	CRMC_INDUSTRY	INDUSTRY	REF	C	CN
15	CRMM_BUT_FRG0041	NIELSEN_ID	CRMC_NIELSEN	NIELSEN_ID	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in