SAP ABAP Table VTS_FC_REP1 (FTR Facilities: Reporting Structure 1)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-TR (Application Component) Transaction Management
     ⤷ FTTR (Package) Treasury: Financial Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	VTS_FC_REP1	Table Relationship Diagram
Short Description	FTR Facilities: Reporting Structure 1

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
4	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
5	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
6	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
7	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
8	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
9	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
10	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
11	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
12	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
13	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
14	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
15	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
16	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
17	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
18	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
19	WGSCHFT	☐	TB_FC_WGSCHFT	WAERS	CUKY	5	0	Currency of Facility	TCURC
20	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
21	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
22	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
23	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
24	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
25	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
26	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
27	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
28	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
29	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
30	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
31	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
32	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
33	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
34	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
35	SFUNKTV	☐	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	*
36	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
37	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
38	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
39	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
40	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
41	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
42	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
43	AMNT_DELTA	☐	TB_FC_AMOUNT_DELTA	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Above/Below the Limit
44	AMNT_LIMIT	☐	TB_FC_AMOUNT_LIMIT	T_POS_AMOUNT	CURR	17	2	FTR Facility: Limit Amount on Key Date
45	AMNT_USED	☐	TB_FC_AMOUNT_USED	T_POS_AMOUNT	CURR	17	2	FTR Facility: Utilization on Key Date
46	AMNT_FREE	☐	TB_FC_AMOUNT_FREE	T_POS_AMOUNT	CURR	17	2	FTR Facility: Amount Available on Key Date
47	AMNT_OVER	☐	TB_FC_AMOUNT_OVER	T_POS_AMOUNT	CURR	17	2	FTR Facility: Overdraft Amount on Key Date
48	DSTICH	☐	TB_DSTICH	DATUM	DATS	8	0	Key date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTS_FC_REP1	ABWTYP	AT05	ABWTYP		1	CN
2	VTS_FC_REP1	BUKRS	T001	BUKRS	KEY	1	CN
3	VTS_FC_REP1	MANDT	T000	MANDT	KEY	1	CN
4	VTS_FC_REP1	OBJNR	ONR00	OBJNR		1	N
5	VTS_FC_REP1	RPORTB	TWPOB	RPORTB
6	VTS_FC_REP1	RREFKONT	T037S	RREFKONT	KEY	1	CN
7	VTS_FC_REP1	RREFKONT2	T037S	RREFKONT	KEY	1	CN
8	VTS_FC_REP1	SKALID	TFACD	IDENT	KEY	1	CN
9	VTS_FC_REP1	SKALID2	TFACD	IDENT	KEY	1	CN
10	VTS_FC_REP1	WGSCHFT	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	462_10