TXI_VWPANLA SAP (Asset master for securities) Structure details

Dictionary Type: Structure
Description: Asset master for securities




ABAP Code to SELECT data from TXI_VWPANLA
Related tables to TXI_VWPANLA
Access table TXI_VWPANLA




Structure field list including key, data, relationships and ABAP select examples

TXI_VWPANLA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Asset master for securities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXI_VWPANLA TYPE TXI_VWPANLA.

The TXI_VWPANLA table consists of various fields, each holding specific information or linking keys about Asset master for securities data available in SAP. These include MANDT (Client), RANL (Security ID Number), SANLF (Product Category), SSTATI (Status of a security).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TXI_VWPANLA structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SSTATIStatus of a security SEC_STATUSNUMC2SEC_STATUS
RANLALT1RANLALT1 RANLALT1SCHAR13CHAR13SRAN
RANLALT2Alternative identification 2 RANLALT2SCHAR13CHAR13SRAN
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SBRSCHIndustry key BRSCHCHAR4T016BRSCH
SWERTTYPSecurity Type ID SWERTTYPNUMC1TW20SAKTTYP
SBOERNOTIndicator: Listed on an Exchange SBOERNOTCHAR1JANEI
WLOMBIndicator eligible as collateral WLOMBCHAR1JANEI
JDECKRegulatory reporting BPV (hedge fund Y/N) JDECKCHAR1JANEI
WPFANIndicator pledgeable WPFANCHAR1JANEI
SSTBETax treatment indicator SSTBECHAR1JANEI
LOEVMDeletion Indicator LOEVMCHAR1XFELD
JABMIJoint partner vote indicator JABMICHAR1JANEI
XALKZShort name XALKZCHAR15XKBEZ
XALLBLong name XALLBCHAR60XLBEZ
REPKEIssuer Identity Key REPKE_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BEMPREISIssue Price BEMPREISCURR10(2) VVBNENNW
REWHRIssue currency REWHRCUKY5TCURCWAERS
PEMKURSIssue rate in percent PEMKURSDEC10(7) DEC3_7
SNOTIQuotation Indicator SNOTINUMC1SNOTI
PKUABPrice deviation in percent PKUABDEC10(7) DEC3_7
BKUABAbsolute price deviation BKUABCURR10(2) WHRBTRG
DANDPFLObligation to offer for sale until DANDPFLDATS8DATUM
DANDRERight to offer until DANDREDATS8DATUM
SOBJEKTInternal key for object VVKEYOBJCHAR10VVKEY
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
SROLEXTGeneral Security Classification ALWPKLCHAR3Assigned to domainALWPKL
VVSLOEKZDeletion indicator VVSLOEKZNUMC1VVSLOEKZ
JMUENDELEligibility indicator VVJMUENDCHAR1JANEI
SMOVERWPossible custody type SMOVERWCHAR2TW50SMOVERW
SIHERKVersion Number Component CHAR2CHAR2CHAR2
KBEMPREISIssue price independent of currency VVKBEMPRDEC15(6) VVKWKURS
SDEPOSTATSecurities account statistics key VVDEPOSTATNUMC2Assigned to domainVVDEPOSTA
SFUNDIIndicator: Funded VVSFUNDICHAR1JANEI
SWPHGMPFSecurities trading law reporting obligation indicator VVSWPHGMPFCHAR1JANEI
RISINInternational securities ID number (no longer used) VVRISINCHAR13RISIN
INSTITUTEInstitute Providing Credit Standing Information BP_SOL_INSCHAR4TP07BP_SOL_INS
RATINGRating BP_RATINGCHAR3TP06BP_RATING
PRICE_INDEXName of Price Index TIDX_INDEX_NAMECHAR15Assigned to domainTIDX_INDEX_NAME
PRICE_IDX_BDATEPrice Index Base Date TIDX_INDEX_BASE_DATEDATS8DATPER
.INCLU--AP 0
BEMPREIS_CYCUKY for SYST SYCUKYCUKY5SYCUKY
BKUAB_CYCUKY for SYST SYCUKYCUKY5SYCUKY

Key field Non-key field



How do I retrieve data from SAP structure TXI_VWPANLA using ABAP code?

As TXI_VWPANLA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_VWPANLA as there is no data to select.

How to access SAP table TXI_VWPANLA

Within an ECC or HANA version of SAP you can also view further information about TXI_VWPANLA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!