SAP ABAP Table VTBLP (Log for Single Transaction Check)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-RA-CL (Application Component) Default Risk and Limit System
     ⤷ FTLM (Package) Financial Services: Limit Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTBLP	Table Relationship Diagram
Short Description	Log for Single Transaction Check

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	*
2	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
3	UDATE	☑	UDATUM	SYDATS	DATS	8	0	Date of Last Change
4	UTIME	☑	UZEIT	UZEIT	TIMS	6	0	Time
5	.INCLUDE	☑				0	0	Limit Record Key
6	SLA	☑	TB_SLA	T_SLA	CHAR	3	0	Limit Type	ATLA
7	RLV	☑	TB_RLV	T_RLV	NUMC	20	0	Number of Limit Record
8	SLH	☑	TB_SLH	NUMC2	NUMC	2	0	Hierarchy Level of Limit Record
9	RESULT	☐	TB_LIGHTS	TB_LIGHTS	CHAR	1	0	Single Transaction Check Result as Traffic Light (Total)
10	.INCLUDE	☐				0	0	Credit Limit Single Transaction Check: Join Limits <-> Util.
11	RESULT_DETAIL	☐	TB_LIGHTS_DETAIL	TB_LIGHTS	CHAR	1	0	Single Transaction Check Result as Traffic Light (Detailed)
12	DLVB	☐	TB_DLVB	DATUM	DATS	8	0	Limit Valid From
13	DLVE	☐	TB_DLVE	DATUM	DATS	8	0	Limit Valid To
14	BLIMIT	☐	TB_BLIMIT	T_BLV	CURR	17	2	Internal Limit Amount
15	ELIMIT	☐	TB_ELIMIT	T_BLV	CURR	17	2	External Limit Amount
16	WLIMIT	☐	TB_WLIMIT	WAERS	CUKY	5	0	Limit Currency	*
17	COMPERD	☐	TB_COMPERD	NUMC4	NUMC	4	0	Maximum Risk Commitment Period in Months
18	RELTEXT	☐	TB_RELTEXT	CHAR12	CHAR	12	0	Text for Release Status
19	RELSTATE	☐	TB_RELSTATE	TB_RELSTATE	CHAR	1	0	Release Status of a Limit
20	SLI	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	ATLSLI
21	DLI	☐	TB_DLI	DATUM	DATS	8	0	Base Date for Determining Limit Utilization
22	VLI	☐	TB_VLI	DATUM	DATS	8	0	'Valid From' Date of the Limit Utilization
23	BLI	☐	TB_BLI_SUM	WERTV9	CURR	17	2	Limit Amount Utilized: Totals Record
24	CLI	☐	TB_CLI_SUM	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record
25	BLS	☐	TB_BLSS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record
26	WLI	☐	TB_WLIZ	WAERS	CUKY	5	0	Target Currency for Conversion of Limit Amount Utilized	*
27	SLP	☐	TB_SLP	DEC3_7	DEC	10	7	Percentage of Attribution
28	DIFF_I	☐	TB_DIFF_I	T_BLV	CURR	17	2	Difference Between Internal Limit and Amount Utilized
29	DIFF_E	☐	TB_DIFF_E	T_BLV	CURR	17	2	Difference Between External Limit and Amount Utilized
30	RLI_NEW	☐	TB_RLI	NUMC4	NUMC	4	0	Risk Commitment Period in Months
31	BLI_NEW	☐	TB_BLI_NEW	WERTV9	CURR	17	2	Limit Utilization Amount for Single Transaction
32	CLI_NEW	☐	TB_CLI_NEW	WERTV9	CURR	17	2	Single Transaction Commitment Amount
33	WLI_NEW	☐	TB_WLIE	WAERS	CUKY	5	0	Transaction Currency	*
34	QLI	☐	TB_QLI	DEC8_2	DEC	10	2	Limit Utilization in Percent
35	BLI_OLD	☐	TB_BLI_OLD	WERTV9	CURR	17	2	Limit Utilization Amount from Single Transaction (Old)
36	CLI_OLD	☐	TB_CLI_OLD	WERTV9	CURR	17	2	Single Transaction Commitment (Old)
37	WLI_OLD	☐	TB_WLIE	WAERS	CUKY	5	0	Transaction Currency	*
38	INFINITE	☐	TB_LIMIT_INFINITE	TB_LIMIT_INFINITE	CHAR	1	0	Indicator: Do Not Check Limit
39	PROZLIMIT	☐	TB_PROZLIMIT	DEC3_2	DEC	5	2	Critical Limit Utilization in Percent
40	TLI	☐	TB_TLI	TB_TLI	CHAR	2	0	Object Number Category in Limit Management
41	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
42	EDLVE	☐	TB_EDLVE	DATUM	DATS	8	0	External Validity End Date of Limit
43	.INCLUDE	☐				0	0	Lock Information for Limits
44	LLOCK	☐	TB_LOCK	DATE	DATS	8	0	Lock Date
45	LLUSER	☐	TB_LUSER	XUBNAME	CHAR	12	0	Limit Locked By	USR02

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTBLP	LLUSER	USR02	BNAME		C	CN
2	VTBLP	SLA	ATLA	SLA		1	N
3	VTBLP	SLI	ATLSLI	SLI		1	N
4	VTBLP	UNAME	USR02	BNAME

History

Last changed by/on	SAP	20110901
SAP Release Created in