SAP ABAP Table U_22603 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_22603	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in