Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

REIS_PL_DB_L SAP (ALV Reporting: Curtailments and Benefits) Structure details

Dictionary Type: Structure
Description: ALV Reporting: Curtailments and Benefits

ABAP Code to SELECT data from REIS_PL_DB_L
Related tables to REIS_PL_DB_L
Access table REIS_PL_DB_L

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

REIS_PL_DB_L is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "ALV Reporting: Curtailments and Benefits" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_REIS_PL_DB_L TYPE REIS_PL_DB_L.

The REIS_PL_DB_L table consists of various fields, each holding specific information or linking keys about ALV Reporting: Curtailments and Benefits data available in SAP. These include LOCSYS01 (ID of Hierarchical Location Structure), LOCHIER01 (Location Key in Location Structure), XLOCSYS01 (Name of Hierarchical Location Structure), XLOCHIER01 (Text for Location Key in Location Structure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP REIS_PL_DB_L structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
.INCLU-01				0
LOCSYS01	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER01	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS01	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER01	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT01	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-02				0
LOCSYS02	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER02	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS02	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER02	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT02	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-03				0
LOCSYS03	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER03	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS03	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER03	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT03	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-04				0
LOCSYS04	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER04	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS04	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER04	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT04	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-05				0
LOCSYS05	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER05	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS05	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER05	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT05	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-06				0
LOCSYS06	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER06	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS06	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER06	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT06	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-07				0
LOCSYS07	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER07	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS07	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER07	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT07	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-08				0
LOCSYS08	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER08	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS08	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER08	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT08	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
.INCLU-09				0
LOCSYS09	ID of Hierarchical Location Structure	REBDLOCSYS	CHAR	4	TIVBDLOCSYS		REBDLOCSYS	REBDLOCSYS
LOCHIER09	Location Key in Location Structure	REBDLOCHIER	CHAR	30	Assigned to domain		REBDLOCHIER
XLOCSYS09	Name of Hierarchical Location Structure	REBDXLOCSYS	CHAR	30			RECAXMDESCRIPTION
XLOCHIER09	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
LOCLEVELCNT09	Number of Levels in Location Structure	REBDLOCLEVELCNT	NUMC	2			REBDLOCLEVEL
OBJNRSRC	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
OBJASSTYPE	Type of Object Assignment	REBDOBJASSTYPE	CHAR	2	TIVBDOBJASSTYPE		REBDOBJASSTYPE
OBJNRTRG	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
OBJVALIDFROM	Date: Relationship Valid From	REBDRELVALIDFROM	DATS	8			RECADATEBEG
OBJVALIDTO	Date: Relationship Valid To	REBDRELVALIDTO	DATS	8		REDAT	RECADATEEND
ASSIGNONLYINFO	Informational Assignment	REBDASSIGNONLYINFO	CHAR	1			RECABOOL
OBJNRSRCARCH	Source Object Was Archived	REBDOBJNRSRCARCH	CHAR	1			RECABOOL
MEASVALUE	Measurement Amount of Assignment	REBDOAMEASVALUE	QUAN	17(4)			REBDMEASVALUE
MEASUNIT	Measurement Unit	REBDMEASUNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ISMULTIASSGEN	Generated Entry for Multiple Assignment	REBDISMULTIASSGEN	CHAR	1			RECABOOL
PEEFFECTDATE	Effective Date	RELMPEEFFECTDATE	DATS	8			RECADATE
PEREVOCDATE	Date Revoked	RELMPEREVOCDATE	DATS	8		REDAT	RECADATEEND
PEPLANDATE	Planning or Decision Date	RELMPEPLANDATE	DATS	8			RECADATE
PELOCATION	Location of Assigned Object	RELMPELOCATION	CHAR	80			RELMPELOCATION
OBJTYPESRC	Object Type	RECAOBJTYPE	CHAR	2	Assigned to domain		J_OBART		RECAOBJTYPE
OBJTYPETRG	Object Type	RECAOBJTYPE	CHAR	2	Assigned to domain		J_OBART		RECAOBJTYPE
XOBJTYPESRC	Partial Object Type ID, for example 'BE'	RECAXOBJTYPE	CHAR	3			CHAR3
XOBJTYPETRG	Partial Object Type ID, for example 'BE'	RECAXOBJTYPE	CHAR	3			CHAR3
IDENTSRC	Complete Object Identification, for Example BE 1000/123	RECAIDENT	CHAR	50			CHAR50
IDENTTRG	Complete Object Identification, for Example BE 1000/123	RECAIDENT	CHAR	50			CHAR50
IDENTKEYSRC	ID Part Key, for example '1000/123'	RECAIDENTKEY	CHAR	45			CHAR45
IDENTKEYTRG	ID Part Key, for example '1000/123'	RECAIDENTKEY	CHAR	45			CHAR45
DESCRIPTIONSRC	Object Description	RECADESCRIPTION	CHAR	60			RECAXLDESCRIPTION
DESCRIPTIONTRG	Object Description	RECADESCRIPTION	CHAR	60			RECAXLDESCRIPTION
XLOBJTYPESRC	Object Type Name (20)	RECAXLOBJTYPE	CHAR	20			TEXT20
XLOBJTYPETRG	Object Type Name (20)	RECAXLOBJTYPE	CHAR	20			TEXT20
HASNOTE	Memo Exists?	RECAHASNOTE	CHAR	1			RECABOOL
AOOBJTYPESRC	Type of Object Assignment	REBDOBJASSTYPE	CHAR	2	TIVBDOBJASSTYPE		REBDOBJASSTYPE
XAOOBJTYPESRC	Partial Object Type ID, for example 'BE'	RECAXOBJTYPE	CHAR	3			CHAR3
AOOBJNRSRC	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
AOIDENTSRC	Complete Object Identification, for Example BE 1000/123	RECAIDENT	CHAR	50			CHAR50
AOIDENTKEYSRC	ID Part Key, for example '1000/123'	RECAIDENTKEY	CHAR	45			CHAR45
AODESCRIPTIONSRC	Object Description	RECADESCRIPTION	CHAR	60			RECAXLDESCRIPTION
DBICON	Encumbrance/Benefit (Color: Red, Green, Yellow)	REISDBICON	CHAR	137			RECAICON
XDB	Text of Curtailment or Benefit	REISXDB	CHAR	60			RECAXLDESCRIPTION
DBTYPE	Type of Curtailment or Benefit	REISDBTYPE	CHAR	8	Assigned to domain		REISDBTYPE
XDBTYPE	Type of Curtailment or Benefit	REISXDBTYPE	CHAR	60			RECAXLDESCRIPTION
PEREGDATE	Date of Entry	RELMPEREGDATE	DATS	8			RECADATE
PECHGDATE	Changed On	RELMPECHGDATE	DATS	8			RECADATE
PEDELDATE	Deletion	RELMPEDELDATE	DATS	8		REDAT	RECADATEEND
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
INTRENO	Internal Key of Real Estate Object	RECAINTRENO	CHAR	13			RECAINTRENO
LOCHIER	Location Key of Parcel in Location Structure	RELMPLLOCHIER	CHAR	30	TIVBDLOCHIER		REBDLOCHIER	RELMPLLOCHIER	REBDLOCHIERO
PLSUBDIVNO	Tract Number	RELMPLSUBDIVNO	CHAR	6		ALPHA	RELMPLSUBDIVNO	RELMPLSUBDIVNO
PLNO	Parcel Number	RELMPLNO	CHAR	20		PLNO	RELMPLNO	RELMPLNO
OBJNR	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
CREATIONTYPE	How the Object Was Created	RECACREATIONTYPE	CHAR	1			RECACREATIONTYPE
RERF	Entered by	RERF	CHAR	12			SYCHAR12
DERF	First Entered on	DERF	DATS	8			DATUM
TERF	Time of Initial Entry	TERF	TIMS	6			TIMES
REHER	Source of initial entry	REHER	CHAR	10			CHAR10
RBEAR	Employee ID	RBEAR	CHAR	12			SYCHAR12
DBEAR	Last Edited on	DBEAR	DATS	8			DATUM
TBEAR	Last Edited at	TBEAR	TIMS	6			TIMES
RBHER	Editing Source	RBHER	CHAR	10			CHAR10
RESPONSIBLE	Person Responsible	RECARESPONSIBLE	CHAR	12	Assigned to domain		XUBNAME		USER_COMP
USEREXCLUSIVE	User with Exclusive Change Authorization	RECAUSEREXCLUSIVE	CHAR	12	Assigned to domain		XUBNAME		USER_COMP
AUTHGRP	Authorization Group	RECAAUTHGRP	CHAR	40			RECAAUTHGRP
XPL	Parcel of Land - Text	RELMXPL	CHAR	60			RECAXLDESCRIPTION
VALIDFROM	Date Parcel Valid From	RELMPLVALIDFROM	DATS	8			RECADATEBEG
VALIDTO	Date: Parcel Ceased to Exist On	RELMPLVALIDTO	DATS	8		REDAT	RECADATEEND
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
PLSURVEYIND	Surveying Status of Parcel	RELMPLSURVEYIND	CHAR	1			RELMPLSURVEYIND
PLISTEMPORARY	Temporary Parcel	RELMPLISTEMPORARY	CHAR	1			RECABOOL
USGFUNCTION	Function of Object	REBDUSGFUNCTION	CHAR	4	Assigned to domain	ALPHA	REBDUSGFUNCTION		REBDUSGFUNC
USESIMPLEPLNO	Use Simplified Parcel Number	RELMPLUSESIMPLEPLNO	CHAR	1			RECABOOL
.INCLU--AP				0
CADASTERREF	Cadastral Register Number	REXCESCADREF	CHAR	20			TEXT20
XAUTHGRP	Description of Authorization Group	RECAXAUTHGRP	CHAR	60			RECAXLDESCRIPTION
XLOCHIER	Text for Location Key in Location Structure	REBDXLOCHIER	CHAR	60			RECAXLDESCRIPTION
GTEXT	Business area description	GTEXT	CHAR	30			TEXT30
XMUSGFUNCTION	Name of Function of Object (Medium)	REBDXMUSGFUNCTION	CHAR	30			RECAXMDESCRIPTION
CADMEAS	Measurement Type	REBDMEAS	CHAR	4	Assigned to domain	ALPHA	REBDMEAS	REBDMEAS	REBDMEAS
CADMEASVALUE	Cadastral Area	RELMPLCADMEASVALUE	QUAN	17(4)			REBDMEASVALUE
CADMEASUNIT	Measurement Unit	REBDMEASUNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CADVALIDFROM	Date: Measurement Valid From	REBDMEASVALIDFROM	DATS	8			RECADATE
CADVALIDTO	Date: Measurement Valid To	REBDMEASVALIDTO	DATS	8		REDAT	RECADATEEND
CADXMMEAS	Name of Measurement Type - Medium-Length	REBDXMMEAS	CHAR	30			RECAXMDESCRIPTION
CADXSMEAS	Name of Measurement Type - Short	REBDXSMEAS	CHAR	15			RECAXSDESCRIPTION
CADISSUMMEAS	Total Measurement	REBDISSUMMEAS	CHAR	1			RECABOOL
OWNERICON	There Are Additional Owners	REISOWNERICON	CHAR	137			RECAICON
ISROLE	Business Partner: Role	REBPROLE	CHAR	6	Assigned to domain		BU_ROLE
ISXROLE	Name of Business Partner Role	REBPXROLE	CHAR	30			RECAXMDESCRIPTION
ISPARTNER	Business Partner Number	BP_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
ISXPARTNER	Name/Address of Business Partner	REBPXPARTNER	CHAR	80			TEXT80
ISTEL_NUMBER_LONG	Complete number: dialling code+number+extension	AD_TELNRLG	CHAR	30			CHAR30
ISFAX_NUMBER_LONG	Complete number: dialling code+number+extension	AD_FXNRLNG	CHAR	30			CHAR30
ISSMTP_ADDR	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
.INCLU-SO				0
ISROLESO	Business Partner: Role	REBPROLE	CHAR	6	Assigned to domain		BU_ROLE
ISXROLESO	Name of Business Partner Role	REBPXROLE	CHAR	30			RECAXMDESCRIPTION
ISPARTNERSO	Business Partner Number	BP_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
ISXPARTNERSO	Name/Address of Business Partner	REBPXPARTNER	CHAR	80			TEXT80
ISTEL_NUMBER_LONGSO	Complete number: dialling code+number+extension	AD_TELNRLG	CHAR	30			CHAR30
ISFAX_NUMBER_LONGSO	Complete number: dialling code+number+extension	AD_FXNRLNG	CHAR	30			CHAR30
ISSMTP_ADDRSO	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
GEN_OBJTYPE	Object Type	RECAOBJTYPE	CHAR	2	Assigned to domain		J_OBART		RECAOBJTYPE
GEN_OBJNR	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
GEN_CONTRACT	Object Number	RECAOBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
GEN_PARTNER1	Business Partner Number	BU_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
GEN_PARTNER2	Business Partner Number	BU_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
ALVROWS	Number of Rows	REISALVROWS	INT2	5

Key field

Non-key field

How do I retrieve data from SAP structure REIS_PL_DB_L using ABAP code?

As REIS_PL_DB_L is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REIS_PL_DB_L as there is no data to select.

How to access SAP table REIS_PL_DB_L

Within an ECC or HANA version of SAP you can also view further information about REIS_PL_DB_L and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!