SAP ABAP Table ESSR_REL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ESSR_REL	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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	LBLNI	☑	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type
7	LOEKZ_H	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
8	ERNAM_H	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
10	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
12	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
13	WAERS_H	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
15	VERKF	☐	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
16	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
17	FRGRL_H	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
18	LOEKZ_P	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
19	TXZ01_P	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
20	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
21	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
22	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
23	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
24	NETWR_P	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
25	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
26	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
27	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
28	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
29	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
30	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
31	PACKNO_P	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
32	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
33	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
34	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
35	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
36	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
37	LBLNE	☐	LBLNE1	XBLNR1	CHAR	16	0	External Entry Sheet Number
38	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
40	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
41	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
42	SBNAMAG	☐	SBNAMAG	SBNAM	CHAR	12	0	Person Responsible (Internally)
43	SBNAMAN	☐	SBNAMAN	SBNAM	CHAR	12	0	Person Responsible (Externally)
44	DLORT	☐	DLORT	TEXT25	CHAR	25	0	Location Where Service Was Performed
45	LBLDT	☐	LBLDT	DATUM	DATS	8	0	Price Reference Date of Entry Sheet
46	LZVON	☐	LZVON	DATUM	DATS	8	0	Period
47	LZBIS	☐	LZBIS	DATUM	DATS	8	0	End of period
48	LWERT	☐	LWERT	WERT11	CURR	11	2	Value of Services
49	UWERT	☐	NETWR_UNG	WERT11V	CURR	11	2	Portion from Unplanned Services
50	NETWR	☐	NETWR_ESSR	WERT11	CURR	11	2	Net Value of Entry Sheet
51	UNPLV	☐	UNPLV	WERT11V	CURR	11	2	Portion Unplanned Value Without Reference to Contract
52	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
53	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
54	TXZ01	☐	TXZ01_ESSR	TEXT40	CHAR	40	0	Short Text of Service Entry Sheet
55	LOEKZ	☐	LOEKZ_ESSR	ELOEK	CHAR	1	0	Deletion indicator in entry sheet
56	KZABN	☐	KZABN	CHAR01	CHAR	1	0	Acceptance indicator
57	FINAL	☐	FINAL	CHAR01	CHAR	1	0	Indicator: Final Entry Sheet
58	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
59	FRGSX	☐	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
60	FRGKL	☐	FRGKL	CHAR01	CHAR	1	0	Release indicator: Entry sheet
61	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
62	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
63	F_LOCK	☐	F_LOCK	XFELD	CHAR	1	0	Block Release of Entry Sheet
64	PWWE	☐	MC_PWWE	DEC3	DEC	3	0	Points score for quality of services
65	PWFR	☐	MC_PWFR	DEC3	DEC	3	0	Points score for on-time delivery
66	BLDAT	☐	BLDAT_SRV	DATUM	DATS	8	0	Document Date in Document
67	BUDAT	☐	BUDAT_SRV	DATUM	DATS	8	0	Posting Date in the Document
68	XBLNR	☐	XBLNR_SRV1	XBLNR1	CHAR	16	0	Reference Document Number
69	BKTXT	☐	BKTXT_SRV	TEXT25	CHAR	25	0	Document Header Text
70	KNTTP_ES	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
71	KZVBR_ES	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
72	BANFN_SH	☐	BANFN_ESSR	BANFN	CHAR	10	0	Purchase Requisition Number
73	BNFPO_SH	☐	BNFPO_ESSR	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
74	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
75	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
76	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
77	FKNUM	☐	FKNUM	FKNUM	CHAR	10	0	Shipment cost number	VFKK
78	FKPOS	☐	FKPOS	FKPOS	NUMC	6	0	Shipment costs item	VFKP
79	USER1	☐	ESSR_D	CHAR20	CHAR	20	0	Technical Reference Field for External Entry Sheet Number
80	USER2	☐	USR_ESSR	CHAR20	CHAR	20	0	User field: Service entry sheet
81	NAVNW_ES	☐	NAVNW_SRV	WERT11V	CURR	11	2	Non-deductible input tax
82	SPEC_NO	☐	SPEC_NO	SPEC10	CHAR	10	0	Number of a Set of Model Service Specifications
83	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESSR_REL	BNFPO	EBAN	BNFPO	REF	1	N
2	ESSR_REL	BNFPO_SH	EBAN	BNFPO	REF	1	CN
3	ESSR_REL	BUKRS	T001	BUKRS	REF	1	N
4	ESSR_REL	EKGRP	T024	EKGRP	REF	1	N
5	ESSR_REL	EKORG	T024E	EKORG	REF	1	N
6	ESSR_REL	FKNUM	VFKK	FKNUM
7	ESSR_REL	FKPOS	VFKP	FKPOS
8	ESSR_REL	FRGGR	T16FG	FRGGR
9	ESSR_REL	FRGSX	T16FS	FRGSX
10	ESSR_REL	KNTTP	T163K	KNTTP	REF	1	N
11	ESSR_REL	KNTTP_ES	T163K	KNTTP	REF	1	N
12	ESSR_REL	KONNR	EKKO	EBELN	REF	1	N
13	ESSR_REL	KTPNR	EKPO	EBELP	REF	1	N
14	ESSR_REL	LIFNR	LFA1	LIFNR	REF	1	N
15	ESSR_REL	MANDT	T000	MANDT	KEY	1	N
16	ESSR_REL	MATKL	T023	MATKL	REF	1	N
17	ESSR_REL	MEINS	T006	MSEHI	REF	1	N
18	ESSR_REL	PACKNO	ESLH	PACKNO
19	ESSR_REL	PACKNO_P	ESLH	PACKNO	KEY	1	N
20	ESSR_REL	PSTYP	T163	PSTYP	REF	1	N
21	ESSR_REL	SPRAS	T002	SPRAS	REF	1	N
22	ESSR_REL	WAERS	TCURC	WAERS	REF	1	N
23	ESSR_REL	WAERS_H	TCURC	WAERS	REF	1	N
24	ESSR_REL	WARPL	MPLA	WARPL
25	ESSR_REL	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in