SAP ABAP Table MCYA (Early Warning: Exceptions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCY (Package) Application development R/3 Early Warning System LIS

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MCYA	Table Relationship Diagram
Short Description	Early Warning: Exceptions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	EXCEP	☑	EXCEP	CHAR12	CHAR	12	0	Name of exception
3	GSTRU	☐	GSTRU	AS4TAB	CHAR	30	0	Generated DDIC table for LIS, conditions, messages	*
4	ANNAM	☐	MCANNAME	UNAME	CHAR	12	0	Created by
5	ANDAT	☐	ANDATUM	DATS	DATS	8	0	Created on
6	GENAM	☐	GENAME	USNAM	CHAR	12	0	Name of user who changed record
7	GEDAT	☐	GEDATUM	DATUM	DATS	8	0	Date of last change
8	XMAIL	☐	XMAIL1	XFELD	CHAR	1	0	Indicator: send mail
9	MNAME	☐	SO_ADRNAME	SO_STRI035	CHAR	35	0	SAPoffice: Recipient name
10	XFAX	☐	XFAX	XFELD	CHAR	1	0	Radio button: send fax
11	FAXNR	☐	FAXNUM	CHAR16	CHAR	16	0	Fax number
12	FARBE	☐	L_FARBE	FARBE	CHAR	1	0	Color in list
13	XTAGL	☐	XTAGL	XFELD	CHAR	1	0	Positive trend in EWS
14	XWOCH	☐	XWOCH	XFELD	CHAR	1	0	Negative trend in EWS
15	XMONAT	☐	XMONAT	XFELD	CHAR	1	0	Start of exception: monthly
16	ALISTE	☐	ALISTE	XFELD	CHAR	1	0	Early Warning: requirement active for standard analysis
17	ASYSTEM	☐	ASYSTEM	XFELD	CHAR	1	0	Requirement active for system-driven periodic analysis
18	AEVENT	☐	AEVENT	XFELD	CHAR	1	0	Event-driven periodic analysis
19	WAERS	☐	MCAWAER1	WAERS	CUKY	5	0	Key for the currency in which the analysis is carried out	*
20	ANZPER	☐	ANZPER	INT4	INT4	10	0	Number of periods for trend analysis
21	TREND	☐	TREND_SIMP	TREND	CHAR	1	0	Direction of trend
22	AKTPER	☐	AKTPER	XFELD	CHAR	1	0	Include current period
23	XSTUND	☐	XSTUND	XFELD	CHAR	1	0	Start of exception: hourly
24	MCPER	☐	MCPER	MCPER	NUMC	3	0	Number of previous periods for analysis period
25	KURST	☐	MCKURST	KURST	CHAR	4	0	Exchange rate type for conversion to analysis currency	*
26	STATI	☐	MCSTATI	XFELD	CHAR	1	0	Indicator: additional statistical test with trend
27	VERKN	☐	MCVERKN	MCVERKN	CHAR	1	0	Indicator: exceptions linked with "and" or "or"
28	EXTYP	☐	MC_EXTYP	CHAR1	CHAR	1	0	Exception category: "N"ormal, "G"roup or " " still open
29	MEBEZ	☐	MEBEZ	XFELD	CHAR	1	0	Characteristic reference for exception
30	PERRI	☐	PERRI	CHAR1	CHAR	1	0	Future/past for number of periods
31	ASYSANA	☐	ASYSANA	XFELD	CHAR	1	0	Exception active for periodic analysis
32	WORKF	☐	WORKF	XFELD	CHAR	1	0	Transfer to workflow (exception result)
33	SELSET	☐	SELSET	SELSET	CHAR	14	0	Variant
34	REC_FAX	☐	SO_RECFAX	TELEX	CHAR	30	0	SAPoffice: Fax or telex number of recipient
35	REC_STATE	☐	SO_FX_SATE	LAND1	CHAR	3	0	SAPoffice: Country code for sending a fax/telex	T005
36	BTCH_MODUS	☐	BTCH_MODUS	XFLAG	CHAR	1	0	Mode of periodic weak point analysis
37	TDFORM	☐	TDFORM	TDFORM	CHAR	16	0	Form name
38	VRSIO	☐	EXC_VRSIO	VRSIO	CHAR	3	0	Planned version of info structure for plan./act. comparison	*
39	XDLI	☐	XDLI	XFELD	CHAR	1	0	Send list of exceptions via distribution list
40	DLINAM	☐	SO_DLI_NAM	SO_OBJ_NAM	CHAR	12	0	Name of distribution list
41	MCPERZ	☐	MCPERZ	MCPER	NUMC	3	0	Future periods of the analysis
42	WORKF_IND	☐	WORKF_IND	XFELD	CHAR	1	0	Tansfer of individual record to workflow (result of exceptn)
43	WORKF_TAB	☐	WORKF_TAB	XFELD	CHAR	1	0	Table transfer to Workflow

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCYA	REC_STATE	T005	LAND1

History

Last changed by/on	SAP	20110901
SAP Release Created in