1. Home
  2. Resources
  3. SAP Tables
  4. RETIFLDS1 - RE: Tenant Information - Structure (Other Contracts)

SAP Table RETIFLDS1

RE: Tenant Information - Structure (Other Contracts)

RETIFLDS1 (RE: Tenant Information - Structure (Other Contracts)) 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 RETIFLDS1 to other SAP tables.

RETIFLDS1 table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
BUTXT Name of Company Code or Company BUTXT CHAR 25 0
SMIVE Tenant Information: Contract Number RETIMVNR CHAR 13 0
SWENR Site Number SWENR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
DATUM Key date VVKEYDATE DATS 8 0
DMIBEG Rental start date DMIBE DATS 8 0
DMIEND Rental end date DMIEN DATS 8 0
RECNDAT Date of Contract Conclusion RECNDAT DATS 8 0
RECNTXT Contract name RECNTXT CHAR 80 0
DERZAHL Date of 1st debit position DERZA DATS 8 0
KONDPJ Conditions on lease-out effective per year (display) VVKONDPJ CHAR 1 0
NULL No
X Yes
NAME_LAST Last Name BP_NAMLAST CHAR 40 0
NAME_FIRST First Name BP_NAMFRST CHAR 40 0
BIRTH_DATE Date of Birth of Business Partner BP_BIRTHD DATS 8 0
DEBHPM Name Field for Master Tenant with Customer Account VVDEBHPTM CHAR 80 0
ORT Address of master tenant with customer account VVADRESSE CHAR 80 0
STRASSE Address of master tenant with customer account VVADRESSE CHAR 80 0
PARTNR Business Partner Number BP_PARTNR_OLD CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
XSNUNR Short description of external usage type of rental unit XNUNRK CHAR 15 0
TELF1 First telephone number TELF1 CHAR 16 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELFX1 Fax Number TELFX CHAR 31 0
TELFX2 Fax Number TELFX CHAR 31 0
ADSMTP E-Mail Address AD_SMTPADR CHAR 241 0
SKUEART Notice Type of Lease-Out SMVKUEART CHAR 1 0
NULL No period of notice
1 Period reg.
2 Deadline reg.
3 free period reg.
4 free deadline reg.
SKUEKEY Notice rule SKUEKEY CHAR 12 0
DKUEZU Contract Notice Per DKUZU DATS 8 0
JVERL Contract renewal JVERL CHAR 1 0
1 Automatic renewal
2 One-time renewal
3 Optional automatic renewal
4 Optional one-time renewal
VERLG Contract renewal by ... months VERLG NUMC 3 0
ANKUEN Notification until (for renewal of contract) ANKUEN NUMC 2 0
MIENKUEN End Date of Lease-Out VVDMIENKUE DATS 8 0
TXT_SKUEART Short Text for Fixed Values VAL_TEXT CHAR 60 0
TXT_SKUEGRU Short Text for Fixed Values VAL_TEXT CHAR 60 0
XMIETSPL Description of representative list of rents XMIETSPL CHAR 50 0
XMIETR Tenancy law long text XMIETR CHAR 50 0
XSTOCKK Short name of floor VVXSTOCKK CHAR 4 0
XSTOCKM Short Description for Floor XGKBEZ CHAR 15 0
XGEBK Short name for parts of building XGEBK CHAR 15 0
XKLGESCH Location in floor short name XKLGESCH CHAR 15 0
MAHNA Dunning Procedure MAHNA CHAR 4 0
BANKL Bank Keys BANKK CHAR 15 0
SBAUAKL Building age category SBAUALT NUMC 2 0
SLAGEKL Location class SLAGK NUMC 2 0
SGROEKL Size class SGROEKL NUMC 3 0
SAUSTKL Fixtures and fittings category SAUSKL NUMC 2 0
MFACH Rent table field VVMFACH CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
DBAUALT Building age for rental unit relevant for rep.list of rents VVDBAUALT DATS 8 0
SMVART External Real Estate contract type VVVSMVART TIV26 CHAR 4 0
XKBEZ Short description of RE contract type XMVARTK CHAR 15 0
SMVANART Lease-Out Adjustment Type SMVAR TIV27 CHAR 1 0
XKBEZ_AN Short description of LO adjustment type XMVANARTK CHAR 15 0
OSMIVE Number of old contract VVOSMIVE CHAR 20 0
E_SMIVE Collective Rental Agreement or Main Contract RETICOLLECT CHAR 13 0
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT CHAR 4 0
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
GFZLSCH Payment method for credit memos RECNGFZLSCH T042Z CHAR 1 0
ZWELS List of the Payment Methods to be Considered DZWELS CHAR 10 0
DAKTV Contract activation DAKTV DATS 8 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
IMKEY Internal Key for Real Estate Object VVIMKEY CHAR 8 0
SNKS Service Charge Collector Number SNKS CHAR 22 0
KLAKTZEI Complaint reference code VVKLAKTZEI CHAR 20 0
KLDATUM Date of complaint VVKLDATUM DATS 8 0
JURISDIC Jurisdiction VVXGERSTD CHAR 35 0
MABER Dunning Area MABER T047M CHAR 2 0
MADAT Last dunned on MADAT DATS 8 0
MANSP Dunning block MANSP T040S CHAR 1 0
MANST Dunning level MAHNS_D NUMC 1 0
R1DATUM 1st date for vacating VVR1DATUM DATS 8 0
R2DATUM 2nd date for vacating VVR2DATUM DATS 8 0
SDUNMOD Dunning level for dunning of non-approved rent adjustments VVRAMAHNVERF CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
KOEIGR Account determination key for account determination VVWERTN_AD CHAR 10 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
KONTOBV Bank procedure account number VVIKONTOBV CHAR 10 0
BERGRP Authorization group VVBERGRP CHAR 40 0
CORRGROUP Correspondence group VVCORRGROUP TIVCORRGRP CHAR 20 0
SBELEGNG RU occupancy by LO (used by third-prty/private/corp.grp) VVSBELEGNG CHAR 1 0
NULL Third-party use
1 Own use
2 Company use
RECNXBLNR Note to payee RECNXBLNR1 CHAR 16 0

