SAP ABAP Table MCESSR (Service Entry Sheet Header Data (PURCHIS/BW Interface))

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

Table Category	INTTAB	Structure
Structure	MCESSR	Table Relationship Diagram
Short Description	Service Entry Sheet Header Data (PURCHIS/BW Interface)

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	*
2	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
3	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	SBNAMAG	☐	SBNAMAG	SBNAM	CHAR	12	0	Person Responsible (Internally)
8	SBNAMAN	☐	SBNAMAN	SBNAM	CHAR	12	0	Person Responsible (Externally)
9	DLORT	☐	DLORT	TEXT25	CHAR	25	0	Location Where Service Was Performed
10	LBLDT	☐	LBLDT	DATUM	DATS	8	0	Price Reference Date of Entry Sheet
11	LZVON	☐	LZVON	DATUM	DATS	8	0	Period
12	LZBIS	☐	LZBIS	DATUM	DATS	8	0	End of period
13	LWERT	☐	LWERT	WERT11	CURR	11	2	Value of Services
14	UWERT	☐	NETWR_UNG	WERT11V	CURR	11	2	Portion from Unplanned Services
15	UNPLV	☐	UNPLV	WERT11V	CURR	11	2	Portion Unplanned Value Without Reference to Contract
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
18	TXZ01	☐	TXZ01_ESSR	TEXT40	CHAR	40	0	Short Text of Service Entry Sheet
19	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
20	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
21	LOEKZ	☐	LOEKZ_ESSR	ELOEK	CHAR	1	0	Deletion indicator in entry sheet
22	KZABN	☐	KZABN	CHAR01	CHAR	1	0	Acceptance indicator
23	FINAL	☐	FINAL	CHAR01	CHAR	1	0	Indicator: Final Entry Sheet
24	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
25	FRGSX	☐	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
26	FRGKL	☐	FRGKL	CHAR01	CHAR	1	0	Release indicator: Entry sheet
27	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
28	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
29	F_LOCK	☐	F_LOCK	XFELD	CHAR	1	0	Block Release of Entry Sheet
30	PWWE	☐	MC_PWWE	DEC3	DEC	3	0	Points score for quality of services
31	PWFR	☐	MC_PWFR	DEC3	DEC	3	0	Points score for on-time delivery
32	BLDAT	☐	BLDAT_SRV	DATUM	DATS	8	0	Document Date in Document
33	BUDAT	☐	BUDAT_SRV	DATUM	DATS	8	0	Posting Date in the Document
34	XBLNR	☐	XBLNR_SRV1	XBLNR1	CHAR	16	0	Reference Document Number
35	BKTXT	☐	BKTXT_SRV	TEXT25	CHAR	25	0	Document Header Text
36	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
37	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
38	NETWR	☐	NETWR_ESSR	WERT11	CURR	11	2	Net Value of Entry Sheet
39	BANFN	☐	BANFN_ESSR	BANFN	CHAR	10	0	Purchase Requisition Number
40	BNFPO	☐	BNFPO_ESSR	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
41	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
42	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
43	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
44	FKNUM	☐	FKNUM	FKNUM	CHAR	10	0	Shipment cost number	VFKK
45	FKPOS	☐	FKPOS	FKPOS	NUMC	6	0	Shipment costs item	VFKP
46	USER1	☐	ESSR_D	CHAR20	CHAR	20	0	Technical Reference Field for External Entry Sheet Number
47	USER2	☐	USR_ESSR	CHAR20	CHAR	20	0	User field: Service entry sheet
48	NAVNW	☐	NAVNW_SRV	WERT11V	CURR	11	2	Non-deductible input tax
49	SPEC_NO	☐	SPEC_NO	SPEC10	CHAR	10	0	Number of a Set of Model Service Specifications	*
50	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
51	LEMIN	☐	SRVRET	XFELD	CHAR	1	0	Returns Indicator
52	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCESSR	BNFPO	EBAN	BNFPO	REF	1	CN
2	MCESSR	EBELN	EKKO	EBELN
3	MCESSR	EBELP	EKPO	EBELP
4	MCESSR	FKNUM	VFKK	FKNUM
5	MCESSR	FKPOS	VFKP	FKPOS
6	MCESSR	FRGGR	T16FG	FRGGR
7	MCESSR	FRGSX	T16FS	FRGSX
8	MCESSR	KNTTP	T163K	KNTTP	REF	1	N
9	MCESSR	PACKNO	ESLH	PACKNO
10	MCESSR	WAERS	TCURC	WAERS
11	MCESSR	WARPL	MPLA	WARPL

History

Last changed by/on	SAP	20130529
SAP Release Created in	700