SAP ABAP View ESSR_REL (View for Collective Release of Service Entry Sheet)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ ML (Package) R/3 services management

Basic Data

View Type	D	Database View
Database View	ESSR_REL
Short Description	View for Collective Release of Service Entry Sheet
Root table	ESSR	Service Entry Sheet Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ESSR	ESSR
2	EKKO
3	EKPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKKO	MANDT	JL	EQ				0	0
2	ESSR	MANDT	JR	EQ			AND	0	0
3	EKKO	EBELN	JL	EQ				0	0
4	ESSR	EBELN	JR	EQ			AND	0	0
5	EKPO	MANDT	JL	EQ				0	0
6	ESSR	MANDT	JR	EQ			AND	0	0
7	EKPO	EBELN	JL	EQ				0	0
8	ESSR	EBELN	JR	EQ			AND	0	0
9	EKPO	EBELP	JL	EQ				0	0
10	ESSR	EBELP	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in