SAP ABAP View CRMV_ISAM_SHELP (Search Help for Vehicle)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IA-IC (Application Component) Automotive Interaction Center
     ⤷ CRM_IOBJECT_CIC (Package) Individual Object Development for the CIC

Basic Data

View Type	D	Database View
Database View	CRMV_ISAM_SHELP
Short Description	Search Help for Vehicle
Root table	ISAM_G_VEH_IDS	General Vehicle IDs

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ISAM_G_VEH_IDS	ISAM_G_VEH_IDS
2	COMM_PRODUCT
3	T000
4	ISAM_VEH_MODEL
5	ISAM_VEH_SPEC
6	COMM_PRSHTEXT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	COMM_PRODUCT	CLIENT	JL	EQ				0	0
2	ISAM_G_VEH_IDS	CLIENT	JR	EQ			AND	0	0
3	COMM_PRODUCT	PRODUCT_GUID	JL	EQ				0	0
4	ISAM_G_VEH_IDS	PRODUCT_GUID	JR	EQ			AND	0	0
5	T000	MANDT	JL	EQ				0	0
6	ISAM_G_VEH_IDS	CLIENT	JR	EQ			AND	0	0
7	COMM_PRODUCT	CLIENT	JL	EQ				0	0
8	ISAM_VEH_MODEL	CLIENT	JR	EQ			AND	0	0
9	COMM_PRODUCT	PRODUCT_GUID	JL	EQ				0	0
10	ISAM_VEH_MODEL	PRODUCT_GUID	JR	EQ			AND	0	0
11	COMM_PRODUCT	CLIENT	JL	EQ				0	0
12	ISAM_VEH_SPEC	CLIENT	JR	EQ			AND	0	0
13	COMM_PRODUCT	PRODUCT_GUID	JL	EQ				0	0
14	ISAM_VEH_SPEC	PRODUCT_GUID	JR	EQ			AND	0	0
15	COMM_PRODUCT	CLIENT	JL	EQ				0	0
16	COMM_PRSHTEXT	CLIENT	JR	EQ			AND	0	0
17	COMM_PRODUCT	PRODUCT_GUID	JL	EQ				0	0
18	COMM_PRSHTEXT	PRODUCT_GUID	JR	EQ			AND	0	0
19	COMM_PRODUCT	OBJECT_FAMILY		NE	' '		AND	0	0
20	COMM_PRODUCT	XNOSEARCH		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ISAM_G_VEH_IDS	CLIENT		☐	MANDT	☐	Client
2	PRODUCT_GUID	ISAM_G_VEH_IDS	PRODUCT_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
3	VIN	ISAM_G_VEH_IDS	VIN		☐	ISAM_VIN	☐	Vehicle Identification Number
4	LPNO	ISAM_G_VEH_IDS	LPNO		☐	ISAM_LICENSEPLATE_NO	☐	Vehicle Licence Plate Number
5	LPCOUNTR	ISAM_G_VEH_IDS	LPCOUNTR		☐	ISAM_LIPLATE_COUNTRY	☐	Vehicle Licence Plate Country
6	LPREGION	ISAM_G_VEH_IDS	LPREGION		☐	ISAM_LIPLATE_REGION	☐	Vehicle Licence Plate Region/State
7	BRAND	ISAM_VEH_MODEL	BRAND		☐	ISAM_BRAND	☐	Manufacturer
8	MODEL	ISAM_VEH_MODEL	MODEL		☐	ISAM_MODEL	☐	Vehicle Model
9	MODELKEY	ISAM_VEH_MODEL	MODELKEY		☐	ISAM_MODEL_KEY	☐	Model Key
10	MODELSUBT	ISAM_VEH_MODEL	MODELSUBT		☐	ISAM_MODEL_SUBTYPE	☐	Vehicle Model Subtype
11	MODELYEAR	ISAM_VEH_MODEL	MODELYEAR		☐	ISAM_MODEL_YEAR	☐	Vehicle Model Year
12	MANUFDATE	ISAM_VEH_SPEC	MANUFDATE		☐	ISAM_DATE_OF_MANUF	☐	Date of Vehicle Manufacture
13	ENGINEKEY	ISAM_VEH_SPEC	ENGINEKEY		☐	ISAM_ENGINE_KEY	☐	Engine Key
14	ENGPERFOR	ISAM_VEH_SPEC	ENGPERFOR		☐	ISAM_PERFORMANCE	☐	Engine Power
15	ENGPERFOR_U	ISAM_VEH_SPEC	ENGPERFOR_U		☐	ISAM_PERFORMANCE_U	☐	Engine Power Unit
16	CUBICCAPA	ISAM_VEH_SPEC	CUBICCAPA		☐	ISAM_CUBIC_CAPACITY	☐	Cubic Capacity
17	CUBICCAPA_U	ISAM_VEH_SPEC	CUBICCAPA_U		☐	ISAM_CUBIC_CAPACITY_U	☐	Cubic Capacity Unit
18	SHORT_TEXT	COMM_PRSHTEXT	SHORT_TEXT		☐	COMT_PRSHTEXTX	☐	Product Description
19	SHTEXT_LARGE	COMM_PRSHTEXT	SHTEXT_LARGE		☐	COMT_PRSHTEXTG	☐	Product Description in Uppercase for F4 Help
20	OBJECT_ID	COMM_PRODUCT	PRODUCT_ID		☐	COMT_PRODUCT_ID	☑	Product ID
21	OBJECT_FAMILY	COMM_PRODUCT	OBJECT_FAMILY		☐	COMT_PRODUCT_OBJECT_FAMILY	☐	Object Family
22	PRODUCT_TYPE	COMM_PRODUCT	PRODUCT_TYPE		☐	COMT_PRODUCT_TYPE	☐	Product Type
23	LOGSYS	COMM_PRSHTEXT	LOGSYS		☐	COMT_LOGSYS	☐	Original System
24	LANGU	COMM_PRSHTEXT	LANGU		☐	SPRAS	☐	Language Key

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	20130604
SAP Release Created in	400