SAP VTVSZBS Scenario Database: Basis Spreads Table

Overview

VTVSZBS is a standard SAP S/4HANA table that stores Scenario Database: Basis Spreads data. There are total 6 fields in the VTVSZBS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VTVSZBS belongs to Market Risk Analyzer (FIN-FSCM-TRM-MR) module and is located in the package Applic. development R/3 Treasury risk simulation analysis (FTB).

In addition, following links provide an overview of foreign key relationships, if any, that link VTVSZBS to other SAP tables and standard CDS views available based on VTVSZBS table in S/4HANA 2020.

Techincal Settings of VTVSZBS

Below are technical details of the table VTVSZBS

  • Buffering switched on
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of VTVSZBS Fields

The following table gives you an overview of the fields available in VTVSZBS

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
SZENARIScenarioTV_SZENARIVTVSZKOCHAR10
BSPRD_IDBasis Spread IDTYC_BSPRD_IDTYC_BSPRD_DEFCHAR15
QUOTYPQuotation TypeTB_QUOTYPNUMC1
RATE_TYPERate TypeTYC_RATETYPECHAR1
BSPRDBasis Spread Value in Basis PointsTYC_BSPRDDEC17

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 VTVSZBS

Table NameFieldCardinalityCheck Table
VTVSZBSBSPRD_ID1: CNTYC_BSPRD_DEF
VTVSZBSMANDT:T000
VTVSZBSSZENARI1: CNVTVSZKO

Other References