SAP ABAP Table VREDB_VICN01 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | VREDB_VICN01 | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | RECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
4 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
5 | RECNTYPE | SMVART | SMVART | CHAR | 4 | 0 | External Real Estate contract type | TIV26 | |
6 | RECNDAT | RECNDAT | DDAT | DATS | 8 | 0 | Date of Contract Conclusion | ||
7 | RECNBEG | RECNBEG | DDAT | DATS | 8 | 0 | Date of contract start | ||
8 | RECNEND | RECNEND | DDAT | DATS | 8 | 0 | Date of contract end | ||
9 | RECNADJT | SMVAR | SMVAR | CHAR | 1 | 0 | Lease-Out Adjustment Type | ||
10 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
11 | RECNDPO | RECNDPO | DDAT | DATS | 8 | 0 | Date of first posting | ||
12 | RECNOBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ||
13 | RECNNOTTYPE | SMVKUEART | SMVKUEART | CHAR | 1 | 0 | Notice Type of Lease-Out | ||
14 | RECNNOTKEY | SKUEKEY | SKUEKEY | CHAR | 12 | 0 | Notice rule | ||
15 | RECNNOTPER | DKUZU | DDAT | DATS | 8 | 0 | Contract Notice Per | ||
16 | RECNAUTHGR | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
17 | RECNBUSAREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
18 | RECNPRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
19 | RECNACCDETVAL | VVWERTN_ADCN | VVWERTN_ADCN | CHAR | 10 | 0 | Account determination key for account determination | TIVCN08 | |
20 | RECNADMONTH | VVJMABGR | JFLAGG | CHAR | 1 | 0 | Accrual/deferral method | ||
21 | RECNDDUNNED | MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
22 | RECNDCOMPLNT | VVKLDATUM | DATUM | DATS | 8 | 0 | Date of complaint | ||
23 | RECNDCOMPLRC | VVKLAKTZEI | CHAR20 | CHAR | 20 | 0 | Complaint reference code | ||
24 | RECNJURISDIC | VVXGERSTD | TEXT35 | CHAR | 35 | 0 | Jurisdiction | ||
25 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
26 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
27 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
28 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
29 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
30 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
31 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
32 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
33 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
34 | RECNUNIT | RECNUNIT | MEINS | UNIT | 3 | 0 | Area unit | T006 | |
35 | RECNKUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
36 | RECNLIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
37 | RECNTXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
38 | RECNCURR | RECNWAERS_H | WAERS | CUKY | 5 | 0 | Currency key for local currency | TCURC | |
39 | RECNTLAW | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | TIV03 | |
40 | RECNCURR2 | RECNWAERS_D | WAERS | CUKY | 5 | 0 | Currency key for the display currency | TCURC | |
41 | RECNTXTOLD | VVOSMIVE | VVOSMIVE | CHAR | 20 | 0 | Number of old contract | ||
42 | RECNDACTIV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
43 | RECNNRCOLLECT | RECNNRCOLLECT | RECNNR | CHAR | 13 | 0 | Number of Real Estate main contract | ||
44 | RECNKOSTL | RECNKOSTL | KOSTL | CHAR | 10 | 0 | Cost center of internal contract | ||
45 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | ||
46 | RECNPREDATA | RECNPREDATA | XFELD | CHAR | 1 | 0 | Flag: Predefined rates | ||
47 | SPARTNR | BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | ||
48 | RECNNOTRECEIPT | DEKUEA | DDAT | DATS | 8 | 0 | Receipt or issue date of notice | ||
49 | RECNNOTREASON | RKUEGRU | RKUEGRU | NUMC | 2 | 0 | Reason for notice | TIV39 | |
50 | RECNNOTINVREA | RABLGRU | RABLGRU | NUMC | 2 | 0 | Reason for rejection | TIV41 | |
51 | RECNJVSTOPT | VVJVSTOPT | JANE | CHAR | 1 | 0 | Input tax opting (indicator) | ||
52 | RECNVSTSOND | SVSTSOND | SVSTSOND | CHAR | 1 | 0 | Input tax opting reason | TIV63 | |
53 | RECNMANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
54 | RECNMABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
55 | RECNMAHNA | MAHNA | MAHNA | CHAR | 4 | 0 | Dunning Procedure | T047A | |
56 | RECNMAHNS_D | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
57 | RECNNOTCAT | SKUAR | SKUAR | CHAR | 1 | 0 | Notice Type | ||
58 | RECNGFZLSCH | RECNGFZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method for credit memos | ||
59 | RECNZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | T008 | |
60 | RECNHBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
61 | RECNXBLNR | RECNXBLNR1 | XBLNR1 | CHAR | 16 | 0 | Note to payee | ||
62 | RECNDKUZUG | VVDKUZUG | DDAT | DATS | 8 | 0 | Date notice approved | ||
63 | RECNDKUABG | VVDKUABG | DDAT | DATS | 8 | 0 | Date notice rejected | ||
64 | RECNDWIKU | VVDWIKU | DDAT | DATS | 8 | 0 | Date of objection to notice | ||
65 | RECNDKUERCK | DKUERCK | DATUM | DATS | 8 | 0 | Date of withdrawal of notice | ||
66 | RECNDKREUEB | VVDKREUEB | DDAT | DATS | 8 | 0 | Date notice submitted to legal department | ||
67 | RECNDAKTKU | VVDAKTKU | DDAT | DATS | 8 | 0 | Activation date | ||
68 | RECNDSTKU | VVDSTKU | DDAT | DATS | 8 | 0 | Reversal date | ||
69 | RECNADJTTYPE | RECNADJTTYPE | RECNADJTTYPE | CHAR | 1 | 0 | Adjustment triggered by | ||
70 | RECNADJTRUECK | RECNADJTRUECK | XFELD | CHAR | 1 | 0 | Retroactive adjustment possible | ||
71 | RECNBUKRSCOLLECT | RECNBUKRSCOLLECT | BUKRS | CHAR | 4 | 0 | Company code of main contract | T001 | |
72 | RECNBASISAEZIF | RECNBASISAEZIF | RECNAEZIF | INT2 | 5 | 0 | Base: equivalence number distribution | ||
73 | RECNXCROSS | RECNXCROSS | XFELD | CHAR | 1 | 0 | Gross amount indicator | ||
74 | RECNMANDAT | RECNMANDAT | CHAR20 | CHAR | 20 | 0 | Mandate | ||
75 | RECNMANDATTYP | RECNMANDATTYP | RECNMANDATTYP | NUMC | 1 | 0 | Role of Contract in Mandate | ||
76 | RECNFLESR | VVKZESR | JANE | CHAR | 1 | 0 | Activation of POR functions | ||
77 | RECNESRNROW | VVESRNR_EIG | NUM9 | NUMC | 9 | 0 | POR participant number of owner | TIV9I | |
78 | RECNESRCUIDOW | VVESRKUID_EIG | CHAR15 | CHAR | 15 | 0 | POR customer identification number | TIV9I | |
79 | RECNVATNROW | VVMWSTNR_EIG | STCEG | CHAR | 20 | 0 | Value-added tax of owner | ||
80 | RECNBUKRSGKT | VVBUKRS_GKT | BUKRS | CHAR | 4 | 0 | Object and account CoCd | T001 | |
81 | RECNKZEIGGKT | VVKZEIGGKT | VVKZEIGGKT | CHAR | 1 | 0 | Cash account control for owner | ||
82 | RELSKASSENZ | RELSKASSENZ | CHAR30 | CHAR | 30 | 0 | Kassenzeichen/Hebebuch-Nr. | ||
83 | RELSGRDNR | RELSGRDNR | CHAR30 | CHAR | 30 | 0 | Grundstücksnummer im Abgabenbescheid | ||
84 | RELSSUBTYPE | RELSSUBTYPE | RELSSUBTYPE | CHAR | 4 | 0 | Untervertragsart (Liegenschaftsvertrag) | TIVLSCNSTYPE | |
85 | RELSAKTZ | RELSAKTZ | TEXT35 | CHAR | 35 | 0 | Aktenzeichen | ||
86 | RELSDAT2 | RELSDAT2 | DDAT | DATS | 8 | 0 | Datum Vertragsbestätigung | ||
87 | RELSWIRTUEBG | RELSWIRTUEBG | DDAT | DATS | 8 | 0 | Wirtschaftlicher Übergang | ||
88 | RELSNOTEARLY | RELSNOTEARLY | DATS | DATS | 8 | 0 | Frühestmögliche Kündigung | ||
89 | RELSOWNER | BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | ||
90 | RELSROLETYP | BP_ROLETYP | BP_ROLETYP | CHAR | 4 | 0 | Business Partner Role Category | ||
91 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
92 | RECNCNCURR | RECNWAERS_CN | WAERS | CUKY | 5 | 0 | Currency for Contract | TCURC | |
93 | RECNENDABS | RECNCNENDABS | RECADATEEND | DATS | 8 | 0 | Term End Date | ||
94 | RECN2DAT | RECN2DAT | RECADATE | DATS | 8 | 0 | Date of Second Signature | ||
95 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | ||
96 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | ||
97 | SRRELEVANT | RECNSALESRENTRELEVANT | RECABOOL | CHAR | 1 | 0 | Relevant to Sales | ||
98 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
99 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
100 | INDUSTRY | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | ||
101 | DPTARGETTYPE | RECNDPTYPE | RECNDPTYPE | CHAR | 4 | 0 | Security Deposit Type | TIVCNDPTYPE | |
102 | BIRELEASE | RELUBIRELEASE | XFELD | CHAR | 1 | 0 | Ausschreibung freigegeben (Kennzeichen) | ||
103 | BIVALIDFROM | RELUBIVALIDFROM | DDAT | DATS | 8 | 0 | Ausschreibung gültig von | ||
104 | BIVALIDTO | RELUBIVALIDTO | DDAT | DATS | 8 | 0 | Ausschreibung gültig bis | ||
105 | BIREPRTO | RELUBIREPRTO | DDAT | DATS | 8 | 0 | Ausschreibung befristet bis | ||
106 | BIREPRTOTIME | RELUBIREPRTOTIME | UZEIT | TIMS | 6 | 0 | Uhrzeit, bis zu der die Ausschreibung befristet ist | ||
107 | BIRECAT | RELUBIRECAT | CHAR02 | CHAR | 2 | 0 | Liegenschaftskategorie | TIVLUBIRECAT | |
108 | PUBLICTYPE | RELUPUBLICTYPE | CHAR02 | CHAR | 2 | 0 | Art der Veröffentlichung | TIVLUPUBLICTYPE | |
109 | FILENO | RELUFILENO | CHAR35 | CHAR | 35 | 0 | Aktenzeichen | ||
110 | BIPURPOSE | RELUBIPURPOSE | CHAR02 | CHAR | 2 | 0 | Zweck der Ausschreibung | TIVLUBIPURPOSE | |
111 | BIPRICING | RELUBIPRICING | CHAR02 | CHAR | 2 | 0 | Preisfindung | TIVLUBIPRICING |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |