SAP ABAP View U_30099 (Connection)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U (Application Component) SAP Utilities
     ⤷ EE99 (Package) IS-U: Data Model

Basic Data

View Type	D	Database View
Database View	U_30099
Short Description	Connection
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EQKT	MANDT	JL	EQ				0	0
2	EQUI	MANDT	JR	EQ			AND	0	0
3	EQKT	EQUNR	JL	EQ				0	0
4	EQUI	EQUNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EQKT	MANDT		☐	MANDT	☐	Client
2	EQUNR	EQKT	EQUNR		☐	EQUNR	☐	Equipment Number
3	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
4	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
5	KZLTX	EQKT	KZLTX		☐	KZLTA	☐	Long Text Indicator
6	TXASP	EQKT	TXASP		☐	KZMLA	☐	Primary language indicator for text segment
7	EQKTU	EQKT	EQKTU		☐	EQKTU	☐	Equipment description in capital letters
8	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
9	ERNAM	EQUI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
10	EQASP	EQUI	EQASP		☐	EQASP	☐	Language in which the piece of equipment was entered
11	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
12	AENAM	EQUI	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
13	BEGRU	EQUI	BEGRU		☐	IAUTG	☐	Authorization Group for Technical Object
14	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
15	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
16	LVORM	EQUI	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
17	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
18	GROES	EQUI	GROES		☐	GROSS	☐	Size/dimension
19	BRGEW	EQUI	BRGEW		☐	OBJ_WEIGHT	☐	Weight of object
20	GEWEI	EQUI	GEWEI		☐	WEIGHT_UNIT	☐	Unit of weight
21	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
22	ANSWT	EQUI	ANSWT		☐	ANSWT	☐	Acquisition Value
23	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
24	ELIEF	EQUI	ELIEF		☐	ELIEF	☐	Vendor number
25	GWLEN	EQUI	GWLEN		☐	GWLEN	☐	Date on which the warranty ends
26	GWLDT	EQUI	GWLDT		☐	GWLDT	☐	Guarantee date
27	WDBWT	EQUI	WDBWT		☐	WDBWT	☐	Equipment replacement value
28	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
29	HERLD	EQUI	HERLD		☐	HERLD	☐	Country of manufacture
30	HZEIN	EQUI	HZEIN		☐	HZEIN	☐	Manufacturer drawing number
31	SERGE	EQUI	SERGE		☐	SERGE	☐	Manufacturer serial number
32	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
33	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
34	BAUMM	EQUI	BAUMM		☐	BAUMM	☐	Month of construction
35	APLKZ	EQUI	APLKZ		☐	APLKZ	☐	Indicator: Task List Exists
36	AULDT	EQUI	AULDT		☐	AULDT	☐	First delivery date of the equipment
37	INBDT	EQUI	INBDT		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
38	GERNR	EQUI	GERNR		☐	GERNR	☐	Serial Number
39	EQLFN	EQUI	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
40	GWLDV	EQUI	GWLDV		☐	GWLDV	☐	Warranty date for Sales and Distribution
41	EQDAT	EQUI	EQDAT		☐	EQDAT	☐	Date
42	EQBER	EQUI	EQBER		☐	EQBER	☐	Text for Notes
43	EQNUM	EQUI	EQNUM		☐	EQNUM	☐	Numerical Field
44	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number
45	EQSNR	EQUI	EQSNR		☐	EQSNR	☐	EQSE Number
46	CUOBJ	EQUI	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
47	KRFKZ	EQUI	KRFKZ		☐	KRFKZ	☐	Referenced Configuration
48	KMATN	EQUI	KMATN		☐	KMATN	☐	Configurable Material
49	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
50	SERNR	EQUI	SERNR		☐	GERNR	☐	Serial Number
51	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
52	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
53	CHARGE	EQUI	CHARGE		☐	CHARG_D	☐	Batch Number
54	KUNDE	EQUI	KUNDE		☐	KUNDSE	☐	Customer to Whom Serial Number was Delivered
55	WARPL	EQUI	WARPL		☐	WARPL	☐	Maintenance Plan
56	IMRC_POINT	EQUI	IMRC_POINT		☐	IMRC_POINT	☐	Measuring Point
57	REVLV	EQUI	REVLV		☐	REVLV	☐	Revision level
58	MGANR	EQUI	MGANR		☐	MGANR	☐	Master warranty number

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