SAP VISCSETTL Settlement Identification with Log Reference Table
Overview
VISCSETTL is a standard SAP S/4HANA table that stores Settlement Identification with Log Reference data. There are total 27 fields in the VISCSETTL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCSETTL belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Settlement (RE_SC_SE).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCSETTL to other SAP tables and standard CDS views available based on VISCSETTL table in S/4HANA 2020.
Techincal Settings of VISCSETTL
Below are technical details of the table VISCSETTL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCSETTL Fields
The following table gives you an overview of the fields available in VISCSETTL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SETTL_GUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| SETTLMODE | Settlement Method | RECASETTLMODE | TIVSCSETTLMODE | CHAR | 3 |
| SETTLTYPE | Settlement type | RESCSTYPE | TIVSCSETTLTYPE | CHAR | 3 |
| PURPOSE | Settlement Purpose | RESCSEPURPOSE | CHAR | 1 | |
| FLG_REVERSAL | Reversal indicator | VSSTORNO | CHAR | 1 | |
| PFROM | Start of Settlement Period | RESCSETTLEVALIDFROM | DATS | 8 | |
| PTO | Date Up to Which Settlement Should Be Performed | RESCSETTLTO | DATS | 8 | |
| SPOOLNR | Spool number | VVSPONR | NUMC | 10 | |
| HEADERTXT | Document Header Text | RERAHEADERTXT | CHAR | 25 | |
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | |
| DOCDATE | Document Date | RERADOCDATE | DATS | 8 | |
| BLINEDATE | Baseline date for due date calculation | VVDZFBDT | DATS | 8 | |
| DTAPE_ACCESS | Reading Method for DME Data | RESCTAPECREATETYPE | CHAR | 1 | |
| DTAPE_NAME | Name of DME File | RESCFILENAME_READ | CHAR | 255 | |
| MLTAPE_SORTBY | Output of M/L Record | RESCHSMLTSORTBY | CHAR | 2 | |
| MLTAPE_ACCESS | Saving Method for DME Data | RESCLOCALSERVER | CHAR | 1 | |
| MLTAPE_NAME | Name of DME File | RESCFILENAME_WRITE | CHAR | 255 | |
| LAST_STEP | Internal Name of Settlement Step | RESCSSETTLSTEP | CHAR | 4 | |
| PARAMKEY | Settlement Schema | RESCPARAMKEY | * | CHAR | 4 |
| DOCCOUNTER | Document Counter | RERADOCCOUNTER | INT4 | 10 | |
| AJPROCESSGUID | Generic Key of Adjustment Run Within SCS | RESCAJPROCESSGUID | RAW | 16 | |
| KEYDATECOP | Key Date for Current Occupancy Principle | RESCKEYDATECOP | DATS | 8 | |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| CHRGPERC | Percentage Surcharge Added to Settlement Result | RESCCHRGPERCSETTLEMENT | DEC | 5 | |
| VERSION | Version | COVERSI | * | CHAR | 3 |
| MEASKEYDATE | Key Date for Determination of Measurement Amount | RESCMEASKEYDATE | DATS | 8 |
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 VISCSETTL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCSETTL | PARAMKEY | : | * |
| VISCSETTL | SANPNR | : | * |
| VISCSETTL | SETTLMODE | : | TIVSCSETTLMODE |
| VISCSETTL | SETTLTYPE | : | TIVSCSETTLTYPE |
| VISCSETTL | SETTL_GUID | 1: C | VICAPROCESSID |