SAP VIBEPP Flow data - Planned items for real estate management Table
Overview
VIBEPP is a standard SAP S/4HANA table that stores Flow data - Planned items for real estate management data. There are total 84 fields in the VIBEPP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBEPP belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBEPP to other SAP tables and standard CDS views available based on VIBEPP table in S/4HANA 2020.
Techincal Settings of VIBEPP
Below are technical details of the table VIBEPP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBEPP Fields
The following table gives you an overview of the fields available in VIBEPP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| SSTATI | Status of data record | SSTATI | * | NUMC | 2 |
| SCWHR | Settlement Currency | SCWHR | TCURC | CUKY | 5 |
| BCWHR | Settlement Amount | BCWHR | CURR | 13 | |
| BMWST | Value-added tax amount included | BMWST | CURR | 13 | |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | TCURC | CUKY | 5 |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| MWART | Tax Type | MWART | CHAR | 1 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | |
| SXBLNR | Debit position identification -> Acctng reference doc. no. | SXBLNR1 | CHAR | 16 | |
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | |
| SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | |
| RSOLL | Account for debit posting | RSOLL | * | CHAR | 10 |
| RHABEN | Account for credit posting | RHABEN | * | CHAR | 10 |
| RBANKK | Bank account | RBANKK | * | CHAR | 10 |
| KUNNR | Customer Number | KUNNR | * | CHAR | 10 |
| KOSTL | Cost Center | KOSTL | * | CHAR | 10 |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| ZAHLS | Block Key for Payment | DZAHLS | T008 | CHAR | 1 |
| FDLEV | Planning Level | FDLEV | T036 | CHAR | 2 |
| FDUPD | Flag as to whether record enters cash management + forecast | FDUPD | CHAR | 1 | |
| SANLF | Product Category | SANLF | * | NUMC | 3 |
| GSART | Product Type | VVSART | TZPA | CHAR | 3 |
| GSBER | Business Area | GSBER | * | CHAR | 4 |
| JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SWOHER | Source of flow record | SWOHER | CHAR | 1 | |
| SBEWZITI | Flow category | SBEWZITI | TZB03 | CHAR | 4 |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| SSORTZIT | Sort indicator for interest/repayment schedule calculations | SSORTZIT | CHAR | 1 | |
| NFOLGE | Display sequence of condition types within the group | NFOLGE | NUMC | 4 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| SREFBEW | Reference flow type | SREFBEW | * | CHAR | 4 |
| DTRANSREF | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANSREF | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANSREF | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SNWHR | Currency of nominal amount | SNWHR | TCURC | CUKY | 5 |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| SVWNR | Management Contract Number | VVSVWNR | * | CHAR | 13 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| AWTYP | Reference procedure | AWTYP | * | CHAR | 5 |
| AWKEY | Object key | AWKEY | CHAR | 20 | |
| IMKEY2 | Second Real Estate object for property management postings | IMKEY2 | CHAR | 8 | |
| INTRENO2 | Second real estate object for property management postings | VVINTRENO2 | CHAR | 13 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| SGRNR | Land Number for BE | SGRNR | * | CHAR | 8 |
| SGENR | Building Number | SGENR | * | CHAR | 8 |
| JLOESCH | Record planned for Real Estate archiving | VVJLOEAR | CHAR | 1 | |
| SRECHNGNR | Rent Invoice: Invoice Number | VVRECHNGNR | NUMC | 10 | |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| RECNNR | Real Estate Contract Number | RECNNR | CHAR | 13 | |
| GFZLSCH | Payment method for credit memos | RECNGFZLSCH | * | CHAR | 1 |
| ZLSPR | Payment Block Key | DZLSPR | * | CHAR | 1 |
| NFZLSCH | Payment Method | DZLSCH | * | CHAR | 1 |
| SABGVERF | Accrual/deferral procedure | RESABGVERF | CHAR | 1 | |
| XCROSS | Gross amount indicator | RECNXCROSS | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIBEPP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBEPP | BUKRS | 1: N | T001 |
| VIBEPP | FDLEV | 1: CN | T036 |
| VIBEPP | GSART | 1: CN | TZPA |
| VIBEPP | MANDT | 1: N | T000 |
| VIBEPP | MWSKZ | 1: CN | T007A |
| VIBEPP | SBEWZITI | 1: CN | TZB03 |
| VIBEPP | SBWHR | C: CN | TCURC |
| VIBEPP | SCWHR | 1: CN | TCURC |
| VIBEPP | SKOART | 1: CN | TZK01 |
| VIBEPP | SMENR | C: CN | VIMI01 |
| VIBEPP | SNWHR | : | TCURC |
| VIBEPP | SWENR | C: CN | VIOB01 |
| VIBEPP | ZAHLS | 1: CN | T008 |
| VIBEPP | ZLSCH | C: CN | T042Z |