MMPUR_ANA_EKET - Analytical Data for Schedule Lines

Analytical Data for Schedule Lines information is stored in SAP table MMPUR_ANA_EKET.
It is part of development package ME in software component MM-PUR. This development package consists of objects that can be grouped under "Purchasing".

Fields for table MMPUR_ANA_EKET

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
EBELN	Purchasing Document Number	X	EBELN	CHAR	20	EKKO
EBELP	Item Number of Purchasing Document	X	EBELP	NUMC	10	EKPO
ETENR	Schedule Line Number	X	ETENR	NUMC	8
BE_SOURCE_SYS	Connected System ID	X	MMPUR_D_SOURCE_SYS	CHAR	20
UNIQUEID	Schedule line id(Concatenation of EBELN, EBELP, EETEN)		PURGDOCSCHEDULELINEUNIQUEID	CHAR	38
.INCLUDE				MMPUR_S_ANA_REPCURR_ATTR	0
NETWR_SL_REPCURR1	Net Amount (in Reporting Currency 1)		BWERT_REPCRCY1	CURR	11
NETWR_SL_REPCURR2	Net Amount (in Reporting Currency 2)		BWERT_REPCRCY2	CURR	11
WAERS_REPCURR1	Reporting Currency 1		WAERS_REPCURR1	CUKY	10	*
WAERS_REPCURR2	Reporting Currency 2		WAERS_REPCURR2	CUKY	10	*
NETWR	Net Order Value in PO Currency		BWERT	CURR	7
WAERS	Currency Key		WAERS	CUKY	10	*
NETWR_BASE	Net Amount in Company Currency		BWERT_BASECURR	CURR	11
WAERS_BASE	Company Currency		WAERS_BASECURR	CUKY	10	*
OBMNG	Open Quantity		OBMNG	QUAN	7
OBMNG_NETWR_REPCURR1	Open Amount (in Reporting Currency 1)		OBMNG_REPCURR1	CURR	11
OBMNG_NETWR_REPCURR2	Open Amount (in Reporting Currency 2)		OBMNG_REPCURR2	CURR	11
OBMNG_NETWR_BASE	Open Amount (in Company Currency)		OBMNG_BASECURR	CURR	11
OBMNG_NETWR	Open Amount (in Document Currency)		OBMNG_CURR	CURR	11
MEINS	Purchase Order Unit of Measure		BSTME	UNIT	6	*
NETPR_REPCURR1	Net Price: Reporting Currency 1		NETPR_REPCRCY1	CURR	11
NETPR_REPCURR2	Net Price: Reporting Currency 2		NETPR_REPCRCY2	CURR	11
NETPR_BASE	Net Price: Company Currency		NETPR_BASECURR	CURR	11
.INCLUDE				MMPUR_S_ANA_DIMENSION_ATTR	0
EKORG	Purchasing organization		EKORG	CHAR	8	*
EKGRP	Purchasing Group		EKGRP	CHAR	6	*
BUKRS	Company Code		BUKRS	CHAR	8
WERKS	Plant		EWERK	CHAR	8	*
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
MATNR	Material Number		MATNR	CHAR	80
MATKL	Material Group		MATKL	CHAR	18
SERVICEPERFORMER	Service Performer		SERVICEPERFORMER	CHAR	20	*
.INCLUDE				MMPUR_S_ANA_OTHER_ATTRIBUTES	0
ELIKZ	"Delivery Completed" Indicator		ELIKZ	CHAR	2
WEPOS	Goods Receipt Indicator		WEPOS	CHAR	2
LOEKZ	Asset class marked for deletion		LOEKZ	CHAR	2
MEMORY	Purchase order not yet complete		MEMER	CHAR	2
BSTYP	Purchasing Document Category		BSTYP	CHAR	2
BSART	Order Type (Purchasing)		BSART	CHAR	8	*
PSTYP	Item category in purchasing document		PSTYP	CHAR	2	*
KTPNR	Item number of principal purchase agreement		KTPNR	NUMC	10	*
KNTTP	Account Assignment Category		KNTTP	CHAR	2	*
VRTKZ	Distribution Indicator for Multiple Account Assignment		VRTKZ	CHAR	2
KONNR	Number of principal purchase agreement		KONNR	CHAR	20	*
AEDAT	Last Changed On		AEDAT	DATS	16
STATU	Status of Purchasing Document		ESTAK	CHAR	2
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
LASTCHANGEDATETIME	Change Time Stamp		CHANGEDATETIME	DEC	11
PROCSTAT	Purchasing document processing state		MEPROCSTATE	CHAR	4
BEDAT_POHDR	Purchasing Document Date		EBDAT	DATS	16
ISAGED	Document is aged		MMPUR_ISAGED	CHAR	2
MENGE_EKPO	Purchase Order Quantity		BSTMG	QUAN	7
MEINS_EKPO	Purchase Order Unit of Measure		BSTME	UNIT	6	*
BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit		BPUMZ	DEC	3
BPUMN	Denominator for Conv. of Order Price Unit into Order Unit		BPUMN	DEC	3
NETPR	Net Price in Purchasing Document (in Document Currency)		BPREI	CURR	6
RETPO	Returns Item		RETPO	CHAR	2
PEINH	Price unit		EPEIN	DEC	3
PRODUCTTYPE	Product Type Group		PRODUCT_TYPE	CHAR	4
FRGRL	Release Not Yet Completely Effected		FRGRL	CHAR	2
FINALSCHEDULELINE	Final Schedule Line for the Purchase Order Item		MMPUR_ANA_FINAL_SCHEDLINE_IND	CHAR	2
TOTALEXPECTEDQUANTITY	Expected Quantity		MMPUR_ANA_TOTAL_EXPECTED_QTY	QUAN	7
LASTEXPECTEDQUANTITY	Expected Quantity		MMPUR_ANA_PREV_EXPECTED_QTY	QUAN	7
NDD	Indicator for Next Delivery Line		NEXT_DELIVERY_LINE_FLAG	CHAR	2
LOEKZ_POHDR	Asset class marked for deletion		LOEKZ	CHAR	2
FIRSTGRPOSTINGDATE	First Goods Receipt Date		MMPUR_A_POI_FIRSTGRPOSTGDATE	DATS	16
FINALGRPOSTINGDATE	Final Goods Receipt Date		MMPUR_A_POI_FINALGRPOSTGDATE	DATS	16
TIMEVARIANCESCORE	Variance Score for Statistical Delivery Date		MM_A_TIMEVAR_SCORE_STATDELIV	DEC	2
TIMEVARIANCESCOREBYDELIVDATE	MM_A_TIMEVARC_SCORE_DELIV_DATE		MM_A_TIMEVARC_SCORE_DELIV_DATE	DEC	2
TIMEVARIANCEINDAYS	Overdue days		MM_A_OVERDUE_DAYS	INT4	4
TIMEVARIANCEINPCT	Variance % for Statistical Delivery Date		MM_A_TIMEVAR_STATDELIV_PCT	DEC	3
TIMEVARIANCEINPCTBYDELIVDATE	Variance for Delivery Date		MM_A_VARIANCE_DELIVERY_PCT	DEC	8
UMREZ	Numerator for Conversion of Order Unit to Base Unit		UMBSZ	DEC	3
UMREN	Denominator for Conversion of Order Unit to Base Unit		UMBSN	DEC	3
LMEIN	Base Unit of Measure		LAGME	UNIT	6	*
BPRME	Order Price Unit (Purchasing)		BBPRM	UNIT	6	*
RESWK	Supplying (issuing) plant in case of stock transport order		RESWK	CHAR	8	*
WEBRE	Indicator: GR-Based Invoice Verification		WEBRE	CHAR	2
.INCLUDE				MMPUR_ANA_EKETDATA	0
EINDT	Item delivery date		EINDT	DATS	16
SLFDT	Statistics-Relevant Delivery Date		SLFDT	DATS	16
LPEIN	Category of delivery date		LPEIN	CHAR	2	TPRG
MENGE	Scheduled Quantity		ETMEN	QUAN	7
AMENG	Previous Quantity (Delivery Schedule Lines)		VOMNG	QUAN	7
WEMNG	Quantity of goods received		WEEMG	QUAN	7
WAMNG	Issued Quantity		WAMNG	QUAN	7
UZEIT	Delivery Date Time-Spot		LZEIT	TIMS	12
BANFN	Purchase Requisition Number		BANFN	CHAR	20
BNFPO	Item number of purchase requisition		BNFPO	NUMC	10	EBAN
ESTKZ	Creation indicator (purchase requisition/schedule lines)		ESTKZ	CHAR	2
MAHNZ	No. of Reminders/Expediters for Schedule Line		MAHNZE	DEC	2
BEDAT	Order date of schedule line		ETBDT	DATS	16
FIXKZ	Schedule Line is "Fixed"		ETFIX	CHAR	2
ABART	Scheduling agreement release type		MEABART	CHAR	2
MNG02	Committed Quantity		MNG06	QUAN	7
DAT01	Committed date		DAT05	DATS	16
ALTDT	Previous delivery date		ALTDT	DATS	16
MBDAT	Material Staging/Availability Date		MBDAT	DATS	16
MBUHR	Material Staging Time (Local, Relating to a Plant)		MBUHR	TIMS	12
LDDAT	Loading Date		LDDAT	DATS	16
LDUHR	Loading Time (Local Time Relating to a Shipping Point)		LDUHR	TIMS	12
TDDAT	Transportation Planning Date		TDDAT_D	DATS	16
TDUHR	Transp. Planning Time (Local, Relating to a Shipping Point)		TDUHR	TIMS	12
WADAT	Goods Issue Date		WADAT	DATS	16
WAUHR	Time of Goods Issue (Local, Relating to a Plant)		WAUHR	TIMS	12
ELDAT	Goods Receipt End Date		ELDAT	DATS	16
ELUHR	Goods Receipt End Time (Local, Relating to a Plant)		ELUHR	TIMS	12
STARTDATE	Start Date for Period of Performance		MMPUR_SERVPROC_PERIOD_START	DATS	16
ENDDATE	End Date for Period of Performance		MMPUR_SERVPROC_PERIOD_END	DATS	16
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
GJAHR	Material Document Year		MJAHR	NUMC	8
BELNR	Number of Material Document		MBLNR	CHAR	20
BUZEI	Item in Material Document		MBLPO	NUMC	8
BUDAT	Posting Date in the Document		BUDAT	DATS	16
.INCLUDE				EKKO_INCL_EEW_PS	0
DUMMY_EKKO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Header		EKKO_INCL_EEW	CHAR	2
.INCLUDE				EKPO_INCL_EEW_PS	0
DUMMY_EKPO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Item		EKPO_INCL_EEW	CHAR	2