SAP VIBEPP Flow data - Planned items for real estate management Table data and field list

VIBEPP is a standard SAP Table which is used to store Flow data - Planned items for real estate management data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VIBEPP table consists of various fields, each holding specific information or linking keys about Flow data - Planned items for real estate management data available in SAP. These include IMKEY (Internal Key for Real Estate Object), DTRANS (Flow data key: System date), TTRANS (Transaction data key: system time), NTRANS (Transaction data key: Consecutive 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. .

VIBEPP 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 or numeric)

SAP VIBEPP 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 VIBEPP 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	T000		MANDT
IMKEY	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
DTRANS	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANS	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANS	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
SBEWART	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
SMIVE	Lease-Out Number	SMIVE	CHAR	13		ALPHA	VVSMIVE	MIV	MRTA
SWENR	Site Number	SWENR	CHAR	8	VIOB01	SWENR	SWENR	WEH	MCWE
SMENR	Number of Rental Unit	SMENR	CHAR	8	VIMI01	SMENR	SMENR	MEH	MCME
SSTATI	Status of data record	SSTATI	NUMC	2	Assigned to domain		STATI
SCWHR	Settlement Currency	SCWHR	CUKY	5	TCURC		WAERS
BCWHR	Settlement Amount	BCWHR	CURR	13(2)			WERTV7
BMWST	Value-added tax amount included	BMWST	CURR	13(2)			WRTV7
BHWHR	Amount in local currency	BHWHR	CURR	13(2)			WERTV7
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	CUKY	5	TCURC		WAERS
BBWHR	Amount in position currency	BBWHR	CURR	13(2)			WERTV7
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	T007A		MWSKZ
MWART	Tax Type	MWART	CHAR	1			MWART
DFAELL	Due date	DFAELL	DATS	8			DATUM
DDISPO	Payment Date	DDISPO	DATS	8			DATUM
DVALUT	Calculation Date	DVALUT	DATS	8			DATUM
SPLANIST	Plan/actual record/record to be released indicator	SPLANIST	CHAR	1			SPLANIST
SXBLNR	Debit position identification -> Acctng reference doc. no.	SXBLNR1	CHAR	16			XBLNR1
SSOLHAB	Debit/credit indicator	VVSSOLHAB	CHAR	1			VVSSOLHAB
SSTORNO	Reversal indicator	SSTORNO	CHAR	1			SSTORNO
RSOLL	Account for debit posting	RSOLL	CHAR	10	Assigned to domain	ALPHA	SAKNR
RHABEN	Account for credit posting	RHABEN	CHAR	10	Assigned to domain	ALPHA	SAKNR
RBANKK	Bank account	RBANKK	CHAR	10	Assigned to domain	ALPHA	SAKNR	BKT
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
ZLSCH	Payment Method	DZLSCH	CHAR	1	T042Z		ZLSCH
ZAHLS	Block Key for Payment	DZAHLS	CHAR	1	T008		ZAHLS
FDLEV	Planning level	FDLEV	CHAR	2	T036		FDLEV	FFE
FDUPD	Flag as to whether record enters cash management + forecast	FDUPD	CHAR	1			KENZX
SANLF	Product Category	SANLF	NUMC	3	Assigned to domain		VVSANLF
GSART	Product Type	VVSART	CHAR	3	TZPA		VVSART	SAN	VVSART_APPL_BAS
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
JONLAEN	Indicator for fixing a flow record	JONLAEN	CHAR	1			VVSONLAEN
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
SWOHER	Source of flow record	SWOHER	CHAR	1			CHAR1
SBEWZITI	Flow category	SBEWZITI	CHAR	4	TZB03		SBEWZITI
BBASIS	Calculation base amount	BBASIS	CURR	13(2)			WERTV7
DBERVON	Start of Calculation Period	DBERVON	DATS	8			DATUM
DBERBIS	End of Calculation Period	DBERBIS	DATS	8			DATUM
SSORTZIT	Sort indicator for interest/repayment schedule calculations	SSORTZIT	CHAR	1			CHAR1
NFOLGE	Display sequence of condition types within the group	NFOLGE	NUMC	4			VVNFOLGE
ATAGE	Number of days	VVATAGE	NUMC	6			INT6
ABASTAGE	Number of base days in a calculation period	ABASTAGE	NUMC	6			INT6
SZBMETH	Interest Calculation Method	SZBMETH	CHAR	1			SZBMETH
SREFBEW	Reference flow type	SREFBEW	CHAR	4	Assigned to domain		SBEWART
DTRANSREF	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANSREF	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANSREF	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BNWHR	Nominal amount	BNWHR	CURR	13(2)			WERTV7
SNWHR	Currency of nominal amount	SNWHR	CUKY	5	TCURC		WAERS
SKOART	Condition Type (Smallest Subdivision of Condition Records)	SKOART	NUMC	4	TZK01		SKOART
SVWNR	Management Contract Number	VVSVWNR	CHAR	13	Assigned to domain	ALPHA	VVSVWNR	VWV	MCVW
INTRENO	Internal Real Estate Master Data Code	VVINTRENO	CHAR	13			VVINTRENO
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWKEY	Reference Key	AWKEY	CHAR	20			AWKEY
IMKEY2	Second Real Estate object for property management postings	IMKEY2	CHAR	8			IMKEY
INTRENO2	Second real estate object for property management postings	VVINTRENO2	CHAR	13			VVINTRENO
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
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
JLOESCH	Record planned for Real Estate archiving	VVJLOEAR	CHAR	1			JLOESCH
SRECHNGNR	Rent Invoice: Invoice Number	VVRECHNGNR	NUMC	10			VVRECHNGNR
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	Assigned to domain		TXJCD	TXJ
RECNNR	Real Estate Contract Number	RECNNR	CHAR	13		ALPHA	RECNNR	RECNNR
GFZLSCH	Payment method for credit memos	RECNGFZLSCH	CHAR	1	Assigned to domain		ZLSCH
ZLSPR	Payment Block Key	DZLSPR	CHAR	1	Assigned to domain		ZAHLS	SPE
NFZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
SABGVERF	Accrual/deferral procedure	RESABGVERF	CHAR	1			RESABVEF
XCROSS	Gross amount indicator	RECNXCROSS	CHAR	1			XFELD

Key field

Non-key field

< VIBEOS - Option/composite rates for correction items VIBEPP_KEY - Cash Flow Item (VIBEPP) >

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

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

SELECT SINGLE *
FROM VIBEPP
INTO CORRESPONDING FIELDS OF WA_VIBEPP
WHERE...

How to access SAP table VIBEPP

Within an ECC or HANA version of SAP you can also view further information about VIBEPP 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 VIBEPP

    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