SAP ABAP Table CRMV_BUT_FRG0040 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_BUT_FRG0040	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
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	TYPE	☑	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
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	CRMV_BUT_FRG0040	ACCOUNT_GROUP	CRMC_T077D	ACCOUNT_GROUP	REF	C	CN
2	CRMV_BUT_FRG0040	ATTRIBUTE	CRMC_ATTR01	ATTRIBUTE	REF	C	CN
3	CRMV_BUT_FRG0040	ATTRIB_10	CRMC_ATTR10	ATTRIB_10	REF	C	CN
4	CRMV_BUT_FRG0040	ATTRIB_2	CRMC_ATTR02	ATTRIB_2	REF	C	CN
5	CRMV_BUT_FRG0040	ATTRIB_3	CRMC_ATTR03	ATTRIB_3	REF	C	CN
6	CRMV_BUT_FRG0040	ATTRIB_4	CRMC_ATTR04	ATTRIB_4	REF	C	CN
7	CRMV_BUT_FRG0040	ATTRIB_5	CRMC_ATTR05	ATTRIB_5	REF	C	CN
8	CRMV_BUT_FRG0040	ATTRIB_6	CRMC_ATTR06	ATTRIB_6	REF	C	CN
9	CRMV_BUT_FRG0040	ATTRIB_7	CRMC_ATTR07	ATTRIB_7	REF	C	CN
10	CRMV_BUT_FRG0040	ATTRIB_8	CRMC_ATTR08	ATTRIB_8	REF	C	CN
11	CRMV_BUT_FRG0040	ATTRIB_9	CRMC_ATTR09	ATTRIB_9	REF	C	CN
12	CRMV_BUT_FRG0040	CLASSIFIC	CRMC_CLASSIF	CLASSIFIC	REF	C	CN
13	CRMV_BUT_FRG0040	CLIENT	T000	MANDT	KEY	1	CN
14	CRMV_BUT_FRG0040	INDUSTRY	CRMC_INDUSTRY	INDUSTRY	REF	C	CN
15	CRMV_BUT_FRG0040	NIELSEN_ID	CRMC_NIELSEN	NIELSEN_ID	REF	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in