TIVLMSET SAP (General Settings in LUM) Table details
Dictionary Type: Table
Description: General Settings in LUM
Description: General Settings in LUM
Table field list including key, data, relationships and ABAP select examples
TIVLMSET is a standard SAP Table which is used to store General Settings in LUM data and is available within R/3 SAP systems depending on the version and release level.
The TIVLMSET table consists of various fields, each holding specific information or linking keys about General Settings in LUM data available in SAP. These include DUMMYKEY (Tech: Help Key (Contents Initial)), LRDEFAULTAREA (Land Register: Default for Area Units), LRDEFAULTCURR (Land Register: Default Currency), PLDEFAULTAREA (Parcel of Land: Default for Area Units).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TIVLMSET table 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DUMMYKEY | Tech: Help Key (Contents Initial) | RECADUMMYKEY | CHAR | 1 | CHAR1 | ||||
LRDEFAULTAREA | Land Register: Default for Area Units | RELMLRDEFAULTAREA | UNIT | 3 | T006 | CUNIT | MEINS | ||
LRDEFAULTCURR | Land Register: Default Currency | RELMLRDEFAULTCURR | CUKY | 5 | TCURC | WAERS | |||
PLDEFAULTAREA | Parcel of Land: Default for Area Units | RELMPLDEFAULTAREA | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLDEFAULTLENGTH | Parcel of Land: Default for Units of Length | RELMPLDEFAULTLENGTH | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLDEFAULTTIME | Parcel of Land: Default for Units of Time | RELMPLDEFAULTTIME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLDEFAULTLOCSYS | ID of Standard Location Structure for Parcels | RELMPLDEFAULTLOCSYS | CHAR | 4 | TIVBDLOCSYS | REBDLOCSYS | |||
PLCADASTRALMEAS | Measurement Type for the Cadastral Area | RELMPLCADASTRALMEAS | CHAR | 4 | TIVBDMEAS | ALPHA | REBDMEAS | REBDMEAS | REBDMEAS |
PLCONTRACTMEAS | Measurement Type for Parcel Subarea in Contract | RELMPLCONTRACTMEAS | CHAR | 4 | Assigned to domain | ALPHA | REBDMEAS | REBDMEAS | REBDMEAS |
PLSLLOCSYS | Hierarchical Location Structure for Overlays | RELMPLSLLOCSYS | CHAR | 4 | TIVBDLOCSYS | REBDLOCSYS | |||
PLSLLOCLEVEL | Level of Location Structure for Overlays | RELMPLSLLOCLEVEL | NUMC | 2 | REBDLOCLEVEL | ||||
PLSLCUSAGETYPE | Overlay for Cadastral Usage Types | RELMPLSLCUSAGETYPE | CHAR | 2 | TIVLMPLSL | RELMPLSLIDENO | |||
PLUSESIMPLEPLNO | Use Simplified Parcel Number | RELMPLUSESIMPLEPLNO | CHAR | 1 | RECABOOL | ||||
NADEFAULTAREA | Default Area Unit for Notice of Assessment | RELMNADEFAULTAREA | UNIT | 3 | T006 | CUNIT | MEINS | ||
NADEFAULTCURR | Default Currency for Notice of Assessment | RELMNADEFAULTCURR | CUKY | 5 | TCURC | WAERS | |||
RCDEFAULTAREA | Parcel Update: Default for Area Unit | RELMRCDEFAULTAREA | UNIT | 3 | T006 | CUNIT | MEINS | ||
PECSVARNR | Other Public Register: Contamination Screen Sequence | RELMPECSVARNR | CHAR | 6 | TBZ3 | BU_VARNR | |||
PENHVARNR | Other Public Register: Non-Hazardous Waste Screen Sequence | RELMPENHVARNR | CHAR | 6 | TBZ3 | BU_VARNR | |||
PEPSVARNR | Other Public Register: Site Protection Screen Sequence | RELMPEPSVARNR | CHAR | 6 | TBZ3 | BU_VARNR | |||
PEDPVARNR | Other Public Register: Development Plan Screen Sequence | RELMPEDPVARNR | CHAR | 6 | TBZ3 | BU_VARNR | |||
PEERVARNR | Other Public Register: Easement Register Screen Sequence | RELMPEERVARNR | CHAR | 6 | TBZ3 | BU_VARNR | |||
PEDPDEFLOCSYS | ID of Standard Location Structure for Development Planning | RELMPEDPDEFAULTLOCSYS | CHAR | 4 | Assigned to domain | REBDLOCSYS | |||
PEERDEFLOCSYS | ID of Standard Location Structure for Easement Registers | RELMPEERDEFAULTLOCSYS | CHAR | 4 | Assigned to domain | REBDLOCSYS |
Key field | Non-key field |
How do I retrieve data from SAP table TIVLMSET using ABAP code
The following ABAP code Example will allow you to do a basic selection on TIVLMSET to SELECT all data from the tableDATA: WA_TIVLMSET TYPE TIVLMSET.
SELECT SINGLE *
FROM TIVLMSET
INTO CORRESPONDING FIELDS OF WA_TIVLMSET
WHERE...
How to access SAP table TIVLMSET
Within an ECC or HANA version of SAP you can also view further information about TIVLMSET and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects