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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TIPZB	Table Relationship Diagram
Short Description	General real estate installation parameters, co.cd.-depend.

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	DEF_FEINS	☐	DEF_FEINS	MEINS	UNIT	3	0	Preallocation for area units	T006
4	DEF_REINS	☐	DEF_REINS	MEINS	UNIT	3	0	Preallocation for volume units	T006
5	DEF_VORZ	☐	DEF_VORZ	KVORSATZ	NUMC	1	0	Advance payment percentage rates indicator
6	RA_INSTALL	☐	RA_INSTALL	JANEI	CHAR	1	0	Flag: AM installed for real estate
7	VVLEN	☐	VVLEN_DEF	MEINS	UNIT	3	0	Pre-setting for units of length	T006
8	JAUTOMV	☐	VVJAUTOMV	JANE	CHAR	1	0	Create Lease-Out Number Automatically
9	JAUTOGEB	☐	VVJAUTOGEB	JANE	CHAR	1	0	Autom. determination of LO no.: Consider building/property?
10	XTRENNMV	☐	VVXTRENNMV	CHAR1	CHAR	1	0	Separator for the individual parts of the RA number
11	SDEBAUT	☐	VVSDEBAUT	JANE	CHAR	1	0	Automatic customer indicator
12	VVJBAV	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
13	JPOSTNOW	☐	VVJPOSTNOW	JANE	CHAR	1	0	Carry out one-time postings immediately
14	JOPTIERT	☐	VVJOPIERT	JANE	CHAR	1	0	Company code opted for input tax - Indicator for opt. rate.
15	JAEPRUEF	☐	VVJAEPRUEF	JANE	CHAR	1	0	Do not carry out check function for settlement units
16	BNOVST	☐	VVBNOVST	WERT7	CURR	13	2	Input tax amount up to which an correction is not applicable
17	BVEVST	☐	VVBVEVST	WERT7	CURR	13	2	Maximum amount for simplification of input tax correction
18	MVKOP	☐	VVJMVKOP	JANE	CHAR	1	0	Transfer Condition Items From Previous Lease-Out
19	ANZSWENR	☐	VVANZSWENR	NUMC1	NUMC	1	0	Number of characters for business entity number
20	ANZGEBGR	☐	VVANZGEBGR	NUMC1	NUMC	1	0	No. of characters for number of building/property
21	ANZSMENR	☐	VVANZSMENR	NUMC1	NUMC	1	0	Number of characters for rental unit number
22	XFILL	☐	VVXFILL	CHAR1	CHAR	1	0	Padding character for non-numerical numbers
23	JAMHIER	☐	VVJAMHIER	XFELD	CHAR	1	0	Take asset hierarchy into consideration for correction items
24	JVSTBEST	☐	VVJVSTBEST	XFELD	CHAR	1	0	Allocation number management indicator
25	JANL1Z1	☐	VVJANL1Z1	JANE	CHAR	1	0	Indic: Real estate object must be assigned 1:1 to asset
26	JANLOBL	☐	VVJANLOBL	JANE	CHAR	1	0	Indic.: Asset assignment is mandatory
27	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
28	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
29	JBRBEW	☐	VVJBRBEW	JANE	CHAR	1	0	Valuation of storable fuel active
30	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
31	OPTABW	☐	VVOPTABW	POPTSATZ	DEC	9	6	Option rate deviation in percentage points
32	DPCFLG	☐	VVDPCFLG	XFELD	CHAR	1	0	Dummy Profit Center from Controlling Area
33	ZLSCH	☐	VVGZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	T042Z
34	EQM_INSTAL	☐	EQM_INSTAL	JANE	CHAR	1	0	Plant Maintenance (PM) comp. is installed for Real Estate
35	EIGT_BLART	☐	VVEBLART	BLART	CHAR	2	0	Owner settlement: Document type for vendor posting	T003
36	ZBUKRS	☐	VVZBUKRS	BUKRS	CHAR	4	0	Assigned company code	T001
37	JEIGTV	☐	VVJEIGTV	JANE	CHAR	1	0	Indicator: Owner management active
38	LZLSCH	☐	VVLZLSCH	ZLSCH	CHAR	1	0	Payment method for debit memos	T042Z
39	KZLSCHG	☐	VVKZLSCHG	ZLSCH	CHAR	1	0	Payment Method for Credit Memos After Lease-Out Ended	T042Z
40	KZLSCHL	☐	VVKZLSCHL	ZLSCH	CHAR	1	0	Payment method for debit memos after lease-out ended	T042Z
41	ZEBLART	☐	VVIEZBLART	BLART	CHAR	2	0	Document type for incoming payment	T003
42	VVMWSKZ0	☐	VVMWSKZ0	MWSKZ	CHAR	2	0	Tax on Sales/Purchases Code with Tax Rate 0	*
43	VVVSTKZ0	☐	VVVSTKZ0	MWSKZ	CHAR	2	0	Input tax indicator with tax rate 0%	*
44	EBBLART	☐	VVEBBLART	BLART	CHAR	2	0	Default document type for one-time postings	T003
45	UNTZLSCH	☐	VVUNTZLSCH	VVVKZ	CHAR	1	0	Default payment method for underpayment from rental agreemnt
46	UEBZLSCH	☐	VVUEBZLSCH	VVVKZ	CHAR	1	0	Default payment method for overpayment from lease-out
47	UNTZLSPR	☐	VVUNTZLSPR	ZAHLS	CHAR	1	0	Default payment block for underpayment	T008
48	UEBZLSPR	☐	VVUEBZLSPR	ZAHLS	CHAR	1	0	Default payment block for overpayment	T008
49	OPTSATZ	☐	OPTSATZ	POPTSATZ	DEC	9	6	Option rate - Default value
50	OPTERM	☐	OPTERM	OPTERM	CHAR	1	0	Option rate determinatioin - Procedure
51	XZUONR	☐	VVIS_ZUONR	JANE	CHAR	1	0	Fill Assignment in Document
52	KPBLART	☐	VVKPBLART	BLART	CHAR	2	0	Default document type for account maintenance	T003
53	JCONDDAY	☐	VVJCONDDAY	XFELD	CHAR	1	0	Contract conditions on a daily basis?
54	TAXUSBLART	☐	VVTAXUSBLART	BLART	CHAR	2	0	Document type for tax transfer to SCS down payments	T003
55	RPNEW	☐	VVRPNEW	VVRPNEW	CHAR	1	0	Create new residual items for incoming payment
56	ZEBKUEB	☐	VVZEBKUEB	XFLAG	CHAR	1	0	Incoming payment: cross company code rental agrmnt selection
57	JEQM_1Z1	☐	VVJEQM_1Z1	JANE	CHAR	1	0	Unique assignment of functional location to RE object
58	JEQM_WE	☐	VVJEQM_AUTO_WE	VVJEQM_AUTO	NUMC	1	0	Automatic change/create FL for business entity
59	JEQM_GR	☐	VVJEQM_AUTO_GR	VVJEQM_AUTO	NUMC	1	0	Automatic create/change FL for property
60	JEQM_GE	☐	VVJEQM_AUTO_GE	VVJEQM_AUTO	NUMC	1	0	Automatic create/change FL for building
61	JEQM_ME	☐	VVJEQM_AUTO_ME	VVJEQM_AUTO	NUMC	1	0	Automatic create/change FL for rental unit
62	EQM_TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
63	EQM_FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
64	JBKBEST	☐	VVJBKBEST	JANE	CHAR	1	0	Indicator: Additional data owner active
65	EQM_TCODE	☐	VVEQM_TCODE	TCODE	CHAR	20	0	Transaction code for creating maintainance message	T365A
66	JEQM_FL	☐	VVJEQM_AUTO_FL	VVJEQM_AUTO	NUMC	1	0	Automatic create/change FL for architectural area
67	JEQM_RA	☐	VVJEQM_AUTO_RA	VVJEQM_AUTO	NUMC	1	0	Automatic create/change FL for architectural room
68	EQM_TPLNR	☐	VVTPLNR_TEMP		CHAR	30	0	Temporary name for generated functional location
69	JEQM_1Z1WE	☐	VVJEQM_1Z1_WE	JANE	CHAR	1	0	Unique business entity assignment to functional location
70	JEQM_1Z1GR	☐	VVJEQM_1Z1_GR	JANE	CHAR	1	0	Unique assignment of property to functional location
71	JEQM_1Z1GE	☐	VVJEQM_1Z1_GE	JANE	CHAR	1	0	Unique assignment of building to functional location
72	JEQM_1Z1ME	☐	VVJEQM_1Z1_ME	JANE	CHAR	1	0	Unique assignment of rental unit to functional location
73	EQM_OT_WE	☐	VVEQM_OT_WE		CHAR	3	0	Object type business entity for generated functional locat.
74	EQM_OT_GR	☐	VVEQM_OT_GR		CHAR	3	0	Object type property for generated functional locations
75	EQM_OT_GE	☐	VVEQM_OT_GE		CHAR	3	0	Object type building for generated functional locations
76	EQM_OT_ME	☐	VVEQM_OT_ME		CHAR	3	0	Object type rental unit for generated functional locations
77	JNOTAXCORR	☐	REJNOTAXCORR	CHAR1	CHAR	1	0	No input tax adjustment in the service charge settlement
78	EQM_OT_FL	☐	VVEQM_OT_FL		CHAR	3	0	Object type arch. space for generated functional locations
79	EQM_OT_RA	☐	VVEQM_OT_RA		CHAR	3	0	Object type arch. room for generated functional location
80	JEQM_VFL	☐	VVJEQM_AUTO_VMFL	VVJEQM_AUTO	NUMC	1	0	Automatic creation/change of FL for rental space
81	EQM_OT_VFL	☐	VVEQM_OT_VFL		CHAR	3	0	Object type rental space for generated functional locations
82	EQM_TCODE2	☐	VVEQM_TCODE22	TCODE	CHAR	20	0	Transaction code for creating PM order for equipment	T365A
83	JMANDBUKRS	☐	REMANDATSBUKRS	XFELD	CHAR	1	0	Indicator: Third Party Company Code
84	.INCLU--AP	☐				0	0	OBSOLETE: Installation Param., CoCd-Dependent: Append Fields
85	ACCSYSTEM	☐	RERAACCSYSTEM	RERAACCSYSTEM	CHAR	4	0	Definition of Accounting System	TIVRAACCSYSTEM
86	CNDSPOS	☐	RERACNDSPOS	RECABOOL	CHAR	1	0	Is Summarization of Line Items Active?
87	CNDSTAX	☐	RERACNDSTAX	RECABOOL	CHAR	1	0	Is Summarization of Tax Items Active?
88	.INCLU--AP	☐				0	0	CRE Erweiterung zur Customizingtabelle TIPZB
89	DEF_TFEINS	☐	VIGWDFTFEINS	MEINS	UNIT	3	0	Vorbelegungswert Maßeinh. Tragfähigkeit	T006
90	FLTGNR	☐	VIGWSFFLTGNR	VIGWFLTGNR	NUMC	4	0	Flächentyp-Gruppennummer	TIG04
91	.INCLU--AP	☐				0	0	WEG-Verwaltung: Eigentümerabrechnung Raumschuldnerprinzip
92	REHORMS	☐	REHORMS	XFELD	CHAR	1	0	WEG-Verwaltung: Eigentümerabrechnung Raumschuldnerprinzip

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TIPZB	ACCSYSTEM	TIVRAACCSYSTEM	ACCSYSTEM	KEY	1	CN
2	TIPZB	BUKRS	T001	BUKRS	KEY	1	C
3	TIPZB	DEF_FEINS	T006	MSEHI	KEY	1	CN
4	TIPZB	DEF_REINS	T006	MSEHI	KEY	1	CN
5	TIPZB	DEF_TFEINS	T006	MSEHI	REF	1	CN
6	TIPZB	EBBLART	T003	BLART	REF	1	CN
7	TIPZB	EIGT_BLART	T003	BLART	KEY	1	CN
8	TIPZB	EQM_FLTYP	T370F	FLTYP
9	TIPZB	EQM_TCODE	T365A	TCODE	KEY	1	CN
10	TIPZB	EQM_TCODE2	T365A	TCODE	KEY	1	CN
11	TIPZB	EQM_TPLKZ	T370S	TPLKZ
12	TIPZB	FLTGNR	TIG04	FLTGNR	REF	C	CN
13	TIPZB	KPBLART	T003	BLART
14	TIPZB	KZLSCHG	T042Z	ZLSCH		1	CN
15	TIPZB	KZLSCHL	T042Z	ZLSCH		1	CN
16	TIPZB	LZLSCH	T042Z	ZLSCH	KEY	1	CN
17	TIPZB	TAXUSBLART	T003	BLART	KEY	1	CN
18	TIPZB	UEBZLSPR	T008	ZAHLS	REF	1	CN
19	TIPZB	UNTZLSPR	T008	ZAHLS	REF	1	CN
20	TIPZB	VVLEN	T006	MSEHI	KEY	1	CN
21	TIPZB	WERKS	T001W	WERKS	KEY	1	CN
22	TIPZB	ZBUKRS	T001	BUKRS	KEY	1	C
23	TIPZB	ZEBLART	T003	BLART		1	CN
24	TIPZB	ZLSCH	T042Z	ZLSCH	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in