SAP table TIPZB (General real estate installation parameters, co.cd.-depend.)

SAP table TIPZB has 2 primary key fields being MANDT,BUKRS.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
DEF_FEINS Preallocation for area units UNIT 3 0 T006 DEF_FEINS
DEF_REINS Preallocation for volume units UNIT 3 0 T006 DEF_REINS
DEF_VORZ Advance payment percentage rates indicator NUMC 1 0 DEF_VORZ
RA_INSTALL Flag: AM installed for real estate CHAR 1 0 RA_INSTALL
VVLEN Pre-setting for units of length UNIT 3 0 T006 VVLEN_DEF
JAUTOMV Create Lease-Out Number Automatically CHAR 1 0 VVJAUTOMV
JAUTOGEB Autom. determination of LO no.: Consider building/property? CHAR 1 0 VVJAUTOGEB
XTRENNMV Separator for the individual parts of the RA number CHAR 1 0 VVXTRENNMV
SDEBAUT Automatic customer indicator CHAR 1 0 VVSDEBAUT
VVJBAV Single-Character Flag CHAR 1 0 CHAR1
JPOSTNOW Carry out one-time postings immediately CHAR 1 0 VVJPOSTNOW
JOPTIERT Company code opted for input tax - Indicator for opt. rate. CHAR 1 0 VVJOPIERT
JAEPRUEF Do not carry out check function for settlement units CHAR 1 0 VVJAEPRUEF
BNOVST Input tax amount up to which an correction is not applicable CURR 13 2 VVBNOVST
BVEVST Maximum amount for simplification of input tax correction CURR 13 2 VVBVEVST
MVKOP Transfer Condition Items From Previous Lease-Out CHAR 1 0 VVJMVKOP
ANZSWENR Number of characters for business entity number NUMC 1 0 VVANZSWENR
ANZGEBGR No. of characters for number of building/property NUMC 1 0 VVANZGEBGR
ANZSMENR Number of characters for rental unit number NUMC 1 0 VVANZSMENR
XFILL Padding character for non-numerical numbers CHAR 1 0 VVXFILL
JAMHIER Take asset hierarchy into consideration for correction items CHAR 1 0 VVJAMHIER
JVSTBEST Allocation number management indicator CHAR 1 0 VVJVSTBEST
JANL1Z1 Indic: Real estate object must be assigned 1:1 to asset CHAR 1 0 VVJANL1Z1
JANLOBL Indic.: Asset assignment is mandatory CHAR 1 0 VVJANLOBL
JKONDMV Transfer conditions to RU when lease-out expires? CHAR 1 0 VVJKONDMV
PKONDMV Percentage rate for transfer of terms from LO to RU DEC 5 2 VVPKONDMV
JBRBEW Valuation of storable fuel active CHAR 1 0 VVJBRBEW
WERKS Plant CHAR 4 0 T001W WERKS_D
OPTABW Option rate deviation in percentage points DEC 9 6 VVOPTABW
DPCFLG Dummy Profit Center from Controlling Area CHAR 1 0 VVDPCFLG
ZLSCH Payment method for credit memos CHAR 1 0 T042Z VVGZLSCH
EQM_INSTAL Plant Maintenance (PM) comp. is installed for Real Estate CHAR 1 0 EQM_INSTAL
EIGT_BLART Owner settlement: Document type for vendor posting CHAR 2 0 T003 VVEBLART
ZBUKRS Assigned company code CHAR 4 0 T001 VVZBUKRS
JEIGTV Indicator: Owner management active CHAR 1 0 VVJEIGTV
LZLSCH Payment method for debit memos CHAR 1 0 T042Z VVLZLSCH
KZLSCHG Payment Method for Credit Memos After Lease-Out Ended CHAR 1 0 T042Z VVKZLSCHG
KZLSCHL Payment method for debit memos after lease-out ended CHAR 1 0 T042Z VVKZLSCHL
ZEBLART Document type for incoming payment CHAR 2 0 T003 VVIEZBLART
VVMWSKZ0 Tax on Sales/Purchases Code with Tax Rate 0 CHAR 2 0 * VVMWSKZ0
VVVSTKZ0 Input tax indicator with tax rate 0% CHAR 2 0 * VVVSTKZ0
EBBLART Default document type for one-time postings CHAR 2 0 T003 VVEBBLART
UNTZLSCH Default payment method for underpayment from rental agreemnt CHAR 1 0 VVUNTZLSCH
UEBZLSCH Default payment method for overpayment from lease-out CHAR 1 0 VVUEBZLSCH
UNTZLSPR Default payment block for underpayment CHAR 1 0 T008 VVUNTZLSPR
UEBZLSPR Default payment block for overpayment CHAR 1 0 T008 VVUEBZLSPR
OPTSATZ Option rate - Default value DEC 9 6 OPTSATZ
OPTERM Option rate determinatioin - Procedure CHAR 1 0 OPTERM
1 Option rate is fixed
2 Default value for option rate
X Option rate is maintained per object
XZUONR Fill Assignment in Document CHAR 1 0 VVIS_ZUONR
KPBLART Default document type for account maintenance CHAR 2 0 T003 VVKPBLART
JCONDDAY Contract conditions on a daily basis? CHAR 1 0 VVJCONDDAY
TAXUSBLART Document type for tax transfer to SCS down payments CHAR 2 0 T003 VVTAXUSBLART
RPNEW Create new residual items for incoming payment CHAR 1 0 VVRPNEW
Excess Amount as Payment on Account
O Leave Item Open
X Payment Difference as Receivable
ZEBKUEB Incoming payment: cross company code rental agrmnt selection CHAR 1 0 VVZEBKUEB
JEQM_1Z1 Unique assignment of functional location to RE object CHAR 1 0 VVJEQM_1Z1
JEQM_WE Automatic change/create FL for business entity NUMC 1 0 VVJEQM_AUTO_WE
JEQM_GR Automatic create/change FL for property NUMC 1 0 VVJEQM_AUTO_GR
JEQM_GE Automatic create/change FL for building NUMC 1 0 VVJEQM_AUTO_GE
JEQM_ME Automatic create/change FL for rental unit NUMC 1 0 VVJEQM_AUTO_ME
EQM_TPLKZ Functional Location Structure Indicator CHAR 5 0 T370S TPLKZ
EQM_FLTYP Functional location category CHAR 1 0 T370F FLTYP
JBKBEST Indicator: Additional data owner active CHAR 1 0 VVJBKBEST
EQM_TCODE Transaction code for creating maintainance message CHAR 20 0 T365A VVEQM_TCODE
JEQM_FL Automatic create/change FL for architectural area NUMC 1 0 VVJEQM_AUTO_FL
JEQM_RA Automatic create/change FL for architectural room NUMC 1 0 VVJEQM_AUTO_RA
EQM_TPLNR Temporary name for generated functional location CHAR 30 0 VVTPLNR_TEMP
JEQM_1Z1WE Unique business entity assignment to functional location CHAR 1 0 VVJEQM_1Z1_WE
JEQM_1Z1GR Unique assignment of property to functional location CHAR 1 0 VVJEQM_1Z1_GR
JEQM_1Z1GE Unique assignment of building to functional location CHAR 1 0 VVJEQM_1Z1_GE
JEQM_1Z1ME Unique assignment of rental unit to functional location CHAR 1 0 VVJEQM_1Z1_ME
EQM_OT_WE Object type business entity for generated functional locat. CHAR 3 0 VVEQM_OT_WE
EQM_OT_GR Object type property for generated functional locations CHAR 3 0 VVEQM_OT_GR
EQM_OT_GE Object type building for generated functional locations CHAR 3 0 VVEQM_OT_GE
EQM_OT_ME Object type rental unit for generated functional locations CHAR 3 0 VVEQM_OT_ME
JNOTAXCORR No input tax adjustment in the service charge settlement CHAR 1 0 REJNOTAXCORR
EQM_OT_FL Object type arch. space for generated functional locations CHAR 3 0 VVEQM_OT_FL
EQM_OT_RA Object type arch. room for generated functional location CHAR 3 0 VVEQM_OT_RA
JEQM_VFL Automatic creation/change of FL for rental space NUMC 1 0 VVJEQM_AUTO_VMFL
EQM_OT_VFL Object type rental space for generated functional locations CHAR 3 0 VVEQM_OT_VFL
EQM_TCODE2 Transaction code for creating PM order for equipment CHAR 20 0 T365A VVEQM_TCODE22
JMANDBUKRS Indicator: Third Party Company Code CHAR 1 0 REMANDATSBUKRS
ACCSYSTEM Definition of Accounting System CHAR 4 0 TIVRAACCSYSTEM RERAACCSYSTEM
CNDSPOS Is Summarization of Line Items Active? CHAR 1 0 RERACNDSPOS
CNDSTAX Is Summarization of Tax Items Active? CHAR 1 0 RERACNDSTAX
DEF_TFEINS UNIT 3 0 T006 VIGWDFTFEINS
FLTGNR NUMC 4 0 TIG04 VIGWSFFLTGNR
REHORMS CHAR 1 0 REHORMS

