SAP Table TIV26
Real Estate Contract Type (Entities)
TIV26 (Real Estate Contract Type (Entities)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TIV26 to other SAP tables.
TIV26 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||
|
SMVART
External Real Estate contract type
|
SMVART |
CHAR
|
4 | 0 | ||||||||||||||||
|
JTYPNUA
Rental unit usage category indicator
|
JTYPNUA |
NUMC
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
RECNCAT
Real Estate contract category
|
RECNCAT |
NUMC
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
NRNR
Number range number
|
NRNR |
CHAR
|
2 | 0 | ||||||||||||||||
|
FELDSTLST1
Field status definition
|
BU_FLDSTLS |
CHAR
|
250 | 0 | ||||||||||||||||
|
FELDSTLST2
Field status definition
|
BU_FLDSTLS |
CHAR
|
250 | 0 | ||||||||||||||||
|
FELDSTLST3
Field status definition
|
BU_FLDSTLS |
CHAR
|
250 | 0 | ||||||||||||||||
|
JALGVART
Indicator for "general contract" contract type
|
JALGVART |
CHAR
|
1 | 0 | ||||||||||||||||
|
JMULTZUORD
Indicator "multiple assignment object -> contract allowed"
|
JMULTZUORD |
CHAR
|
1 | 0 | ||||||||||||||||
|
JNOAREA
Rental based on area is not permitted
|
VVJNOAREA |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
RECNSRELOB
Real Estate Contract: Reference between objects and contract
|
VVSMVARTINT | TIVCN05 |
NUMC
|
2 | 0 | |||||||||||||||
|
GSART
Product Type
|
VVSART | TZPA |
CHAR
|
3 | 0 | |||||||||||||||
|
JNOVERTEIL
Indicator "no distribution on object"
|
JNOVERTEIL |
CHAR
|
1 | 0 | ||||||||||||||||
|
JAUTVERTEIL
Indicator for automatic distribution on object
|
JAUTVERTEIL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
NRNRVOR
Number range number
|
NRNR |
CHAR
|
2 | 0 | ||||||||||||||||
|
ROLETYP
Business Partner Role Category
|
BP_ROLETYP_OLD | TPZ3 |
CHAR
|
4 | 0 | |||||||||||||||
|
VARNR
BDT: Screen sequence
|
BU_VARNR | TBZ3 |
CHAR
|
6 | 0 | |||||||||||||||
|
TDOBJECT
Texts: Application Object
|
TDOBJECT | TTXOB |
CHAR
|
10 | 0 | |||||||||||||||
|
FELDSTLST4
Field status definition
|
BU_FLDSTLS |
CHAR
|
250 | 0 | ||||||||||||||||
|
APPL
Application Category
|
BP_APPL | TPZ12 |
CHAR
|
4 | 0 | |||||||||||||||
|
REMANDAT
Role of Contract in Mandate
|
REMANDAT |
NUMC
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
ROLETYP2
Business Partner Role Category
|
BP_ROLETYP_OLD | TPZ3 |
CHAR
|
4 | 0 | |||||||||||||||
|
RECNNONOTICE
Indicator: unlimited, without any arrangements for notice
|
RECNNONOTICE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
NEWCNTYPE
Contract Type of Flexible Real Estate Management
|
RECNNEWCNTYPE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
TIV26 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TIV26 | APPL | TIV26 | APPL |
TPZ12
Business partner: Application category
|
APPL |
| TIV26 | APPL | TIV26 | MANDT |
TPZ12
Business partner: Application category
|
MANDT |
| TIV26 | GSART | TIV26 | MANDT |
TZPA
Financial Assets Management Product Types
|
MANDT |
| TIV26 | GSART | TIV26 | GSART |
TZPA
Financial Assets Management Product Types
|
GSART |
| TIV26 | MANDT | TIV26 | MANDT |
T000
Clients
|
MANDT |
| TIV26 | RECNSRELOB | TIV26 | RECNSRELOB |
TIVCN05
RE Contract: Relationship between Contract and Objects
|
RECNSRELOB |
| TIV26 | ROLETYP | TIV26 | MANDT |
TPZ3
BP: Business Partner - Role Category
|
MANDT |
| TIV26 | ROLETYP | TIV26 | ROLETYP |
TPZ3
BP: Business Partner - Role Category
|
ROLETYP |
| TIV26 | ROLETYP2 | TIV26 | MANDT |
TPZ3
BP: Business Partner - Role Category
|
MANDT |
| TIV26 | ROLETYP2 | TIV26 | ROLETYP2 |
TPZ3
BP: Business Partner - Role Category
|
ROLETYP |
| TIV26 | TDOBJECT | TIV26 | TDOBJECT |
TTXOB
Valid text objects
|
TDOBJECT |
| TIV26 | VARNR | TIV26 | MANDT |
TBZ3
BDT Screen Sequences
|
CLIENT |
| TIV26 | VARNR | 'RECN' |
TBZ3
BDT Screen Sequences
|
OBJAP | |
| TIV26 | VARNR | TIV26 | VARNR |
TBZ3
BDT Screen Sequences
|
VARNR |