SAP ABAP Table CRMT_ISA_SHOP_EXT (Shop Data in External Format)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISA (Application Component) Internet Sales
     ⤷ CRM_ISALES (Package) CRM Internet Sales

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ISA_SHOP_EXT	Table Relationship Diagram
Short Description	Shop Data in External Format

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	Internal Key for Shop
2	ID	☐	CRMT_SHOP_ID	CRM_SHOP_ID	CHAR	10	0	Web Shop Identifier	*
3	.INCLUDE	☐				0	0	Shop Data with Same Format both Internally and Externally
4	SCENARIO	☐	CRMT_ISA_SCENARIO	CRM_ISA_SCENARIO	CHAR	4	0	CRM Scenario Shop
5	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
6	PROFILE_TEMPL_ID	☐	CRMT_SHOP_PROF_TEMPLATE	KLASSE	CHAR	18	0	Web Shop Attribute Set
7	PERSONALIZED_CU	☐	CRMT_ISA_PERSONAL_CU_RECOMMEND	XFELD	CHAR	1	0	Personalized Cross/Upselling
8	PCAT_DETERMIN	☐	CRMT_ISA_PCAT_DETERMINATION	XFELD	CHAR	1	0	Catalog Determination
9	COUNTRY_GROUP	☐	CRMT_ISA_COUNTRY_GROUP	CRM_ISA_COUNTRY_GROUP	CHAR	4	0	Country Grouping During Address Maintenance	CRMC_CNTRY_GRP
10	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
11	PART_FCT_CONTACT	☐	CRMT_ISA_PARTNER_FCT_CONTACT	COM_PARTNER_FCT	CHAR	8	0	Partner Function for Contacts in B2B Scenario	CRMC_PARTNER_FCT
12	PRICING_TYPE	☐	CRMT_ISA_PRICING_TYPE	PRC_PRICING_TYPE	CHAR	1	0	Pricing Type (Obsolete from CRM 2.0C)	*
13	USE4B2C	☐	XFELD	XFELD	CHAR	1	0	Checkbox
14	USE4B2B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
15	METHOD_SCHEME_ID	☐	CRMT_SHOP_MS_ID	CRMT_MKTIMG_MS_ID	CHAR	6	0	Methods Schema of a Web Shop	CRMC_MKTIMG_MS_H
16	QUOTATION	☐	CRMT_ISA_QUOTATION_ENABLE	XFELD	CHAR	1	0	Quotation Using Open Catalog Interface
17	PRICING_MODE	☐	CRMT_ISA_PRICE_DETERMINATION	CHAR1	CHAR	1	0	Controlling Catalog Price Determination
18	AVAILAB_CHECK	☐	CRMT_ISA_AVAILABILITY_CHECK	CRM_ISA_AVAILABILITY_CHECK	CHAR	1	0	Availability Check Control
19	EVENT_CAPTURE	☐	CRMT_ISA_EVENT_CAPTURE_ENABLE	XFELD	CHAR	1	0	Enter Business Events
20	CNT_USE_IN_SHOP	☐	CRMT_ISA_CNT_USE_IN_SHOP	CRM_BOOLEAN	CHAR	1	0	Contract Determination in Web Shop
21	CNT_FIELD_PROF	☐	CRMT_ISA_CNT_FIELD_PROFILE	CRM_ISA_CNT_FIELD_PROFILE	CHAR	4	0	Profile for Selection of Contract Fields	CRMC_ISA_CFP
22	PART_FCT_COMPANY	☐	CRMT_ISA_PARTNER_FCT_COMPANY	COM_PARTNER_FCT	CHAR	8	0	Partner Function of Company
23	PART_PFT_COMPANY	☐	CRMT_PARTNER_PFT	COM_PARTNER_PFT	CHAR	4	0	Partner Function Category	*
24	DOC_TYPE_LATE	☐	CRMT_ISA_DOCTYPE_LATE_DECISION	CRM_BOOLEAN	CHAR	1	0	Indicator: Late Decision on Document Class
25	USE_TEMPLATES	☐	CRMT_ISA_TEMPLATES_ENABLE	XFELD	CHAR	1	0	Indicator: Order Templates Allowed
26	SELECT_SOLDTO	☐	CRMT_ISA_SOLDTO_SELECTABLE	XFELD	CHAR	1	0	Indicator: Sold-To Party Can be Selected
27	EXTENDED_QUOTE	☐	CRMT_ISA_EXTENDED_QUOTE	CRM_BOOLEAN	CHAR	1	0	Use Quotation with Request for Quotation Option
28	PROC_TYPE_QUOTE	☐	CRMT_ISA_PROC_TYPE_QUOTE	CRM_PROCESS_TYPE	CHAR	4	0	Transaction Type for Request for Quotation in Internet Sales	CRMC_PROC_TYPE
29	SEARCH_ALL_QUOTE	☐	CRMT_ISA_SEARCH_ALL_QUOTE	CRM_BOOLEAN	CHAR	1	0	Allow Lean Quotations in Search
30	BEGRU	☐	CRMT_ISA_SHOP_BEGRU	BEGRU	CHAR	4	0	Authorization Group for Internet Sales Shops
31	.INCLUDE	☐				0	0	Shop Data for Channel Commerce
32	DOC_PRIC_PROC	☐	CRMT_DOC_PRIC_PROC	CRM_DOC_PRIC_PROC	CHAR	1	0	Document Pricing Procedure for Pricing Proc. Determination	CRMC_DPRICPROC
33	USER_STAT_PROC	☐	CRMT_ISA_USER_STATUS_PROFILE	J_STSMA	CHAR	8	0	User Status Profile in Internet Sales POM Scenario	TJ20
34	FORWARD_OCI	☐	CRMT_ISA_BASKET_FORWARD_OCI	CRM_BOOLEAN	CHAR	1	0	Flag: Forward Basket to Partner via OCI
35	SOLDFROM_ON_ITEM	☐	CRM_ISA_PARTNER_ON_ITEMLEVEL	CRM_BOOLEAN	CHAR	1	0	Flag: Partner is Entered at Item Level
36	AVAIL_SOLDFROM	☐	CRM_ISA_SP_PARTNER_AVAIL_INFO	CRM_BOOLEAN	CHAR	1	0	Flag: Display Availability Information for Partner
37	CREAT_PART_ORDER	☐	CRM_ISA_CREATE_PARTNER_ORDER	CRM_BOOLEAN	CHAR	1	0	Flag: Order was Created for a Partner
38	CNT_NEGOTIATION	☐	CRMT_ISA_CNT_NEGOT_USE_IN_SHOP	CRM_BOOLEAN	CHAR	1	0	Contract Negotiation in Web Shop
39	CNT_PROC_TYPE_GR	☐	CRMT_ISA_PROCESS_TYPE_GROUP	CRM_ISA_PROCESS_TYPE_GROUP	CHAR	4	0	Transaction Type Group	CRMC_ISA_PTG
40	BATCHES_ENABLED	☐	CRMT_ISA_BATCHES_ENABLED	CRM_BOOLEAN	CHAR	1	0	Shop: Batch Management Allowed
41	PROC_TYPE_POM	☐	CRMT_ISA_PROC_TYPE_POM_SELECT	CRM_PROCESS_TYPE	CHAR	4	0	Transaction Type for Selecting Sales Orders	*
42	LEAD_CREATION	☐	CRMT_ISA_LEAD_CREATION_ALLOWED	CRM_BOOLEAN	CHAR	1	0	Indicator for Lead Creation
43	NO_INTERNAL_CAT	☐	CRMT_ISA_NO_INTERNAL_CATALOG	CRM_BOOLEAN	CHAR	1	0	Flag: Display Internal Catalog
44	PROD_DET_INFO	☐	CRMT_ISA_PROD_DET_INFO_DISPLAY	CRM_BOOLEAN	CHAR	1	0	Flag: Display Info. for Product Determination
45	MKT_FOR_UNKNOWN	☐	CRMT_ISA_MKT_FOR_UNKNOWN_USER	CRM_BOOLEAN	CHAR	1	0	Flag: Marketing Functions for Unknown Users
46	PROC_TYPE_GR_ORD	☐	CRMT_ISA_PROCESS_TYPE_GROUP	CRM_ISA_PROCESS_TYPE_GROUP	CHAR	4	0	Transaction Type Group	CRMC_ISA_PTG
47	PROC_TYPE_GR_QUT	☐	CRMT_ISA_PROCESS_TYPE_GROUP	CRM_ISA_PROCESS_TYPE_GROUP	CHAR	4	0	Transaction Type Group	CRMC_ISA_PTG
48	PROC_TYPE_TMPLTE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
49	PROC_TYPE_BSKTLD	☐	CRMT_ISA_PROC_TYPE_BASKT_FG	CRM_PROCESS_TYPE	CHAR	4	0	Transaction Type for Free Good Det. in Basket/Late Decision	*
50	ORD_GR_SELECTED	☐	CRMT_ISA_ORD_GR_SELECTED	CRM_BOOLEAN	CHAR	1	0	Use Transaction Type Group for Orders
51	QUT_GR_SELECTED	☐	CRMT_ISA_QUT_GR_SELECTED	CRM_BOOLEAN	CHAR	1	0	Use Transaction Type Group for Quotations
52	ITEMS_THRESHOLD	☐	CRMT_ISA_ITEMS_TRESHOLD	INT4	INT4	10	0	Threshold Value for Large Documents
53	MANUAL_CAMPAIGNS	☐	CRMT_ISA_MANUAL_CAMPAIGNS	CRM_BOOLEAN	CHAR	1	0	Indicator for Manual Entry of Campaigns
54	.INCLUDE	☐				0	0	Extension Fields for Auction Scenario
55	AUCTION_FLAG	☐	CRMT_ISA_AUCTION_ENABLE	XFELD	CHAR	1	0	Flag to Enable the Auctioning Scenario
56	AUC_ORDER_TYPE	☐	CRMT_ISA_AUC_ORDER_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	The Sales Order Type for the Auction Scenario (Seller Side)	CRMC_PROC_TYPE
57	AUC_QUOTE_TYPE	☐	CRMT_ISA_AUC_QUOTE_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Quotation Type for the Auction Scenario (Seller Side)	CRMC_PROC_TYPE
58	PRICE_COND	☐	CRMT_AUC_WIN_PRICE_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Price Condition Type for the Auction Winning Price	*
59	BILLING_SELECT	☐	CRMT_ISA_BILL_ENABLE	CRM_ISA_BILL_ENABLE	CHAR	1	0	Selection of Billing Document Display in Shop
60	.INCLUDE	☐				0	0	Shop Data for Partner Locator
61	BUSINESS_PARTNER	☐	CRMT_ISA_STORE_LOCATOR_BP	BU_PARTNER	CHAR	10	0	Bus. Partner to Which Other BPs Are Assigned via Relationshp	*
62	REL_SHIP_GROUP	☐	CRMT_ISA_REL_SHIP_GROUP	CRM_ISA_REL_SHIP_GROUP	CHAR	2	0	Identifier for Relationship Type Group	CRMC_ISA_RSG
63	AVAIL_STORE_LOC	☐	CRMT_ISA_STORE_LOCATOR_AVAIL	CRM_BOOLEAN	CHAR	1	0	Indicator: Store Locator Available in Web Shop
64	EXCH_PROF_GROUP	☐	CRM_ISA_EXCH_PRC_ATTR	CRM_ISA_EXCH_PROF_GRP	CHAR	6	0	Exchange Product Pricing-Related Attributes Profile Group	CRM_ISA_EXCH_PA
65	BOM_ENABLED	☐	CRMT_ISA_BOM_ENABLED	CRM_BOOLEAN	CHAR	1	0	Shop: BOM Explosion Permitted
66	BP_HIER_ENABLED	☐	CRMT_ISA_BP_HIERARCHY_ENABLED	CRM_BOOLEAN	CHAR	1	0	Shop: Order Management for Partners from BP Hierarchy
67	NEWS_TEMPL_ID	☐	CRMT_ISA_NEWSLETTER_SET_ID	KLASSE	CHAR	18	0	Attribute Set for Newsletter Registration
68	BACKORD_ENABLED	☐	CRMT_ISA_BACKORDER_SELECTION	CRM_BOOLEAN	CHAR	1	0	Display Backorder Selection Indicator
69	BASKLOAD_ENABLED	☐	CRMT_ECO_BASKETLOAD_ENABLED	CRM_BOOLEAN	CHAR	1	0	Enable Load Functionality for Stored Baskets
70	PAYMATBP_ENABLED	☐	CRMT_ECO_PAYMENT_AT_BP_ENABLED	CRM_BOOLEAN	CHAR	1	0	Activate Saving of Payment Data to the Business Partner
71	PAYMASK4COLLAUTH	☐	CRMT_ECO_PAYMENT_ASK4COLLAUTH	CRM_BOOLEAN	CHAR	1	0	Activate Query After Collection Authorization
72	MULTIP_CAMPAIGNS	☐	CRMT_ISA_MULTIPLE_CAMPAIGNS	CRM_BOOLEAN	CHAR	1	0	Flag, If Multiple Campaigns Are Allowed
73	ENROLLM_ENABLED	☐	CRMT_ISA_ENROLLMENT_ENABLED	CRM_BOOLEAN	CHAR	1	0	Enable Campaign Enrollment Functionality
74	TEXTID_CAMPDESCR	☐	TDID	TDID	CHAR	4	0	Text ID	TTXID
75	.INCLUDE	☐				0	0	structure for loyality management
76	ENABLE_LOY_PROG	☐	CRMT_ISA_LOYALITY_ENABLED	CRM_BOOLEAN	CHAR	1	0	Enable Loyalty Management
77	POINT_CODE	☐	COMT_PCAT_LOY_POINT_CODE		CHAR	31	0	Product Catalog - Point Type
78	REDEM_ORDER_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
79	BUYPT_ORDER_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
80	DISP_REWARD_CAT	☐	CRMT_ISA_LOY_DISP_REWARD_PCAT	CRM_BOOLEAN	CHAR	1	0	Display Reward Catalog for Anonymous User
81	DISP_EARN_POINTS	☐	CRMT_ISA_LOY_DISP_EARN_PTS	CRM_BOOLEAN	CHAR	1	0	Display Earn Points
82	REFUSERVARIABLE	☐	CRMT_ISA_SHOP_REFUSERVAR	XUBNAME	CHAR	12	0	Reference user variable used for B2C users	*
83	.INCLUDE	☐				0	0	Shop data with internal and external, in external format
84	CATALOG_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
85	VARIANT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
86	VIEW_ID	☐	COMT_PCAT_VIEW_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog View
87	TARGET_GRP_DESCR	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
88	CU_DEF_TG_DESCR	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
89	CU_GLOB_TG_DESCR	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
90	QUOTATION_MODE	☐	CRMT_ISA_QUOTATION_TYPE	CRM_ISA_QUOTATION_TYPE	CHAR	1	0	Quotation Selection in Shop
91	LOY_PROGRAMID	☐	CRM_MKTPL_LOYALTY_PROGRAMID	CGPL_EXTID	CHAR	24	0	Loyalty Program

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_ISA_SHOP_EXT	AUC_ORDER_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE
2	CRMT_ISA_SHOP_EXT	AUC_QUOTE_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE
3	CRMT_ISA_SHOP_EXT	CNT_FIELD_PROF	CRMC_ISA_CFP	CLIENT	REF	1	1
4	CRMT_ISA_SHOP_EXT	CNT_PROC_TYPE_GR	CRMC_ISA_PTG	CLIENT
5	CRMT_ISA_SHOP_EXT	COUNTRY_GROUP	CRMC_CNTRY_GRP	COUNTRY_GROUP
6	CRMT_ISA_SHOP_EXT	DOC_PRIC_PROC	CRMC_DPRICPROC	DOC_PRIC_PROC
7	CRMT_ISA_SHOP_EXT	EXCH_PROF_GROUP	CRM_ISA_EXCH_PA	EXCH_PROF_GROUP	KEY
8	CRMT_ISA_SHOP_EXT	METHOD_SCHEME_ID	CRMC_MKTIMG_MS_H	CLIENT	REF	1	CN
9	CRMT_ISA_SHOP_EXT	PART_FCT_CONTACT	CRMC_PARTNER_FCT	PARTNER_FCT
10	CRMT_ISA_SHOP_EXT	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE	REF	1	CN
11	CRMT_ISA_SHOP_EXT	PROC_TYPE_GR_ORD	CRMC_ISA_PTG	CLIENT
12	CRMT_ISA_SHOP_EXT	PROC_TYPE_GR_QUT	CRMC_ISA_PTG	CLIENT
13	CRMT_ISA_SHOP_EXT	PROC_TYPE_QUOTE	CRMC_PROC_TYPE	PROCESS_TYPE
14	CRMT_ISA_SHOP_EXT	REL_SHIP_GROUP	CRMC_ISA_RSG	REL_SHIP_GROUP
15	CRMT_ISA_SHOP_EXT	TEXTID_CAMPDESCR	TTXID	TDID
16	CRMT_ISA_SHOP_EXT	USER_STAT_PROC	TJ20	STSMA

History

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