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
⤷ 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 |