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
⤷ 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 |