SAP ABAP Table V_EQUI_EQBS_SML (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EQUI_EQBS_SML	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_EQUI_EQBS_SML	BEGRU	T370B	BEGRU	REF	C	CN
2	V_EQUI_EQBS_SML	B_LAGER	T001L	LGORT
3	V_EQUI_EQBS_SML	B_WERK	T001W	WERKS
4	V_EQUI_EQBS_SML	CHARGE	MCH1	CHARG
5	V_EQUI_EQBS_SML	ELIEF	LFA1	LIFNR	REF	1	CN
6	V_EQUI_EQBS_SML	EQART	T370K	EQART	REF	C	CN
7	V_EQUI_EQBS_SML	EQASP	T002	SPRAS	KEY	1	CN
8	V_EQUI_EQBS_SML	EQSNR	EQSE	EQSNR	KEY	1	C
9	V_EQUI_EQBS_SML	EQTYP	T370T	EQTYP	REF	1	CN
10	V_EQUI_EQBS_SML	EQUI_SNTYPE	TQ80	QMART	KEY	1	CN
11	V_EQUI_EQBS_SML	EQUI_SRTYPE	COCF_CU_SRTYPE	SRTYPE	KEY	1	CN
12	V_EQUI_EQBS_SML	GEWEI	T006	MSEHI	REF	1	CN
13	V_EQUI_EQBS_SML	HERLD	T005	LAND1	REF	1	CN
14	V_EQUI_EQBS_SML	IMRC_POINT	IMPTT	POINT
15	V_EQUI_EQBS_SML	IUID_TYPE	TIUID_TYPE	IUID_TYPE
16	V_EQUI_EQBS_SML	KDAUF	VBUK	VBELN
17	V_EQUI_EQBS_SML	KMATN	MARA	MATNR	REF	1	CN
18	V_EQUI_EQBS_SML	KUNDE	KNA1	KUNNR
19	V_EQUI_EQBS_SML	KUNNR	KNA1	KUNNR
20	V_EQUI_EQBS_SML	LAGER	T001L	LGORT
21	V_EQUI_EQBS_SML	LBBSA	T156C	LBBSA
22	V_EQUI_EQBS_SML	LIFNR	LFA1	LIFNR
23	V_EQUI_EQBS_SML	MANDT	T000	MANDT	KEY	1	CN
24	V_EQUI_EQBS_SML	MATNR	MARA	MATNR
25	V_EQUI_EQBS_SML	MGANR	BGMK	MGANR
26	V_EQUI_EQBS_SML	SOBKZ	T148	SOBKZ
27	V_EQUI_EQBS_SML	SPARTE	TSPA	SPART	KEY	1	CN
28	V_EQUI_EQBS_SML	WAERS	TCURC	WAERS	REF	1	CN
29	V_EQUI_EQBS_SML	WARPL	MPLA	WARPL
30	V_EQUI_EQBS_SML	WERK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in