SAP ABAP View /SAPCEM/V_VERSI (Insurance Data)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-EC-CEM (Application Component) Construction Equipment Management
     ⤷ /SAPCEM/PROG (Package) CEM Programs

Basic Data

View Type	D	Database View
Database View	/SAPCEM/V_VERSI
Short Description	Insurance Data
Root table	J_3GVERSI	Tax/Insurance Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	J_3GVERSI	J_3GVERSI
2	EQUI
3	EQKT
4	T099T
5	T099U

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	J_3GVERSI	MANDT	JL	EQ				0	0
2	EQUI	MANDT	JR	EQ			AND	0	0
3	J_3GVERSI	EQUNR	JL	EQ				0	0
4	EQUI	EQUNR	JR	EQ			AND	0	0
5	J_3GVERSI	MANDT	JL	EQ				0	0
6	EQKT	MANDT	JR	EQ			AND	0	0
7	J_3GVERSI	EQUNR	JL	EQ				0	0
8	EQKT	EQUNR	JR	EQ			AND	0	0
9	J_3GVERSI	MANDT	JL	EQ				0	0
10	T099T	MANDT	JR	EQ			AND	0	0
11	J_3GVERSI	J_3GVSART	JL	EQ				0	0
12	T099T	VSART	JR	EQ			AND	0	0
13	EQKT	SPRAS	JL	EQ				0	0
14	T099T	SPRAS	JR	EQ			AND	0	0
15	J_3GVERSI	MANDT	JL	EQ				0	0
16	T099U	MANDT	JR	EQ			AND	0	0
17	J_3GVERSI	VSGES	JL	EQ				0	0
18	T099U	VSGES	JR	EQ			AND	0	0
19	EQKT	SPRAS	JL	EQ				0	0
20	T099U	SPRAS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	J_3GVERSI	MANDT		☐	MANDT	☐	Client
2	EQUNR	J_3GVERSI	EQUNR		☐	EQUNR	☐	Equipment Number
3	J_3GVSART	J_3GVERSI	J_3GVSART		☐	J_3GVSART	☐	Insurance Type
4	J_3GANDAT	J_3GVERSI	J_3GANDAT		☐	J_3GANDAT	☐	Registration Date
5	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
6	J_3GORDNER	J_3GVERSI	J_3GORDNER		☐	J_3GORDNER	☐	File
7	VSGES	J_3GVERSI	VSGES		☐	AVGES	☐	Insurance companies
8	VSSTX	J_3GVERSI	VSSTX		☐	VSSTX	☐	Insurance policy number
9	J_3GABDAT	J_3GVERSI	J_3GABDAT		☐	J_3GABDAT	☐	Cancellation Date
10	J_3GVERSUM	J_3GVERSI	J_3GVERSUM		☐	J_3GVERSUM	☐	Amount Insured
11	J_3GVSWS	J_3GVERSI	J_3GVSWS		☐	WAERS	☐	Currency Key
12	WRBTR	J_3GVERSI	WRBTR		☐	WRBTR	☐	Amount in document currency
13	WAERS	J_3GVERSI	WAERS		☐	WAERS	☐	Currency Key
14	J_3GPERIOD	J_3GVERSI	J_3GPERIOD		☐	J_3GPERIOD	☐	Period of Portion of Insurance Contribution
15	J_3GDAUERB	J_3GVERSI	J_3GDAUERB		☐	J_3GDAUERB	☐	Indicator for Recurring Entry Document
16	BUKRS	J_3GVERSI	BUKRS		☐	BUKRS	☐	Company Code
17	J_3GDGJAHR	J_3GVERSI	J_3GDGJAHR		☐	J_3GDGJAHR	☐	Fiscal Year of Recurring Entry
18	J_3GDBELNR	J_3GVERSI	J_3GDBELNR		☐	J_3GDBELNR	☐	Number of Recurring Entry Document
19	J_3GLOEKZ	J_3GVERSI	J_3GLOEKZ		☐	J_3GLOEKZ	☐	Deletion Indicator
20	J_3GERNAM	J_3GVERSI	J_3GERNAM		☐	ERNAM	☐	Name of Person who Created the Object
21	J_3GERSDA	J_3GVERSI	J_3GERSDA		☐	ERSDA	☐	Created On
22	J_3GAENAM	J_3GVERSI	J_3GAENAM		☐	AENAM	☐	Name of Person Who Changed Object
23	J_3GLAEDA	J_3GVERSI	J_3GLAEDA		☐	LAEDA	☐	Date of Last Change
24	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
25	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
26	VRSTX	T099T	VRSTX		☐	VRSXT	☐	Insurance types description
27	VSGTX	T099U	VSGTX		☐	VSGTX	☐	Insurance companies description

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