SAP ABAP View V_EQUI_S (Equipment view (slimline version only EQUI and EQKT))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IEQM (Package) Application Develoment R/3 Equipment Management

Basic Data

View Type	D	Database View
Database View	V_EQUI_S
Short Description	Equipment view (slimline version only EQUI and EQKT)
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQKT
3	EQUZ
4	ILOA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EQUI	MANDT	JL	EQ				0	0
2	EQKT	MANDT	JR	EQ			AND	0	0
3	EQUI	EQUNR	JL	EQ				0	0
4	EQKT	EQUNR	JR	EQ			AND	0	0
5	EQKT	MANDT	JL	EQ				0	0
6	EQUZ	MANDT	JR	EQ			AND	0	0
7	EQKT	EQUNR	JL	EQ				0	0
8	EQUZ	EQUNR	JR	EQ			AND	0	0
9	EQUZ	MANDT	JL	EQ				0	0
10	ILOA	MANDT	JR	EQ			AND	0	0
11	EQUZ	ILOAN	JL	EQ				0	0
12	ILOA	ILOAN	JR	EQ				0	0

View Fields

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

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