SAP ABAP Table VIBEPP (Flow data - Planned items for real estate management)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
Basic Data
Table Category TRANSP    Transparent table 
Transparent table VIBEPP   Table Relationship Diagram
Short Description Flow data - Planned items for real estate management    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
3 DTRANS VVDTRANS DATUM DATS 8   0   Flow data key: System date  
4 TTRANS VVTTRANS UZEIT TIMS 6   0   Transaction data key: system time  
5 NTRANS VVNTRANS NUMC4 NUMC 4   0   Transaction data key: Consecutive number  
6 SBEWART SBEWART SBEWART CHAR 4   0   Flow Type *
7 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
8 SMIVE SMIVE VVSMIVE CHAR 13   0   Lease-Out Number  
9 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
10 SMENR SMENR SMENR CHAR 8   0   Number of Rental Unit VIMI01
11 SSTATI SSTATI STATI NUMC 2   0   Status of data record *
12 SCWHR SCWHR WAERS CUKY 5   0   Settlement Currency TCURC
13 BCWHR BCWHR WERTV7 CURR 13   2   Settlement Amount  
14 BMWST BMWST WRTV7 CURR 13   2   Value-added tax amount included  
15 BHWHR BHWHR WERTV7 CURR 13   2   Amount in local currency  
16 SBWHR SBWHR WAERS CUKY 5   0   Position Currency (Currency of Position Amount) TCURC
17 BBWHR BBWHR WERTV7 CURR 13   2   Amount in position currency  
18 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
19 MWART MWART MWART CHAR 1   0   Tax Type  
20 DFAELL DFAELL DATUM DATS 8   0   Due date  
21 DDISPO DDISPO DATUM DATS 8   0   Payment Date  
22 DVALUT DVALUT DATUM DATS 8   0   Calculation Date  
23 SPLANIST SPLANIST SPLANIST CHAR 1   0   Plan/actual record/record to be released indicator  
24 SXBLNR SXBLNR1 XBLNR1 CHAR 16   0   Debit position identification -> Acctng reference doc. no.  
25 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
26 SSTORNO SSTORNO SSTORNO CHAR 1   0   Reversal indicator  
27 RSOLL RSOLL SAKNR CHAR 10   0   Account for debit posting *
28 RHABEN RHABEN SAKNR CHAR 10   0   Account for credit posting *
29 RBANKK RBANKK SAKNR CHAR 10   0   Bank account *
30 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
31 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
32 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
33 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
34 ZAHLS DZAHLS ZAHLS CHAR 1   0   Block Key for Payment T008
35 FDLEV FDLEV FDLEV CHAR 2   0   Planning Level T036
36 FDUPD FDUPD KENZX CHAR 1   0   Flag as to whether record enters cash management + forecast  
37 SANLF SANLF VVSANLF NUMC 3   0   Product Category *
38 GSART VVSART VVSART CHAR 3   0   Product Type TZPA
39 GSBER GSBER GSBER CHAR 4   0   Business Area *
40 JONLAEN JONLAEN VVSONLAEN CHAR 1   0   Indicator for fixing a flow record  
41 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
42 DERF DERF DATUM DATS 8   0   First Entered on  
43 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
44 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
45 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
46 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
47 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
48 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
49 SWOHER SWOHER CHAR1 CHAR 1   0   Source of flow record  
50 SBEWZITI SBEWZITI SBEWZITI CHAR 4   0   Flow category TZB03
51 BBASIS BBASIS WERTV7 CURR 13   2   Calculation base amount  
52 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
53 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
54 SSORTZIT SSORTZIT CHAR1 CHAR 1   0   Sort indicator for interest/repayment schedule calculations  
55 NFOLGE NFOLGE VVNFOLGE NUMC 4   0   Display sequence of condition types within the group  
56 ATAGE VVATAGE INT6 NUMC 6   0   Number of days  
57 ABASTAGE ABASTAGE INT6 NUMC 6   0   Number of base days in a calculation period  
58 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
59 SREFBEW SREFBEW SBEWART CHAR 4   0   Reference flow type *
60 DTRANSREF VVDTRANS DATUM DATS 8   0   Flow data key: System date  
61 TTRANSREF VVTTRANS UZEIT TIMS 6   0   Transaction data key: system time  
62 NTRANSREF VVNTRANS NUMC4 NUMC 4   0   Transaction data key: Consecutive number  
63 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
64 BNWHR BNWHR WERTV7 CURR 13   2   Nominal amount  
65 SNWHR SNWHR WAERS CUKY 5   0   Currency of nominal amount TCURC
66 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) TZK01
67 SVWNR VVSVWNR VVSVWNR CHAR 13   0   Management Contract Number *
68 INTRENO VVINTRENO VVINTRENO CHAR 13   0   Internal Real Estate Master Data Code  
69 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
70 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
71 IMKEY2 IMKEY2 IMKEY CHAR 8   0   Second Real Estate object for property management postings  
72 INTRENO2 VVINTRENO2 VVINTRENO CHAR 13   0   Second real estate object for property management postings  
73 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
74 SGRNR SGRNR SGRNR CHAR 8   0   Land Number for BE *
75 SGENR SGENR SGENR CHAR 8   0   Building Number *
76 JLOESCH VVJLOEAR JLOESCH CHAR 1   0   Record planned for Real Estate archiving  
77 SRECHNGNR VVRECHNGNR VVRECHNGNR NUMC 10   0   Rent Invoice: Invoice Number  
78 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
79 RECNNR RECNNR RECNNR CHAR 13   0   Real Estate Contract Number  
80 GFZLSCH RECNGFZLSCH ZLSCH CHAR 1   0   Payment method for credit memos *
81 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key *
82 NFZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
83 SABGVERF RESABGVERF RESABVEF CHAR 1   0   Accrual/deferral procedure  
84 XCROSS RECNXCROSS XFELD CHAR 1   0   Gross amount indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VIBEPP BUKRS T001 BUKRS KEY 1 N
2 VIBEPP FDLEV T036 EBENE KEY 1 CN
3 VIBEPP GSART TZPA GSART KEY 1 CN
4 VIBEPP MANDT T000 MANDT KEY 1 N
5 VIBEPP MWSKZ T007A MWSKZ REF 1 CN
6 VIBEPP SBEWZITI TZB03 SBEWZITI KEY 1 CN
7 VIBEPP SBWHR TCURC WAERS REF C CN
8 VIBEPP SCWHR TCURC WAERS KEY 1 CN
9 VIBEPP SKOART TZK01 SKOART KEY 1 CN
10 VIBEPP SMENR VIMI01 SMENR REF C CN
11 VIBEPP SNWHR TCURC WAERS    
12 VIBEPP SWENR VIOB01 SWENR REF C CN
13 VIBEPP ZAHLS T008 ZAHLS KEY 1 CN
14 VIBEPP ZLSCH T042Z ZLSCH REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in