SAP ABAP Table CRMT_BUS_SET0010_BW (BW Extraction: CRM Sales Data)

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_SET0010_BW	Table Relationship Diagram
Short Description	BW Extraction: CRM Sales 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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	.INCLUDE	☐				0	0	CRM BP Set Structure for Sales Data
4	CUSTOMER_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
5	CUSTOMER_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
6	CUSTOMER_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
7	CUSTOMER_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
8	CUSTOMER_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
9	PAY_GUAR_PROC	☐	COMT_CUST_PAY_GUAR_PROC	COM_CUST_PAY_GUAR_PROC	CHAR	4	0	Customer Payment Guarantee Procedure	COMC_CUSTPAYG
10	CERR_GRP	☐	CRMT_CUST_ERR_GRP	CRM_CUST_ERR_GRP	CHAR	4	0	Incompleteness Group: Business Partner	CRMC_CERR_GRP
11	PODC_GROUP	☐	CRMT_PODC_GROUP	CRM_PODC_GROUP	CHAR	4	0	BP Group for Purchase Order Number Check	CRMC_PODCGROUP
12	LOC_REQUIRED	☐	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
13	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
14	SET_GUID	☐	CRMT_BU_SET_GUID	SYSUUID	RAW	16	0	GUID for sets of business partner
15	KEY_GUID	☐	CRMT_KEY_GUID_BW	SYSUUID	RAW	16	0	Technical Key (GUID)
16	KEYTYPE_ID	☐	CRMT_KEY_TYPE_ID_BW	OBJECTNAME	CHAR	30	0	Key Type
17	.INCLUDE	☐				0	0	Internal Structure for Sales and Distribution Area
18	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
19	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
20	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUS_SET0010_BW	CERR_GRP	CRMC_CERR_GRP	CERR_GRP	KEY	1	CN
2	CRMT_BUS_SET0010_BW	CUSTOMER_GROUP1	CRMC_CUSTGRP1	CUST_GROUP1	REF	C	CN
3	CRMT_BUS_SET0010_BW	CUSTOMER_GROUP2	CRMC_CUSTGRP2	CUST_GROUP2	REF	C	CN
4	CRMT_BUS_SET0010_BW	CUSTOMER_GROUP3	CRMC_CUSTGRP3	CUST_GROUP3	REF	C	CN
5	CRMT_BUS_SET0010_BW	CUSTOMER_GROUP4	CRMC_CUSTGRP4	CUST_GROUP4	REF	C	CN
6	CRMT_BUS_SET0010_BW	CUSTOMER_GROUP5	CRMC_CUSTGRP5	CUST_GROUP5	REF	C	CN
7	CRMT_BUS_SET0010_BW	PAY_GUAR_PROC	COMC_CUSTPAYG	CUST_PAY_GUAR	REF	C	CN

History

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