Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

MCEX_PO_HIST_MAA_S SAP (BW: Purchase Order History MAA) Structure details

Dictionary Type: Structure
Description: BW: Purchase Order History MAA

ABAP Code to SELECT data from MCEX_PO_HIST_MAA_S
Related tables to MCEX_PO_HIST_MAA_S
Access table MCEX_PO_HIST_MAA_S

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

MCEX_PO_HIST_MAA_S is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "BW: Purchase Order History MAA" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MCEX_PO_HIST_MAA_S TYPE MCEX_PO_HIST_MAA_S.

The MCEX_PO_HIST_MAA_S table consists of various fields, each holding specific information or linking keys about BW: Purchase Order History MAA data available in SAP. These include BEDAT (Purchasing Document Date), BSART (Purchasing Document Type), BSTYP (Purchasing Document Category), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MCEX_PO_HIST_MAA_S structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
BEDAT	Purchasing Document Date	EBDAT	DATS	8			DATUM
BSART	Purchasing Document Type	ESART	CHAR	4	Assigned to domain		BSART	BSA
BSTYP	Purchasing Document Category	BSTYP	CHAR	1			BSTYP
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
EBELN	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
EKGRP	Purchasing Group	BKGRP	CHAR	3	Assigned to domain		EKGRP	EKG
EKORG	Purchasing Organization	EKORG	CHAR	4	Assigned to domain		EKORG	EKO
HWAER	Local Currency	HWAER	CUKY	5	Assigned to domain		WAERS
KDATB	Start of Validity Period	KDATB	DATS	8			DATUM
KDATE	End of Validity Period	KDATE	DATS	8			DATUM
LIFNR	Vendor Account Number	ELIFN	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
LIFRE	Different Invoicing Party	LIFRE	CHAR	10	Assigned to domain	ALPHA	LIFNR	LRE
LLIEF	Supplying Vendor	LLIEF	CHAR	10	Assigned to domain	ALPHA	LIFNR	LLI
LOGSY	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
ORGLOGSY	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
RESWK	Supplying (Issuing) Plant in Stock Transport Order	RESWK	CHAR	4	Assigned to domain		WERKS
STATU	Status of Purchasing Document	ESTAK	CHAR	1			ESTAK
SYDAT	Date on which the purchasing document was entered	MC_ERFDAT	DATS	8			DATUM
WAERS	Purchase order currency	BSTWA	CUKY	5	Assigned to domain		WAERS
WKURS	Exchange Rate	WKURS	DEC	9(5)		EXCRT	KURSP
AFNAM	Name of Requisitioner/Requester	AFNAM	CHAR	12			AFNAM
AKTNR	COUPON	WAKTION	CHAR	10	Assigned to domain	ALPHA	WAKTION	WAK
BSGRU	Reason for Ordering	BSGRU	CHAR	3			BSGRU
BWAPPLNM	Application Component	RSAPPLNM	CHAR	30			RSAPPLNM
BWVORG	SAP BW transaction key	MCW_BWVORG	NUMC	3			NUM3
EBELP	Item Number of Purchasing Document	EBELP	NUMC	5	Assigned to domain		EBELP	BSP
ELIKZ	'Delivery Completed' Indicator	ELIKZ	CHAR	1			XFELD
EMATN	Material Number	EMATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT
EREKZ	Final Invoice Indicator	EREKZ	CHAR	1			XFELD
KNTTP	Account Assignment Category	KNTTP	CHAR	1	Assigned to domain		KNTTP	KNT
KONNR	Number of Principal Purchase Agreement	KONNR	CHAR	10	Assigned to domain	ALPHA	EBELN	KTR
KTPNR	Item Number of Principal Purchase Agreement	KTPNR	NUMC	5	Assigned to domain		EBELP
LGORT	Storage Location	LGORT_D	CHAR	4	Assigned to domain		LGORT	LAG
LMEIN	Base Unit of Measure	LAGME	UNIT	3	Assigned to domain	CUNIT	MEINS
MATKL	Material Group	MATKL	CHAR	9	Assigned to domain		MATKL	MKL	S_WBWG
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
MEINS	Purchase Order Unit of Measure	BSTME	UNIT	3	Assigned to domain	CUNIT	MEINS
NETPR	Net price	NETPR	CURR	11(2)			WERTV6
PEINH	Price Unit	PEINH	DEC	5			PACK3
PSTYP	Item Category in Purchasing Document	PSTYP	CHAR	1	Assigned to domain		PSTYP
TWRKZ	Partial Invoice Indicator	TWRKZ	CHAR	1			TWRKZ
TXZ01	Short Text	TXZ01	CHAR	40			TEXT40
UMREN	Denominator for Conversion of Order Unit to Base Unit	UMBSN	DEC	5			UMBSN
UMREZ	Numerator for Conversion of Order Unit to Base Unit	UMBSZ	DEC	5			UMBSZ
VRTKZ	Distribution indicator for multiple account assignment	VRTKZ	CHAR	1			VRTKZ
WEBRE	Indicator: GR-Based Invoice Verification	WEBRE	CHAR	1			XFELD
WERKS	Plant	EWERK	CHAR	4	Assigned to domain		WERKS	WRK
XERSY	Evaluated Receipt Settlement (ERS)	XERSY	CHAR	1			XFELD
EMLIF	Vendor to be supplied/who is to receive delivery	EMLIF	CHAR	10	Assigned to domain	ALPHA	LIFNR
EMNFR	External manufacturer code name or number	EMNFR	CHAR	10			CHAR10
EMPST	Receiving point	EMPST	CHAR	25			TEXT25
AEDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ANLN1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
APLZL	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
EFFHW	Effective order value in local currency	MC_EFFHW	CURR	15(2)			WERTV8
EFFWR	Effective order value	MC_EFFWR	CURR	15(2)			WERTV8
FIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
KBLNR	Document Number for Earmarked Funds	KBLNR	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
KBLPOS	Earmarked Funds: Document Item	KBLPOS	NUMC	3	Assigned to domain		KBLPOS	KBP
KOKRS	Controlling Area	KOKRS	CHAR	4	Assigned to domain		CACCD	CAC
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
KSTRG	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
KTOPL	Chart of Accounts	KTOPL	CHAR	4	Assigned to domain		KTOPL	KPL	C_KTOPL
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
NAVNW	Non-deductible input tax	NAVNW	CURR	13(2)			WERT7
NETHW	Net purchase local value (base unit)	MC_NETHW	CURR	15(2)			WERTV8
NETWR	Net Order Value in PO Currency	BWERT	CURR	13(2)			WERT7
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR	NUMC	10			RKEOBJNR
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
SAKTO	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
VBELN	Sales and Distribution Document Number	VBELN	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
VBELP	Sales Document Item	POSNR_VA	NUMC	6	Assigned to domain		POSNR	APO
VPROZ	Percentage for Account Assignment Value Distribution	WPROZ	DEC	4(1)			DEC3_1
XBAUF	Post To Order	XBAUF	CHAR	1			XFELD
XBKST	Posting to cost center?	XBKST	CHAR	1			XFELD
XBPRO	Post to project	XBPRO	CHAR	1			XFELD
ZEKKN	Sequential Number of Account Assignment	DZEKKN	NUMC	2			NUM02
MENGE	Quantity	MENGE_D	QUAN	13(3)			MENG13
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
BPWEB	Quantity in Valuated GR Blocked Stock in Order Price Unit	BPWEB	QUAN	13(3)			MENG13
BPWES	Quantity in GR blocked stock in order price unit	BPWES	QUAN	13(3)			MENG13
BWART	Movement Type (Inventory Management)	BWART	CHAR	3	Assigned to domain		BWART	BWA
ETENS	Sequential Number of Vendor Confirmation	ETENS	NUMC	4			NUM04
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
GRUND	Reason for manual valuation of net assets	GRUND	CHAR	3	Assigned to domain		GRUND
LEMIN	Returns Indicator	SRVRET	CHAR	1			XFELD
LSMEH	Unit of Measure From Delivery Note	LSMEH	UNIT	3	Assigned to domain	CUNIT	MEINS
LSMNG	Quantity in Unit of Measure from Delivery Note	LSMNG	QUAN	13(3)			MENG13
WESBB	Valuated Goods Receipt Blocked Stock in Order Unit	WESBB	QUAN	13(3)			MENG13
WESBS	Goods Receipt Blocked Stock in Order Unit	WESBS	QUAN	13(3)			MENG13
LFGJA	Fiscal Year of Current Period	LFGJA	NUMC	4		GJAHR	GJAHR
LFPOS	Item of a Reference Document	LFPOS	NUMC	4			MBLPO
LFBNR	Document No. of a Reference Document	LFBNR	CHAR	10		ALPHA	BELNR
BEKKN	Number of PO Account Assignment	BEKKN	NUMC	2			NUM02
PACKNO	Package number	PACKNO	NUMC	10	Assigned to domain		PACKNO
INTROW	Internal line number for limits	INTROW	NUMC	10			NUMC10
BEWTP	PO history category	BEWTP	CHAR	1	Assigned to domain		BEWTP
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
HSWAE	Local currency key	HSWAE	CUKY	5	Assigned to domain		WAERS
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
SHKKO	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
STUNR	Step number	STUNR	NUMC	3	Assigned to domain		STUNR
ZAEHK	Condition counter	DZAEHK	NUMC	2			ZAEHK
WAERS2	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
WAERS3	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
BPRME	Order Price Unit (Purchasing)	BPRME	UNIT	3	Assigned to domain	CUNIT	MEINS
WAERS_EKBE	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
WAERS_EKBZ	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
VGABE	Transaction/event type, purchase order history	VGABE	CHAR	1			VGABE
MENGE_ESKL	Quantity	MENGE_D	QUAN	13(3)			MENG13
WPROZ_ESKL	Percentage for Account Assignment Value Distribution	WPROZ	DEC	4(1)			DEC3_1
NETWR_ESKL	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
AREW2_EKBEMA	Clearing Value on GR/IR Account in First ML Currency	AREW2	CURR	13(2)			WERT7
AREW3_EKBEMA	Clearing Value on GR/IR Account in Second ML Currency	AREW3	CURR	13(2)			WERT7
AREWB_EKBEMA	Clearing Value on GR/IR Account in PO Currency	AREWB	CURR	13(2)			WERT7
AREWR_EKBEMA	GR/IR account clearing value in local currency	AREWR	CURR	13(2)			WERT7
AREWW_EKBEMA	Clearing value on GR/IR clearing account (transac. currency)	AREWW	CURR	13(2)			WERT7
BPMNG_EKBEMA	Quantity in Purchase Order Price Unit	BPMNG	QUAN	13(3)			MENG13
BPMNG_F_EKBEMA	Quantity in PO Price Unit (as Floating Point No. - Int. Fld)	BPMNG_F	FLTP	16(16)
CURTP2_EKBEMA	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
CURTP3_EKBEMA	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
DMBT2_EKBEMA	Amount in First ML Currency	DMBT2	CURR	13(2)			WERT7
DMBT3_EKBEMA	Amount in Second ML Currency	DMBT3	CURR	13(2)			WERT7
DMBTR_EKBEMA	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
KUDIF_EKBEMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
KUDIF2_EKBEMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
KUDIF3_EKBEMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
MENGE_EKBEMA	Quantity	MENGE_D	QUAN	13(3)			MENG13
MENGE_F_EKBEMA	Quantity (Floating Point Number - Internal Field)	MENGE_F	FLTP	16(16)
REEWR_EKBEMA	Invoice Value Entered (in Local Currency)	REEWR	CURR	13(2)			WRTV7
REFWR_EKBEMA	Invoice value in foreign currency	REFWR	CURR	13(2)			WRTV7
REWRB_EKBEMA	Invoice Amount in PO Currency	REWRB	CURR	13(2)			WERT7
AREW2_EKBZMA	Clearing Value on GR/IR Account in First ML Currency	AREW2	CURR	13(2)			WERT7
AREW3_EKBZMA	Clearing Value on GR/IR Account in Second ML Currency	AREW3	CURR	13(2)			WERT7
AREWB_EKBZMA	Clearing Value on GR/IR Account in PO Currency	AREWB	CURR	13(2)			WERT7
AREWR_EKBZMA	GR/IR account clearing value in local currency	AREWR	CURR	13(2)			WERT7
AREWW_EKBZMA	Clearing value on GR/IR clearing account (transac. currency)	AREWW	CURR	13(2)			WERT7
BPMNG_EKBZMA	Quantity in Purchase Order Price Unit	BPMNG	QUAN	13(3)			MENG13
BPMNG_F_EKBZMA	Quantity in PO Price Unit (as Floating Point No. - Int. Fld)	BPMNG_F	FLTP	16(16)
CURTP2_EKBZMA	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
CURTP3_EKBZMA	Currency Type and Valuation View	CURTP	CHAR	2			CURTP
DMBT2_EKBZMA	Amount in First ML Currency	DMBT2	CURR	13(2)			WERT7
DMBT3_EKBZMA	Amount in Second ML Currency	DMBT3	CURR	13(2)			WERT7
DMBTR_EKBZMA	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
KUDIF_EKBZMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
KUDIF2_EKBZMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
KUDIF3_EKBZMA	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
MENGE_EKBZMA	Quantity	MENGE_D	QUAN	13(3)			MENG13
MENGE_F_EKBZMA	Quantity (Floating Point Number - Internal Field)	MENGE_F	FLTP	16(16)
REEWR_EKBZMA	Invoice Value Entered (in Local Currency)	REEWR	CURR	13(2)			WRTV7
REFWR_EKBZMA	Invoice value in foreign currency	REFWR	CURR	13(2)			WRTV7
REWRB_EKBZMA	Invoice Amount in PO Currency	REWRB	CURR	13(2)			WERT7
AREWB_EKBE	Clearing Value on GR/IR Account in PO Currency	AREWB	CURR	13(2)			WERT7
AREWR_EKBE	GR/IR account clearing value in local currency	AREWR	CURR	13(2)			WERT7
AREWW_EKBE	Clearing value on GR/IR clearing account (transac. currency)	AREWW	CURR	13(2)			WERT7
BPMNG_EKBE	Quantity in Purchase Order Price Unit	BPMNG	QUAN	13(3)			MENG13
DMBTR_EKBE	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
KUDIF_EKBE	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
MENGE_EKBE	Quantity	MENGE_D	QUAN	13(3)			MENG13
REEWR_EKBE	Invoice Value Entered (in Local Currency)	REEWR	CURR	13(2)			WRTV7
REFWR_EKBE	Invoice value in foreign currency	REFWR	CURR	13(2)			WRTV7
REWRB_EKBE	Invoice Amount in PO Currency	REWRB	CURR	13(2)			WERT7
AREWB_EKBZ	Clearing Value on GR/IR Account in PO Currency	AREWB	CURR	13(2)			WERT7
AREWR_EKBZ	GR/IR account clearing value in local currency	AREWR	CURR	13(2)			WERT7
AREWW_EKBZ	Clearing value on GR/IR clearing account (transac. currency)	AREWW	CURR	13(2)			WERT7
KUDIF_EKBZ	Exchange Rate Difference Amount	KUDIF	CURR	13(2)			WERT7
MENGE_EKBZ	Quantity	MENGE_D	QUAN	13(3)			MENG13
REEWR_EKBZ	Invoice Value Entered (in Local Currency)	REEWR	CURR	13(2)			WRTV7
REFWR_EKBZ	Invoice value in foreign currency	REFWR	CURR	13(2)			WRTV7
REWRB_EKBZ	Invoice Amount in PO Currency	REWRB	CURR	13(2)			WERT7
ROCANCEL	Indicator: Cancel Data Record	ROCANCEL	CHAR	1			BOOLE
WRBTR_EKBEMA	Amount in document currency	WRBTR	CURR	13(2)			WERT7
WRBTR_EKBZMA	Amount in document currency	WRBTR	CURR	13(2)			WERT7
WRBTR_EKBE	Amount in document currency	WRBTR	CURR	13(2)			WERT7
WRBTR_EKBZ	Amount in document currency	WRBTR	CURR	13(2)			WERT7
BWTAR	Valuation Type	BWTAR_D	CHAR	10	Assigned to domain		BWTAR	BWT
CHARG	Batch Number	CHARG_D	CHAR	10	Assigned to domain		CHARG	CHA
KSCHL	Condition Type	KSCHL	CHAR	4	Assigned to domain		KSCHL	VKS

Key field

Non-key field

How do I retrieve data from SAP structure MCEX_PO_HIST_MAA_S using ABAP code?

As MCEX_PO_HIST_MAA_S is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCEX_PO_HIST_MAA_S as there is no data to select.

How to access SAP table MCEX_PO_HIST_MAA_S

Within an ECC or HANA version of SAP you can also view further information about MCEX_PO_HIST_MAA_S and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!