SAP ABAP Table REEX_EXT_CMVIBEPP (Enhanced CMVIBEPP for Cash Management Link to RE-FX)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CN (Application Component) Real Estate Contract
     ⤷ RE_EX_TR (Package) RE: Treasury

Basic Data

Table Category	INTTAB	Structure
Structure	REEX_EXT_CMVIBEPP	Table Relationship Diagram
Short Description	Enhanced CMVIBEPP for Cash Management Link to RE-FX

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	Structure for Transferring Real Estate to Cash Management
2	.INCLUDE	☐				0	0	Flow data - Planned items for real estate management
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
5	DTRANS	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
6	TTRANS	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
7	NTRANS	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
8	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
11	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
12	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
13	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
14	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
15	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
16	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
17	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
18	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
19	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
20	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
21	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
22	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
23	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
24	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
25	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
26	SXBLNR	☐	SXBLNR1	XBLNR1	CHAR	16	0	Debit position identification -> Acctng reference doc. no.
27	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
28	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
29	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	*
30	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	*
31	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
32	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
33	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
34	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
35	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
36	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
37	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
38	FDUPD	☐	FDUPD	KENZX	CHAR	1	0	Flag as to whether record enters cash management + forecast
39	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
40	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
41	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
42	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
43	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
44	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
45	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
46	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
47	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
48	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
49	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
50	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
51	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
52	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
53	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
54	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
55	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
56	SSORTZIT	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
57	NFOLGE	☐	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
58	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
59	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
60	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
61	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
62	DTRANSREF	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
63	TTRANSREF	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
64	NTRANSREF	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
65	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
66	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
67	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
68	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
69	SVWNR	☐	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number	*
70	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
71	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
72	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
73	IMKEY2	☐	IMKEY2	IMKEY	CHAR	8	0	Second Real Estate object for property management postings
74	INTRENO2	☐	VVINTRENO2	VVINTRENO	CHAR	13	0	Second real estate object for property management postings
75	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
76	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
77	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
78	JLOESCH	☐	VVJLOEAR	JLOESCH	CHAR	1	0	Record planned for Real Estate archiving
79	SRECHNGNR	☐	VVRECHNGNR	VVRECHNGNR	NUMC	10	0	Rent Invoice: Invoice Number
80	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
81	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
82	GFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
83	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
84	NFZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
85	SABGVERF	☐	RESABGVERF	RESABVEF	CHAR	1	0	Accrual/deferral procedure
86	XCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
87	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
88	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
89	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
90	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
91	FDGRP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
92	FDTAG	☐	FDTAG	DATUM	DATS	8	0	Planning Date
93	AKTION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
94	CFPAYGUID	☐	RECDCFPAYGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Payment-Related Cash Flow

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	200