SAP Table VWPANLA
Asset master for securities
VWPANLA (Asset master for securities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VWPANLA to other SAP tables.
VWPANLA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| RANL | Security ID Number | VVRANLW | CHAR | 13 | 0 | |||||||||
| SANLF | Product Category | SANLF | TZAF | NUMC | 3 | 0 | ||||||||
| SSTATI | Status of a security | SEC_STATUS | NUMC | 2 | 0 |
Possible values
|
||||||||
| RANLALT1 | RANLALT1 | RANLALT1S | CHAR | 13 | 0 | |||||||||
| RANLALT2 | Alternative identification 2 | RANLALT2S | CHAR | 13 | 0 | |||||||||
| GSART | Product Type | VVSART | TZPA | CHAR | 3 | 0 | ||||||||
| SBRSCH | Industry key | BRSCH | T016 | CHAR | 4 | 0 | ||||||||
| SWERTTYP | Security Type ID | SWERTTYP | TW20 | NUMC | 1 | 0 | ||||||||
| SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | 0 |
Possible values
|
||||||||
| WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 1 | 0 |
Possible values
|
||||||||
| JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | 0 |
Possible values
|
||||||||
| WPFAN | Indicator pledgeable | WPFAN | CHAR | 1 | 0 |
Possible values
|
||||||||
| SSTBE | Tax treatment indicator | SSTBE | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | 0 |
Possible values
|
||||||||
| JABMI | Joint partner vote indicator | JABMI | CHAR | 1 | 0 |
Possible values
|
||||||||
| XALKZ | Short name | XALKZ | CHAR | 15 | 0 | |||||||||
| XALLB | Long name | XALLB | CHAR | 60 | 0 | |||||||||
| REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | 0 | |||||||||
| BEMPREIS | Issue Price | BEMPREIS | CURR | 10 | 2 | |||||||||
| REWHR | Issue currency | REWHR | TCURC | CUKY | 5 | 0 | ||||||||
| PEMKURS | Issue rate in percent | PEMKURS | DEC | 10 | 7 | |||||||||
| SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | 0 |
Possible values
|
||||||||
| PKUAB | Price deviation in percent | PKUAB | DEC | 10 | 7 | |||||||||
| BKUAB | Absolute price deviation | BKUAB | CURR | 10 | 2 | |||||||||
| DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | 0 | |||||||||
| DANDRE | Right to offer until | DANDRE | DATS | 8 | 0 | |||||||||
| SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | 0 | |||||||||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||||||||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||||||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||||||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||||||||
| SROLEXT | General Security Classification | ALWPKL | TW22 | CHAR | 3 | 0 | ||||||||
| VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | 0 |
Possible values
|
||||||||
| JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 1 | 0 |
Possible values
|
||||||||
| SMOVERW | Possible custody type | SMOVERW | TW50 | CHAR | 2 | 0 | ||||||||
| SIHERK | Version Number Component | CHAR2 | CHAR | 2 | 0 | |||||||||
| KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 15 | 6 | |||||||||
| SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | TW51 | NUMC | 2 | 0 | ||||||||
| SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 1 | 0 |
Possible values
|
||||||||
| SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | 0 |
Possible values
|
||||||||
| RISIN | International securities ID number (no longer used) | VVRISIN | CHAR | 13 | 0 | |||||||||
| INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | TP07 | CHAR | 4 | 0 | ||||||||
| RATING | Rating | BP_RATING | TP06 | CHAR | 3 | 0 | ||||||||
| PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | TIDX_PRICE_INDEX | CHAR | 15 | 0 | ||||||||
| PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | 0 | |||||||||
VWPANLA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VWPANLA | GSART | VWPANLA | MANDT | TZPA | Financial Assets Management Product Types | MANDT |
| VWPANLA | GSART | VWPANLA | GSART | TZPA | Financial Assets Management Product Types | GSART |
| VWPANLA | INSTITUTE | VWPANLA | MANDT | TP07 | Business Partner: Credit Rating Institute | MANDT |
| VWPANLA | INSTITUTE | VWPANLA | INSTITUTE | TP07 | Business Partner: Credit Rating Institute | SOL_INS |
| VWPANLA | MANDT | VWPANLA | MANDT | T000 | Clients | MANDT |
| VWPANLA | PRICE_INDEX | VWPANLA | MANDT | TIDX_PRICE_INDEX | Price Index Main Entity | MANDT |
| VWPANLA | PRICE_INDEX | VWPANLA | PRICE_INDEX | TIDX_PRICE_INDEX | Price Index Main Entity | INDEX_NAME |
| VWPANLA | RATING | VWPANLA | MANDT | TP06 | Business Partner: Rating | MANDT |
| VWPANLA | RATING | VWPANLA | RATING | TP06 | Business Partner: Rating | RATING |
| VWPANLA | REWHR | VWPANLA | MANDT | TCURC | Currency Codes | MANDT |
| VWPANLA | REWHR | VWPANLA | REWHR | TCURC | Currency Codes | WAERS |
| VWPANLA | SANLF | VWPANLA | SANLF | TZAF | Product categories | SANLF |
| VWPANLA | SBRSCH | VWPANLA | SBRSCH | T016 | Industries | BRSCH |
| VWPANLA | SBRSCH | VWPANLA | MANDT | T016 | Industries | MANDT |
| VWPANLA | SDEPOSTAT | VWPANLA | SDEPOSTAT | TW51 | Securities Account Statistics Key | SDEPOSTAT |
| VWPANLA | SDEPOSTAT | VWPANLA | MANDT | TW51 | Securities Account Statistics Key | MANDT |
| VWPANLA | SMOVERW | VWPANLA | MANDT | TW50 | Table for possible deposit types | MANDT |
| VWPANLA | SMOVERW | VWPANLA | SMOVERW | TW50 | Table for possible deposit types | SMOVERW |
| VWPANLA | SROLEXT | VWPANLA | MANDT | TW22 | Securities classification | MANDT |
| VWPANLA | SROLEXT | VWPANLA | SROLEXT | TW22 | Securities classification | ALWPKL |
| VWPANLA | SWERTTYP | VWPANLA | SWERTTYP | TW20 | Security category | SWERTTYP |
| VWPANLA | SWERTTYP | VWPANLA | MANDT | TW20 | Security category | MANDT |
