SAP ABAP Table FTR_XI_COMMON (Mapping: General Data)

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	FTR_XI_COMMON	Table Relationship Diagram
Short Description	Mapping: General Data

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	Mapping: General Data in External Format
2	TRADE_ID	☐	FTR_XI_TRADE_ID		CHAR	35	0	Identifier of Transaction
3	TRADE_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
4	TRADE_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
5	PORTFOLIO_ID	☐	FTR_XI_PORTFOLIO_ID		CHAR	30	0	Portfolio
6	REQUESTOR_PRTY_REQ_ID	☐	FTR_XI_REQPARTY_REQ_ID		CHAR	60	0	Identifier for Transaction Initiator (Requestor ID)
7	REQUESTOR_PRTY_PROV_ID	☐	FTR_XI_REQPARTY_PROV_ID		CHAR	60	0	Identifier for Transaction Initiator (Provider ID)
8	REQUESTOR_PRTY_TRPL_ID	☐	FTR_XI_REQPARTY_TRPL_ID		CHAR	60	0	Identifier for Transaction Initiator (Trading Platform ID)
9	REQUESTOR_PRTY_CP_FORM_NAME	☐	FTR_XI_REQPARTY_CP_FNAME		CHAR	80	0	Contact Person/Trader for Transaction Initiator
10	PROVIDER_PRTY_REQ_ID	☐	FTR_XI_PROVPARTY_REQ_ID		CHAR	60	0	Identifier for Transaction Provider (Requestor ID)
11	PROVIDER_PRTY_PROV_ID	☐	FTR_XI_PROVPARTY_PROV_ID		CHAR	60	0	Identifier for Transaction Provider (Provider ID)
12	PROVIDER_PRTY_TRPL_ID	☐	FTR_XI_PROVPARTY_TRPL_ID		CHAR	60	0	Identifier for Transaction Provider (Trading Platform ID)
13	PROVIDER_PRTY_CP_FORM_NAME	☐	FTR_XI_PROVPARTY_CP_FNAME		CHAR	80	0	Contact Person/Trader of Transaction Provider
14	TRADING_PL_PRTY_REQ_ID	☐	FTR_XI_TRPLPARTY_REQ_ID		CHAR	60	0	Identifier for Trading Platform (ID of Requestor)
15	TRADING_PL_PRTY_PROV_ID	☐	FTR_XI_TRPLPARTY_PROV_ID		CHAR	60	0	Identifier for Trading Platform (ID of Providers)
16	TRADING_PL_PRTY_TRPL_ID	☐	FTR_XI_TRPLPARTY_TRPL_ID		CHAR	60	0	Identifier for Trading Platform (ID of Trading Platform)
17	TRADING_PL_PRTY_CP_FORM_NAME	☐	FTR_XI_TRPLPARTY_CP_FNAME		CHAR	80	0	Trading Platform Contact Person
18	.INCLUDE	☐				0	0	Mapping: 2xGeneral Data in SAP Internal Format (re. FX Swap)
19	.INCLUDE	☐				0	0	Mapping: General Data in SAP Internal Format
20	.INCLUDE	☐				0	0	FTR: BAPI Structure for Creating Transactions
21	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
22	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
23	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
24	EXTERNAL_TRANSACTION_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
25	PARTNER	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
26	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
27	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
28	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
29	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
30	ACCT_ASSIGNMENT_REF	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	*
31	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
32	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
33	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
34	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
35	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
36	EXTERNAL_REFERENCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
37	INTERNAL_REFERENCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
38	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
39	AUTH_GROUP	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
40	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
41	ENTRY_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
42	FACILITY	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
43	FACILITY_COMPANY_CODE	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
44	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
45	EXPENSE_KEY	☐	TB_SPESEN	T_SPESEN	CHAR	1	0	Expenses key
46	RESERV_REASON	☐	TB_SANST	SANST	CHAR	2	0	Reservation Reason	*
47	PRODUCT_CATEGORY	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
48	TRANSACTION_CATEGORY	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
49	.INCLU-_2	☐				0	0	Mapping: General Data in SAP Internal Format
50	.INCLUDE	☐				0	0	FTR: BAPI Structure for Creating Transactions
51	COMPANY_CODE_2	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
52	PRODUCT_TYPE_2	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
53	TRANSACTION_TYPE_2	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
54	EXTERNAL_TRANSACTION_NUMBER_2	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
55	PARTNER_2	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
56	CONTRACT_DATE_2	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
57	CONTRACT_TIME_2	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
58	CONTACT_PERSON_2	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
59	TRADER_2	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
60	ACCT_ASSIGNMENT_REF_2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	*
61	PORTFOLIO_2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
62	FINANCE_PROJECT_2	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
63	GUARANTOR_2	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
64	MASTER_AGREEMENT_2	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
65	ASSIGNMENT_2	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
66	EXTERNAL_REFERENCE_2	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
67	INTERNAL_REFERENCE_2	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
68	CHARACTERISTICS_2	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
69	AUTH_GROUP_2	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
70	CREATE_USER_2	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
71	ENTRY_DATE_2	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
72	FACILITY_2	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
73	FACILITY_COMPANY_CODE_2	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
74	VALUATION_CLASS_2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
75	EXPENSE_KEY_2	☐	TB_SPESEN	T_SPESEN	CHAR	1	0	Expenses key
76	RESERV_REASON_2	☐	TB_SANST	SANST	CHAR	2	0	Reservation Reason	*
77	PRODUCT_CATEGORY_2	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
78	TRANSACTION_CATEGORY_2	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTR_XI_COMMON	AUTH_GROUP	TRBRG	TBEGRU
2	FTR_XI_COMMON	AUTH_GROUP_2	TRBRG	TBEGRU
3	FTR_XI_COMMON	GUARANTOR	BUT000	PARTNER
4	FTR_XI_COMMON	GUARANTOR_2	BUT000	PARTNER
5	FTR_XI_COMMON	MASTER_AGREEMENT	VTBMA	RMAID
6	FTR_XI_COMMON	MASTER_AGREEMENT_2	VTBMA	RMAID
7	FTR_XI_COMMON	PARTNER	BUT000	PARTNER
8	FTR_XI_COMMON	PARTNER_2	BUT000	PARTNER
9	FTR_XI_COMMON	PORTFOLIO	TWPOB	RPORTB
10	FTR_XI_COMMON	PORTFOLIO_2	TWPOB	RPORTB
11	FTR_XI_COMMON	TRADER	TZDEA	RDEALER
12	FTR_XI_COMMON	TRADER_2	TZDEA	RDEALER

History

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