SAP ABAP Table CMVIBEPP (Structure for Transferring Real Estate to Cash Management)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ FF (Package) Cash Management

Basic Data

Table Category	INTTAB	Structure
Structure	CMVIBEPP	Table Relationship Diagram
Short Description	Structure for Transferring Real Estate to Cash Management

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	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
87	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
88	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
89	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
90	FDGRP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
91	FDTAG	☐	FDTAG	DATUM	DATS	8	0	Planning Date
92	AKTION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in