SAP ABAP Table CRMT_BUS_SET0030_BW (BW Extraction: CRM Billing 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_SET0030_BW	Table Relationship Diagram
Short Description	BW Extraction: CRM Billing 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 Billing Data
4	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
5	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
6	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
7	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
8	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
9	PRICE_LIST_TYPE	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
10	CUSTOMER_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
11	BILLPLAN_PROC	☐	CRMT_BILLPLAN_PROC	CRM_BILLPLAN_PROC	CHAR	4	0	Billing Plan Procedure	CRMC_BILP_PROC
12	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	CRMC_ETAX_HTYP
13	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
14	ACCOUNT_ASGNGRP	☐	CRM_ACCTGRPBP	CRM_ACCTGRPBP	CHAR	2	0	Business Partner Account Assignment Group	CRMC_ACGRPBP
15	REBATE_RELEVANT	☐	CRMT_REBATE_RELEVANT	XFELD	CHAR	1	0	Indicator: Business Partner is Eligible for Rebate in TPM
16	DIRECT_INVOICE	☐	CRMT_DIRECT_INVOICE	CRM_DIRECT_INVOICE	CHAR	1	0	Indicator: Direct Billing
17	SPLIT_BY_COND	☐	CRMT_SPLIT_INVOICE_BY_COND	CRM_SPLIT_INVOICE	CHAR	1	0	Split Invoice by Condition
18	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
19	SET_GUID	☐	CRMT_BU_SET_GUID	SYSUUID	RAW	16	0	GUID for sets of business partner
20	KEY_GUID	☐	CRMT_KEY_GUID_BW	SYSUUID	RAW	16	0	Technical Key (GUID)
21	KEYTYPE_ID	☐	CRMT_KEY_TYPE_ID_BW	OBJECTNAME	CHAR	30	0	Key Type
22	.INCLUDE	☐				0	0	Internal Structure for Sales and Distribution Area
23	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
24	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
25	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_SET0030_BW	ACCOUNT_ASGNGRP	CRMC_ACGRPBP	ACCTGRP_BP	KEY	1	CN
2	CRMT_BUS_SET0030_BW	BILLPLAN_PROC	CRMC_BILP_PROC	BILLPLAN_PROC	REF	C	CN
3	CRMT_BUS_SET0030_BW	CURRENCY	TCURC	WAERS	REF	C	CN
4	CRMT_BUS_SET0030_BW	CUSTOMER_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	C	CN
5	CRMT_BUS_SET0030_BW	CUST_PRIC_PROC	CRMC_CPRICPROC	CUST_PRIC_PROC	REF	C	CN
6	CRMT_BUS_SET0030_BW	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
7	CRMT_BUS_SET0030_BW	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
8	CRMT_BUS_SET0030_BW	EXCHANGE_TYPE	TCURV	KURST	REF	C	CN
9	CRMT_BUS_SET0030_BW	PAYMENT_TERMS	CRMC_PMNTTRMS	PAYMENT_TERMS	REF	C	CN
10	CRMT_BUS_SET0030_BW	PRICE_GROUP	CRMC_PRICEGRP	PRICE_GROUP	REF	C	CN
11	CRMT_BUS_SET0030_BW	PRICE_LIST_TYPE	CRMC_PRICELIST	PRICE_LIST	REF	C	CN

History

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