SAP ABAP Table CRMM_ISA_SHOP_H (Header Data for a Shop)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMM_ISA_SHOP_H	Table Relationship Diagram
Short Description	Header Data for a Shop

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in