SAP ABAP Table VMCAR01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VMCAR01	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	SIDGDEMAND	☑	RESADSGDEMAND	RESADSGDEMAND	CHAR	20	0	Rental Request Identification (Global ID)
2	SIDLDEMAND	☐	RESADSLDEMAND	RESADSLIDENT	CHAR	35	0	Rental Request Identification (Local ID)
3	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
4	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
5	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
6	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
7	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
8	PARTNR	☑	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number
9	XMEMOTEXT	☐	RESADXMEMOTEXT	RESADXMEMOTEXT	CHAR	85	0	Memo Text For The Request (User-Defined Text)
10	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
11	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
12	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
13	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
14	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
15	DFREEFROM	☐	RESADDFREEFROMDE	DATS	DATS	8	0	Occup.as from
16	DFREETILL	☐	RESADDFREETILLDE	DATS	DATS	8	0	Limited lease in until
17	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
18	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
19	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
20	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
21	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
22	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
23	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
24	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
25	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
26	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
27	SLOCALGRP	☐	RESADSLOCALGRP	RESADSLOCALGRP	NUMC	1	0	District Location Group Rental Request	TIVAR14
28	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
29	SAGEGROUP	☐	RESADSAGEGROUP	RESADSNEWBUILD	CHAR	1	0	Building Age Class
30	SPARKGRP	☐	RESADSPARKGRP	RESADSPARKGRP	NUMC	2	0	Group of Real Estate Object Parking Spaces	TIVAR12
31	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
32	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
33	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
34	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
35	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
36	ZIPSTRING	☐	RESADZIPSTRING	RESADZIPSTRING	CHAR	35	0	Character String With Zip Code Details For Rental Request
37	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
38	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
39	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
40	AUTHGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
41	PROCESSMARK	☐	VVIBEARKZ	CHAR4	CHAR	4	0	Processing Indicator for Rental Request	TIVC1
42	PRESELECTION	☐	VVIVORMKZ	CHAR4	CHAR	4	0	Preselection Indicator for Rental Request	TIVC2
43	PROCESSSTAT	☐	VVIBSTAT	CHAR4	CHAR	4	0	Rental Request Processing Status	TIVC3
44	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
45	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
46	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
47	DAPPLY	☐	DEINB	DDAT	DATS	8	0	Date application was received
48	SCRDSTNDG	☐	SBONI	SBONI	NUMC	2	0	Credit standing application	TIV62
49	DWBS	☐	WBSDATUM	DATUM	DATS	8	0	Accommodation entitlement certificate from
50	DWBSVALID	☐	WBSGUELT	DATUM	DATS	8	0	Accommodation entitlement certificate valid to
51	WBSPRIORITY	☐	VVWBSDRING	CHAR4	CHAR	4	0	Priority for accommodation entitlement certificate	TIVB7
52	WBSPERSON	☐	WBSPERS	CHAR4	CHAR	4	0	Accomm.entitlement certif: Special group of people	TIVB8
53	WBSAPPEND	☐	WBSZUS	CHAR8	CHAR	8	0	Additional information for accomm.entitlemnt certif.	TIVB9
54	WBSNROOMFULL	☐	WBSAZIMM	DEC3	DEC	3	0	No. of rooms acc.to accommodation entitlement certificate
55	WBSNROOMHALF	☐	WBSAHALBZI	DEC2	DEC	2	0	Half room acc.to accommodation entitlement certificate
56	WBSAREAKEY	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
57	WBSPSIZE	☐	WBSFQM	VVBFLART	QUAN	14	4	Area factor acc.to accommodation entitlement certificate
58	INCOME_CUR	☐	VVINCOME_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
59	NET_INCOME	☐	VVNET_INCOME	WERTV8	CURR	15	2	Annual Net Income
60	NATION	☐	VVNATION	LAND1	CHAR	3	0	Nationality	T005

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VMCAR01	AREAKEY	T006	MSEHI	KEY	1	CN
2	VMCAR01	CURRKEY	TCURC	WAERS	KEY	1	CN
3	VMCAR01	INCOME_CUR	TCURC	WAERS	KEY	1	CN
4	VMCAR01	NATION	T005	LAND1	KEY	1	CN
5	VMCAR01	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
6	VMCAR01	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
7	VMCAR01	PARTWAY	TIVP3	WAY	KEY	1	CN
8	VMCAR01	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
9	VMCAR01	PRESELECTION	TIVC2	VORMKZ	KEY	1	CN
10	VMCAR01	PROCESSMARK	TIVC1	BEARKZ	KEY	1	CN
11	VMCAR01	PROCESSSTAT	TIVC3	BSTAT	KEY	1	CN
12	VMCAR01	SCITYC	T005G	CITYC	KEY	1	CN
13	VMCAR01	SCOUNC	T005E	COUNC	KEY	1	CN
14	VMCAR01	SCOUNTRY	T005	LAND1	KEY	1	CN
15	VMCAR01	SCRDSTNDG	TIV62	SBONI	KEY	1	CN
16	VMCAR01	SLOCALGRP	TIVAR14	SLOCALGRP	KEY	1	CN
17	VMCAR01	SOBJGROUP	TIVAR02	SOBJGROUP	KEY	1	CN
18	VMCAR01	SPARKGRP	TIVAR12	SPARKGRP	KEY	1	CN
19	VMCAR01	SREGIO	T005S	BLAND	KEY	1	CN
20	VMCAR01	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN
21	VMCAR01	WBSAPPEND	TIVB9	WBSZUS	KEY	1	CN
22	VMCAR01	WBSAREAKEY	T006	MSEHI	KEY	1	CN
23	VMCAR01	WBSPERSON	TIVB8	WBSPERS	KEY	1	CN
24	VMCAR01	WBSPRIORITY	TIVB7	WBSDRING	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in