SAP table TIV26 (Real Estate Contract Type (Entities))

SAP table TIV26 has 2 primary key fields being MANDT,SMVART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SMVART External Real Estate Contract Type CHAR 4 0 SMVART
JTYPNUA Rental unit usage category indicator NUMC 1 0 JTYPNUA
1 Non-commercial
2 Commercial
3 Used for both
4 Area and room rental
5 Vacant rental unit
RECNCAT Real Estate contract category NUMC 1 0 RECNCAT
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 CHAR 2 0 NRNR
FELDSTLST1 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST2 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST3 Field Status Bar CHAR 250 0 BU_FLDSTLS
JALGVART Indicator for "general contract" contract type CHAR 1 0 JALGVART
JMULTZUORD Indicator "multiple assignment object -> contract allowed" CHAR 1 0 JMULTZUORD
JNOAREA Rental based on area is not permitted CHAR 1 0 VVJNOAREA
RECNSRELOB Real Estate Contract: Reference between objects and contract NUMC 2 0 TIVCN05 VVSMVARTINT
GSART Product Type CHAR 3 0 TZPA VVSART
JNOVERTEIL Indicator "no distribution on object" CHAR 1 0 JNOVERTEIL
JAUTVERTEIL Indicator for automatic distribution on object CHAR 1 0 JAUTVERTEIL
NRNRVOR Number range number CHAR 2 0 NRNR
ROLETYP Business Partner Role Category CHAR 4 0 TPZ3 BP_ROLETYP_OLD
VARNR BDT: Screen sequence CHAR 6 0 TBZ3 BU_VARNR
TDOBJECT Texts: application object CHAR 10 0 TTXOB TDOBJECT
FELDSTLST4 Field Status Bar CHAR 250 0 BU_FLDSTLS
APPL Application Category CHAR 4 0 TPZ12 BP_APPL
REMANDAT Role of Contract in Mandate NUMC 1 0 REMANDAT
ROLETYP2 Business Partner Role Category CHAR 4 0 TPZ3 BP_ROLETYP_OLD
RECNNONOTICE Indicator: unlimited, without any arrangements for notice CHAR 1 0 RECNNONOTICE
NEWCNTYPE Contract Type of Flexible Real Estate Management CHAR 1 0 RECNNEWCNTYPE

TIV26 foreign key relationships

Table Field Check Table Check Field
0 TIV26 APPL TPZ12 Business partner: Application category MANDT
0 TIV26 APPL TPZ12 Business partner: Application category APPL
1 TIV26 GSART TZPA Financial Assets Management Product Types MANDT
1 TIV26 GSART TZPA Financial Assets Management Product Types GSART
0 TIV26 ROLETYP TPZ3 BP: Business Partner - Role Category MANDT
0 TIV26 ROLETYP TPZ3 BP: Business Partner - Role Category ROLETYP
1 TIV26 ROLETYP2 TPZ3 BP: Business Partner - Role Category MANDT
1 TIV26 ROLETYP2 TPZ3 BP: Business Partner - Role Category ROLETYP
0 TIV26 TDOBJECT TTXOB Valid text objects TDOBJECT
1 TIV26 VARNR TBZ3 BDT Screen Sequences CLIENT
1 TIV26 VARNR TBZ3 BDT Screen Sequences OBJAP
1 TIV26 VARNR TBZ3 BDT Screen Sequences VARNR