This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table VICN01 (Real Estate Contract: Contract Data) is a standard table in SAP ERP. It belongs to the package FVVICN.
Table | VICN01 |
Short Text | Real Estate Contract: Contract Data |
Package | FVVICN |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
INTRENO | ✔ | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
RECNTYPE | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | |
RECNNR | Real Estate Contract Number | RECNNR | CHAR | 13 | ||
RECNDAT | Date of Contract Conclusion | RECNDAT | DATS | 8 | ||
RECNBEG | Date of contract start | RECNBEG | DATS | 8 | ||
RECNEND | Date of contract end | RECNEND | DATS | 8 | ||
RECNADJT | Lease-Out Adjustment Type | SMVAR | CHAR | 1 | * | |
RECNTXT | Contract name | RECNTXT | CHAR | 80 | ||
RECNDPO | Date of first posting | RECNDPO | DATS | 8 | ||
RECNOBJNR | Object number | J_OBJNR | CHAR | 22 | * | |
RECNNOTTYPE | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | ||
RECNNOTKEY | Notice rule | SKUEKEY | CHAR | 12 | ||
RECNNOTPER | Contract Notice Per | DKUZU | DATS | 8 | ||
RECNAUTHGR | Authorization group | VVBERGRP | CHAR | 40 | ||
RECNBUSAREA | Business Area | GSBER | CHAR | 4 | TGSB | |
RECNPRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | |
RECNACCDETVAL | Account determination key for account determination | VVWERTN_ADCN | CHAR | 10 | TIVCN08 | |
RECNADMONTH | Accrual/deferral method | VVJMABGR | CHAR | 1 | ||
RECNDDUNNED | Last dunned on | MADAT | DATS | 8 | ||
RECNDCOMPLNT | Date of complaint | VVKLDATUM | DATS | 8 | ||
RECNDCOMPLRC | Complaint reference code | VVKLAKTZEI | CHAR | 20 | ||
RECNJURISDIC | Jurisdiction | VVXGERSTD | CHAR | 35 | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | ||
RERF | Entered by | RERF | CHAR | 12 | ||
DERF | First Entered on | DERF | DATS | 8 | ||
TERF | Time of Initial Entry | TERF | TIMS | 6 | ||
REHER | Source of initial entry | REHER | CHAR | 10 | ||
RBEAR | Employee ID | RBEAR | CHAR | 12 | ||
DBEAR | Last Edited on | DBEAR | DATS | 8 | ||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | ||
RBHER | Editing Source | RBHER | CHAR | 10 | ||
RECNUNIT | Area unit | RECNUNIT | UNIT | 3 | T006 | |
RECNLIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | |
RECNTXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | * | |
RECNCURR | Currency key for local currency | RECNWAERS_H | CUKY | 5 | TCURC | |
RECNTLAW | Tenancy law | SMIETR | CHAR | 5 | TIV03 | |
RECNCURR2 | Currency key for the display currency | RECNWAERS_D | CUKY | 5 | TCURC | |
RECNTXTOLD | Number of old contract | VVOSMIVE | CHAR | 20 | ||
RECNDACTIV | Contract activation | DAKTV | DATS | 8 | ||
RECNNRCOLLECT | Number of Real Estate main contract | RECNNRCOLLECT | CHAR | 13 | ||
RECNKOSTL | Cost center of internal contract | RECNKOSTL | CHAR | 10 | * | |
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | * | |
RECNPREDATA | Flag: Predefined rates | RECNPREDATA | CHAR | 1 | ||
SPARTNR | Business Partner Number | BP_PARTNR | CHAR | 10 | * | |
RECNNOTRECEIPT | Receipt or issue date of notice | DEKUEA | DATS | 8 | ||
RECNNOTREASON | Reason for notice | RKUEGRU | NUMC | 2 | TIV39 | |
RECNNOTINVREA | Reason for rejection | RABLGRU | NUMC | 2 | TIV41 | |
RECNJVSTOPT | Input tax opting (indicator) | VVJVSTOPT | CHAR | 1 | ||
RECNVSTSOND | Input tax opting reason | SVSTSOND | CHAR | 1 | TIV63 | |
RECNMANSP | Dunning block | MANSP | CHAR | 1 | T040S | |
RECNMABER | Dunning Area | MABER | CHAR | 2 | T047M | |
RECNMAHNA | Dunning Procedure | MAHNA | CHAR | 4 | T047A | |
RECNMAHNS_D | Dunning level | MAHNS_D | NUMC | 1 | ||
RECNNOTCAT | Notice Type | SKUAR | CHAR | 1 | ||
RECNGFZLSCH | Payment method for credit memos | RECNGFZLSCH | CHAR | 1 | * | |
RECNZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | |
RECNHBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | |
RECNXBLNR | Note to payee | RECNXBLNR1 | CHAR | 16 | ||
RECNDKUZUG | Date notice approved | VVDKUZUG | DATS | 8 | ||
RECNDKUABG | Date notice rejected | VVDKUABG | DATS | 8 | ||
RECNDWIKU | Date of objection to notice | VVDWIKU | DATS | 8 | ||
RECNDKUERCK | Date of withdrawal of notice | DKUERCK | DATS | 8 | ||
RECNDKREUEB | Date notice submitted to legal department | VVDKREUEB | DATS | 8 | ||
RECNDAKTKU | Activation date | VVDAKTKU | DATS | 8 | ||
RECNDSTKU | Reversal date | VVDSTKU | DATS | 8 | ||
RECNADJTTYPE | Adjustment triggered by | RECNADJTTYPE | CHAR | 1 | ||
RECNADJTRUECK | Retroactive adjustment possible | RECNADJTRUECK | CHAR | 1 | ||
RECNBUKRSCOLLECT | Company code of main contract | RECNBUKRSCOLLECT | CHAR | 4 | T001 | |
RECNBASISAEZIF | Base: equivalence number distribution | RECNBASISAEZIF | INT2 | 5 | ||
RECNXCROSS | Gross amount indicator | RECNXCROSS | CHAR | 1 | ||
RECNMANDAT | Mandate | RECNMANDAT | CHAR | 20 | ||
RECNMANDATTYP | Role of Contract in Mandate | RECNMANDATTYP | NUMC | 1 | ||
RECNFLESR | Activation of POR functions | VVKZESR | CHAR | 1 | ||
RECNESRNROW | POR participant number of owner | VVESRNR_EIG | NUMC | 9 | TIV9I | |
RECNESRCUIDOW | POR customer identification number | VVESRKUID_EIG | CHAR | 15 | TIV9I | |
RECNVATNROW | Value-added tax of owner | VVMWSTNR_EIG | CHAR | 20 | ||
RECNBUKRSGKT | Object and account CoCd | VVBUKRS_GKT | CHAR | 4 | T001 | |
RECNKZEIGGKT | Cash account control for owner | VVKZEIGGKT | CHAR | 1 | ||
RELSKASSENZ | Kassenzeichen/Hebebuch-Nr. | RELSKASSENZ | CHAR | 30 | ||
RELSGRDNR | Grundstücksnummer im Abgabenbescheid | RELSGRDNR | CHAR | 30 | ||
RELSSUBTYPE | Untervertragsart (Liegenschaftsvertrag) | RELSSUBTYPE | CHAR | 4 | TIVLSCNSTYPE | |
RELSAKTZ | Aktenzeichen | RELSAKTZ | CHAR | 35 | ||
RELSDAT2 | Datum Vertragsbestätigung | RELSDAT2 | DATS | 8 | ||
RELSWIRTUEBG | Wirtschaftlicher Übergang | RELSWIRTUEBG | DATS | 8 | ||
RELSNOTEARLY | Frühestmögliche Kündigung | RELSNOTEARLY | DATS | 8 | ||
RELSOWNER | Business Partner Number | BP_PARTNR | CHAR | 10 | * | |
RELSROLETYP | Business Partner Role Category | BP_ROLETYP | CHAR | 4 | * | |
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | ||
RECNCNCURR | Currency for Contract | RECNWAERS_CN | CUKY | 5 | TCURC | |
RECNENDABS | Term End Date | RECNCNENDABS | DATS | 8 | ||
RECN2DAT | Date of Second Signature | RECN2DAT | DATS | 8 | ||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | * | |
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | * | |
SRRELEVANT | Relevant to Sales | RECNSALESRENTRELEVANT | CHAR | 1 | ||
CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | ||
CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 | ||
INDUSTRY | Industry | BU_IND_SECTOR | CHAR | 10 | * | |
DPTARGETTYPE | Security Deposit Type | RECNDPTYPE | CHAR | 4 | TIVCNDPTYPE | |
BIRELEASE | Ausschreibung freigegeben (Kennzeichen) | RELUBIRELEASE | CHAR | 1 | ||
BIVALIDFROM | Ausschreibung gültig von | RELUBIVALIDFROM | DATS | 8 | ||
BIVALIDTO | Ausschreibung gültig bis | RELUBIVALIDTO | DATS | 8 | ||
BIREPRTO | Ausschreibung befristet bis | RELUBIREPRTO | DATS | 8 | ||
BIREPRTOTIME | Uhrzeit, bis zu der die Ausschreibung befristet ist | RELUBIREPRTOTIME | TIMS | 6 | ||
BIRECAT | Liegenschaftskategorie | RELUBIRECAT | CHAR | 2 | TIVLUBIRECAT | |
PUBLICTYPE | Art der Veröffentlichung | RELUPUBLICTYPE | CHAR | 2 | TIVLUPUBLICTYPE | |
FILENO | Aktenzeichen | RELUFILENO | CHAR | 35 | ||
BIPURPOSE | Zweck der Ausschreibung | RELUBIPURPOSE | CHAR | 2 | TIVLUBIPURPOSE | |
BIPRICING | Preisfindung | RELUBIPRICING | CHAR | 2 | TIVLUBIPRICING |