SAP ABAP Table CRMT_BSP_SALES_DATA_BP (BSP: Sales Area Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-PCU (Application Component) People-Centric UI (Business Partner)
     ⤷ CRM_BSP_MODEL_IL_BP (Package) Model Implementation: Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SALES_DATA_BP	Table Relationship Diagram
Short Description	BSP: Sales Area 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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	.INCLUDE	☐				0	0	CRM BP Set Structure for Sales Data
3	CUSTOMER_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
4	CUSTOMER_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
5	CUSTOMER_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
6	CUSTOMER_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
7	CUSTOMER_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
8	PAY_GUAR_PROC	☐	COMT_CUST_PAY_GUAR_PROC	COM_CUST_PAY_GUAR_PROC	CHAR	4	0	Customer Payment Guarantee Procedure	COMC_CUSTPAYG
9	CERR_GRP	☐	CRMT_CUST_ERR_GRP	CRM_CUST_ERR_GRP	CHAR	4	0	Incompleteness Group: Business Partner	CRMC_CERR_GRP
10	PODC_GROUP	☐	CRMT_PODC_GROUP	CRM_PODC_GROUP	CHAR	4	0	BP Group for Purchase Order Number Check	CRMC_PODCGROUP
11	LOC_REQUIRED	☐	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
12	.INCLUDE	☐				0	0	CRM BP Set Structure for Shipping Data
13	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
14	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
15	SHIPPING_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
16	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
17	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
18	UNLIM_DLV_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
19	DLV_PRIORITY	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	CRMC_DLV_PRIO
20	ORDER_COMBINED	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
21	PARTIAL_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
22	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
23	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
24	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)
25	MAX_NO_DLV	☐	CRMT_MAX_PL_DLV		DEC	1	0	Maximum number of partial deliveries allowed per item
26	.INCLUDE	☐				0	0	CRM BP Set Structure for Billing Data
27	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
28	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
29	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
30	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
31	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
32	PRICE_LIST_TYPE	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
33	CUSTOMER_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
34	BILLPLAN_PROC	☐	CRMT_BILLPLAN_PROC	CRM_BILLPLAN_PROC	CHAR	4	0	Billing Plan Procedure	CRMC_BILP_PROC
35	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
36	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
37	ACCOUNT_ASGNGRP	☐	CRM_ACCTGRPBP	CRM_ACCTGRPBP	CHAR	2	0	Business Partner Account Assignment Group	CRMC_ACGRPBP
38	REBATE_RELEVANT	☐	CRMT_REBATE_RELEVANT	XFELD	CHAR	1	0	Indicator: Business Partner is Eligible for Rebate in TPM
39	DIRECT_INVOICE	☐	CRMT_DIRECT_INVOICE	CRM_DIRECT_INVOICE	CHAR	1	0	Indicator: Direct Billing
40	SPLIT_BY_COND	☐	CRMT_SPLIT_INVOICE_BY_COND	CRM_SPLIT_INVOICE	CHAR	1	0	Split Invoice by Condition
41	.INCLUDE	☐				0	0	CRM BP: Sales Data (Not MD, No Templates)
42	SA_GUID_DEF	☐	CRMT_BU_DEF_SA_EXTERNAL	CHAR32	CHAR	32	0	Default Sales Agreement (GUID as CHAR32)
43	.INCLUDE	☐				0	0	CRM BP Set Structure for Organizational Data
44	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
45	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
46	DISTRICT	☐	CRMT_DISTRICT	CRM_DISTRICT	CHAR	6	0	District	CRMC_DISTRICT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SALES_DATA_BP	ACCOUNT_ASGNGRP	CRMC_ACGRPBP	ACCTGRP_BP	KEY	1	CN
2	CRMT_BSP_SALES_DATA_BP	BILLPLAN_PROC	CRMC_BILP_PROC	BILLPLAN_PROC	REF	C	CN
3	CRMT_BSP_SALES_DATA_BP	CERR_GRP	CRMC_CERR_GRP	CERR_GRP	KEY	1	CN
4	CRMT_BSP_SALES_DATA_BP	CURRENCY	TCURC	WAERS	REF	C	CN
5	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	C	CN
6	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP1	CRMC_CUSTGRP1	CUST_GROUP1	REF	C	CN
7	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP2	CRMC_CUSTGRP2	CUST_GROUP2	REF	C	CN
8	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP3	CRMC_CUSTGRP3	CUST_GROUP3	REF	C	CN
9	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP4	CRMC_CUSTGRP4	CUST_GROUP4	REF	C	CN
10	CRMT_BSP_SALES_DATA_BP	CUSTOMER_GROUP5	CRMC_CUSTGRP5	CUST_GROUP5	REF	C	CN
11	CRMT_BSP_SALES_DATA_BP	CUST_PRIC_PROC	CRMC_CPRICPROC	CUST_PRIC_PROC	REF	C	CN
12	CRMT_BSP_SALES_DATA_BP	DISTRICT	CRMC_DISTRICT	DISTRICT	REF	C	CN
13	CRMT_BSP_SALES_DATA_BP	DLV_PRIORITY	CRMC_DLV_PRIO	DLV_PRIO	REF	C	CN
14	CRMT_BSP_SALES_DATA_BP	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
15	CRMT_BSP_SALES_DATA_BP	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
16	CRMT_BSP_SALES_DATA_BP	EXCHANGE_TYPE	TCURV	KURST	REF	C	CN
17	CRMT_BSP_SALES_DATA_BP	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1	REF	C	CN
18	CRMT_BSP_SALES_DATA_BP	PAYMENT_TERMS	CRMC_PMNTTRMS	PAYMENT_TERMS	REF	C	CN
19	CRMT_BSP_SALES_DATA_BP	PAY_GUAR_PROC	COMC_CUSTPAYG	CUST_PAY_GUAR	REF	C	CN
20	CRMT_BSP_SALES_DATA_BP	PRICE_GROUP	CRMC_PRICEGRP	PRICE_GROUP	REF	C	CN
21	CRMT_BSP_SALES_DATA_BP	PRICE_LIST_TYPE	CRMC_PRICELIST	PRICE_LIST	REF	C	CN
22	CRMT_BSP_SALES_DATA_BP	SHIPPING_COND	CRMC_SHIP_COND	SHIP_COND	REF	C	CN
23	CRMT_BSP_SALES_DATA_BP	TRANS_MOT	CRMC_TRANS_MOT	MOT		1	1

History

Last changed by/on	SAP	20070309
SAP Release Created in	310