1. Home
  2. Resources
  3. SAP Tables
  4. VWPBONO - Securities listing

SAP Table VWPBONO

Securities listing

VWPBONO (Securities listing) 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 VWPBONO to other SAP tables.

VWPBONO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RANTYP Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
RANL Security ID Number VVRANLW CHAR 13 0
RHANDPL Exchange VVRHANDPL TWH01 CHAR 10 0
WAERS Currency Key WAERS TCURC CUKY 5 0
FLAT Flat price - Yes/No VVJFLAT CHAR 1 0
X Selection character
NULL Blank
HEIBOE Home exchange - Yes/No VVJHEIBOE CHAR 1 0
X Selection character
NULL Blank
SBOEN Listing key VVSBOEN TW53 NUMC 2 0
PKUAB Price of Unit- or Percentage-Quoted Security VVPKTKUR DEC 15 6
BKUAB Price of Unit- or Percentage-Quoted Security VVPKTKUR DEC 15 6

VWPBONO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VWPBONO MANDT VWPBONO MANDT T000 Clients MANDT
VWPBONO RHANDPL VWPBONO MANDT TWH01 Stock exchange table MANDT
VWPBONO RHANDPL VWPBONO RHANDPL TWH01 Stock exchange table RHANDPL
VWPBONO SBOEN VWPBONO SBOEN TW53 Listing key SBOEN
VWPBONO SBOEN VWPBONO MANDT TW53 Listing key MANDT
VWPBONO WAERS VWPBONO MANDT TCURC Currency Codes MANDT
VWPBONO WAERS VWPBONO WAERS TCURC Currency Codes WAERS