SAP ABAP Table EQUZ (Equipment time 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

Table Category	TRANSP	Transparent table
Transparent table	EQUZ	Table Relationship Diagram
Short Description	Equipment time segment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	EQUI
3	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
4	EQLFN	☑	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
5	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
11	ESTAI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
12	ESTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
13	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
14	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
15	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
16	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
17	IWERKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
18	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
19	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
20	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
21	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
22	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
23	INGRPI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
24	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
25	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
26	GEWRKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
27	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
28	TIDNRI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
29	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
30	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
31	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
32	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
33	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
34	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
35	EZDAT	☐	EQDAT	DATUM	DATS	8	0	Date
36	EZBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
37	EZNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
38	RBNR_I	☐	INHER	INHER	CHAR	1	0	Data origin indicator
39	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
40	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
41	PVS_FOCUS	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
42	PPEGUID	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
43	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
44	FUNCID	☐	CCC_FUNCID	CHAR40	CHAR	40	0	Function Identifier
45	FRCFIT	☐	CCC_FRCFIT	XCHAR	CHAR	1	0	Indicator: Forced Installation/Dismantling
46	FRCRMV	☐	CCC_FRCRMV	XCHAR	CHAR	1	0	Force Dismantling Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EQUZ	EQUNR	EQUI	EQUNR	KEY	1	CN
2	EQUZ	GEWRK	CRID	OBJID	REF	C	CN
3	EQUZ	HEQUI	EQUI	EQUNR	REF	C	CN
4	EQUZ	ILOAN	ILOA	ILOAN	KEY	1	CN
5	EQUZ	INGRP	T024I	INGRP	REF	C	CN
6	EQUZ	IWERK	T399I	IWERK
7	EQUZ	KUND1	KNA1	KUNNR	KEY	1	CN
8	EQUZ	KUND2	KNA1	KUNNR	KEY	1	CN
9	EQUZ	KUND3	KNA1	KUNNR	KEY	1	CN
10	EQUZ	MANDT	T000	MANDT	KEY	1	CN
11	EQUZ	RBNR	T352B	RBNR	REF	C	CN
12	EQUZ	SUBMT	MARA	MATNR	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in