SAP VIKOKO Real Estate condition header Table data and field list

VIKOKO is a standard SAP Table which is used to store Real Estate condition header data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VIKOKO table consists of various fields, each holding specific information or linking keys about Real Estate condition header data available in SAP. These include MANDT (Client), BUKRS (Company Code), SANLF (Product Category), RKEY1 (Key part 1)... 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. .

VIKOKO table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP VIKOKO table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VIKOKO table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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
SANLF	Product Category	SANLF	NUMC	3	Assigned to domain		VVSANLF
RKEY1	Key part 1	RKEY1	CHAR	13			RKEY1
RKEY2	Key part 2	RKEY2	CHAR	8			RKEY2
RKEY3	Key part 3	RKEY3	CHAR	8			RKEY3
DGUEL_KK	Date Condition Effective from	DGUEL	DATS	8			DATUM
NLFD_ANG	Offer consecutive number	NLFD_ANG	NUMC	3			LFNR3
SSTATI	Status of data record	SSTATI	NUMC	2	Assigned to domain		STATI
SINKASSO	Collection Type	SINKASSO	CHAR	1			SINKASSO
SWHRKOND	Currency of Condition Item	SWHRKOND	CUKY	5	TCURC		WAERS
AMMRHY	Frequency in months	AMMRHY	NUMC	3			NUMC03
JPROR	Indicator as to whether calculation should be made pro rata	JPRORATA	CHAR	1			JANEI
SFART	Due date type	VVSFART	NUMC	1			STERMIN
SZAWS	Payment form (at start of period, mid-period, at period end)	SZAWS	NUMC	1			SZAHLDIV
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	T007A		MWSKZ
DMIEND	Rental end date	DMIEN	DATS	8			DDAT
JLASTOP	Direct debit stop indicator	JLAST	CHAR	1			JANEI
DLSTSP	Direct debit stop as from	DLSTSP	DATS	8			DATUM
ZLSCH	Rental agreement payment method	VVZSCHLMV	CHAR	1	T042Z		ZLSCH
SVSTSOND	Input tax opting reason	SVSTSOND	CHAR	1	TIV63		SVSTSOND
JBMONAT	Indicator for calculating amount per month	JBMONAT	CHAR	1			JANEI
JVSTOPT	Input tax opting (indicator)	VVJVSTOPT	CHAR	1			JANE
GZLSCH	Payment method for credit memos	VVGZLSCH	CHAR	1	T042Z		ZLSCH
SZEITANT	Indicator for Pro Rata Temporis Calculations	VVSZEITMV	NUMC	1			VVSZEITMV
SZBMETH	Calculation method for time-dependent periods	VVSZBMETMV	NUMC	1			VVSZBMETMV
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	Assigned to domain		TXJCD	TXJ
SFKALRI	Calculation of periods with flexible valid-to date?	VVSFKALRI	CHAR	1			XFELD
ATTRHY	Frequency in Days	ATTRHY	NUMC	3			NUMC03

Key field

Non-key field

< VIITTC_TAB - Correction Object: Attributes VIKOKO_IP - Condition Header; Entry Fields >

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

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

SELECT SINGLE *
FROM VIKOKO
INTO CORRESPONDING FIELDS OF WA_VIKOKO
WHERE...

How to access SAP table VIKOKO

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

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

Related SAP tables and the relationships to VIKOKO

    VIOB01 - Business Entities
        VVIMI01 - Generated Table for View VVIMI01
    VVZZKOP2 - Generated Table for View VVZZKOP2
    VIMI04 - Old. Replaced in 3.0 with VIMIMV
        VIKOKO - Real Estate Condition Header
            VZZKOPO - Condition Items Table
        VIMI07 - Reported Sales for Sales-Based Lease-Out
        VIMI23 - Determination of Year and Percent for Sls-Bsd LO
        VIMI24 - Percentage for Sales for Sales-Based Lease-Out
        VIMI25 - Sales Reports
    VVIKOKO - Generated Table for View VVIKOKO

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
    VIGBSTD - Real Estate Register of Land Register
        VIGBFLS - Parcels of Land for Property
        VIGBZAB - Appreciation/Depreciation in Real Estate Register
    VIGBA1 - Section 1 of Land Register
    VIGBA2 - Section 2 of Land Register
        VIGB2A - Changes in Section 2 of Land Register
    VIGBA3 - Section 3 of Land Register
        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-Dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Settl.: Assign RUs to part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship between Real Estate objs and SAP-PM
        VZSORT - Sort Values for Object

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (Plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
    VIGBSTD - Real Estate Register of Land Register
        VIGBFLS - Parcels of Land for Property
        VIGBZAB - Appreciation/Depreciation in Real Estate Register
    VIGBA1 - Section 1 of Land Register
    VIGBA2 - Section 2 of Land Register
        VIGB2A - Changes in Section 2 of Land Register
    VIGBA3 - Section 3 of Land Register
        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Stt. Assign RUs to No. of Part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship Between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship Between Real Estate Objs and SAP-PM
        VZSORT - Sort Values for Object

    RECONTRACT_KEY - Root Node: Key Fields of LDB RECONTRACT
        VICN01 - Real Estate Contract: Contract Data
            VICN03 - Real Estate Contract: Posting Distribution
            VIKOKO - Real Estate Condition Header
                VZZKOPO - Condition Items Table
            VIMIUH - Sales-Based Rental Agreement: Contracted Sales
                VIMIUI - Sales-Based Grading Lease-Out Items
            VIMI54 - Real Estate: Time-dependent Adjustment Data
            VIMI55 - Index Data for Lease-Out (Time-Dependent)
            RFVILSP - Dummy Node: Time Dependence
            VZGPO - Partner/Role Object Relationship
            VIOB01 - Business Entities
                VIOB02 - Property Master Data
                VIOB03 - Real Estate Building Master
                VIMI01 - Rental Unit - Master Data
                    VIMIMV - Lease-Out
            VIOBOV - Assignment Table for RE to Standard Objects