SAP ABAP Table TXI_VWPANLA (Asset master for securities)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_VWPANLA	Table Relationship Diagram
Short Description	Asset master for securities

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Asset master for securities
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
4	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
5	SSTATI	☐	SEC_STATUS	SEC_STATUS	NUMC	2	0	Status of a security
6	RANLALT1	☐	RANLALT1S	CHAR13S	CHAR	13	0	RANLALT1
7	RANLALT2	☐	RANLALT2S	CHAR13S	CHAR	13	0	Alternative identification 2
8	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
9	SBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
10	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
11	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
12	WLOMB	☐	WLOMB	JANEI	CHAR	1	0	Indicator eligible as collateral
13	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
14	WPFAN	☐	WPFAN	JANEI	CHAR	1	0	Indicator pledgeable
15	SSTBE	☐	SSTBE	JANEI	CHAR	1	0	Tax treatment indicator
16	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
17	JABMI	☐	JABMI	JANEI	CHAR	1	0	Joint partner vote indicator
18	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
19	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
20	REPKE	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	*
21	BEMPREIS	☐	BEMPREIS	VVBNENNW	CURR	10	2	Issue Price
22	REWHR	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
23	PEMKURS	☐	PEMKURS	DEC3_7	DEC	10	7	Issue rate in percent
24	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
25	PKUAB	☐	PKUAB	DEC3_7	DEC	10	7	Price deviation in percent
26	BKUAB	☐	BKUAB	WHRBTRG	CURR	10	2	Absolute price deviation
27	DANDPFL	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
28	DANDRE	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
29	SOBJEKT	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
30	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
31	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
32	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
33	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
34	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
35	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
36	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
37	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
38	SROLEXT	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	*
39	VVSLOEKZ	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
40	JMUENDEL	☐	VVJMUEND	JANEI	CHAR	1	0	Eligibility indicator
41	SMOVERW	☐	SMOVERW	SMOVERW	CHAR	2	0	Possible custody type	TW50
42	SIHERK	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
43	KBEMPREIS	☐	VVKBEMPR	VVKWKURS	DEC	15	6	Issue price independent of currency
44	SDEPOSTAT	☐	VVDEPOSTAT	VVDEPOSTA	NUMC	2	0	Securities account statistics key	*
45	SFUNDI	☐	VVSFUNDI	JANEI	CHAR	1	0	Indicator: Funded
46	SWPHGMPF	☐	VVSWPHGMPF	JANEI	CHAR	1	0	Securities trading law reporting obligation indicator
47	RISIN	☐	VVRISIN	RISIN	CHAR	13	0	International securities ID number (no longer used)
48	INSTITUTE	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
49	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
50	PRICE_INDEX	☐	TIDX_INDEX_NAME	TIDX_INDEX_NAME	CHAR	15	0	Name of Price Index	*
51	PRICE_IDX_BDATE	☐	TIDX_INDEX_BASE_DATE	DATPER	DATS	8	0	Price Index Base Date
52	.INCLU--AP	☐				0	0	Append for VWPANLA
53	BEMPREIS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
54	BKUAB_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_VWPANLA	GSART	TZPA	GSART	KEY	1	CN
2	TXI_VWPANLA	INSTITUTE	TP07	SOL_INS
3	TXI_VWPANLA	MANDT	T000	MANDT	KEY	1	1
4	TXI_VWPANLA	RATING	TP06	RATING
5	TXI_VWPANLA	REWHR	TCURC	WAERS	KEY	1	1
6	TXI_VWPANLA	SANLF	TZAF	SANLF	KEY	1	CN
7	TXI_VWPANLA	SBRSCH	T016	BRSCH	KEY	1	1
8	TXI_VWPANLA	SMOVERW	TW50	SMOVERW	KEY	1	CN
9	TXI_VWPANLA	SWERTTYP	TW20	SWERTTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in