SAP ABAP Table SECURITY_DB_ANLA (Test)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

Table Category	INTTAB	Structure
Structure	SECURITY_DB_ANLA	Table Relationship Diagram
Short Description	Test

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	TW22
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	TW51
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	TIDX_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	RANL2	☐	WP_RANL	WP_RANL	CHAR	13	0	Security ID number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SECURITY_DB_ANLA	GSART	TZPA	GSART	KEY	1	CN
2	SECURITY_DB_ANLA	INSTITUTE	TP07	SOL_INS
3	SECURITY_DB_ANLA	MANDT	T000	MANDT	KEY	1	1
4	SECURITY_DB_ANLA	PRICE_INDEX	TIDX_PRICE_INDEX	INDEX_NAME	REF	C	CN
5	SECURITY_DB_ANLA	RATING	TP06	RATING
6	SECURITY_DB_ANLA	REWHR	TCURC	WAERS	KEY	1	1
7	SECURITY_DB_ANLA	SANLF	TZAF	SANLF	KEY	1	CN
8	SECURITY_DB_ANLA	SBRSCH	T016	BRSCH	KEY	1	1
9	SECURITY_DB_ANLA	SDEPOSTAT	TW51	SDEPOSTAT	REF	C	CN
10	SECURITY_DB_ANLA	SMOVERW	TW50	SMOVERW	KEY	1	CN
11	SECURITY_DB_ANLA	SROLEXT	TW22	ALWPKL	REF	C	CN
12	SECURITY_DB_ANLA	SWERTTYP	TW20	SWERTTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in