SAP Table VIRPRE5

Real Estate: Service charges settlement

VIRPRE5 (Real Estate: Service charges settlement) 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 VIRPRE5 to other SAP tables.

VIRPRE5 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OBART Object Type J_OBART CHAR 2 0
OBJNR Object J_OBJNREXT CHAR 22 0
OBJNRX Object no: Real estate extended object number reporting VVJ_OBJNRX CHAR 30 0
VVABBLN Settlement Identification ->Accounting Ref. Doc.Number VVABBLN1 CHAR 16 0
DVONPER Period start date DVONPER DATS 8 0
DBISPER Date of settlement period end DBISPER DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
PERIO Period/year JAHRPER NUMC 7 0
PERDE Period PERIODE NUMC 3 0
DSTICH Key date VVDSTICH DATS 8 0
ATAGE No. of days VVATAGE2 QUAN 6 0
ATAGE_EH Base Unit of Measure MEINS UNIT 3 0
BUMLGR Apportionment factor for settlement VVBUMLGR QUAN 15 4
BUMLGR_EH Base Unit of Measure MEINS UNIT 3 0
BEZGR Reference Factor VVBEZGR QUAN 14 3
BEZGR_EH Base Unit of Measure MEINS UNIT 3 0
BNETTO Net amount BNETTO CURR 13 2
BSTEUER Tax amount BSTEUER CURR 13 2
BBRUTTO Gross amount BBRUTTO CURR 13 2
JVSTOPT Input tax opting (indicator) VVJVSTOPT CHAR 1 0
NULL No
X Yes
WAERS Currency Key WAERS CUKY 5 0
SABRG Apportionment unit SABRG NUMC 4 0
AEPERIO Effective period of settlement units VVAEPERIO CHAR 20 0
PMIETER Tenant share per service charge key VVPMIETER QUAN 8 3
PMIETER_EH Base Unit of Measure MEINS UNIT 3 0
HEIZPROZ Heating value percentage rate VVHEIZPRO2 QUAN 5 2
HEIZPRO_EH Base Unit of Measure MEINS UNIT 3 0
SKOART Condition Type (Smallest Subdivision of Condition Records) SKOART NUMC 4 0
ABREART Settlement type for service charges after settlement perfor. VVABREART CHAR 1 0
0 No participation
1 Advance payment, tenant's share
2 Flat rate
3 Final settlement, tenant's share
4 Advance payment, owner's share
5 Final settlement, owner's share
6 Reduction, owner's share
NULL Vacancy
BUKRS Company Code BUKRS CHAR 4 0
BUKVW Company code of property manager VVBUKRSVW CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
SWENR Site Number SWENR CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
SGENR Building Number SGENR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
SNKSL Service Charge Key SNKSL CHAR 4 0
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SVWNR Management Contract Number VVSVWNR CHAR 13 0