SAP ABAP Table RIEQUI (Internal Structure for IEQUI)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IQSM (Package) Application Development R/3 Serial Numbers

Basic Data

Table Category	INTTAB	Structure
Structure	RIEQUI	Table Relationship Diagram
Short Description	Internal Structure for IEQUI

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in