TIPZB foreign key relationships

Table Field Check Table Check Field
0 TIPZB ACCSYSTEM TIVRAACCSYSTEM Accounting System ACCSYSTEM
1 TIPZB BUKRS T001 Company Codes BUKRS
0 TIPZB DEF_FEINS T006 Units of Measurement MANDT
1 TIPZB DEF_REINS T006 Units of Measurement MANDT
0 TIPZB EBBLART T003 Document Types MANDT
1 TIPZB EIGT_BLART T003 Document Types MANDT
0 TIPZB EQM_FLTYP T370F Functional Location Category MANDT
0 TIPZB EQM_FLTYP T370F Functional Location Category FLTYP
1 TIPZB EQM_TCODE T365A Start values for notification transactions - Customizing MANDT
1 TIPZB EQM_TCODE T365A Start values for notification transactions - Customizing TCODE
0 TIPZB EQM_TCODE2 T365A Start values for notification transactions - Customizing MANDT
0 TIPZB EQM_TCODE2 T365A Start values for notification transactions - Customizing TCODE
1 TIPZB EQM_TPLKZ T370S Functional Location Structure Indicators MANDT
1 TIPZB EQM_TPLKZ T370S Functional Location Structure Indicators TPLKZ
0 TIPZB FLTGNR TIG04 MANDT
0 TIPZB FLTGNR TIG04 FLTGNR
1 TIPZB KPBLART T003 Document Types MANDT
0 TIPZB KZLSCHG T042Z Payment Methods for Automatic Payment MANDT
0 TIPZB KZLSCHG T042Z Payment Methods for Automatic Payment LAND1
0 TIPZB KZLSCHG T042Z Payment Methods for Automatic Payment ZLSCH
1 TIPZB KZLSCHL T042Z Payment Methods for Automatic Payment MANDT
1 TIPZB KZLSCHL T042Z Payment Methods for Automatic Payment LAND1
1 TIPZB KZLSCHL T042Z Payment Methods for Automatic Payment ZLSCH
0 TIPZB LZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 TIPZB LZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 TIPZB LZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
1 TIPZB TAXUSBLART T003 Document Types MANDT
0 TIPZB UEBZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 TIPZB UEBZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
1 TIPZB UNTZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
1 TIPZB UNTZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
0 TIPZB VVLEN T006 Units of Measurement MANDT
0 TIPZB VVLEN T006 Units of Measurement MSEHI
1 TIPZB WERKS T001W Plants/Branches WERKS
0 TIPZB ZBUKRS T001 Company Codes BUKRS
1 TIPZB ZEBLART T003 Document Types MANDT
0 TIPZB ZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 TIPZB ZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 TIPZB ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH