SAP ABAP Table EQSE (Serial Number Records)

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	TRANSP	Transparent table
Transparent table	EQSE	Table Relationship Diagram
Short Description	Serial Number Records

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	EQSNR	☑	EQSNR	EQSNR	CHAR	18	0	EQSE Number
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
9	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
10	STATUS	☐	SERSTATUS	SERSTATUS	CHAR	1	0	Status of Serial Number Managment
11	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
13	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
14	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
15	SDBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
16	WABELN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
17	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
18	HEQSNR	☐	HEQSNR	EQSNR	CHAR	18	0	Main Serial Number	EQSE
19	HSNPOS	☐	HSNPOS	HSNPOS	CHAR	4	0	Item in Superior Serial Number
20	HMATNR	☐	HMATNR	MATNR	CHAR	18	0	Material of Superior Serial Number	MARA
21	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
22	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EQSE	BLART	T003	BLART	KEY	1	CN
2	EQSE	CHARGE	MCHA	CHARG	KEY	1	CN
3	EQSE	EQUNR	EQUI	EQUNR	KEY	1	CN
4	EQSE	HEQSNR	EQSE	EQSNR	KEY	1	CN
5	EQSE	HMATNR	MARA	MATNR	KEY	1	CN
6	EQSE	KUNDE	KNA1	KUNNR	KEY	1	CN
7	EQSE	LAGER	T001L	LGORT	KEY	1	CN
8	EQSE	MANDT	T000	MANDT	KEY	1	CN
9	EQSE	MATNR	MARA	MATNR	KEY	1	CN
10	EQSE	SDBELN	VBUK	VBELN	KEY	1	CN
11	EQSE	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20060208
SAP Release Created in