SAP VICNSCS Real Estate Contract: Service Charge Key Table
Overview
VICNSCS is a standard SAP S/4HANA table that stores Real Estate Contract: Service Charge Key data. There are total 16 fields in the VICNSCS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VICNSCS belongs to Real Estate Management (RE) module and is located in the package Applic.Dev. R/3 Real Estate - Gen.Contract - Enhancements (FVVICNZ).
In addition, following links provide an overview of foreign key relationships, if any, that link VICNSCS to other SAP tables and standard CDS views available based on VICNSCS table in S/4HANA 2020.
Techincal Settings of VICNSCS
Below are technical details of the table VICNSCS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VICNSCS Fields
The following table gives you an overview of the fields available in VICNSCS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| SNKSL | Service Charge Key | SNKSL | TIV05 | CHAR | 4 |
| DGULTAB | Date from when assignment is valid | DGULTAB | DATS | 8 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| ABRVAR | Settlement variant | ABRVAR | TIA01 | CHAR | 4 |
| RECNKOART | Real Estate Contract: Cost Element of Landlord | RECNKOART | CHAR | 30 | |
| SABRG | Apportionment unit | SABRG | TIV07 | NUMC | 4 |
| ABREART | Settlement type for service charges | ABREART | CHAR | 1 | |
| RECNPLANDLORD | Landlord's Share Per Service Charge Key in Percent | RECNPLANDLORD | DEC | 5 | |
| AE_INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| MAXCOST1 | Maximum costs value per service charge key for SCS | VVMAXCOST1 | CURR | 13 | |
| MAXCOST2 | Maximum costs value per condition type for SCS | VVMAXCOST2 | CURR | 13 | |
| RECNSCSTOAE | No Pass-On to Settlement Unit | RECNSCSTOAE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VICNSCS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VICNSCS | ABRVAR | : | TIA01 |
| VICNSCS | SABRG | : | TIV07 |
| VICNSCS | SKOART | : | TZK01 |
| VICNSCS | SNKSL | : | TIV05 |