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
⤷ 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 |