SAP ABAP Table VIAK03 (Settlement Unit Master Record)

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	VIAK03	Table Relationship Diagram
Short Description	Settlement Unit Master Record

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SWENR	☑	VVSWENRNKA	SWENR	CHAR	8	0	Valid business entity	VIOB01
4	SNKSL	☑	SNKSL	SNKSL	CHAR	4	0	Service Charge Key	TIV05
5	SEMPSL	☑	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit
6	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
7	JLOESCH	☐	VVJLOESCH	JLOESCHAE	CHAR	1	0	Real Estate Delection Indicator for Settlement Unit
8	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
9	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
10	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
11	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
12	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
13	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
14	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
15	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
16	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
17	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
18	JSPERR	☐	VVJSPERR	JANE	CHAR	1	0	Indicator for general block of CU
19	DAEEND	☐	VVDAEEND	DDAT	DATS	8	0	End of settlement unit effective period
20	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
21	SABRG	☐	VVSABRG	SABRG	NUMC	4	0	Apportionment unit for determining option rate	TIV07
22	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
23	SMIETR	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
24	XTEXTAE	☐	VVXTEXTAE	XTEXT50	CHAR	50	0	Name of settlement unit
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
27	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
28	UEBERAE	☐	VVJUEBERAE	JANE	CHAR	1	0	Predistribution settlement unit indicator
29	JNOTAXCORR	☐	REJNOTAXCORR	CHAR1	CHAR	1	0	No input tax adjustment in the service charge settlement
30	.INCLU--AP	☐				0	0	OBSOLETE: Settlement Unit: Append Fields
31	.INCLUDE	☐				0	0	OBSOLETE: Settlement Unit: Append Fields
32	SUTYPE	☐	RESCSUTYPE	RESCSUTYPE	CHAR	2	0	Type of Settlement Unit
33	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
34	VALIDFROM	☐	RESCSUVALIDFROM	RECADATEBEG	DATS	8	0	Valid-From Date of Settlement Unit
35	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
36	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
37	HAS_COSTOBJECT	☐	RESCHASCOSTOBJECT	RECABOOL	CHAR	1	0	Cost Object SUs Can Be Assigned to the SU
38	EXCHANGETYPE	☐	RESCEXCHANGETYPE	RESCEXCHANGETYPE	CHAR	2	0	Type of Data Exchange
39	SETTLADVPAY	☐	VERRKZ	VERRKZ	CHAR	1	0	Settlement by settlement company
40	PERHEATING	☐	VVPGKHZ	DEC3_2	DEC	5	2	Percentage of heating basic costs
41	PERHOTWATER	☐	VVPGKWW	DEC3_2	DEC	5	2	Percentage of hot water basic costs
42	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAK03	BUKRS	T001	BUKRS	KEY	1	1
2	VIAK03	GSBER	TGSB	GSBER	KEY	1	CN
3	VIAK03	MANDT	T000	MANDT	KEY	1	1
4	VIAK03	PRCTR	CEPC	PRCTR	KEY	1	CN
5	VIAK03	SABRG	TIV07	SABRG	KEY	1	CN
6	VIAK03	SMIETR	TIV03	SMIETR		1	CN
7	VIAK03	SNKS	ONR00	OBJNR	KEY	1	1
8	VIAK03	SNKSL	TIV05	SNKSL	KEY	1	CN
9	VIAK03	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in