SE11 ABAP Dictionary SE11 ESSR

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

ESSR

Service Entry Sheet Header Data

SAP SAP Transparent Table 52 Fields

Primary Key:

MANDT LBLNI

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	LBLNI	KEY	Entry Sh.	CHAR	10	-	-	Entry Sheet Number
3	LBLNE	-	Ext. No.	CHAR	16	-	-	External Entry Sheet Number
4	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
5	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
6	AEDAT	-	Chngd	DATS	8	-	-	Changed On
7	AENAM	-	By	CHAR	12	-	-	Name of Person Who Changed Object
8	SBNAMAG	-	PersRspInt	CHAR	12	-	-	Person Responsible (Internally)
9	SBNAMAN	-	PersRspExt	CHAR	12	-	-	Person Responsible (Externally)
10	DLORT	-	Location	CHAR	25	-	-	Location Where Service Was Performed
11	LBLDT	-	Ref. Date	DATS	8	-	-	Price Reference Date of Entry Sheet
12	LZVON	-	Period	DATS	8	-	-	Period
13	LZBIS	-	End	DATS	8	-	-	End of period
14	LWERT	-	Gross Val.	CURR	11	2	-	Value of Services
15	UWERT	-	Unplanned	CURR	11	2	-	Portion from Unplanned Services
16	UNPLV	-	Unpl. Val.	CURR	11	2	-	Portion Unplanned Value Without Reference to Contract
17	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
18	PACKNO	-	Number	NUMC	10	-	-	Package number
19	TXZ01	-	Short Text	CHAR	40	-	-	Short Text of Service Entry Sheet
20	EBELN	-	Purch.Doc.	CHAR	10	-	EKKO	Purchasing Document Number
21	EBELP	-	Item	NUMC	5	-	-	Item Number of Purchasing Document
22	LOEKZ	-	Delet.ind.	CHAR	1	-	-	Deletion indicator in entry sheet
23	KZABN	-	Acceptance	CHAR	1	-	-	Acceptance indicator
24	FINAL	-	Fin. Entry	CHAR	1	-	-	Indicator: Final Entry Sheet
25	FRGGR	-	Rel. group	CHAR	2	-	-	Release group
26	FRGSX	-	Strategy	CHAR	2	-	-	Release Strategy
27	FRGKL	-	Release	CHAR	1	-	-	Release indicator: Entry sheet
28	FRGZU	-	Rel.status	CHAR	8	-	-	Release status
29	FRGRL	-	Subj.to r.	CHAR	1	-	-	Release Not Yet Completely Effected
30	F_LOCK	-	Block	CHAR	1	-	-	Block Release of Entry Sheet
31	PWWE	-	Quality	DEC	3	-	-	Points score for quality of services
32	PWFR	-	Date	DEC	3	-	-	Points score for on-time delivery
33	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
34	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
35	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
36	BKTXT	-	Header Txt	CHAR	25	-	-	Document Header Text
37	KNTTP	-	AcctAssCat	CHAR	1	-	-	Account Assignment Category
38	KZVBR	-	Consumpt.	CHAR	1	-	-	Consumption Posting
39	NETWR	-	Net Value	CURR	11	2	-	Net Value of Entry Sheet
40	BANFN	-	Pur. Req.	CHAR	10	-	-	Purchase Requisition Number
41	BNFPO	-	Item	NUMC	5	-	-	Item number of purchase requisition
42	WARPL	-	MntPlan	CHAR	12	-	-	Maintenance Plan
43	WAPOS	-	MntItem	CHAR	16	-	-	Maintenance item
44	ABNUM	-	Call No.	INT4	10	-	-	Maintenance Plan Call Number
45	FKNUM	-	ShptCstNo.	CHAR	10	-	-	Shipment Cost Number
46	FKPOS	-	Item	NUMC	6	-	-	Shipment costs item
47	USER1	-	Comm. No.	CHAR	20	-	-	Technical Reference Field for External Entry Sheet Number
48	USER2	-	User field	CHAR	20	-	-	User field: Service entry sheet
49	NAVNW	-	Non-deductible input tax	CURR	11	2	-	Non-deductible input tax
50	SPEC_NO	-	Mod. Specs	CHAR	10	-	-	Number of a Set of Model Service Specifications
51	CUOBJ	-	Int.obj.no	NUMC	18	-	-	Configuration (internal object number)
52	LEMIN	-	SrvRet	CHAR	1	-	-	Returns Indicator

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk ESSR.

Interactive ERD Diagrams

SAP Procurement & MM Document Flow - MIRO Service PO Clearing →

Standard T-Codes

SE11 SE16

Related Tables

TCURC EKKO EKPO EKKN LFM1 LFB1 ESLL EKBE

ANSI SQL Query

SELECT a.LBLNI,
       a.LBLNE,
       a.ERNAM,
       a.ERDAT,
       a.AEDAT,
       a.AENAM
FROM ESSR AS a
WHERE a.LBLNI = '0001';

ABAP OpenSQL (7.40+)

SELECT a~lblni,
       a~lblne,
       a~ernam,
       a~erdat,
       a~aedat,
       a~aenam
  FROM essr AS a
  WHERE a~lblni = '0001'
  INTO TABLE @DATA(lt_essr)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 ESSR

ESSR

Dictionary Fields Fields

Related References & SQL