SAP ABAP View CRMV_LINK_CTYPE (Access to Customer Type)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-CTR (Application Component) Contracts
     ⤷ CRM_CONTRACT (Package) Functions for sales contracts

Basic Data

View Type	D	Database View
Database View	CRMV_LINK_CTYPE
Short Description	Access to Customer Type
Root table	CRMD_LINK	Transaction - Set - Link

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_LINK	CRMD_LINK
2	CRMD_PRICING
3	CRMD_ORDER_INDEX

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_PRICING	CLIENT	JL	EQ				0	0
2	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
3	CRMD_PRICING	GUID	JL	EQ				0	0
4	CRMD_LINK	GUID_SET	JR	EQ			AND	0	0
5	CRMD_LINK	CLIENT	JL	EQ				0	0
6	CRMD_ORDER_INDEX	CLIENT	JR	EQ			AND	0	0
7	CRMD_LINK	GUID_HI	JL	EQ				0	0
8	CRMD_ORDER_INDEX	HEADER	JR	EQ			AND	0	0
9	CRMD_LINK	OBJTYPE_HI		EQ	'05'		AND	0	0
10	CRMD_LINK	OBJTYPE_SET		EQ	'09'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	CRMD_ORDER_INDEX	*		☐		☐
2	CLIENT	CRMD_ORDER_INDEX	CLIENT		☐	MANDT	☐	Client
3	GUID	CRMD_ORDER_INDEX	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	HEADER	CRMD_ORDER_INDEX	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
5	ITEM	CRMD_ORDER_INDEX	ITEM		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
6	OBJECT_TYPE	CRMD_ORDER_INDEX	OBJECT_TYPE		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
7	PROCESS_TYPE_IX	CRMD_ORDER_INDEX	PROCESS_TYPE_IX		☐	CRMT_PROCESS_TYPE	☐	Business Transaction Type
8	CURR_PHASE	CRMD_ORDER_INDEX	CURR_PHASE		☐	CRMT_CURR_PHASE	☐	Sales Stage
9	IMPORTANCE	CRMD_ORDER_INDEX	IMPORTANCE		☐	CRMT_IMPORTANCE	☐	Opportunity/Lead Priority
10	PARTNER_NO	CRMD_ORDER_INDEX	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
11	SALES_ORG	CRMD_ORDER_INDEX	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
12	DIS_CHANNEL	CRMD_ORDER_INDEX	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
13	DIVISION	CRMD_ORDER_INDEX	DIVISION		☐	CRMT_DIVISION	☐	Division
14	SERVICE_ORG	CRMD_ORDER_INDEX	SERVICE_ORG		☐	CRMT_SERVICE_ORG	☐	Service Organization
15	SALES_OFFICE	CRMD_ORDER_INDEX	SALES_OFFICE		☐	CRMT_SALES_OFFICE	☐	Sales Office
16	SALES_GROUP	CRMD_ORDER_INDEX	SALES_GROUP		☐	CRMT_SALES_GROUP	☐	Sales Group
17	PURCH_ORG	CRMD_ORDER_INDEX	PURCH_ORG		☐	CRMT_PURCH_ORG	☐	Purchasing Organization
18	PO_NUMBER_UC	CRMD_ORDER_INDEX	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
19	STAT_OPEN	CRMD_ORDER_INDEX	STAT_OPEN		☐	CRMT_STATUS_OPEN	☐	Transaction is Still Open
20	STAT_PROCESS	CRMD_ORDER_INDEX	STAT_PROCESS		☐	CRMT_STATUS_PROCESS	☐	Postprocessing Required
21	STAT_RELEASED	CRMD_ORDER_INDEX	STAT_RELEASED		☐	CRMT_STATUS_RELEASED	☐	Status: Released
22	STAT_BILL	CRMD_ORDER_INDEX	STAT_BILL		☐	CRMT_STATUS_TO_BE_BILLED	☐	Select for Billing Document
23	STAT_SERVICE_DWP	CRMD_ORDER_INDEX	STAT_SERVICE_DWP		☐	CRMT_STATUS_SERVICE_DWP	☐	Selection Control Station
24	STAT_PLANNED	CRMD_ORDER_INDEX	STAT_PLANNED		☐	CRMT_STATUS_PLANNED	☐	Status: Planned
25	STAT_QUOT	CRMD_ORDER_INDEX	STAT_QUOT		☐	CRMT_BOOLEAN	☐	Logical Variable
26	PRIVATE_FLAG_IX	CRMD_ORDER_INDEX	PRIVATE_FLAG_IX		☐	CRMT_PRIVAT	☐	Indicator: Task is Private
27	STAT_INQ	CRMD_ORDER_INDEX	STAT_INQ		☐	CRMT_BOOLEAN	☐	Logical Variable
28	STAT_CREDIT	CRMD_ORDER_INDEX	STAT_CREDIT		☐	CRMT_STATUS_CRED	☐	Credit Block on Transaction
29	INVCR_DATE	CRMD_ORDER_INDEX	INVCR_DATE		☐	CRMT_INVCR_DATE	☐	Billing Document Creation Date
30	DATE_1	CRMD_ORDER_INDEX	DATE_1		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
31	DATE_2	CRMD_ORDER_INDEX	DATE_2		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
32	DATE_3	CRMD_ORDER_INDEX	DATE_3		☐	CRMT_CONTACT_FROM	☐	Time Stamp: Start of Customer Contact
33	DATE_4	CRMD_ORDER_INDEX	DATE_4		☐	CRMT_CONTACT_TO	☐	Time Stamp: End of Customer Contact
34	NO_APPT	CRMD_ORDER_INDEX	NO_APPT		☐	CRMT_BOOLEAN	☐	Logical Variable
35	PRODUCT_ID	CRMD_ORDER_INDEX	PRODUCT_ID		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
36	CATEGORY_ID	CRMD_ORDER_INDEX	CATEGORY_ID		☐	COMT_CATEGORY_ID	☐	Category ID
37	CATALOG_ID	CRMD_ORDER_INDEX	CATALOG_ID		☐	CRMT_CATALOG	☐	Catalog ID from which the line was selected
38	CATALOG_ITEM	CRMD_ORDER_INDEX	CATALOG_ITEM		☐	CRMT_CATALOGITEM	☐	Catalog Item (Unique Key)
39	DESCRIPT_PARTNER	CRMD_ORDER_INDEX	DESCRIPT_PARTNER		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner
40	NET_VALUE	CRMD_ORDER_INDEX	NET_VALUE		☐	CRMT_NET_VALUE_CUM	☐	Total Net Value of Document in Document Currency
41	CURRENCY	CRMD_ORDER_INDEX	CURRENCY		☐	CRMT_CURRENCY	☐	Currency
42	POSTING_DATE_HD	CRMD_ORDER_INDEX	POSTING_DATE_HD		☐	CRMT_POSTING_DATE	☐	Posting Date for a Business Transaction
43	PATH_ID	CRMD_ORDER_INDEX	PATH_ID		☐	CRMT_TERRITORY_PATH_ID	☐	Territory Hierarchy ID
44	IR_EXISTS	CRMD_ORDER_INDEX	IR_EXISTS		☐	CRMT_BOOLEAN	☐	Logical Variable
45	TEMPLATE_TYPE_IX	CRMD_ORDER_INDEX	TEMPLATE_TYPE_IX		☐	CRMT_TEMPLATE_TYPE_DB	☐	Template Type of CRM Transaction
46	OBJECT_TYPE_HDIX	CRMD_ORDER_INDEX	OBJECT_TYPE_HDIX		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
47	HEAD	CRMD_ORDER_INDEX	HEAD		☐	CRMT_BOOLEAN	☐	Logical Variable
48	PFT_0	CRMD_ORDER_INDEX	PFT_0		☐	CRMT_BOOLEAN	☐	Logical Variable
49	PFT_1	CRMD_ORDER_INDEX	PFT_1		☐	CRMT_BOOLEAN	☐	Logical Variable
50	PFT_2	CRMD_ORDER_INDEX	PFT_2		☐	CRMT_BOOLEAN	☐	Logical Variable
51	PFT_3	CRMD_ORDER_INDEX	PFT_3		☐	CRMT_BOOLEAN	☐	Logical Variable
52	PFT_4	CRMD_ORDER_INDEX	PFT_4		☐	CRMT_BOOLEAN	☐	Logical Variable
53	PFT_5	CRMD_ORDER_INDEX	PFT_5		☐	CRMT_BOOLEAN	☐	Logical Variable
54	PFT_6	CRMD_ORDER_INDEX	PFT_6		☐	CRMT_BOOLEAN	☐	Logical Variable
55	PFT_7	CRMD_ORDER_INDEX	PFT_7		☐	CRMT_BOOLEAN	☐	Logical Variable
56	PFT_8	CRMD_ORDER_INDEX	PFT_8		☐	CRMT_BOOLEAN	☐	Logical Variable
57	PFT_9	CRMD_ORDER_INDEX	PFT_9		☐	CRMT_BOOLEAN	☐	Logical Variable
58	PFT_10	CRMD_ORDER_INDEX	PFT_10		☐	CRMT_BOOLEAN	☐	Logical Variable
59	PFT_11	CRMD_ORDER_INDEX	PFT_11		☐	CRMT_BOOLEAN	☐	Logical Variable
60	PFT_12	CRMD_ORDER_INDEX	PFT_12		☐	CRMT_BOOLEAN	☐	Logical Variable
61	PFT_13	CRMD_ORDER_INDEX	PFT_13		☐	CRMT_BOOLEAN	☐	Logical Variable
62	PFT_14	CRMD_ORDER_INDEX	PFT_14		☐	CRMT_BOOLEAN	☐	Logical Variable
63	PFT_15	CRMD_ORDER_INDEX	PFT_15		☐	CRMT_BOOLEAN	☐	Logical Variable
64	PFT_16	CRMD_ORDER_INDEX	PFT_16		☐	CRMT_BOOLEAN	☐	Logical Variable
65	PFT_17	CRMD_ORDER_INDEX	PFT_17		☐	CRMT_BOOLEAN	☐	Logical Variable
66	PFT_18	CRMD_ORDER_INDEX	PFT_18		☐	CRMT_BOOLEAN	☐	Logical Variable
67	PFT_19	CRMD_ORDER_INDEX	PFT_19		☐	CRMT_BOOLEAN	☐	Logical Variable
68	PFT_20	CRMD_ORDER_INDEX	PFT_20		☐	CRMT_BOOLEAN	☐	Logical Variable
69	PFT_21	CRMD_ORDER_INDEX	PFT_21		☐	CRMT_BOOLEAN	☐	Logical Variable
70	PFT_22	CRMD_ORDER_INDEX	PFT_22		☐	CRMT_BOOLEAN	☐	Logical Variable
71	PFT_23	CRMD_ORDER_INDEX	PFT_23		☐	CRMT_BOOLEAN	☐	Logical Variable
72	PFT_24	CRMD_ORDER_INDEX	PFT_24		☐	CRMT_BOOLEAN	☐	Logical Variable
73	PFT_25	CRMD_ORDER_INDEX	PFT_25		☐	CRMT_BOOLEAN	☐	Logical Variable
74	PFT_26	CRMD_ORDER_INDEX	PFT_26		☐	CRMT_BOOLEAN	☐	Logical Variable
75	PFT_27	CRMD_ORDER_INDEX	PFT_27		☐	CRMT_BOOLEAN	☐	Logical Variable
76	PFT_28	CRMD_ORDER_INDEX	PFT_28		☐	CRMT_BOOLEAN	☐	Logical Variable
77	PFT_30	CRMD_ORDER_INDEX	PFT_30		☐	CRMT_BOOLEAN	☐	Logical Variable
78	PFT_32	CRMD_ORDER_INDEX	PFT_32		☐	CRMT_BOOLEAN	☐	Logical Variable
79	PFT_33	CRMD_ORDER_INDEX	PFT_33		☐	CRMT_BOOLEAN	☐	Logical Variable
80	PFT_34	CRMD_ORDER_INDEX	PFT_34		☐	CRMT_BOOLEAN	☐	Logical Variable
81	PFT_40	CRMD_ORDER_INDEX	PFT_40		☐	CRMT_BOOLEAN	☐	Logical Variable
82	PFT_41	CRMD_ORDER_INDEX	PFT_41		☐	CRMT_BOOLEAN	☐	Logical Variable
83	PFT_49	CRMD_ORDER_INDEX	PFT_49		☐	CRMT_BOOLEAN	☐	Logical Variable
84	PFT_50	CRMD_ORDER_INDEX	PFT_50		☐	CRMT_BOOLEAN	☐	Logical Variable
85	PFT_51	CRMD_ORDER_INDEX	PFT_51		☐	CRMT_BOOLEAN	☐	Logical Variable
86	PFT_52	CRMD_ORDER_INDEX	PFT_52		☐	CRMT_BOOLEAN	☐	Logical Variable
87	PFT_54	CRMD_ORDER_INDEX	PFT_54		☐	CRMT_BOOLEAN	☐	Logical Variable
88	PFT_55	CRMD_ORDER_INDEX	PFT_55		☐	CRMT_BOOLEAN	☐	Logical Variable
89	PFT_56	CRMD_ORDER_INDEX	PFT_56		☐	CRMT_BOOLEAN	☐	Logical Variable
90	PFT_57	CRMD_ORDER_INDEX	PFT_57		☐	CRMT_BOOLEAN	☐	Logical Variable
91	PFT_58	CRMD_ORDER_INDEX	PFT_58		☐	CRMT_BOOLEAN	☐	Logical Variable
92	PFT_37	CRMD_ORDER_INDEX	PFT_37		☐	CRMT_BOOLEAN	☐	Logical Variable
93	PFT_59	CRMD_ORDER_INDEX	PFT_59		☐	CRMT_BOOLEAN	☐	Logical Variable
94	PFT_62	CRMD_ORDER_INDEX	PFT_62		☐	CRMT_BOOLEAN	☐	Logical Variable
95	PFT_68	CRMD_ORDER_INDEX	PFT_68		☐	CRMT_BOOLEAN	☐	Logical Variable
96	PFT_69	CRMD_ORDER_INDEX	PFT_69		☐	CRMT_BOOLEAN	☐	Logical Variable
97	PFT_70	CRMD_ORDER_INDEX	PFT_70		☐	CRMT_BOOLEAN	☐	Logical Variable
98	MAINPARTNER	CRMD_ORDER_INDEX	MAINPARTNER		☐	CRMT_PARTNER_MAIN	☐	Main Partner (For Ambiguous Partner Functions)
99	PFT_46	CRMD_ORDER_INDEX	PFT_46		☐	CRMT_BOOLEAN	☐	Logical Variable
100	GUID_SET	CRMD_PRICING	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
101	CUSTOMER_TYPE	CRMD_PRICING	CUSTOMER_TYPE		☐	CRMT_CUSTOMER_TYPE	☐	Business Partner Type

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140117
SAP Release Created in	400