SAP ABAP Table REIS_PL_DB_L (ALV Reporting: Curtailments and Benefits)

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_DB_L	Table Relationship Diagram
Short Description	ALV Reporting: Curtailments and Benefits

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	OBJNRSRC	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
56	OBJASSTYPE	☐	REBDOBJASSTYPE	REBDOBJASSTYPE	CHAR	2	0	Type of Object Assignment	TIVBDOBJASSTYPE
57	OBJNRTRG	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
58	OBJVALIDFROM	☐	REBDRELVALIDFROM	RECADATEBEG	DATS	8	0	Date: Relationship Valid From
59	OBJVALIDTO	☐	REBDRELVALIDTO	RECADATEEND	DATS	8	0	Date: Relationship Valid To
60	ASSIGNONLYINFO	☐	REBDASSIGNONLYINFO	RECABOOL	CHAR	1	0	Informational Assignment
61	OBJNRSRCARCH	☐	REBDOBJNRSRCARCH	RECABOOL	CHAR	1	0	Source Object Was Archived
62	MEASVALUE	☐	REBDOAMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount of Assignment
63	MEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
64	ISMULTIASSGEN	☐	REBDISMULTIASSGEN	RECABOOL	CHAR	1	0	Generated Entry for Multiple Assignment
65	PEEFFECTDATE	☐	RELMPEEFFECTDATE	RECADATE	DATS	8	0	Effective Date
66	PEREVOCDATE	☐	RELMPEREVOCDATE	RECADATEEND	DATS	8	0	Date Revoked
67	PEPLANDATE	☐	RELMPEPLANDATE	RECADATE	DATS	8	0	Planning or Decision Date
68	PELOCATION	☐	RELMPELOCATION	RELMPELOCATION	CHAR	80	0	Location of Assigned Object
69	OBJTYPESRC	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
70	OBJTYPETRG	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
71	XOBJTYPESRC	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
72	XOBJTYPETRG	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
73	IDENTSRC	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
74	IDENTTRG	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
75	IDENTKEYSRC	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
76	IDENTKEYTRG	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
77	DESCRIPTIONSRC	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
78	DESCRIPTIONTRG	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
79	XLOBJTYPESRC	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
80	XLOBJTYPETRG	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
81	HASNOTE	☐	RECAHASNOTE	RECABOOL	CHAR	1	0	Memo Exists?
82	AOOBJTYPESRC	☐	REBDOBJASSTYPE	REBDOBJASSTYPE	CHAR	2	0	Type of Object Assignment	TIVBDOBJASSTYPE
83	XAOOBJTYPESRC	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
84	AOOBJNRSRC	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
85	AOIDENTSRC	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
86	AOIDENTKEYSRC	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
87	AODESCRIPTIONSRC	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
88	DBICON	☐	REISDBICON	RECAICON	CHAR	137	0	Encumbrance/Benefit (Color: Red, Green, Yellow)
89	XDB	☐	REISXDB	RECAXLDESCRIPTION	CHAR	60	0	Text of Curtailment or Benefit
90	DBTYPE	☐	REISDBTYPE	REISDBTYPE	CHAR	8	0	Type of Curtailment or Benefit	*
91	XDBTYPE	☐	REISXDBTYPE	RECAXLDESCRIPTION	CHAR	60	0	Type of Curtailment or Benefit
92	PEREGDATE	☐	RELMPEREGDATE	RECADATE	DATS	8	0	Date of Entry
93	PECHGDATE	☐	RELMPECHGDATE	RECADATE	DATS	8	0	Changed On
94	PEDELDATE	☐	RELMPEDELDATE	RECADATEEND	DATS	8	0	Deletion
95	.INCLUDE	☐				0	0	Parcel: Basic Data and Additional Data
96	.INCLUDE	☐				0	0	Parcel of Land: Basic Data
97	.INCLUDE	☐				0	0	Parcel of Land
98	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
99	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
100	.INCLUDE	☐				0	0	Parcel: Key Fields
101	LOCHIER	☐	RELMPLLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key of Parcel in Location Structure	TIVBDLOCHIER
102	PLSUBDIVNO	☐	RELMPLSUBDIVNO	RELMPLSUBDIVNO	CHAR	6	0	Tract Number
103	PLNO	☐	RELMPLNO	RELMPLNO	CHAR	20	0	Parcel Number
104	.INCLUDE	☐				0	0	Parcel: Non-Key Fields
105	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
106	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
107	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
108	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
109	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
110	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
111	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
112	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
113	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
114	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
115	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
116	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
117	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
118	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
119	XPL	☐	RELMXPL	RECAXLDESCRIPTION	CHAR	60	0	Parcel of Land - Text
120	VALIDFROM	☐	RELMPLVALIDFROM	RECADATEBEG	DATS	8	0	Date Parcel Valid From
121	VALIDTO	☐	RELMPLVALIDTO	RECADATEEND	DATS	8	0	Date: Parcel Ceased to Exist On
122	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
123	PLSURVEYIND	☐	RELMPLSURVEYIND	RELMPLSURVEYIND	CHAR	1	0	Surveying Status of Parcel
124	PLISTEMPORARY	☐	RELMPLISTEMPORARY	RECABOOL	CHAR	1	0	Temporary Parcel
125	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	*
126	USESIMPLEPLNO	☐	RELMPLUSESIMPLEPLNO	RECABOOL	CHAR	1	0	Use Simplified Parcel Number
127	.INCLUDE	☐				0	0
128	.INCLU--AP	☐				0	0	Active Country Specific Fields for Spain
129	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Parcel of Land
130	CADASTERREF	☐	REXCESCADREF	TEXT20	CHAR	20	0	Cadastral Register Number
131	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
132	XLOCHIER	☐	REBDXLOCHIER	RECAXLDESCRIPTION	CHAR	60	0	Text for Location Key in Location Structure
133	GTEXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
134	XMUSGFUNCTION	☐	REBDXMUSGFUNCTION	RECAXMDESCRIPTION	CHAR	30	0	Name of Function of Object (Medium)
135	CADMEAS	☐	REBDMEAS	REBDMEAS	CHAR	4	0	Measurement Type	*
136	CADMEASVALUE	☐	RELMPLCADMEASVALUE	REBDMEASVALUE	QUAN	17	4	Cadastral Area
137	CADMEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
138	CADVALIDFROM	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
139	CADVALIDTO	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
140	CADXMMEAS	☐	REBDXMMEAS	RECAXMDESCRIPTION	CHAR	30	0	Name of Measurement Type - Medium-Length
141	CADXSMEAS	☐	REBDXSMEAS	RECAXSDESCRIPTION	CHAR	15	0	Name of Measurement Type - Short
142	CADISSUMMEAS	☐	REBDISSUMMEAS	RECABOOL	CHAR	1	0	Total Measurement
143	OWNERICON	☐	REISOWNERICON	RECAICON	CHAR	137	0	There Are Additional Owners
144	.INCLUDE	☐				0	0	Reporting Fields: Partner Data
145	ISROLE	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
146	ISXROLE	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
147	ISPARTNER	☐	BP_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
148	ISXPARTNER	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
149	ISTEL_NUMBER_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
150	ISFAX_NUMBER_LONG	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
151	ISSMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
152	.INCLU-SO	☐				0	0	Reporting Fields: Partner Data
153	ISROLESO	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
154	ISXROLESO	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
155	ISPARTNERSO	☐	BP_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
156	ISXPARTNERSO	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
157	ISTEL_NUMBER_LONGSO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
158	ISFAX_NUMBER_LONGSO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
159	ISSMTP_ADDRSO	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
160	.INCLUDE	☐				0	0	Reporting Fields: Generic Part
161	GEN_OBJTYPE	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
162	GEN_OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
163	GEN_CONTRACT	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
164	GEN_PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
165	GEN_PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
166	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_DB_L	AOOBJTYPESRC	TIVBDOBJASSTYPE	OBJASSTYPE	KEY	1	CN
2	REIS_PL_DB_L	LOCHIER	TIVBDLOCHIER	LOCHIER	KEY	1	CN
3	REIS_PL_DB_L	LOCSYS01	TIVBDLOCSYS	LOCSYS
4	REIS_PL_DB_L	LOCSYS02	TIVBDLOCSYS	LOCSYS
5	REIS_PL_DB_L	LOCSYS03	TIVBDLOCSYS	LOCSYS
6	REIS_PL_DB_L	LOCSYS04	TIVBDLOCSYS	LOCSYS
7	REIS_PL_DB_L	LOCSYS05	TIVBDLOCSYS	LOCSYS
8	REIS_PL_DB_L	LOCSYS06	TIVBDLOCSYS	LOCSYS
9	REIS_PL_DB_L	LOCSYS07	TIVBDLOCSYS	LOCSYS
10	REIS_PL_DB_L	LOCSYS08	TIVBDLOCSYS	LOCSYS
11	REIS_PL_DB_L	LOCSYS09	TIVBDLOCSYS	LOCSYS
12	REIS_PL_DB_L	OBJASSTYPE	TIVBDOBJASSTYPE	OBJASSTYPE	KEY	1	CN

History

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