SAP VWPDEPO Securities Account Position Table
Overview
VWPDEPO is a standard SAP S/4HANA table that stores Securities Account Position data. There are total 33 fields in the VWPDEPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VWPDEPO belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Treasury Management: Securities (FVVW).
In addition, following links provide an overview of foreign key relationships, if any, that link VWPDEPO to other SAP tables and standard CDS views available based on VWPDEPO table in S/4HANA 2020.
Techincal Settings of VWPDEPO
Below are technical details of the table VWPDEPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VWPDEPO Fields
The following table gives you an overview of the fields available in VWPDEPO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RANL | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| RLDEPO | Securities Account | VRLDEPO | TWD01 | CHAR | 10 |
| SSTATI | Status of data record | SSTATI | * | NUMC | 2 |
| XDKBZ | Sec.acct position short description | XDKBZ | CHAR | 15 | |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | T037S | CHAR | 8 |
| SVERWA | Custody type | SVERWA | * | CHAR | 1 |
| DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | |
| DANDRE | Right to offer until | DANDRE | DATS | 8 | |
| SFIBG | Asset Grouping Indicator | SFIBG | TW08 | NUMC | 4 |
| SGLZB | SCB Asset Group Indicator | SGLZB | TW07 | CHAR | 4 |
| SBILK | Balance Sheet Indicator | SBILK | TW11 | CHAR | 2 |
| JSPRI | Intercorporate Privilege Indicator | JSPRI | CHAR | 1 | |
| JBTEI | Shareholding indicator | JBTEI | CHAR | 1 | |
| RFGEB | Releaser of master record (person) | RFGEB_NEW | * | CHAR | 10 |
| DFREI | Date of release | DFREI | DATS | 8 | |
| TFREI | Time of release | TFREI | TIMS | 6 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBHER | Origin indicator for table | TBHER | CHAR | 1 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SBESANT | Holding | SBESANT | TZBA | CHAR | 2 |
| JBETEIL | Shareholding Indicator | JBETEIL | CHAR | 1 | |
| VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | |
| SKWG14NEU | Position Grouping Acc. Article 14 GBA (Sec. and Loans) | VVSKWG14 | CHAR | 2 | |
| SMOVERW | Custody Type | TB_SVERWA | TW50 | CHAR | 2 |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| DERIV_CAT | Position management procedure | TPM_DERIV_CAT | NUMC | 3 |
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 VWPDEPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VWPDEPO | BUKRS | 1: 1 | T001 |
| VWPDEPO | MANDT | 1: 1 | T000 |
| VWPDEPO | RANL | : | VWPANLA |
| VWPDEPO | RLDEPO | 1: CN | TWD01 |
| VWPDEPO | RREFKONT | 1: CN | T037S |
| VWPDEPO | SBESANT | 1: 1 | TZBA |
| VWPDEPO | SBILK | 1: 1 | TW11 |
| VWPDEPO | SFIBG | 1: 1 | TW08 |
| VWPDEPO | SGLZB | 1: 1 | TW07 |
| VWPDEPO | SMOVERW | 1: CN | TW50 |