SAP ABAP Table FTI_LDB_SWAP_POSITION (Treasury: Positions (Transactions) Swaps (-> LDB))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI_LDB (Package) Logical Databases for the R/3 CFM Information System

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_LDB_SWAP_POSITION	Table Relationship Diagram
Short Description	Treasury: Positions (Transactions) Swaps (-> LDB)

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	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	*
4	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
5	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
6	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	*
7	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
8	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
9	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
11	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
12	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
13	STICHTAG	☐	FTI_STICHTAG	VVSTDAT	DATS	8	0	Key Date
14	RANTYP_R	☐	FTI_RANTYP	FTI_RANTYP	CHAR	1	0	Contract type
15	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	*
16	ACC_ASS_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	*
17	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	*
18	.INCLUDE	☐				0	0	Include for Transaction Attributes Rel. for Position (->LDB)
19	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
20	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
21	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
22	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
23	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
24	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
25	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
26	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
27	PORTFOLIO_TM	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
28	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
29	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
30	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
31	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
32	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
33	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
34	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
35	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
36	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
37	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
38	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
39	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
40	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
41	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
42	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
43	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
44	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
45	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
46	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
47	SSIGN	☐	SSIGN	PD_SIGN	CHAR	1	0	Sign
48	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	*
49	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
50	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
51	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
52	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	*
53	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
54	SCONFIRM	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
55	SECONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
56	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
57	RAHABAKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
58	BNWHR	☐	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
59	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
60	.INCLUDE	☐				0	0	Treasury: Partner Attributes
61	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
62	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
63	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
64	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
65	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
66	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
67	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
68	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
69	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
70	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
71	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
72	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
73	.INCLUDE	☐				0	0	Business partner credit standing data
74	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
75	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
76	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
77	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
78	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
79	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	*
80	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
81	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
82	NOMINAL_AMT_OUT_PC	☐	FTI_NOMINAL_OUT_PCOUT	TPM_AMOUNT	CURR	21	2	Nominal Value, Outgoing Side, in Position Crcy (Outg. Side)
83	NOMINAL_AMT_IN_PC	☐	FTI_NOMINAL_IN_PCIN	TPM_AMOUNT	CURR	21	2	Nominal Value, Incoming Side, in Position Crcy (Inc. Side)
84	BSZINS_AS	☐	FTI_BSUMZINS_AUSGS	WERTV8_TR	CURR	15	2	Total interest - outgoing side (outgoing position currency)
85	BSZINS_ES	☐	FTI_BSUMZINS_EINGS	WERTV8_TR	CURR	15	2	Total interest - incoming side (incoming position currency)
86	ZSREF_OUT	☐	FTI_SZSREF_OUT	ZIREFKU	CHAR	10	0	Reference Interest Rate of Outgoing Side	*
87	ZSREF_IN	☐	FTI_SZSREF_IN	ZIREFKU	CHAR	10	0	Reference Interest Rate Incoming Side	*
88	XFORMEL_AS	☐	FTI_XFORMEL_AS	T_XTEXT30	CHAR	30	0	Formula for variable interest condition - outgoing side
89	XFORMEL_ES	☐	FTI_XFORMEL_ES	T_XTEXT30	CHAR	30	0	Formula for variable interest condition - incoming side
90	PZINSFEST_AS	☐	FTI_ZINSFEST_AS	DECV3_7	DEC	10	7	Fixed-interest condition - outgoing side
91	PZINSFEST_ES	☐	FTI_ZINSFEST_ES	DECV3_7	DEC	10	7	Fixed-interest condition - incoming side
92	PZINSFIX_AS	☐	FTI_ZINSFIX_AS	DECV3_7	DEC	10	7	Fixed Interest Rate for Variable Condition Outgoing Side
93	PZINSFIX_ES	☐	FTI_ZINSFIX_ES	DECV3_7	DEC	10	7	Fixed Interest Rate for Variable Condition Incoming Side
94	AMMRHY_OUT	☐	FTI_AMMRHY_OUT	NUMC03	NUMC	3	0	Current Frequency in Months/Outgoing Side
95	AMMRHY_IN	☐	FTI_AMMRHY_IN	NUMC03	NUMC	3	0	Current Frequency in Months/Incoming Side
96	SPREAD_IN	☐	FTI_SPREAD_IN	DECV3_7	DEC	10	7	Spread Rate Incoming Side
97	SPREAD_OUT	☐	FTI_SPREAD_OUT	DECV3_7	DEC	10	7	Spread Rate Outgoing Side
98	TOTAL_TERM	☐	FTI_TOTAL_TERM	DEC04	DEC	4	0	Total Term in Days
99	LAST_FIX_DATE	☐	FTI_LAST_FIXINGDATE	DATUM	DATS	8	0	Last Fixing Date
100	NEXT_FIX_DATE	☐	FTI_NEXT_FIXINGDATE	DATUM	DATS	8	0	Next Fixing Date
101	LAST_INTFIXING_IN	☐	FTI_LAST_INTFIXING	DECV3_7	DEC	10	7	Last Interest Fixing
102	EXPCTD_INTFIXING	☐	FTI_EXPECTED_INTFIXING	DECV3_7	DEC	10	7	Expected Interest Rate Next Interest Fixing
103	FIX_VARIABLE_IN	☐	FTI_FIX_VAR_IN	FTI_FIX_VAR	CHAR	1	0	Fixed/Variable ID: Incoming Side of a Transaction
104	FIX_VARIABLE_OUT	☐	FTI_FIX_VAR_OUT	FTI_FIX_VAR	CHAR	1	0	Fixed/Variable ID: Outgoing Side of a Transaction
105	FIX_VARIABLE	☐	FTI_FIX_VAR	FTI_FIX_VAR	CHAR	1	0	Indicator Fixed/Variable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_SWAP_POSITION	CNTRY_COMP	T005	LAND1
2	FTI_LDB_SWAP_POSITION	GROUP_D	TP13	GROUP_D
3	FTI_LDB_SWAP_POSITION	GROUP_ID	TB001	BU_GROUP
4	FTI_LDB_SWAP_POSITION	IND_SECTOR	TB038A	IND_SECTOR
5	FTI_LDB_SWAP_POSITION	ISTYPE	TB038	ISTYPE
6	FTI_LDB_SWAP_POSITION	LEGAL_ENTY	TB019	LEGAL_ENTY
7	FTI_LDB_SWAP_POSITION	LEGAL_ORG	TB032	LEGAL_ORG
8	FTI_LDB_SWAP_POSITION	NATION	T005	LAND1
9	FTI_LDB_SWAP_POSITION	PORTFOLIO_TM	TWPOB	RPORTB
10	FTI_LDB_SWAP_POSITION	RATING	TP06	RATING
11	FTI_LDB_SWAP_POSITION	RGARANT	BUT000	PARTNER
12	FTI_LDB_SWAP_POSITION	RMAID	VTBMA	RMAID
13	FTI_LDB_SWAP_POSITION	SOL_INS	TP07	SOL_INS
14	FTI_LDB_SWAP_POSITION	STAFF_GRP	TP05	STAFF_GRP		C	CN
15	FTI_LDB_SWAP_POSITION	STATE	T005	LAND1

History

Last changed by/on	SAP	20131127
SAP Release Created in	200