SAP ABAP Table CRMM_BUT_SET0030 (Business Partner: Billing Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_FRG0030_MD (Package) CRM BP Billing Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMM_BUT_SET0030	Table Relationship Diagram
Short Description	Business Partner: Billing Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SET_GUID	☑	CRMT_BU_SET_GUID	SYSUUID	RAW	16	0	GUID for sets of business partner
3	VALID_TO	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
4	VALID_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	.INCLUDE	☐				0	0	CRM BP Set Structure for Billing Data
6	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
7	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
8	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
9	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
10	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
11	PRICE_LIST_TYPE	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
12	CUSTOMER_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
13	BILLPLAN_PROC	☐	CRMT_BILLPLAN_PROC	CRM_BILLPLAN_PROC	CHAR	4	0	Billing Plan Procedure	CRMC_BILP_PROC
14	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
15	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
16	ACCOUNT_ASGNGRP	☐	CRM_ACCTGRPBP	CRM_ACCTGRPBP	CHAR	2	0	Business Partner Account Assignment Group	CRMC_ACGRPBP
17	REBATE_RELEVANT	☐	CRMT_REBATE_RELEVANT	XFELD	CHAR	1	0	Indicator: Business Partner is Eligible for Rebate in TPM
18	DIRECT_INVOICE	☐	CRMT_DIRECT_INVOICE	CRM_DIRECT_INVOICE	CHAR	1	0	Indicator: Direct Billing
19	SPLIT_BY_COND	☐	CRMT_SPLIT_INVOICE_BY_COND	CRM_SPLIT_INVOICE	CHAR	1	0	Split Invoice by Condition

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMM_BUT_SET0030	ACCOUNT_ASGNGRP	CRMC_ACGRPBP	ACCTGRP_BP	KEY	1	CN
2	CRMM_BUT_SET0030	BILLPLAN_PROC	CRMC_BILP_PROC	BILLPLAN_PROC	REF	C	CN
3	CRMM_BUT_SET0030	CLIENT	T000	MANDT	KEY	1	CN
4	CRMM_BUT_SET0030	CURRENCY	TCURC	WAERS	REF	C	CN
5	CRMM_BUT_SET0030	CUSTOMER_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	C	CN
6	CRMM_BUT_SET0030	CUST_PRIC_PROC	CRMC_CPRICPROC	CUST_PRIC_PROC	REF	C	CN
7	CRMM_BUT_SET0030	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
8	CRMM_BUT_SET0030	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
9	CRMM_BUT_SET0030	EXCHANGE_TYPE	TCURV	KURST	REF	C	CN
10	CRMM_BUT_SET0030	PAYMENT_TERMS	CRMC_PMNTTRMS	PAYMENT_TERMS	REF	C	CN
11	CRMM_BUT_SET0030	PRICE_GROUP	CRMC_PRICEGRP	PRICE_GROUP	REF	C	CN
12	CRMM_BUT_SET0030	PRICE_LIST_TYPE	CRMC_PRICELIST	PRICE_LIST	REF	C	CN

History

Last changed by/on	SAP	20041223
SAP Release Created in