SAP VTBFSEC Securities Collateral Table
Overview
VTBFSEC is a standard SAP S/4HANA table that stores Securities Collateral data. There are total 14 fields in the VTBFSEC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBFSEC belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package CFM-TM: Securities Lending (FTR_LENDING).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBFSEC to other SAP tables and standard CDS views available based on VTBFSEC table in S/4HANA 2020.
Techincal Settings of VTBFSEC
Below are technical details of the table VTBFSEC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBFSEC Fields
The following table gives you an overview of the fields available in VTBFSEC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| RANL | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| VALID_FROM | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15 | |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SNWHR | Currency of nominal amount | SNWHR | * | CUKY | 5 |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 |
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 VTBFSEC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBFSEC | COMPANY_CODE | 1: CN | T001 |
| VTBFSEC | MANDT | 1: CN | T000 |
| VTBFSEC | OBJNR | 1: N | ONR00 |
| VTBFSEC | RANL | 1: CN | VWPANLA |