VIGW_R_VIMVF03 SAP () Structure details
Description:
Related tables to VIGW_R_VIMVF03
Access table VIGW_R_VIMVF03
Structure field list including key, data, relationships and ABAP select examples
VIGW_R_VIMVF03 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VIGW_R_VIMVF03 TYPE VIGW_R_VIMVF03.
The VIGW_R_VIMVF03 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include MANDT (Client), BUKRS (Company Code), SWENR (Site Number), SMENR (Number of Rental Unit).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIGW_R_VIMVF03 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SWENR | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | MEH | MCME |
SGRNR | Property Number for BE | SGRNR | CHAR | 8 | Assigned to domain | SGRNR | SGRNR | GRS | MCGR |
SGENR | Building Number | SGENR | CHAR | 8 | Assigned to domain | SGENR | SGENR | GEB | MCGE |
SGEBSWENR | BE no.of rental unit to which the RU is linked | SGEBSWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | ||
SGEBSMENR | RU no. of rental unit to which the RU is linked | SGEBSMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | ||
SHEIZNR | Real Estate heating system number | SHEIZNR | NUMC | 4 | SHEIZNR | ||||
SNUNR | Rental unit external usage type | SNUNR | NUMC | 4 | TIV01 | SNUNR | |||
DBEZU | Date of initial usage | DBEZU | DATS | 8 | DDAT | ||||
DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | DATUM | ||||
UMBRAUM | Cubic Volume | BUBRA | DEC | 11(3) | DEC8_3 | ||||
AZIMM | Number of rooms | AZIMM | DEC | 3 | DEC3 | ||||
AHALBZI | Number of half rooms | AHALBZI | DEC | 2 | DEC2 | ||||
STOCK | Dummy (previously storey, replaced by VVSSTOCKW) | RGESCH | CHAR | 2 | CHAR2 | ||||
SBELART | Occupancy type indicator | SBELA | NUMC | 1 | SBELA | ||||
SHEIZART | Heating type | SHEIZ | CHAR | 1 | SHEIZ | ||||
DRESAB | Date: Reserved from | DRESA | DATS | 8 | DDAT | ||||
DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | DDAT | ||||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | SGEBT | |||
SBWNR | Application number | SBWNR | NUMC | 7 | VIMI11 | SBWNR | OWK | ||
XAUSTKL | Fixtures and fittings category | SAUSKL | NUMC | 2 | Assigned to domain | SAUSKL | |||
XLAGE | Location class | SLAGK | NUMC | 2 | Assigned to domain | SLAGK | |||
SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | SMOEB | ||||
SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | SALTNR | ||||
DBEGEH | Date of last RU inspection | DBEGEH | DATS | 8 | DDAT | ||||
XBEGEH | Inspected by | XBEGEH | CHAR | 15 | XKBEZ | ||||
PZUABSP | Surcharge or reduction for representative list of rents | PZUABSP | DEC | 4(2) | PZUABSP | ||||
PERHOE | Percentage rate increase | PERHOE | DEC | 5(2) | DEC3_2 | ||||
RPROZGRD | Reason for variance in rate of percentage increase | RPROZGRD | CHAR | 2 | TIV43 | RPROZGRD | |||
DBINDBIS | Obligation period until | DBINDBIS | DATS | 8 | DATUM | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
RBELBIND | Occupancy obligation key | RBELBIND | CHAR | 4 | TIV31 | RBELBIND | |||
RLIFT | Type of elevator installation | RLIFT | NUMC | 2 | TIV32 | RLIFT | |||
RMEDIEN | Media reception | RMEDIEN | NUMC | 3 | TIV33 | RMEDIEN | |||
RWASSER | Type of water mains connection | RWASSER | NUMC | 2 | TIV34 | RWASSER | |||
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | ALPHA | RLGESCH | ||
JVORSTEIG | Input tax deduction for vacancy | JVORSTEIG | CHAR | 1 | OPTIERT | ||||
SADRME | Object number of rental unit for address purposes | SADRME | NUMC | 10 | Assigned to domain | SOBJNR | |||
XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | ALPHA | VVXSTANDNR | |||
JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | JANE | ||||
RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | VVRFAKT | ||||
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | VVSSTOCKW | |||
JKONDMV | Transfer conditions to RU when lease-out expires? | VVJKONDMV | CHAR | 1 | XFELD | ||||
PKONDMV | Percentage rate for transfer of terms from LO to RU | VVPKONDMV | DEC | 5(2) | PRZ32 | ||||
DFSTRBIS | Date up to when the rental unit cash flow is created | VVDFSTRBIS | DATS | 8 | DATUM | ||||
SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | NUMC | 3 | TIV37 | VVSSTOCKW | |||
DHPZSAKT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAKT | DATS | 8 | DATUM | ||||
DUTBKAKT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAKT | DATS | 8 | DATUM | ||||
DTEURAKT | CH rnt adj.:Dte of living stndrd index status for curr.rent | VVDTEURAKT | DATS | 8 | DATUM | ||||
BRDBRTZZ | CH rent adj: Actual gross yield earned | VVBRDBRTZZ | DEC | 10(7) | DECV3_7 | ||||
BRDBRTKD | Marginal Gross Yield | VVBRDBRTKD | DEC | 10(7) | DECV3_7 | ||||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
XMETXT | Text for rental unit | VVXMETXT2 | CHAR | 30 | XMBEZ | ||||
SBASTEU | Swiss rent adj.: Base year for standard of living index | VVSBASTEU | NUMC | 4 | Assigned to domain | GJAHR | BASJHR | ||
DRESTAUR | Date of reconstruction/extensive modernization | VVDRESTAUR | DATS | 8 | DATUM | ||||
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
VERKT_MV | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
VERKT_WE | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
VERKT_ME | Number of Rental Unit | SMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | MEH | MCME |
DMIBEG | Rental start date | DMIBE | DATS | 8 | DDAT | ||||
DMIEND | Rental end date | DMIEN | DATS | 8 | DDAT | ||||
DERZAHL | Date of 1st debit position | DERZA | DATS | 8 | DDAT | ||||
SMVART | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
SMVANART | Lease-Out Adjustment Type | SMVAR | CHAR | 1 | TIV27 | SMVAR | |||
DUNTBIS | Date provisional agreement from | DUNBI | DATS | 8 | DDAT | ||||
BKAUTION | Security deposit amount | BKAUT | CURR | 13(2) | WRTV7 | ||||
SKAUTART | Type of Rental Collateral | SKAUA | CHAR | 1 | TIV18 | SKAUA | |||
DEINKUE | Date of receipt of notice | DEKUE | DATS | 8 | DDAT | ||||
DKUEZU | Contract Notice Per | DKUZU | DATS | 8 | DDAT | ||||
JMAHNSP | Dunning block indicator - no longer used! | JMASP | CHAR | 1 | JANE | ||||
STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | STECHEM | ||||
JMINDER | Rent reduction indicator | JMINDER | CHAR | 1 | JANEI | ||||
AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | INTVJ | ||||
BUMSPROJ | not used (copy of BUMSPROJ) | BUMSPRNUSD | CURR | 13(2) | WRTV7 | ||||
BMINUMS | not used (copy of BUMSATZ1) | BUMS1NUSD | CURR | 13(2) | WRTV7 | ||||
PPROZ0 | Minimum percentage rate | PPROZ0 | DEC | 5(2) | DEC3_2 | ||||
DSTAEN | Status change date | DSTAEN | DATS | 8 | DSTAEN | ||||
DAKTV | Contract activation | DAKTV | DATS | 8 | DATUM | ||||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | JLOESCH | ||||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | Assigned to domain | BUSAB | |||
JVERL | Contract renewal | JVERL | CHAR | 1 | VVVERL | ||||
JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | JANEI | ||||
JKAUFOPT | Option to buy | JKAUFOPT | CHAR | 1 | JANEI | ||||
DKAUFOPT | Purchase option date | DKAUFOPT | DATS | 8 | DDAT | ||||
SNKS | Service Charge Collector Number | SNKS | CHAR | 22 | Assigned to domain | J_OBJNR | |||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
DKUEFR | Notice period in months | DKUEFR | NUMC | 2 | NUMC2 | ||||
ANKUEN | Notification until (for renewal of contract) | ANKUEN | NUMC | 2 | NUMC2 | ||||
DABTR | Declaration of assignment | DABTR | DATS | 8 | DATUM | ||||
DFREIS | Exemption (bank) | DFREIS | DATS | 8 | DATUM | ||||
DABLF | Expiration Date | DABLF | DATS | 8 | DATUM | ||||
VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | NUMC3 | ||||
ZSICH | Indicator that other collateral is available | VVZSICH | CHAR | 1 | JANEI | ||||
JBETRST | Security deposit granted | JBETRST | CHAR | 1 | JANEI | ||||
DBKERH | Cash deposit received on | DBKERH | DATS | 8 | DATUM | ||||
ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | TEXT20 | ||||
ABNUNR | Customer subnumber | ABNUNR | NUMC | 3 | NUM3 | ||||
BANKKS | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | SKUEFR | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KUNNR | Customer number main contract partner | VVRDEBIHVP | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
SPARTNR | Alternative payer (partner number) | VVRPARTABW | CHAR | 10 | SPRT1 | SPARTNR | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
JBKRZ | Cash deposit instalment payment | VVJBKRZ | CHAR | 1 | JANEI | ||||
DEINZG | Move-in date | VVDEINZG | DATS | 8 | DATS | ||||
DAUSZG | Move-out date | VVDAUSZG | DATS | 8 | DATS | ||||
JANPIB | Adjustment being processed (indicator) | VVJANPIB | CHAR | 1 | JANE | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
ZUSP | Subsidies available, indicator | VVZUSP | CHAR | 1 | JANE | ||||
REFNR | Reference number for collateral securities | VVREFNR | CHAR | 30 | TEXT30 | ||||
SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGNG | CHAR | 1 | VVSBELEGNG | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
DERSTDR | Date When the Lease-Out was First Printed | VVDERSTDR | DATS | 8 | DATUM | ||||
DAENDDR | Date When the Lease-Out was Changed and Printed Out | VVDAENDDR | DATS | 8 | DATUM | ||||
JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | JANE | ||||
DVMUN | Contract signed by landlord | VVDVMUN | DATS | 8 | DATUM | ||||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
KBK_PARTNR | Partner number | SPARTNR | CHAR | 10 | SPRT1 | SPARTNR | PNN | ||
GERSTD | Jurisdiction | VVXGERSTD | CHAR | 35 | TEXT35 | ||||
KONDPJ | Conditions on lease-out effective per year (display) | VVKONDPJ | CHAR | 1 | JFLAGG | ||||
JMABGR | Accrual/deferral method | VVJMABGR | CHAR | 1 | JFLAGG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SKUEKEY | Notice rule | SKUEKEY | CHAR | 12 | SKUEKEY | ||||
SKUEART | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | SMVKUEART | ||||
E_SMIVE | Contract No. of Collective Lease-Outs | VVESMIVE | CHAR | 13 | ALPHA | VVSMIVE | MVE | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
FEHLBEL | Reference code false occupancy charges | VVFEHLBEL | CHAR | 20 | VVFEHLBEL | ||||
R1DATUM | 1st date for vacating | VVR1DATUM | DATS | 8 | DATUM | ||||
R2DATUM | 2nd date for vacating | VVR2DATUM | DATS | 8 | DATUM | ||||
KLDATUM | Date of complaint | VVKLDATUM | DATS | 8 | DATUM | ||||
KLAKTZEI | Complaint reference code | VVKLAKTZEI | CHAR | 20 | CHAR20 | ||||
IND_SECTOR | Industry of master tenant | VVMVINDSEC | CHAR | 4 | T016 | BRSCH | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | DATUM | ||||
INTRENO_MFL | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
DGUELAB | Valid-from date | VIGWGUELAB | DATS | 8 | DDAT | ||||
DGUELBIS | Date: Valid To | VIGWSGUELBIS | DATS | 8 | DDAT | ||||
FLG_LME | VIGWFLGLME | CHAR | 1 | JANE | |||||
GFLFAK | VIGWGFLNUFAK | QUAN | 12(2) | VIGWGFLNUFAK | |||||
GFAKEH | VIGWGFNFAKEH | UNIT | 2 | VIGWQPROMILLE | |||||
AUTOTYP | VIGWGFAUTOTYP | CHAR | 1 | VIGWZUAUTOTYP |
Key field | Non-key field |
How do I retrieve data from SAP structure VIGW_R_VIMVF03 using ABAP code?
As VIGW_R_VIMVF03 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VIGW_R_VIMVF03 as there is no data to select.How to access SAP table VIGW_R_VIMVF03
Within an ECC or HANA version of SAP you can also view further information about VIGW_R_VIMVF03 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects