SAP ABAP Table VTBFSEC (Securities Collateral)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_LENDING (Package) CFM-TM: Securities Lending

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTBFSEC	Table Relationship Diagram
Short Description	Securities Collateral

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	COMPANY_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	RANL	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
5	VALID_FROM	☑	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
6	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
7	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
8	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
9	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
10	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
11	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
12	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
13	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
14	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTBFSEC	COMPANY_CODE	T001	BUKRS	KEY	1	CN
2	VTBFSEC	MANDT	T000	MANDT	KEY	1	CN
3	VTBFSEC	OBJNR	ONR00	OBJNR		1	N
4	VTBFSEC	RANL	VWPANLA	RANL	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600