SAP VWPANLA Asset master for securities Table
Overview
VWPANLA is a standard SAP S/4HANA table that stores Asset master for securities data. There are total 51 fields in the VWPANLA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VWPANLA belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package TR-CORE: Former Objects from FVVW (TR-TM: Securities) (FVVW_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link VWPANLA to other SAP tables and standard CDS views available based on VWPANLA table in S/4HANA 2020.
Techincal Settings of VWPANLA
Below are technical details of the table VWPANLA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VWPANLA Fields
The following table gives you an overview of the fields available in VWPANLA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RANL | Security Class ID Number | VVRANLW | CHAR | 13 | |
| SANLF | Product Category | SANLF | TZAF | NUMC | 3 |
| SSTATI | Status of a Security | SEC_STATUS | NUMC | 2 | |
| RANLALT1 | RANLALT1 | RANLALT1S | CHAR | 13 | |
| RANLALT2 | Alternative identification 2 | RANLALT2S | CHAR | 13 | |
| GSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SBRSCH | Industry key | BRSCH | T016 | CHAR | 4 |
| SWERTTYP | Security Type ID | SWERTTYP | TW20 | NUMC | 1 |
| SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | |
| WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 1 | |
| JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | |
| WPFAN | Indicator pledgeable | WPFAN | CHAR | 1 | |
| SSTBE | Tax Treatment Indicator | SSTBE | CHAR | 1 | |
| LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | |
| JABMI | Joint partner vote indicator | JABMI | CHAR | 1 | |
| XALKZ | Short Name | XALKZ | CHAR | 15 | |
| XALLB | Long Name | XALLB | CHAR | 60 | |
| REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | |
| BEMPREIS | Issue Price | BEMPREIS | CURR | 10 | |
| REWHR | Issue Currency | REWHR | TCURC | CUKY | 5 |
| PEMKURS | Issue rate in percent | PEMKURS | DEC | 10 | |
| SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | |
| PKUAB | Price deviation in percent | PKUAB | DEC | 10 | |
| BKUAB | Absolute price deviation | BKUAB | CURR | 10 | |
| DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | |
| DANDRE | Right to offer until | DANDRE | DATS | 8 | |
| SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | |
| 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 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SROLEXT | General Security Classification | ALWPKL | TW22 | CHAR | 3 |
| VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | |
| JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 1 | |
| SMOVERW | Possible custody type | SMOVERW | TW50 | CHAR | 2 |
| SIHERK | Component of the Version Number | CHAR2 | CHAR | 2 | |
| KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 15 | |
| SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | TW51 | NUMC | 2 |
| SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 1 | |
| SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | |
| RISIN | International securities ID number (no longer used) | VVRISIN | CHAR | 13 | |
| INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | TP07 | CHAR | 4 |
| RATING | Rating | BP_RATING | TP06 | CHAR | 3 |
| PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | TIDX_PRICE_INDEX | CHAR | 15 |
| PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | |
| SFIMAMETHOD | Cash Flow Calculation | VVSFIMAMETHOD | 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 VWPANLA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VWPANLA | GSART | 1: CN | TZPA |
| VWPANLA | INSTITUTE | : | TP07 |
| VWPANLA | MANDT | 1: 1 | T000 |
| VWPANLA | PRICE_INDEX | C: CN | TIDX_PRICE_INDEX |
| VWPANLA | RATING | : | TP06 |
| VWPANLA | REWHR | 1: 1 | TCURC |
| VWPANLA | SANLF | 1: CN | TZAF |
| VWPANLA | SBRSCH | 1: 1 | T016 |
| VWPANLA | SDEPOSTAT | C: CN | TW51 |
| VWPANLA | SMOVERW | 1: CN | TW50 |
| VWPANLA | SROLEXT | C: CN | TW22 |
| VWPANLA | SWERTTYP | : | TW20 |