VIMMMN SAP table for – Mandate

Here we would like to draw your attention to VIMMMN table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIMMMN is a SAP standard transp table used for storing Mandate related data in SAP. It comes under the package RE_MM_MN.

SAP VIMMMN table

Table VIMMMN technical data

TableVIMMMN
Data storingMandate
ModuleRE
Sub ModuleRE-FX-MM
SAP PackageRE_MM_MN
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIMMMN Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIMMMN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Mandate: Key Fields
  • MANDATEID : Mandate
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Mandate: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • VALIDFROM : Mandate Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Mandate Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MANDATETYPE : Mandate Type
    Its data type is CHAR (Character String) with field length 1
  • XMANDATE : Name of Mandate
    Its data type is CHAR (Character String) with field length 60
  • CCREF : Reference Company Code
    Its data type is CHAR (Character String) with field length 4
  • CCMNG : Manager Company Code
    Its data type is CHAR (Character String) with field length 4
  • CCCR : Condominium Owner Company Code
    Its data type is CHAR (Character String) with field length 4
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • MANDATEOLD : Legacy Mandate Number Including Company Code
    Its data type is CHAR (Character String) with field length 20
  • MNACTIVATED : Date Mandate Was Activated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HASTAXDIST : Company Code Opts for Input Tax
    Its data type is CHAR (Character String) with field length 1
  • BEHAVIOURMNGM : Link with COA Objects Allowed
    Its data type is CHAR (Character String) with field length 1
  • PLANTREF : Reference Plant
    Its data type is CHAR (Character String) with field length 4
  • PLANTMN : Plant in Mandate Company Code
    Its data type is CHAR (Character String) with field length 4
  • SEPA_REC_CRDID : Creditor Identification Number
    Its data type is CHAR (Character String) with field length 35
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes