SAP ABAP View CRMV_MI_REACOD (Database View: Reason Codes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-INV (Application Component) Investigation
     ⤷ CRM_MI_DT (Package) Investigation - Customizing Objects

Basic Data

View Type	D	Database View
Database View	CRMV_MI_REACOD
Short Description	Database View: Reason Codes
Root table	CRMC_MI_CDTCGR	Assignment of Code Group to Code Type

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_MI_CDTCGR	CRMC_MI_CDTCGR
2	CRMC_MI_CODTYP
3	TQ15
4	TQ15T
5	QPGR
6	QPGT
7	QPCD
8	QPCT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_MI_CODTYP	CODTYP	JL	EQ				0	0
2	CRMC_MI_CDTCGR	CODTYP	JR	EQ			AND	0	0
3	TQ15	MANDT	JL	EQ				0	0
4	CRMC_MI_CDTCGR	CLIENT	JR	EQ			AND	0	0
5	TQ15	KATALOGART	JL	EQ				0	0
6	CRMC_MI_CDTCGR	CAT_ID	JR	EQ			AND	0	0
7	TQ15	MANDT	JL	EQ				0	0
8	TQ15T	MANDT	JR	EQ			AND	0	0
9	TQ15	KATALOGART	JL	EQ				0	0
10	TQ15T	KATALOGART	JR	EQ			AND	0	0
11	QPGR	MANDT	JL	EQ				0	0
12	CRMC_MI_CDTCGR	CLIENT	JR	EQ			AND	0	0
13	QPGR	KATALOGART	JL	EQ				0	0
14	CRMC_MI_CDTCGR	CAT_ID	JR	EQ			AND	0	0
15	QPGR	CODEGRUPPE	JL	EQ				0	0
16	CRMC_MI_CDTCGR	CODEGROUP	JR	EQ			AND	0	0
17	QPGR	MANDT	JL	EQ				0	0
18	QPGT	MANDANT	JR	EQ			AND	0	0
19	QPGR	KATALOGART	JL	EQ				0	0
20	QPGT	KATALOGART	JR	EQ			AND	0	0
21	QPGR	CODEGRUPPE	JL	EQ				0	0
22	QPGT	CODEGRUPPE	JR	EQ			AND	0	0
23	QPGR	MANDT	JL	EQ				0	0
24	QPCD	MANDT	JR	EQ			AND	0	0
25	QPGR	KATALOGART	JL	EQ				0	0
26	QPCD	KATALOGART	JR	EQ			AND	0	0
27	QPGR	CODEGRUPPE	JL	EQ				0	0
28	QPCD	CODEGRUPPE	JR	EQ			AND	0	0
29	QPCD	MANDT	JL	EQ				0	0
30	QPCT	MANDT	JR	EQ			AND	0	0
31	QPCD	KATALOGART	JL	EQ				0	0
32	QPCT	KATALOGART	JR	EQ			AND	0	0
33	QPCD	CODEGRUPPE	JL	EQ				0	0
34	QPCT	CODEGRUPPE	JR	EQ			AND	0	0
35	QPCD	CODE	JL	EQ				0	0
36	QPCT	CODE	JR	EQ			AND	0	0
37	CRMC_MI_CODTYP	CODTYP		EQ	'REA_MI'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMC_MI_CDTCGR	CLIENT		☐	MANDT	☐	Client
2	SPRACHE	TQ15T	SPRACHE		☐	SPRAS	☐	Language Key
3	KATALOGART	TQ15	KATALOGART		☐	COMT_CATALOG	☐	Catalog
4	KATALOGTXT	TQ15T	KATALOGTXT		☐	QTXTCATALG	☐	Short Text for the Catalog
5	CODEGRUPPE	QPGT	CODEGRUPPE		☐	QCODEGRP	☐	Code Group
6	KURZTEXT	QPGT	KURZTEXT		☐	QKTEXTGR	☐	Code Group Description
7	CODE	QPCT	CODE		☐	QCODE	☐	Code
8	COD_KURZTEXT	QPCT	KURZTEXT		☐	QTXT_CODE	☐	Short Text for Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in	500