SAP ABAP Table RETIFLDS (RE: Tenant Information - Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	RETIFLDS	Table Relationship Diagram
Short Description	RE: Tenant Information - Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
3	SMIVE	☐	RETIMVNR	VVSMIVE	CHAR	13	0	Tenant Information: Contract Number
4	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
5	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
6	DATUM	☐	VVKEYDATE	VVKEYDATE	DATS	8	0	Key date
7	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
8	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
9	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
10	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
11	DERZAHL	☐	DERZA	DDAT	DATS	8	0	Date of 1st debit position
12	KONDPJ	☐	VVKONDPJ	JFLAGG	CHAR	1	0	Conditions on lease-out effective per year (display)
13	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
14	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
15	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
16	DEBHPM	☐	VVDEBHPTM	CHAR80	CHAR	80	0	Name Field for Master Tenant with Customer Account
17	ORT	☐	VVADRESSE	CHAR80	CHAR	80	0	Address of master tenant with customer account
18	STRASSE	☐	VVADRESSE	CHAR80	CHAR	80	0	Address of master tenant with customer account
19	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
20	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
21	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
22	XSNUNR	☐	XNUNRK	XKBEZ	CHAR	15	0	Short description of external usage type of rental unit
23	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
24	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
25	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
26	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
27	ADSMTP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
28	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
29	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
30	DKUEZU	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
31	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
32	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
33	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
34	MIENKUEN	☐	VVDMIENKUE	DATS	DATS	8	0	End Date of Lease-Out
35	TXT_SKUEART	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
36	TXT_SKUEGRU	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
37	XMIETSPL	☐	XMIETSPL	XTEXT50	CHAR	50	0	Description of representative list of rents
38	XMIETR	☐	XMIETR	XTEXT50	CHAR	50	0	Tenancy law long text
39	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
40	XSTOCKM	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
41	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
42	XKLGESCH	☐	XKLGESCH	XKBEZ	CHAR	15	0	Location in floor short name
43	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
44	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
45	SBAUAKL	☐	SBAUALT	SBAUALT	NUMC	2	0	Building age category
46	SLAGEKL	☐	SLAGK	SLAGK	NUMC	2	0	Location class	*
47	SGROEKL	☐	SGROEKL	SGROEKL	NUMC	3	0	Size class
48	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	*
49	MFACH	☐	VVMFACH	CHAR10	CHAR	10	0	Rent table field
50	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
51	DBAUALT	☐	VVDBAUALT	DATE	DATS	8	0	Building age for rental unit relevant for rep.list of rents
52	SMVART	☐	VVVSMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
53	XKBEZ	☐	XMVARTK	XKBEZ	CHAR	15	0	Short description of RE contract type
54	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
55	XKBEZ_AN	☐	XMVANARTK	XKBEZ	CHAR	15	0	Short description of LO adjustment type
56	OSMIVE	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
57	E_SMIVE	☐	RETICOLLECT	VVSMIVE	CHAR	13	0	Collective Rental Agreement or Main Contract
58	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	*
59	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
60	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	T042Z
61	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
62	DAKTV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
63	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
64	IMKEY	☐	VVIMKEY	CHAR0008	CHAR	8	0	Internal Key for Real Estate Object
65	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	*
66	KLAKTZEI	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
67	KLDATUM	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
68	JURISDIC	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
69	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
70	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
71	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
72	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
73	R1DATUM	☐	VVR1DATUM	DATUM	DATS	8	0	1st date for vacating
74	R2DATUM	☐	VVR2DATUM	DATUM	DATS	8	0	2nd date for vacating
75	SDUNMOD	☐	VVRAMAHNVERF	CHAR004	CHAR	4	0	Dunning level for dunning of non-approved rent adjustments
76	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
77	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
78	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination	*
79	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
80	KONTOBV	☐	VVIKONTOBV	VVIKONTOBV	CHAR	10	0	Bank procedure account number
81	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
82	CORRGROUP	☐	VVCORRGROUP	VVCORRGROUP	CHAR	20	0	Correspondence group	TIVCORRGRP
83	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
84	RECNXBLNR	☐	RECNXBLNR1	XBLNR1	CHAR	16	0	Note to payee

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RETIFLDS	CORRGROUP	TIVCORRGRP	CORRGROUP
2	RETIFLDS	GFZLSCH	T042Z	ZLSCH
3	RETIFLDS	HBKID	T012	HBKID
4	RETIFLDS	MABER	T047M	MABER
5	RETIFLDS	MANSP	T040S	MANSP
6	RETIFLDS	SMVANART	TIV27	SMVANART
7	RETIFLDS	SMVART	TIV26	SMVART
8	RETIFLDS	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in