1. Home
  2. Resources
  3. SAP Tables
  4. VIMMMN_TAB - Mandate: Non-Key Fields

SAP Table VIMMMN_TAB

Mandate: Non-Key Fields

VIMMMN_TAB (Mandate: Non-Key Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIMMMN_TAB to other SAP tables.

VIMMMN_TAB table fields

Field Data element Checktable Datatype Length Decimals
OBJNR Object Number RECAOBJNR CHAR 22 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RESPONSIBLE Person Responsible RECARESPONSIBLE USR02 CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE USR02 CHAR 12 0
AUTHGRP Authorization Group RECAAUTHGRP CHAR 40 0
VALIDFROM Mandate Valid From REMMMANDATEVALIDFROM DATS 8 0
VALIDTO Mandate Valid To REMMMANDATEVALIDTO DATS 8 0
MANDATETYPE Mandate Type REMMMANDATETYPE CHAR 1 0
1 COA Mandate
2 Object Mandate
XMANDATE Name of Mandate REMMXMANDATE CHAR 60 0
CCREF Reference Company Code REMMCCREF T001 CHAR 4 0
CCMNG Manager Company Code REMMCCMNG T001 CHAR 4 0
CCCR Condominium Owner Company Code REMMCCCR CHAR 4 0
STCEG VAT Registration Number STCEG CHAR 20 0
MANDATEOLD Legacy Mandate Number Including Company Code REMMMANDATEOLD CHAR 20 0
MNACTIVATED Date Mandate Was Activated REMMMNACTIVATED DATS 8 0
HASTAXDIST Company Code Opts for Input Tax REITHASTAXDIST CHAR 1 0
X Yes
NULL No
BEHAVIOURMNGM Link with COA Objects Allowed REMMBEHAVIOURMNGM CHAR 1 0
X Yes
NULL No
PLANTREF Reference Plant REMMPLANTREF T001W CHAR 4 0
PLANTMN Plant in Mandate Company Code REMMPLANTMN T001W CHAR 4 0
SEPA_REC_CRDID Creditor Identification Number SEPA_CRDID CHAR 35 0

VIMMMN_TAB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIMMMN_TAB CCMNG SYST MANDT T001 Company Codes MANDT
VIMMMN_TAB CCMNG VIMMMN_TAB CCMNG T001 Company Codes BUKRS
VIMMMN_TAB CCREF SYST MANDT T001 Company Codes MANDT
VIMMMN_TAB CCREF VIMMMN_TAB CCREF T001 Company Codes BUKRS
VIMMMN_TAB PLANTMN SYST MANDT T001W Plants/Branches MANDT
VIMMMN_TAB PLANTMN VIMMMN_TAB PLANTMN T001W Plants/Branches WERKS
VIMMMN_TAB PLANTREF SYST MANDT T001W Plants/Branches MANDT
VIMMMN_TAB PLANTREF VIMMMN_TAB PLANTREF T001W Plants/Branches WERKS
VIMMMN_TAB RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
VIMMMN_TAB RESPONSIBLE VIMMMN_TAB RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
VIMMMN_TAB USEREXCLUSIVE VIMMMN_TAB USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
VIMMMN_TAB USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT