MMPUR_ANAEXTEKET - Consoludated Table for Central PO, Item, Scheduleline

Consoludated Table for Central PO, Item, Scheduleline information is stored in SAP table MMPUR_ANAEXTEKET.
It is part of development package ODATA_MM_ANALYTICS in software component MM-IS-PU-RPT. This development package consists of objects that can be grouped under "ODATA Services for MM Analytics".

Fields for table MMPUR_ANAEXTEKET

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
EBELN	Purchasing Document Number	X	EBELN	CHAR	20
EBELP	Item Number of Purchasing Document	X	EBELP	NUMC	10
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_HUB_ANA_OTHER_ATTRIBUT	0
ELIKZ	Indicator for Delivery Completion		MMPUR_ANA_DE_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
BPRME	Order Price Unit (Purchasing)		BBPRM	UNIT	6	*
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
LOEKZ_POHDR	Asset class marked for deletion		LOEKZ	CHAR	2
USERDESCRIPTION	Full Name of Person		AD_NAMTEXT	CHAR	160
EXTRACTIONDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	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	*
RESWK	Supplying (issuing) plant in case of stock transport order		RESWK	CHAR	8	*
.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				EXT_EKPO_INCL_EEW_PS	0
DUMMY_EXT_EKPO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Item		EKPO_INCL_EEW	CHAR	2
.INCLUDE				EXTN_EKKO_INCL_EEW_PS	0
DUMMY_EXTN_EKKO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Header		EKKO_INCL_EEW	CHAR	2
.INCLUDE				EXT_EKKO_INCL_EEW_PS	0
DUMMY_EXT_EKKO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Header		EKKO_INCL_EEW	CHAR	2