MCYA SAP (Early Warning: Exceptions) Table details

Dictionary Type: Table
Description: Early Warning: Exceptions




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




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

MCYA is a standard SAP Table which is used to store Early Warning: Exceptions data and is available within R/3 SAP systems depending on the version and release level.

The MCYA table consists of various fields, each holding specific information or linking keys about Early Warning: Exceptions data available in SAP. These include EXCEP (Name of exception), GSTRU (Generated DDIC table for LIS, conditions, messages), ANNAM (Created by), ANDAT (Created on).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP MCYA table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
EXCEPName of exception EXCEPCHAR12CHAR12EXCEPNAME
GSTRUGenerated DDIC table for LIS, conditions, messages GSTRUCHAR30Assigned to domainAS4TAB
ANNAMCreated by MCANNAMECHAR12UNAME
ANDATCreated on ANDATUMDATS8DATS
GENAMName of user who changed record GENAMECHAR12USNAM
GEDATDate of last change GEDATUMDATS8DATUM
XMAILIndicator: send mail XMAIL1CHAR1XFELD
MNAMESAPoffice: Recipient name SO_ADRNAMECHAR35SO_STRI035
XFAXRadio button: send fax XFAXCHAR1XFELD
FAXNRFax number FAXNUMCHAR16CHAR16
FARBEColor in list L_FARBECHAR1FARBE
XTAGLPositive trend in EWS XTAGLCHAR1XFELD
XWOCHNegative trend in EWS XWOCHCHAR1XFELD
XMONATStart of exception: monthly XMONATCHAR1XFELD
ALISTEEarly Warning: requirement active for standard analysis ALISTECHAR1XFELD
ASYSTEMRequirement active for system-driven periodic analysis ASYSTEMCHAR1XFELD
AEVENTEvent-driven periodic analysis AEVENTCHAR1XFELD
WAERSKey for the currency in which the analysis is carried out MCAWAER1CUKY5Assigned to domainWAERS
ANZPERNumber of periods for trend analysis ANZPERINT410INT4
TRENDDirection of trend TREND_SIMPCHAR1TREND
AKTPERInclude current period AKTPERCHAR1XFELD
XSTUNDStart of exception: hourly XSTUNDCHAR1XFELD
MCPERNumber of previous periods for analysis period MCPERNUMC3MCPER
KURSTExchange rate type for conversion to analysis currency MCKURSTCHAR4Assigned to domainKURST
STATIIndicator: additional statistical test with trend MCSTATICHAR1XFELD
VERKNIndicator: exceptions linked with 'and' or 'or' MCVERKNCHAR1MCVERKN
EXTYPException category: 'N'ormal, 'G'roup or ' ' still open MC_EXTYPCHAR1CHAR1
MEBEZCharacteristic reference for exception MEBEZCHAR1XFELD
PERRIFuture/past for number of periods PERRICHAR1CHAR1
ASYSANAException active for periodic analysis ASYSANACHAR1XFELD
WORKFTransfer to workflow (exception result) WORKFCHAR1XFELD
SELSETVariant SELSETCHAR14SELSET
REC_FAXSAPoffice: Fax or telex number of recipient SO_RECFAXCHAR30TELEX
REC_STATESAPoffice: Country code for sending a fax/telex SO_FX_SATECHAR3T005LAND1
BTCH_MODUSMode of periodic weak point analysis BTCH_MODUSCHAR1XFLAG
TDFORMForm Name TDFORMCHAR16TDFORM
VRSIOPlanned version of info structure for plan./act. comparison EXC_VRSIOCHAR3Assigned to domainVRSIO
XDLISend list of exceptions via distribution list XDLICHAR1XFELD
DLINAMName of distribution list SO_DLI_NAMCHAR12SO_OBJ_NAM
MCPERZFuture periods of the analysis MCPERZNUMC3MCPER
WORKF_INDTansfer of individual record to workflow (result of exceptn) WORKF_INDCHAR1XFELD
WORKF_TABTable transfer to Workflow WORKF_TABCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table MCYA using ABAP code

The following ABAP code Example will allow you to do a basic selection on MCYA to SELECT all data from the table
DATA: WA_MCYA TYPE MCYA.

SELECT SINGLE *
FROM MCYA
INTO CORRESPONDING FIELDS OF WA_MCYA
WHERE...

How to access SAP table MCYA

Within an ECC or HANA version of SAP you can also view further information about MCYA 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!