SAP ABAP Table JBD_STR_FX_DATA_MAP (Details of Forex Transaction)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-DP (Application Component) Transaction Data Pool
     ⤷ JBD_FX (Package) Foreign Exchange

Basic Data

Table Category	INTTAB	Structure
Structure	JBD_STR_FX_DATA_MAP	Table Relationship Diagram
Short Description	Details of Forex Transaction

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	General Data of Financial Transactions
2	.INCLUDE	☐				0	0	External Key of Financial Transaction
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
5	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
6	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
7	TRANSACTION_ACTIVITY	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
8	ACTIVITY_CAT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
9	PARTNER	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
10	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
11	CONTRACT_DATE	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
12	CONTRACT_TIME	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
13	CONTACT_PERSON	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
14	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
15	ACCT_ASSIGNMENT_REF	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
16	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
17	FINANCE_PROJECT	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
18	GUARANTOR	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
19	MASTER_AGREEMENT	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
20	ASSIGNMENT	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
21	EXTERNAL_REFERENCE	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
22	INTERNAL_REFERENCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
23	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
24	AUTH_GROUP	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
25	CREATE_USER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
26	ENTRY_DATE	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
27	CHANGE_USER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
28	CHANGE_DATE	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
29	CONFIRMATION_STATUS	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
30	RECONFIRMATION_STATUS	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
31	FACILITY	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	*
32	FACILITY_COMPANY_CODE	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	*
33	VALUATION_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
34	ACTIVE_STATUS_TRANSACTION	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
35	ACTIVE_STATUS_ACTIVITY	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
36	RELEASE_STATUS	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
37	REVERSAL_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	*
38	BUY_CURRENCY	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	*
39	BUY_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
40	SELL_CURRENCY	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	*
41	SELL_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
42	LEAD_CURRENCY	☐	TB_WLWAERS	WAERS	CUKY	5	0	Leading currency	*
43	LEAD_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
44	FOLLOW_CURRENCY	☐	TB_WFWAERS	WAERS	CUKY	5	0	Following Currency	*
45	FOLLOW_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
46	BUY_AMOUNT	☐	BAPITB_BZBETR	BAPICURR	DEC	23	4	Payment Amount
47	BUY_AMOUNT_CHAR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
48	SELL_AMOUNT	☐	BAPITB_BZBETR	BAPICURR	DEC	23	4	Payment Amount
49	SELL_AMOUNT_CHAR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
50	VALUE_DATE	☐	TB_DVALUTA	DATUM	DATS	8	0	Value date of forex transaction
51	FORWARD_RATE	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
52	SPOT_RATE	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
53	SWAP_RATE	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBD_STR_FX_DATA_MAP	ACCT_ASSIGNMENT_REF	T037S	RREFKONT
2	JBD_STR_FX_DATA_MAP	AUTH_GROUP	TRBRG	TBEGRU
3	JBD_STR_FX_DATA_MAP	GUARANTOR	BUT000	PARTNER
4	JBD_STR_FX_DATA_MAP	MASTER_AGREEMENT	VTBMA	RMAID
5	JBD_STR_FX_DATA_MAP	PORTFOLIO	TWPOB	RPORTB
6	JBD_STR_FX_DATA_MAP	TRADER	TZDEA	RDEALER

History

Last changed by/on	SAP	20130529
SAP Release Created in	463_20