VIZNRN SAP (Assignment: Real Estate numbers <-> IMKEY <-> INTRENO) Table details

Dictionary Type: Table
Description: Assignment: Real Estate numbers <-> IMKEY <-> INTRENO




ABAP Code to SELECT data from VIZNRN
Related tables to VIZNRN
Access table VIZNRN




Table field list including key, data, relationships and ABAP select examples

VIZNRN is a standard SAP Table which is used to store Assignment: Real Estate numbers <-> IMKEY <-> INTRENO data and is available within R/3 SAP systems depending on the version and release level.

The VIZNRN table consists of various fields, each holding specific information or linking keys about Assignment: Real Estate numbers <-> IMKEY <-> INTRENO data available in SAP. These include IMKEY (Internal Key for Real Estate Object), INTRENO (Internal Real Estate Master Data Code), BUKRS (Company Code), SWENR (Site Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP VIZNRN table 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
MANDTClient MANDTCLNT3T000MANDT
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SGRNRProperty Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
SGENRBuilding Number SGENRCHAR8VIOB03SGENRSGENRGEBMCGE
SMENRNumber of Rental Unit SMENRCHAR8VIMI01SMENRSMENRMEHMCME
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
SVWNRManagement Contract Number VVSVWNRCHAR13VIVW01ALPHAVVSVWNRVWVMCVW
SNKSLService Charge Key SNKSLCHAR4TIV05ALPHASNKSLNKLREFXCLSNKSL
SEMPSLSettlement Unit SEMPSLCHAR5VIAK03ALPHASEMPSLEMPMCEM
SBERICorrection item number SBERICHAR10VIBEBEALPHASBERIBEB
J_OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
RECNNRReal Estate Contract Number RECNNRCHAR13ALPHARECNNRRECNNR

Key field Non-key field



How do I retrieve data from SAP table VIZNRN using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIZNRN to SELECT all data from the table
DATA: WA_VIZNRN TYPE VIZNRN.

SELECT SINGLE *
FROM VIZNRN
INTO CORRESPONDING FIELDS OF WA_VIZNRN
WHERE...

How to access SAP table VIZNRN

Within an ECC or HANA version of SAP you can also view further information about VIZNRN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!