SAP ABAP Table CRMT_BUS_FRG0040_BW (BW Extraction: CRM Sales Classification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_EXT_MD (Package) CRM BP Extraction BW for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUS_FRG0040_BW	Table Relationship Diagram
Short Description	BW Extraction: CRM 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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	.INCLUDE	☐				0	0	CRM BP Fragment Structure of the Sales Classification
5	IS_COMPETITOR	☐	CRMT_BU_IS_COMPETITOR	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is competitor
6	IS_PROSPECT	☐	CRMT_BU_IS_PROSPECT	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is a prospect
7	IS_CONSUMER	☐	CRMT_BU_IS_CONSUMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is consumer
8	IS_CUSTOMER	☐	CRMT_BU_IS_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is customer
9	CUSTOMER_SINCE	☐	CRMT_CUSTOMER_SINCE	DATUM	DATS	8	0	Customer Since Date
10	IS_COD_CUSTOMER	☐	CRMT_BU_IS_COD_CUSTOMER	CRM_BOOLEAN	CHAR	1	0	Indicator: Business partner is cash on delivery customer
11	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	CRMC_INDUSTRY
12	IS_RENTED	☐	CRMT_BU_IS_RENTED	CRM_BOOLEAN	CHAR	1	0	Indicator: Rented Address
13	ACCOUNT_GROUP	☐	CRMT_BU_ACCOUNT_GROUP	CRM_BU_ACCOUNT_GROUP	CHAR	4	0	R/3 Account Group	CRMC_T077D
14	NIELSEN_ID	☐	CRMT_BU_NIELSEN_ID	CRM_BU_NIELSEN_ID	CHAR	2	0	Nielsen ID	CRMC_NIELSEN
15	CLASSIFIC	☐	CRMT_BU_CUST_CLASSIFIC	CRM_BU_CUST_CLASSIFIC	CHAR	2	0	Customer Classification	CRMC_CLASSIF
16	ATTRIBUTE	☐	CRMT_BU_KATR1	CRM_BU_KATR1	CHAR	2	0	Attribute 1	CRMC_ATTR01
17	ATTRIB_2	☐	CRMT_BU_KATR2	CRM_BU_KATR2	CHAR	2	0	Attribute 2	CRMC_ATTR02
18	ATTRIB_3	☐	CRMT_BU_KATR3	CRM_BU_KATR3	CHAR	2	0	Attribute 3	CRMC_ATTR03
19	ATTRIB_4	☐	CRMT_BU_KATR4	CRM_BU_KATR4	CHAR	2	0	Attribute 4	CRMC_ATTR04
20	ATTRIB_5	☐	CRMT_BU_KATR5	CRM_BU_KATR5	CHAR	2	0	Attribute 5	CRMC_ATTR05
21	ATTRIB_6	☐	CRMT_BU_KATR6	CRM_BU_KATR6	CHAR	3	0	Attribute 6	CRMC_ATTR06
22	ATTRIB_7	☐	CRMT_BU_KATR7	CRM_BU_KATR7	CHAR	3	0	Attribute 7	CRMC_ATTR07
23	ATTRIB_8	☐	CRMT_BU_KATR8	CRM_BU_KATR8	CHAR	3	0	Attribute 8	CRMC_ATTR08
24	ATTRIB_9	☐	CRMT_BU_KATR9	CRM_BU_KATR9	CHAR	3	0	Attribute 9	CRMC_ATTR09
25	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_BW	ACCOUNT_GROUP	CRMC_T077D	ACCOUNT_GROUP	REF	C	CN
2	CRMT_BUS_FRG0040_BW	ATTRIBUTE	CRMC_ATTR01	ATTRIBUTE	REF	C	CN
3	CRMT_BUS_FRG0040_BW	ATTRIB_10	CRMC_ATTR10	ATTRIB_10	REF	C	CN
4	CRMT_BUS_FRG0040_BW	ATTRIB_2	CRMC_ATTR02	ATTRIB_2	REF	C	CN
5	CRMT_BUS_FRG0040_BW	ATTRIB_3	CRMC_ATTR03	ATTRIB_3	REF	C	CN
6	CRMT_BUS_FRG0040_BW	ATTRIB_4	CRMC_ATTR04	ATTRIB_4	REF	C	CN
7	CRMT_BUS_FRG0040_BW	ATTRIB_5	CRMC_ATTR05	ATTRIB_5	REF	C	CN
8	CRMT_BUS_FRG0040_BW	ATTRIB_6	CRMC_ATTR06	ATTRIB_6	REF	C	CN
9	CRMT_BUS_FRG0040_BW	ATTRIB_7	CRMC_ATTR07	ATTRIB_7	REF	C	CN
10	CRMT_BUS_FRG0040_BW	ATTRIB_8	CRMC_ATTR08	ATTRIB_8	REF	C	CN
11	CRMT_BUS_FRG0040_BW	ATTRIB_9	CRMC_ATTR09	ATTRIB_9	REF	C	CN
12	CRMT_BUS_FRG0040_BW	CLASSIFIC	CRMC_CLASSIF	CLASSIFIC	REF	C	CN
13	CRMT_BUS_FRG0040_BW	INDUSTRY	CRMC_INDUSTRY	INDUSTRY	REF	C	CN
14	CRMT_BUS_FRG0040_BW	NIELSEN_ID	CRMC_NIELSEN	NIELSEN_ID	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	20B