SAP Table VIAK03

Settlement Unit Master Record

VIAK03 (Settlement Unit Master Record) 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 VIAK03 to other SAP tables.

VIAK03 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SWENR Valid business entity VVSWENRNKA VIOB01 CHAR 8 0
SNKSL Service Charge Key SNKSL TIV05 CHAR 4 0
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SNKS Service Charge Collector Number SNKS ONR00 CHAR 22 0
JLOESCH Real Estate Delection Indicator for Settlement Unit VVJLOESCH CHAR 1 0
X Deletion flag
Z Deletion indicator
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
JSPERR Indicator for general block of CU VVJSPERR CHAR 1 0
NULL No
X Yes
DAEEND End of settlement unit effective period VVDAEEND DATS 8 0
RARTOPT Option rate calculation type RARTOPT NUMC 1 0
0 No calculation/date of service
1 Square meter ratio (automatic)
2 Cubic meter ratio (automatic)
3 Apport.unit relat. (automatic)
4 Predistribution (automatic)
5 Plan option rate (manual)
6 Square meter ratio (manual)
7 Cubic meter ratio (manual)
8 Other procedure (manual)
9 No input tax option (automatic)
SABRG Apportionment unit for determining option rate VVSABRG TIV07 NUMC 4 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
SMIETR Tenancy law SMIETR TIV03 CHAR 5 0
XTEXTAE Name of settlement unit VVXTEXTAE CHAR 50 0
GSBER Business Area GSBER TGSB CHAR 4 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
BERGRP Authorization group VVBERGRP CHAR 40 0
UEBERAE Predistribution settlement unit indicator VVJUEBERAE CHAR 1 0
JNOTAXCORR No input tax adjustment in the service charge settlement REJNOTAXCORR CHAR 1 0
SUTYPE Type of Settlement Unit RESCSUTYPE CHAR 2 0
01 Settlement Unit
02 Master Settlement Unit
03 Cost Object Settlement Unit
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
VALIDFROM Valid-From Date of Settlement Unit RESCSUVALIDFROM DATS 8 0
RESPONSIBLE Person Responsible RECARESPONSIBLE CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE CHAR 12 0
HAS_COSTOBJECT Cost Object SUs Can Be Assigned to the SU RESCHASCOSTOBJECT CHAR 1 0
X Yes
NULL No
EXCHANGETYPE Type of Data Exchange RESCEXCHANGETYPE CHAR 2 0
NULL No Data Exchange
01 Complete Data Exchange
02 M/L-Tape Only
03 D-Tape Entered Manually
SETTLADVPAY Settlement by settlement company VERRKZ CHAR 1 0
0 Clearing of Advance Payments by Settlement Company
1 No Advance Payment Clearing by Settlement Company
PERHEATING Percentage of heating basic costs VVPGKHZ DEC 5 2
PERHOTWATER Percentage of hot water basic costs VVPGKWW DEC 5 2

VIAK03 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIAK03 BUKRS VIAK03 MANDT T001 Company Codes MANDT
VIAK03 BUKRS VIAK03 BUKRS T001 Company Codes BUKRS
VIAK03 GSBER VIAK03 GSBER TGSB Business Areas GSBER
VIAK03 GSBER VIAK03 MANDT TGSB Business Areas MANDT
VIAK03 MANDT VIAK03 MANDT T000 Clients MANDT
VIAK03 PRCTR VIAK03 MANDT CEPC Profit Center Master Data Table MANDT
VIAK03 PRCTR VIAK03 PRCTR CEPC Profit Center Master Data Table PRCTR
VIAK03 PRCTR * CEPC Profit Center Master Data Table DATBI
VIAK03 PRCTR * CEPC Profit Center Master Data Table KOKRS
VIAK03 SABRG VIAK03 SABRG TIV07 Apportionment unit ID SABRG
VIAK03 SABRG VIAK03 MANDT TIV07 Apportionment unit ID MANDT
VIAK03 SMIETR VIAK03 MANDT TIV03 Country-specific tenancy law MANDT
VIAK03 SMIETR VIAK03 SMIETR TIV03 Country-specific tenancy law SMIETR
VIAK03 SNKS VIAK03 SNKS ONR00 General Object Number OBJNR
VIAK03 SNKS VIAK03 MANDT ONR00 General Object Number MANDT
VIAK03 SNKSL VIAK03 MANDT TIV05 Definition of Service Charge Keys MANDT
VIAK03 SNKSL VIAK03 SNKSL TIV05 Definition of Service Charge Keys SNKSL
VIAK03 SWENR VIAK03 MANDT VIOB01 Business entities MANDT
VIAK03 SWENR VIAK03 BUKRS VIOB01 Business entities BUKRS
VIAK03 SWENR VIAK03 SWENR VIOB01 Business entities SWENR