SAP ABAP Table CRMT_FCT_SALES_AREA (structure for sales area data pdf)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_UIU_BP (Package) unified user interface for business partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_FCT_SALES_AREA	Table Relationship Diagram
Short Description	structure for sales area data pdf

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	.INCLUDE	☐				0	0	CRM BP Set Structure for Billing Data
2	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
3	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
4	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
5	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
6	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
7	PRICE_LIST_TYPE	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
8	CUSTOMER_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
9	BILLPLAN_PROC	☐	CRMT_BILLPLAN_PROC	CRM_BILLPLAN_PROC	CHAR	4	0	Billing Plan Procedure	CRMC_BILP_PROC
10	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
11	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
12	ACCOUNT_ASGNGRP	☐	CRM_ACCTGRPBP	CRM_ACCTGRPBP	CHAR	2	0	Business Partner Account Assignment Group	CRMC_ACGRPBP
13	REBATE_RELEVANT	☐	CRMT_REBATE_RELEVANT	XFELD	CHAR	1	0	Indicator: Business Partner is Eligible for Rebate in TPM
14	DIRECT_INVOICE	☐	CRMT_DIRECT_INVOICE	CRM_DIRECT_INVOICE	CHAR	1	0	Indicator: Direct Billing
15	SPLIT_BY_COND	☐	CRMT_SPLIT_INVOICE_BY_COND	CRM_SPLIT_INVOICE	CHAR	1	0	Split Invoice by Condition
16	.INCLUDE	☐				0	0	CRM BP Set Structure for Shipping Data
17	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
18	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
19	SHIPPING_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
20	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
21	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
22	UNLIM_DLV_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
23	DLV_PRIORITY	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	CRMC_DLV_PRIO
24	ORDER_COMBINED	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
25	PARTIAL_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
26	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
27	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
28	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)
29	MAX_NO_DLV	☐	CRMT_MAX_PL_DLV		DEC	1	0	Maximum number of partial deliveries allowed per item
30	.INCLUDE	☐				0	0	CRM BP Set Structure for Sales Data
31	CUSTOMER_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
32	CUSTOMER_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
33	CUSTOMER_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
34	CUSTOMER_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
35	CUSTOMER_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
36	PAY_GUAR_PROC	☐	COMT_CUST_PAY_GUAR_PROC	COM_CUST_PAY_GUAR_PROC	CHAR	4	0	Customer Payment Guarantee Procedure	COMC_CUSTPAYG
37	CERR_GRP	☐	CRMT_CUST_ERR_GRP	CRM_CUST_ERR_GRP	CHAR	4	0	Incompleteness Group: Business Partner	CRMC_CERR_GRP
38	PODC_GROUP	☐	CRMT_PODC_GROUP	CRM_PODC_GROUP	CHAR	4	0	BP Group for Purchase Order Number Check	CRMC_PODCGROUP
39	LOC_REQUIRED	☐	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
40	.INCLUDE	☐				0	0	BSP: Sales Areas
41	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
42	ASSIGNED	☐	CRMT_ASSIGN		CHAR	1	0	Assign (For Example, Sales Area for Business Partner)
43	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
44	SALES_ORG_NAME	☐	CRMT_SALES_ORG_NAME		CHAR	20	0	Description of Sales Organization
45	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
46	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
47	SALES_ORG_TEXT	☐	CRMT_SALES_ORG_TXT		CHAR	40	0	Sales Organization Long Text
48	CHANNEL_TEXT	☐	CRMT_CHANNEL_TXT		CHAR	40	0	Description of Distribution Channel
49	DIVISION_TEXT	☐	CRMT_DIVISION_TXT		CHAR	40	0	Description of Division
50	SALES_ORG_R3	☐	CRMT_VKORG	VKORG	CHAR	4	0	BSP: R/3 Key for Sales Organization	*
51	CHANNEL_R3	☐	CRMT_VTWEG	VTWEG	CHAR	2	0	BSP: R/3 Key for Distribution Channel	*
52	DIVISION_R3	☐	CRMT_SPART	SPART	CHAR	2	0	BSP: R/3 Key for Division

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in