TIVMISET SAP (Basic Settings for Migration) Table details
Dictionary Type: Table
Description: Basic Settings for Migration
Description: Basic Settings for Migration
Table field list including key, data, relationships and ABAP select examples
TIVMISET is a standard SAP Table which is used to store Basic Settings for Migration data and is available within R/3 SAP systems depending on the version and release level.
The TIVMISET table consists of various fields, each holding specific information or linking keys about Basic Settings for Migration data available in SAP. These include DUMMYKEY (Tech: Help Key (Contents Initial)), NEWDATADELETABLE (General Yes/No Field), DEFAULTAREAUNIT (Defaults for Area Units), CCSOURCE (Source Company Code).. 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 TIVMISET 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 | ||||
| NEWDATADELETABLE | General Yes/No Field | RECABOOL | CHAR | 1 | RECABOOL | ||||
| DEFAULTAREAUNIT | Defaults for Area Units | REBDDEFAULTAREA | UNIT | 3 | T006 | CUNIT | MEINS | ||
| CCSOURCE | Source Company Code | REMICCSOURCE | CHAR | 4 | Assigned to domain | BUKRS | |||
| SMIETR | Tenancy law | SMIETR | CHAR | 5 | TIV03 | SMIETR | |||
| FIRSTPOSTING | Cash Flow Generated Starting On | RECDCFSTARTFROM | DATS | 8 | RECADATE | ||||
| RECNDPO | Cash Flow Generated Starting On | RECDCFSTARTFROM | DATS | 8 | RECADATE | ||||
| CNTYPEMANAGEMENT | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
| KUNNR_CNMANAGE | BP Role | BU_PARTNERROLE | CHAR | 6 | Assigned to domain | BU_ROLE | BUPA_ROLE | ||
| LIFNR_CNMANAGE | BP Role | BU_PARTNERROLE | CHAR | 6 | Assigned to domain | BU_ROLE | BUPA_ROLE | ||
| FIXFITCHARACT | Fixtures/Fittings Characteristic for Apportionment Loss Risk | REMIFIXFITCHARACT_EXTRACHRG | CHAR | 6 | TIVBDCHARACT | ALPHA | REBDFIXFITCHARACT | ||
| MEASREFAREA | Measurement Type for Reference Area | REMIMEASREFAREA | CHAR | 4 | TIVBDMEAS | ALPHA | REBDMEAS | ||
| MEASVOLUME | Measurement Type for Volume | REMIMEASVOLUME | CHAR | 4 | TIVBDMEAS | ALPHA | REBDMEAS | ||
| MEASROOMS | Measurement Type for Transfer of Rooms | REMIMEASROOMS | CHAR | 4 | Assigned to domain | ALPHA | REBDMEAS | ||
| MEASHALFROOMS | Measurement Type for Transferring Half Room | REMIMEASHALFROOMS | CHAR | 4 | Assigned to domain | ALPHA | REBDMEAS | ||
| MEASROOMUNIT | Unit for Number of Rooms | REMIMEASROOMUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
| SERVERGRP | Server Group for Parallel Processing | SPTA_RFCGR | CHAR | 20 | RZLLI_ACN | SPTA_RFCGR | SPTA_SERVER_GROUP | ||
| MAXTASKS | Maximum Number of Tasks | RECAMAXTASKS | INT4 | 10 | INT4 | ||||
| MAXCOLLECTCN | Maximum Number of Rental Objects per Main Contract | REMIMAXCOLLECTCN | INT1 | 3 | INT1 | ||||
| CONDBASICRENT | Condition Type -Basic Rent of Comparative Apt.(Net, No Heat) | REMICONDTYPEBASICRENT | CHAR | 4 | TIVCDCONDTYPE | ALPHA | RECDCONDTYPE | ||
| CONDVALIDFROM | Date Beginning on Which the Condition Is Valid | REMICONDVALIDFROM | DATS | 8 | RECADATE | ||||
| CONDPURPOSEEXT | Conditions - External Purpose | REMICONDPURPOSEEXT | CHAR | 4 | TIVCDCOPUEXT | RECDCONDPURPOSEEXT | |||
| USAGETYPE | Usage Type of Rental Object | REMIUSAGETYPE | NUMC | 4 | TIV01 | SNUNR | |||
| USEESMIVE | Always Use Number of Collective Lease-Out | REMIUSEESMIVE | CHAR | 1 | RECABOOL | ||||
| MIGLANDREQ | Migrate Land Registers | REMIMIGLANDREQ | CHAR | 1 | RECABOOL | ||||
| IMPLCLNAME | Name of Implementation Class | RECAIMPLCLNAME | CHAR | 30 | SEOCLSNAME | RECAIMPLCLNAME | |||
| USEEXTCHECK | Activates Extended Check | REMIUSEEXTCHECK | CHAR | 1 | RECABOOL | ||||
| BUSOBJCHECKIND | How Should BOs Be Checked | REMIBUSOBJCHECKIND | CHAR | 1 | REMIBUSOBJCHECKIND | ||||
| MIGOFFER | Migrate Offer | REMIMIGOFFER | CHAR | 1 | RECABOOL | ||||
| CEACONDGROUP | Condition Group | RECDCONDGROUP | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDGROUP |
| Key field | Non-key field |
How do I retrieve data from SAP table TIVMISET using ABAP code
The following ABAP code Example will allow you to do a basic selection on TIVMISET to SELECT all data from the tableDATA: WA_TIVMISET TYPE TIVMISET.
SELECT SINGLE *
FROM TIVMISET
INTO CORRESPONDING FIELDS OF WA_TIVMISET
WHERE...
How to access SAP table TIVMISET
Within an ECC or HANA version of SAP you can also view further information about TIVMISET 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