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