1. Home
  2. Resources
  3. SAP Tables
  4. TIV26 - Real Estate Contract Type (Entities)

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
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
1 Non-commercial
2 Commercial
3 Used for both
4 Area and room rental
5 Vacant rental unit
RECNCAT Real Estate contract category RECNCAT NUMC 1 0
0 Customer contract
1 Vendor contract
2 Customer/vendor contract
3 Internal contract
4 G/L account contract
5 Mandate contract
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
X Yes
NULL No
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
X Yes
NULL No
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
0 No Mandate Contract
1 Object Mandate (Simple Mandate)
5 Condominium Owners Association (COA)
6 Condominium Managemement (Separate Ownership)
9 Assessment Contract
ROLETYP2 Business Partner Role Category BP_ROLETYP_OLD TPZ3 CHAR 4 0
RECNNONOTICE Indicator: unlimited, without any arrangements for notice RECNNONOTICE CHAR 1 0
X Yes
NULL No
NEWCNTYPE Contract Type of Flexible Real Estate Management RECNNEWCNTYPE CHAR 1 0
X Yes
NULL No

TIV26 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TIV26 APPL TIV26 MANDT TPZ12 Business partner: Application category MANDT
TIV26 APPL TIV26 APPL TPZ12 Business partner: Application category APPL
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 'RECN' TBZ3 BDT Screen Sequences OBJAP
TIV26 VARNR TIV26 VARNR TBZ3 BDT Screen Sequences VARNR
TIV26 VARNR TIV26 MANDT TBZ3 BDT Screen Sequences CLIENT