SAP ABAP Table REIS_PL_US_L (ALV Reporting: Usages of Parcels)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-IS (Application Component) Information System
     ⤷ RE_IS_LM (Package) RE: Land Use Management (LUM)Information System

Basic Data

Table Category	INTTAB	Structure
Structure	REIS_PL_US_L	Table Relationship Diagram
Short Description	ALV Reporting: Usages of Parcels

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	.INCLU-01	☐				0	0	Hierarchical Object Location - Screen Fields
2	LOCSYS01	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
3	LOCHIER01	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
4	XLOCSYS01	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
5	XLOCHIER01	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
6	LOCLEVELCNT01	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
7	.INCLU-02	☐				0	0	Hierarchical Object Location - Screen Fields
8	LOCSYS02	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
9	LOCHIER02	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
10	XLOCSYS02	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
11	XLOCHIER02	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
12	LOCLEVELCNT02	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
13	.INCLU-03	☐				0	0	Hierarchical Object Location - Screen Fields
14	LOCSYS03	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
15	LOCHIER03	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
16	XLOCSYS03	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
17	XLOCHIER03	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
18	LOCLEVELCNT03	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
19	.INCLU-04	☐				0	0	Hierarchical Object Location - Screen Fields
20	LOCSYS04	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
21	LOCHIER04	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
22	XLOCSYS04	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
23	XLOCHIER04	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
24	LOCLEVELCNT04	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
25	.INCLU-05	☐				0	0	Hierarchical Object Location - Screen Fields
26	LOCSYS05	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
27	LOCHIER05	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
28	XLOCSYS05	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
29	XLOCHIER05	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
30	LOCLEVELCNT05	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
31	.INCLU-06	☐				0	0	Hierarchical Object Location - Screen Fields
32	LOCSYS06	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
33	LOCHIER06	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
34	XLOCSYS06	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
35	XLOCHIER06	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
36	LOCLEVELCNT06	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
37	.INCLU-07	☐				0	0	Hierarchical Object Location - Screen Fields
38	LOCSYS07	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
39	LOCHIER07	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
40	XLOCSYS07	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
41	XLOCHIER07	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
42	LOCLEVELCNT07	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
43	.INCLU-08	☐				0	0	Hierarchical Object Location - Screen Fields
44	LOCSYS08	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
45	LOCHIER08	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
46	XLOCSYS08	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
47	XLOCHIER08	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
48	LOCLEVELCNT08	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
49	.INCLU-09	☐				0	0	Hierarchical Object Location - Screen Fields
50	LOCSYS09	☐	REBDLOCSYS	REBDLOCSYS	CHAR	4	0	ID of Hierarchical Location Structure	TIVBDLOCSYS
51	LOCHIER09	☐	REBDLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key in Location Structure	*
52	XLOCSYS09	☐	REBDXLOCSYS	RECAXMDESCRIPTION	CHAR	30	0	Name of Hierarchical Location Structure
53	XLOCHIER09	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
54	LOCLEVELCNT09	☐	REBDLOCLEVELCNT	REBDLOCLEVEL	NUMC	2	0	Number of Levels in Location Structure
55	PLUSSEQNO	☐	RELMPLUSSEQNO	RECANUMBER	NUMC	4	0	Sequence Number of Usage
56	PLUSIND	☐	RELMPLUSIND	RELMPLUSIND	CHAR	1	0	Indicator for the Usage
57	PLUSTYPE	☐	RELMPLUSTYPE	RELMPLUSTYPE	CHAR	6	0	Usage Type of Parcel	*
58	PLUSSUBTYPE	☐	RELMPLUSSUBTYPE	RELMPLUSSUBTYPE	CHAR	6	0	Subusage Type on Parcel	*
59	PLUSMEASVALUE	☐	RELMPLUSMEASVALUE	REBDMEASVALUE	QUAN	17	4	Size of Usage Area
60	PLUSMEASUNIT	☐	RELMPLUSMEASUNIT	MEINS	UNIT	3	0	Unit of Measurement for Usage Area	*
61	PLUSISOPNEC	☐	RELMPLUSISOPNEC	RECABOOL	CHAR	1	0	Operationally Necessary Area
62	PLUSVALIDFROM	☐	RECADATEFROM	RECADATEBEG	DATS	8	0	Date: Valid From
63	PLUSVALIDTO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
64	PLUSREALDATE	☐	RELMPLUSREALDATE	RECADATE	DATS	8	0	Date of Execution
65	XPLUSCOMMENT	☐	RELMXPLUSTYPE	RECAXLDESCRIPTION	CHAR	60	0	Usage Type on Parcel - Text
66	XPLUSTYPE	☐	RELMXPLUSSUBTYPE	RECAXLDESCRIPTION	CHAR	60	0	Subusage Type on Parcel - Text
67	XPLUSSUBTYPE	☐	RELMXPLUSIND	RECAXMDESCRIPTION	CHAR	30	0	Indicator for Usage - Text
68	XPLUSIND	☐	RELMXPLUSIND	RECAXMDESCRIPTION	CHAR	30	0	Indicator for Usage - Text
69	INTRENOCN	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
70	OBJNRCN	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
71	BUKRSCN	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
72	RECNNRCN	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
73	RECNTYPECN	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	*
74	RECNBEGCN	☐	RECNCNBEG	RECADATE	DATS	8	0	Date of contract start
75	RECNENDABSCN	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
76	RECNTXTCN	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
77	XRECNTYPECN	☐	XMVARTM	XMBEZ	CHAR	30	0	Description of type of RE contract type
78	TRANSPOSSFROMCN	☐	RECNTRANSPOSSFROM	RECADATEBEG	DATS	8	0	Transfer of Possession: Start Date
79	TRANSPOSSTOCN	☐	RECNTRANSPOSSTO	RECADATEEND	DATS	8	0	Transfer of Possession: End Date
80	IDENTKEYCN	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
81	.INCLUDE	☐				0	0	Parcel: Basic Data and Additional Data
82	.INCLUDE	☐				0	0	Parcel of Land: Basic Data
83	.INCLUDE	☐				0	0	Parcel of Land
84	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
85	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
86	.INCLUDE	☐				0	0	Parcel: Key Fields
87	LOCHIER	☐	RELMPLLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key of Parcel in Location Structure	TIVBDLOCHIER
88	PLSUBDIVNO	☐	RELMPLSUBDIVNO	RELMPLSUBDIVNO	CHAR	6	0	Tract Number
89	PLNO	☐	RELMPLNO	RELMPLNO	CHAR	20	0	Parcel Number
90	.INCLUDE	☐				0	0	Parcel: Non-Key Fields
91	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
92	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
93	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
94	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
95	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
96	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
97	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
98	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
99	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
100	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
101	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
102	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
103	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
104	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
105	XPL	☐	RELMXPL	RECAXLDESCRIPTION	CHAR	60	0	Parcel of Land - Text
106	VALIDFROM	☐	RELMPLVALIDFROM	RECADATEBEG	DATS	8	0	Date Parcel Valid From
107	VALIDTO	☐	RELMPLVALIDTO	RECADATEEND	DATS	8	0	Date: Parcel Ceased to Exist On
108	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
109	PLSURVEYIND	☐	RELMPLSURVEYIND	RELMPLSURVEYIND	CHAR	1	0	Surveying Status of Parcel
110	PLISTEMPORARY	☐	RELMPLISTEMPORARY	RECABOOL	CHAR	1	0	Temporary Parcel
111	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	*
112	USESIMPLEPLNO	☐	RELMPLUSESIMPLEPLNO	RECABOOL	CHAR	1	0	Use Simplified Parcel Number
113	.INCLUDE	☐				0	0
114	.INCLU--AP	☐				0	0	Active Country Specific Fields for Spain
115	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Parcel of Land
116	CADASTERREF	☐	REXCESCADREF	TEXT20	CHAR	20	0	Cadastral Register Number
117	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
118	XLOCHIER	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
119	GTEXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
120	XMUSGFUNCTION	☐	REBDXMUSGFUNCTION	RECAXMDESCRIPTION	CHAR	30	0	Name of Function of Object (Medium)
121	CADMEAS	☐	REBDMEAS	REBDMEAS	CHAR	4	0	Measurement Type	*
122	CADMEASVALUE	☐	RELMPLCADMEASVALUE	REBDMEASVALUE	QUAN	17	4	Cadastral Area
123	CADMEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
124	CADVALIDFROM	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
125	CADVALIDTO	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
126	CADXMMEAS	☐	REBDXMMEAS	RECAXMDESCRIPTION	CHAR	30	0	Name of Measurement Type - Medium-Length
127	CADXSMEAS	☐	REBDXSMEAS	RECAXSDESCRIPTION	CHAR	15	0	Name of Measurement Type - Short
128	CADISSUMMEAS	☐	REBDISSUMMEAS	RECABOOL	CHAR	1	0	Total Measurement
129	CNMEAS	☐	REBDMEAS	REBDMEAS	CHAR	4	0	Measurement Type	*
130	CNMEASVALUE	☐	RELMPLCNMEASVALUE	REBDMEASVALUE	QUAN	17	4	Contract Area
131	CNMEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
132	CNVALIDFROM	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
133	CNVALIDTO	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
134	CNXMMEAS	☐	REBDXMMEAS	RECAXMDESCRIPTION	CHAR	30	0	Name of Measurement Type - Medium-Length
135	CNXSMEAS	☐	REBDXSMEAS	RECAXSDESCRIPTION	CHAR	15	0	Name of Measurement Type - Short
136	CNISSUMMEAS	☐	REBDISSUMMEAS	RECABOOL	CHAR	1	0	Total Measurement
137	.INCLUDE	☐				0	0	Reporting Fields: Partner Data
138	ISROLE	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
139	ISXROLE	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
140	ISPARTNER	☐	BP_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
141	ISXPARTNER	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
142	ISTEL_NUMBER_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
143	ISFAX_NUMBER_LONG	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
144	ISSMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
145	.INCLU-SO	☐				0	0	Reporting Fields: Partner Data
146	ISROLESO	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
147	ISXROLESO	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
148	ISPARTNERSO	☐	BP_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
149	ISXPARTNERSO	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
150	ISTEL_NUMBER_LONGSO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
151	ISFAX_NUMBER_LONGSO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
152	ISSMTP_ADDRSO	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
153	.INCLUDE	☐				0	0	Reporting Fields: Generic Part
154	GEN_OBJTYPE	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
155	GEN_OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
156	GEN_CONTRACT	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
157	GEN_PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
158	GEN_PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
159	ALVROWS	☐	REISALVROWS		INT2	5	0	Number of Rows

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REIS_PL_US_L	LOCHIER	TIVBDLOCHIER	LOCHIER	KEY	1	CN
2	REIS_PL_US_L	LOCSYS01	TIVBDLOCSYS	LOCSYS
3	REIS_PL_US_L	LOCSYS02	TIVBDLOCSYS	LOCSYS
4	REIS_PL_US_L	LOCSYS03	TIVBDLOCSYS	LOCSYS
5	REIS_PL_US_L	LOCSYS04	TIVBDLOCSYS	LOCSYS
6	REIS_PL_US_L	LOCSYS05	TIVBDLOCSYS	LOCSYS
7	REIS_PL_US_L	LOCSYS06	TIVBDLOCSYS	LOCSYS
8	REIS_PL_US_L	LOCSYS07	TIVBDLOCSYS	LOCSYS
9	REIS_PL_US_L	LOCSYS08	TIVBDLOCSYS	LOCSYS
10	REIS_PL_US_L	LOCSYS09	TIVBDLOCSYS	LOCSYS

History

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