SAP ABAP View V_EQUI_EQBS_SML (Equipment master selection view including stock segment)

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_EQBS_SML
Short Description	Equipment master selection view including stock segment
Root table	EQUI	Equipment master data

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	EQUI	*		☐		☐
2	MANDT	EQUI	MANDT		☐	MANDT	☐	Client
3	EQUNR	EQUI	EQUNR		☐	EQUNR	☐	Equipment Number
4	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
5	ERNAM	EQUI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
6	EQASP	EQUI	EQASP		☐	EQASP	☐	Language in which the piece of equipment was entered
7	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
8	AENAM	EQUI	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
9	BEGRU	EQUI	BEGRU		☐	IAUTG	☐	Authorization Group for Technical Object
10	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
11	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
12	LVORM	EQUI	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
13	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
14	GROES	EQUI	GROES		☐	GROSS	☐	Size/dimension
15	BRGEW	EQUI	BRGEW		☐	OBJ_WEIGHT	☐	Weight of object
16	GEWEI	EQUI	GEWEI		☐	WEIGHT_UNIT	☐	Unit of weight
17	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
18	ANSWT	EQUI	ANSWT		☐	ANSWT	☐	Acquisition Value
19	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
20	ELIEF	EQUI	ELIEF		☐	ELIEF	☐	Vendor number
21	GWLEN	EQUI	GWLEN		☐	GWLEN	☐	Date on which the warranty ends
22	GWLDT	EQUI	GWLDT		☐	GWLDT	☐	Guarantee date
23	WDBWT	EQUI	WDBWT		☐	WDBWT	☐	Equipment replacement value
24	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
25	HERLD	EQUI	HERLD		☐	HERLD	☐	Country of manufacture
26	HZEIN	EQUI	HZEIN		☐	HZEIN	☐	Manufacturer drawing number
27	SERGE	EQUI	SERGE		☐	SERGE	☐	Manufacturer serial number
28	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
29	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
30	BAUMM	EQUI	BAUMM		☐	BAUMM	☐	Month of construction
31	APLKZ	EQUI	APLKZ		☐	APLKZ	☐	Indicator: Task List Exists
32	AULDT	EQUI	AULDT		☐	AULDT	☐	First delivery date of the equipment
33	INBDT	EQUI	INBDT		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
34	GERNR	EQUI	GERNR		☐	GERNR	☐	Serial Number
35	EQLFN	EQUI	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
36	GWLDV	EQUI	GWLDV		☐	GWLDV	☐	Warranty date for Sales and Distribution
37	EQDAT	EQUI	EQDAT		☐	EQDAT	☐	Date
38	EQBER	EQUI	EQBER		☐	EQBER	☐	Text for Notes
39	EQNUM	EQUI	EQNUM		☐	EQNUM	☐	Numerical Field
40	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number
41	EQSNR	EQUI	EQSNR		☐	EQSNR	☐	EQSE Number
42	CUOBJ	EQUI	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
43	KRFKZ	EQUI	KRFKZ		☐	KRFKZ	☐	Referenced Configuration
44	KMATN	EQUI	KMATN		☐	KMATN	☐	Configurable Material
45	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
46	SERNR	EQUI	SERNR		☐	GERNR	☐	Serial Number
47	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
48	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
49	CHARGE	EQUI	CHARGE		☐	CHARG_D	☐	Batch Number
50	KUNDE	EQUI	KUNDE		☐	KUNDSE	☐	Customer to Whom Serial Number was Delivered
51	WARPL	EQUI	WARPL		☐	WARPL	☐	Maintenance Plan
52	IMRC_POINT	EQUI	IMRC_POINT		☐	IMRC_POINT	☐	Measuring Point
53	REVLV	EQUI	REVLV		☐	REVLV	☐	Revision level
54	MGANR	EQUI	MGANR		☐	MGANR	☐	Master warranty number
55	BEGRUI	EQUI	BEGRUI		☐	INH_BEGRUI	☐	Data origin for authorization group field
56	S_EQUI	EQUI	S_EQUI		☐	EQUIP_KNZ	☐	Equipment
57	S_SERIAL	EQUI	S_SERIAL		☐	KZKSD	☐	Serial data when maintaining equipment
58	S_KONFI	EQUI	S_KONFI		☐	KONFKNZ	☐	Configuration supported
59	S_SALE	EQUI	S_SALE		☐	SDKNZ	☐	Sales equipment
60	S_FHM	EQUI	S_FHM		☐	FHMKZ	☐	Equip. category relevant to production resources and tools
61	S_ELSE	EQUI	S_ELSE		☐	ELSE_KNZ	☐	Indicator: Other Data Active
62	S_ISU	EQUI	S_ISU		☐	ISU_KNZ	☐	IS-U data
63	S_EQBS	EQUI	S_EQBS		☐	KZEQBS	☐	EQSI Exists
64	S_FLEET	EQUI	S_FLEET		☐	FLEET_KNZ	☐	Indicator: Fleet object active
65	BSTVP	EQUI	BSTVP		☐	BSTVP	☐	Stock Check for Serial Numbers
66	SPARTE	EQUI	SPARTE		☐	SPARTE	☐	Division
67	HANDLE	EQUI	HANDLE		☐	ITOBTMP_TSEGGUID	☐	SAP Development Reserve: Integration of Date Segment (Key)
68	TSEGTP	EQUI	TSEGTP		☐	ITOBTMP_TSEGTEMPLA	☐	SAP Development Reserve: Integration Date Segment (Template)
69	EMATN	EQUI	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
70	ACT_CHANGE_AA	EQUI	ACT_CHANGE_AA		☐	AAPM_ACT_CHANGE_AA	☐	Change Equipment Master when Changing Asset
71	S_CC	EQUI	S_CC		☐	CCC_KNZ	☐	Configuration Control Data
72	DATLWB	EQUI	DATLWB		☐	DATLWB	☐	Date of Last Goods Movement
73	UII	EQUI	UII		☐	UII_CHAR72	☐	Unique Item Identifier
74	IUID_TYPE	EQUI	IUID_TYPE		☐	IUID_TYPE	☐	Structure Type of UII
75	UII_PLANT	EQUI	UII_PLANT		☐	UII_PLANT	☐	Plant Responsible for UII
76	EQEXT_ACTIVE	EQUI	EQEXT_ACTIVE		☐	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	☐	Backpack Table /isdfps/lmeqext Active
77	EQUI_SRTYPE	EQUI	EQUI_SRTYPE		☐	COCF_SR_SRTYPE	☐	Shift Report Type
78	EQUI_SNTYPE	EQUI	EQUI_SNTYPE		☐	COCF_SN_SNTYPE	☐	Shift Note Type
79	EQLB_DUTY	EQUI	EQLB_DUTY		☐	DIACL_DUTY	☐	Logbook Duty
80	EQLB_HIDE	EQUI	EQLB_HIDE		☐	DIACL_HIDE	☐	Hide Logbook Display
81	*	EQBS	*		☐		☐
82	-	EQBS	MANDT		☐	MANDT	☐	Client
83	-	EQBS	EQUNR		☐	EQUNR	☐	Equipment Number
84	LBBSA	EQBS	LBBSA		☐	LBBSA	☐	Stock Type of Goods Movement (Primary Posting)
85	B_WERK	EQBS	B_WERK		☐	WERKS_D	☐	Plant
86	B_LAGER	EQBS	B_LAGER		☐	LGORT_D	☐	Storage location
87	B_CHARGE	EQBS	B_CHARGE		☐	B_CHARGE	☐	Batch Number
88	SOBKZ	EQBS	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
89	KUNNR	EQBS	KUNNR		☐	B_KUNNR	☐	Customer account number
90	LIFNR	EQBS	LIFNR		☐	B_LIFNR	☐	Account number of the vendor
91	KDAUF	EQBS	KDAUF		☐	KDAUF	☐	Sales Order Number
92	KDPOS	EQBS	KDPOS		☐	KDPOS	☐	Item number in Sales Order
93	PS_PSP_PNR	EQBS	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)

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