SAP ABAP Table CRMT_BSP_IOB_ISA_ODC_VEHICLE (Vehicle Complete structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO-PCU (Application Component) People-Centric UI (Product)
     ⤷ CRM_ISA_VEHICLE_WB (Package) Automotive: Vehicle Workbench People Centric UI

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_IOB_ISA_ODC_VEHICLE	Table Relationship Diagram
Short Description	Vehicle Complete structure

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
3	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
4	OBJECT_ID	☐	CRMT_BSP_ISA_VEHICLE_ID	COM_PRODUCT_ID	CHAR	40	0	Vehicle ID
5	IOBJECT_DESC	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
6	.INCLUDE	☐				0	0	Vehicle Model Extension
7	BRAND	☐	ISAM_BRAND	ISAM_BRAND	CHAR	10	0	Manufacturer
8	MODEL	☐	ISAM_MODEL	ISAM_MODEL	CHAR	40	0	Vehicle Model
9	MODELKEY	☐	ISAM_MODEL_KEY	ISAM_MODEL_KEY	CHAR	10	0	Model Key
10	MODELSUBT	☐	ISAM_MODEL_SUBTYPE	ISAM_MODEL_SUBTYPE	CHAR	30	0	Vehicle Model Subtype
11	MODELYEAR	☐	ISAM_MODEL_YEAR	ISAM_MODEL_YEAR	CHAR	4	0	Vehicle Model Year
12	.INCLUDE	☐				0	0	General Vehicle IDs
13	VIN	☐	ISAM_VIN	ISAM_VIN	CHAR	35	0	Vehicle Identification Number
14	LPNO	☐	ISAM_LICENSEPLATE_NO	ISAM_LICENSEPLATE_NO	CHAR	15	0	Vehicle Licence Plate Number
15	LPCOUNTR	☐	ISAM_LIPLATE_COUNTRY	LAND1	CHAR	3	0	Vehicle Licence Plate Country	T005
16	LPREGION	☐	ISAM_LIPLATE_REGION	REGIO	CHAR	3	0	Vehicle Licence Plate Region/State	T005S
17	.INCLUDE	☐				0	0	Other Vehicle IDs Extension
18	EXTVEHNO	☐	ISAM_EXTERNAL_VEH_NO	ISAM_EXTERNAL_VEH_NO	CHAR	35	0	External Vehicle Number
19	INTVEHNO	☐	ISAM_INTERNAL_VEH_NO	ISAM_INTERNAL_VEH_NO	CHAR	10	0	Internal Vehicle Number
20	ALTVEHNO	☐	ISAM_ALTERNATIVE_NO	ISAM_ALTERNATIVE_NO	CHAR	35	0	Alternative Identifier for Vehicle
21	.INCLUDE	☐				0	0	Third Party Extension
22	PRICE	☐	ISAM_PRICE	ISAM_PRICE	CURR	8	2	Price of the vehicle
23	PRICE_C	☐	ISAM_PRICE_C	WAERS	CUKY	5	0	Vehicle Price	TCURC
24	USEDVEH	☐	ISAM_USED_VEHICLE	ISAM_USED_VEHICLE	CHAR	1	0	Used Vehicle
25	MANUFDATE	☐	ISAM_DATE_OF_MANUF	ISAM_DATE_OF_MANUF	DATS	8	0	Date of Vehicle Manufacture
26	ENGINEKEY	☐	ISAM_ENGINE_KEY	ISAM_ENGINE_KEY	CHAR	10	0	Engine Key
27	ENGPERFOR	☐	ISAM_PERFORMANCE	ISAM_PERFORMANCE	QUAN	4	0	Engine Power
28	ENGPERFOR_U	☐	ISAM_PERFORMANCE_U	MEINS	UNIT	3	0	Engine Power Unit	*
29	ENGPERFOR_U_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
30	CUBICCAPA	☐	ISAM_CUBIC_CAPACITY	ISAM_CUBIC_CAPACITY	QUAN	6	1	Cubic Capacity
31	CUBICCAPA_U	☐	ISAM_CUBIC_CAPACITY_U	MEINS	UNIT	3	0	Cubic Capacity Unit	*
32	CUBICCAPA_U_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
33	FUELTYPE	☐	ISAM_FUEL_TYPE	ISAM_FUEL_TYPE	CHAR	1	0	Fuel Type
34	TRANSMKEY	☐	ISAM_TYPE_OF_TRM_KEY	ISAM_TYPE_OF_TRM_KEY	CHAR	3	0	Type of Transmission Key
35	TRANSMTYP	☐	ISAM_TRANSMISSION_TY	ISAM_TRANSMISSION_TY	CHAR	10	0	Type of Transmission
36	INTCOLOR	☐	ISAM_INTERIOR_COLOR	ISAM_INTERIOR_COLOR	CHAR	10	0	Vehicle Interior Color
37	EXTCOLKEY	☐	ISAM_EXTER_COLOR_KEY	ISAM_EXTER_COLOR_KEY	CHAR	6	0	Vehicle Exterior Color Key
38	EXTCOLOR	☐	ISAM_EXTERIOR_COLOR	ISAM_EXTERIOR_COLOR	CHAR	10	0	Vehicle Exterior Color
39	REGDATE	☐	ISAM_INIT_REG_DATE	ISAM_INIT_REG_DATE	DATS	8	0	Vehicle Initial Registration Date
40	COMMENT1	☐	ISAM_COMMENT_1	ISAM_COMMENT_1	CHAR	60	0	Comment 1
41	INTCOLKEY	☐	ISAM_INTER_COLOR_KEY	ISAM_INTER_COLOR_KEY	CHAR	6	0	Vehicle Interior Color Key
42	PRREF	☐	COMT_REF_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
43	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_IOB_ISA_ODC_VEHICLE	LPCOUNTR	T005	LAND1
2	CRMT_BSP_IOB_ISA_ODC_VEHICLE	LPREGION	T005S	BLAND
3	CRMT_BSP_IOB_ISA_ODC_VEHICLE	PRICE_C	TCURC	WAERS

History

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