SAP ABAP Table RETIFLDS1 (RE: Tenant Information - Structure (Other Contracts))

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	RETIFLDS1	Table Relationship Diagram
Short Description	RE: Tenant Information - Structure (Other Contracts)

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C