RETIFLDS1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RETIFLDS1 CORRGROUP * TIVCORRGRP Definition of Correspondence Group VVIMKOB
RETIFLDS1 CORRGROUP RETIFLDS1 CORRGROUP TIVCORRGRP Definition of Correspondence Group CORRGROUP
RETIFLDS1 CORRGROUP SYST MANDT TIVCORRGRP Definition of Correspondence Group MANDT
RETIFLDS1 GFZLSCH SYST MANDT T042Z Payment Methods for Automatic Payment MANDT
RETIFLDS1 GFZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
RETIFLDS1 GFZLSCH RETIFLDS1 GFZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
RETIFLDS1 HBKID SYST MANDT T012 House Banks MANDT
RETIFLDS1 HBKID RETIFLDS1 BUKRS T012 House Banks BUKRS
RETIFLDS1 HBKID RETIFLDS1 HBKID T012 House Banks HBKID
RETIFLDS1 MABER SYST MANDT T047M Dunning areas MANDT
RETIFLDS1 MABER RETIFLDS1 BUKRS T047M Dunning areas BUKRS
RETIFLDS1 MABER RETIFLDS1 MABER T047M Dunning areas MABER
RETIFLDS1 MANSP SYST MANDT T040S Blocking reasons for dunning notices MANDT
RETIFLDS1 MANSP RETIFLDS1 MANSP T040S Blocking reasons for dunning notices MANSP
RETIFLDS1 SMVANART SYST MANDT TIV27 Value Table for Lease-Out Adjustment Type MANDT
RETIFLDS1 SMVANART RETIFLDS1 SMVANART TIV27 Value Table for Lease-Out Adjustment Type SMVANART
RETIFLDS1 SMVART * TIV26 Real Estate Contract Type (Entities) MANDT
RETIFLDS1 SMVART RETIFLDS1 SMVART TIV26 Real Estate Contract Type (Entities) SMVART
RETIFLDS1 ZLSCH SYST MANDT T042Z Payment Methods for Automatic Payment MANDT
RETIFLDS1 ZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
RETIFLDS1 ZLSCH RETIFLDS1 ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH