VWPANLA SAP table for – Asset master for securities

Here we would like to draw your attention to VWPANLA table in SAP. As we know it is being mainly used with the SAP Treasury module. VWPANLA is a SAP standard transparent table used for storing Asset master for securities related data in SAP. It comes under the package FVVW_CORE.

SAP VWPANLA table

Table VWPANLA technical data

TableVWPANLA
Data storingAsset master for securities
ModuleTR
ComponentTR
SAP PackageFVVW_CORE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VWPANLA Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VWPANLA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SBOERNOT
    Its data type is C (Character String) with field length 1
  • WLOMB
    Its data type is C (Character String) with field length 1
  • JDECK
    Its data type is C (Character String) with field length 1
  • WPFAN
    Its data type is C (Character String) with field length 1
  • SSTBE
    Its data type is C (Character String) with field length 1
  • LOEVM : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • JABMI
    Its data type is C (Character String) with field length 1
  • XALKZ
    Its data type is C (Character String) with field length 15
  • XALLB
    Its data type is C (Character String) with field length 60
  • REPKE
    Its data type is C (Character String) with field length 10
  • RANL
    Its a key field. Its data type is C (Character String) with field length 13
  • BEMPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • REWHR
    Its data type is C (Character String) with field length 5
  • PEMKURS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SNOTI
    Its data type is N (Character String with Digits Only) with field length 1
  • PKUAB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • BKUAB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • DANDPFL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DANDRE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SOBJEKT
    Its data type is C (Character String) with field length 10
  • RERF
    Its data type is C (Character String) with field length 12
  • SANLF
    Its data type is N (Character String with Digits Only) with field length 3
  • DERF
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TERF
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • REHER
    Its data type is C (Character String) with field length 10
  • RBEAR
    Its data type is C (Character String) with field length 12
  • DBEAR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • RBHER
    Its data type is C (Character String) with field length 10
  • SROLEXT
    Its data type is C (Character String) with field length 3
  • VVSLOEKZ
    Its data type is N (Character String with Digits Only) with field length 1
  • JMUENDEL
    Its data type is C (Character String) with field length 1
  • SSTATI
    Its data type is N (Character String with Digits Only) with field length 2
  • SMOVERW
    Its data type is C (Character String) with field length 2
  • SIHERK
    Its data type is C (Character String) with field length 2
  • KBEMPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SDEPOSTAT
    Its data type is N (Character String with Digits Only) with field length 2
  • SFUNDI
    Its data type is C (Character String) with field length 1
  • SWPHGMPF
    Its data type is C (Character String) with field length 1
  • RISIN
    Its data type is C (Character String) with field length 13
  • INSTITUTE
    Its data type is C (Character String) with field length 4
  • RATING : Numeric values for traffic lights
    Its data type is C (Character String) with field length 3
  • PRICE_INDEX
    Its data type is C (Character String) with field length 15
  • RANLALT1
    Its data type is C (Character String) with field length 13
  • PRICE_IDX_BDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is VWPANLA_CFM
  • RANLALT2
    Its data type is C (Character String) with field length 13
  • GSART
    Its data type is C (Character String) with field length 3
  • SBRSCH
    Its data type is C (Character String) with field length 4
  • SWERTTYP
    Its data type is N (Character String with Digits Only) with field length 1