SAP ABAP Table VIMMMN (Mandate)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MM (Application Component) Third Party Management/COA
     ⤷ RE_MM_MN (Package) RE: Mandate Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIMMMN	Table Relationship Diagram
Short Description	Mandate

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	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	.INCLUDE	☐				0	0	Mandate: Key Fields
4	MANDATEID	☐	REMMMANDATEID	BUKRS	CHAR	4	0	Mandate	*
5	.INCLUDE	☐				0	0	Mandate: Non-Key Fields
6	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
7	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
8	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
9	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
10	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
11	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
12	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
13	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
14	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
15	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
16	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
17	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
18	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
19	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
20	VALIDFROM	☐	REMMMANDATEVALIDFROM	RECADATE	DATS	8	0	Mandate Valid From
21	VALIDTO	☐	REMMMANDATEVALIDTO	RECADATEEND	DATS	8	0	Mandate Valid To
22	MANDATETYPE	☐	REMMMANDATETYPE	REMMMANDATETYPE	CHAR	1	0	Mandate Type
23	XMANDATE	☐	REMMXMANDATE	RECAXLDESCRIPTION	CHAR	60	0	Name of Mandate
24	CCREF	☐	REMMCCREF	BUKRS	CHAR	4	0	Reference Company Code	T001
25	CCMNG	☐	REMMCCMNG	BUKRS	CHAR	4	0	Manager Company Code	T001
26	CCCR	☐	REMMCCCR	BUKRS	CHAR	4	0	Condominium Owner Company Code	*
27	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
28	MANDATEOLD	☐	REMMMANDATEOLD	CHAR20	CHAR	20	0	Legacy Mandate Number Including Company Code
29	MNACTIVATED	☐	REMMMNACTIVATED	RECADATE	DATS	8	0	Date Mandate Was Activated
30	HASTAXDIST	☐	REITHASTAXDIST	RECABOOL	CHAR	1	0	Company Code Opts for Input Tax
31	BEHAVIOURMNGM	☐	REMMBEHAVIOURMNGM	RECABOOL	CHAR	1	0	Link with COA Objects Allowed
32	PLANTREF	☐	REMMPLANTREF	WERKS	CHAR	4	0	Reference Plant	T001W
33	PLANTMN	☐	REMMPLANTMN	WERKS	CHAR	4	0	Plant in Mandate Company Code	T001W
34	SEPA_REC_CRDID	☐	SEPA_CRDID	ID035	CHAR	35	0	Creditor Identification Number
35	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMMMN	CCMNG	T001	BUKRS	REF	1	CN
2	VIMMMN	CCREF	T001	BUKRS	KEY	1	CN
3	VIMMMN	PLANTMN	T001W	WERKS	KEY	1	CN
4	VIMMMN	PLANTREF	T001W	WERKS	KEY	1	CN
5	VIMMMN	RESPONSIBLE	USR02	BNAME	REF	1	CN
6	VIMMMN	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

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