SAP ABAP Table RVIBEPP (Transaction record structure for transfer to posting)

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	INTTAB	Structure
Structure	RVIBEPP	Table Relationship Diagram
Short Description	Transaction record structure for transfer to posting

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Flow data - Planned items for real estate management
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
4	DTRANS	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
5	TTRANS	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
6	NTRANS	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
7	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
10	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
12	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
13	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
14	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
15	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
16	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
17	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
18	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
19	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
20	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
21	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
22	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
23	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
24	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
25	SXBLNR	☐	SXBLNR1	XBLNR1	CHAR	16	0	Debit position identification -> Acctng reference doc. no.
26	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
27	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
28	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	*
29	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	*
30	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
31	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
32	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
33	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
34	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
35	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
36	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
37	FDUPD	☐	FDUPD	KENZX	CHAR	1	0	Flag as to whether record enters cash management + forecast
38	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
39	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
40	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
41	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
42	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
43	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
44	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
45	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
46	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
47	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
48	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
49	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
50	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
51	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
52	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
53	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
54	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
55	SSORTZIT	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
56	NFOLGE	☐	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
57	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
58	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
59	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
60	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
61	DTRANSREF	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
62	TTRANSREF	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
63	NTRANSREF	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
64	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
65	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
66	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
67	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
68	SVWNR	☐	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number	*
69	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
70	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
71	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
72	IMKEY2	☐	IMKEY2	IMKEY	CHAR	8	0	Second Real Estate object for property management postings
73	INTRENO2	☐	VVINTRENO2	VVINTRENO	CHAR	13	0	Second real estate object for property management postings
74	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
75	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
76	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
77	JLOESCH	☐	VVJLOEAR	JLOESCH	CHAR	1	0	Record planned for Real Estate archiving
78	SRECHNGNR	☐	VVRECHNGNR	VVRECHNGNR	NUMC	10	0	Rent Invoice: Invoice Number
79	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
80	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
81	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
82	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
83	NFZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
84	SABGVERF	☐	RESABGVERF	RESABVEF	CHAR	1	0	Accrual/deferral procedure
85	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
86	.INCLUDE	☐				0	0	Structures for generating change document update programs
87	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
88	SPARTNR	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	SPRT1
89	APPLI	☐	VV_APPLN	APPKZ	NUMC	3	0	Application number = Price list components
90	VORGI	☐	VORGI	VORGI	CHAR	25	0	Transaction
91	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	*
92	.INCLUDE	☐				0	0	Subsidy STORE/RESTOR for RVIBEPP
93	ZUS_BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
94	ZUS_BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
95	ZUS_BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
96	ZUS_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
97	ZUS_BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
98	ZUS_ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
99	ZUS_BACKUP	☐	VVIS_ZUSON	JANE	CHAR	1	0	Different indicator for editing subsidies
100	ZUS_ZUSON	☐	VVIS_ZUSON	JANE	CHAR	1	0	Different indicator for editing subsidies
101	.INCLUDE	☐				0	0	Dunning Procedure - Real Estate
102	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
103	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
104	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
105	EIGR1	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value	*
106	EIGR2	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value	*
107	EIGR3	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value	*
108	EIGR4	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value	*
109	ANWND	☐	ANWND_AD	ANWND_AD	CHAR	4	0	Account Determination: Application	*
110	RECNTYPE	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	*
111	RECN_VIRTUAL	☐	VVITEM_VIRTUAL	CHAR1	CHAR	1	0	Indicator: Lines not in database
112	RECN_TRANSFER	☐	VVITEM_RECN_TRANSFER_POST	CHAR1	CHAR	1	0	Indicator: Transfer posting for lease-out
113	RECN_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
114	RECN_ORI_BEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVIBEPP	BUKRS	T001	BUKRS
2	RVIBEPP	FDLEV	T036	EBENE
3	RVIBEPP	GSART	TZPA	GSART
4	RVIBEPP	MANDT	T000	MANDT
5	RVIBEPP	MWSKZ	T007A	MWSKZ
6	RVIBEPP	SBEWZITI	TZB03	SBEWZITI
7	RVIBEPP	SBWHR	TCURC	WAERS
8	RVIBEPP	SCWHR	TCURC	WAERS
9	RVIBEPP	SKOART	TZK01	SKOART
10	RVIBEPP	SMENR	VIMI01	SMENR
11	RVIBEPP	SNWHR	TCURC	WAERS
12	RVIBEPP	SPARTNR	SPRT1	PARTNR
13	RVIBEPP	SWENR	VIOB01	SWENR
14	RVIBEPP	ZAHLS	T008	ZAHLS
15	RVIBEPP	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in