SAP table TIPZZ (Real estate installation parameters, comp.code-independent)

SAP table TIPZZ has 2 primary key fields being MANDT,VVXLEERKEY.

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 * MANDT
VVXLEERKEY Empty key only for client-specific tables CHAR 1 0 VVXLEERKEY
HKOST_MD Indicator read / write DATASETs tape / diskette (HeatCst) CHAR 1 0 HKOST_MD
D Disk
M Magnetic tape
RZNR Computer center number NUMC 2 0 RZNR
DTAUSHVERZ Directory for files CHAR 50 0 DTAUSHVERZ
DTAUSNAMEA Heating costs exchange file name record type A CHAR 20 0 DTAUSNAMEA
DTAUSNAMED Heating exchange record type D file name CHAR 20 0 DTAUSNAMED
DTAUSBK Heating costs exchange balance sheet/ costs CHAR 20 0 DTAUSBK
DTAUSLM Heating costs exchange record type L/M file name CHAR 20 0 DTAUSLM
DTAUSTRENN File name list separator (data medium exchange) CHAR 1 0 DTAUSTRENN
IND_BAUK Construction costs index CHAR 5 0 T094A IND_BAUK
EQM_INSTAL Plant Maintenance (PM) comp. is installed for Real Estate CHAR 1 0 EQM_INSTAL
JINPWE Suppress leading zeros for entry of BE number ? CHAR 1 0 VVJINPWE
JOUTWE Suppress leading zeros for output of bus. entity no.? CHAR 1 0 VVJOUTWE
JINPGEB Suppress leading zeros for building no. entry ? CHAR 1 0 VVJINPGEB
JOUTGEB Suppress leading zeros for output of building no. ? CHAR 1 0 VVJOUTGEB
JINPGRU Suppress leading zeros for property no. entry ? CHAR 1 0 VVJINPGRU
JOUTGRU Suppress leading zeros for output of property no. ? CHAR 1 0 VVJOUTGRU
JINPME Suppress leading zeros for rental unit no. entry ? CHAR 1 0 VVJINPME
JOUTME Suppress leading zeros for output of rental unit no. ? CHAR 1 0 VVJOUTME
BWAUS Application field Status CHAR 60 0 FEAUS2
MBWAUS Field status co-applicant (real estate application) CHAR 60 0 FEAUS3
ARC_INSTAL X - Optical archive installed CHAR 1 0 ARC_INSTAL
MWSKZ Tax code for unqualified down payment CHAR 2 0 * VVMWSKZ
VVSBSCHL Posting key for bank debit posting CHAR 2 0 TBSL VVSBSCHL
XTXTV Word processing connected CHAR 10 0 VVXTXTV
CTV Word processing interface: CTV
M/TEXT Word processing interface: M/Text
SAPSCRIPT Word processing interface: SAPSCRIPT
BLART Doc.type for transfers btwn corr.items in an asset CHAR 2 0 T003 VVBLARTBB
ACCSYSTEM Definition of Accounting System CHAR 4 0 TIVRAACCSYSTEM RERAACCSYSTEM
JINPASP CHAR 1 0 VJINPASP
JOUTASP CHAR 1 0 VJOUTASP
JINPARO CHAR 1 0 VJINPARO
JOUTARO CHAR 1 0 VJOUTARO
JINPUSP CHAR 1 0 VJINPUSP
JOUTUSP CHAR 1 0 VJOUTUSP

TIPZZ foreign key relationships

Table Field Check Table Check Field
0 TIPZZ ACCSYSTEM TIVRAACCSYSTEM Accounting System ACCSYSTEM
1 TIPZZ BLART T003 Document Types MANDT
0 TIPZZ VVSBSCHL TBSL Posting Key MANDT
0 TIPZZ VVSBSCHL TBSL Posting Key BSCHL