SAP ABAP Table FTI_LDB_TR_SEC_DEAL_1 (Treasury: Transaction Reporting, Securities Main Data)
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
⤷ 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_TR_SEC_DEAL_1 | Table Relationship Diagram |
Short Description | Treasury: Transaction Reporting, Securities Main 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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | COMPANYCODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | SE_DEAL_NUMBER | FTI_SE_RFHA | T_RFHA | CHAR | 13 | 0 | Securities/Futures Transaction | * | |
4 | OBJECTNUMBER | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
5 | CREATE_USER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
6 | CREATE_DATE | TB_DCRDAT | DATUM | DATS | 8 | 0 | Entered On | ||
7 | CREATE_TIME | TB_TCRTIM | UZEIT | TIMS | 6 | 0 | Entry Time | ||
8 | UPDATE_USER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
9 | UPDATE_DATE | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
10 | UPDATE_TIME | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
11 | CONTRACT_TYPE | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
12 | PRODUCT_CAT | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
13 | PRODUCT_TYPE | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
14 | TRANSACTION_CAT | TB_SFGTYP | T_SFGTYP | NUMC | 3 | 0 | Transaction Category | AT01 | |
15 | ACTIVITY_CAT | TB_SFGZUTY | T_SFGZUTY | NUMC | 2 | 0 | Transaction Activity Category | AT02 | |
16 | TRANSACTION_TYPE | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | AT10 | |
17 | CONTRACT_DATE | TB_DVTRAB | DATUM | DATS | 8 | 0 | Contract Conclusion Date | ||
18 | CONTRACT_TIME | TB_TVTRAB | UZEIT | TIMS | 6 | 0 | Time of contract conclusion | ||
19 | TRADER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | TZDEA | |
20 | COUNTERPARTY | TB_KONTRH | BU_PARTNER | CHAR | 10 | 0 | Counterparty | BUT000 | |
21 | CONTACT_PERSON | TB_GSPPART | TEXT19 | CHAR | 19 | 0 | Contact Person | ||
22 | GUARANTOR | TB_RGARANT_NEW | BU_PARTNER | CHAR | 10 | 0 | Guarantor of Financial Transaction | BUT000 | |
23 | EXTERNAL_REFNCE | TB_NORDEXT | FTI_CHAR16LOW | CHAR | 16 | 0 | External Reference | ||
24 | PORTFOLIO | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | * | |
25 | FINANCE_PROJECT | TB_TFPROJ | T_TFPROJ | CHAR | 13 | 0 | Finance Project | ||
26 | MASTER_AGREEMENT | TB_RMAID | T_RMAID | CHAR | 10 | 0 | Master Agreement | * | |
27 | ASSIGNMENT | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
28 | INTERNAL_REFNCE | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
29 | CHARACTERISTICS | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
30 | VALUATION_CLASS | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | TRGC_COM_VALCL | |
31 | DEAL_ACTIVE | TB_SAKTIV | T_SAKTIV | NUMC | 1 | 0 | Active Status of Transaction or Activity | ||
32 | RELEASE_STATUS | TB_FRGZUST | T_FRGZUST | CHAR | 1 | 0 | Transaction Release: Release Status | ||
33 | CONFIRM_STATUS | TB_CONF | TB_CONF | NUMC | 1 | 0 | Confirmation Status | ||
34 | CONFIRM_DATE | TB_DCONF | DATUM | DATS | 8 | 0 | Confirmation Date | ||
35 | CONFIRM_USER | TB_UCONF | USNAM | CHAR | 12 | 0 | Confirmation Executed By (User Responsible) | ||
36 | CNTRCONFIRM | TB_RECONF | TB_RECONF | NUMC | 1 | 0 | Counterconfirmation | ||
37 | CNTRCONFIRM_DATE | TB_DREDAT | DATUM | DATS | 8 | 0 | Counterconfirmation Date | ||
38 | CNTRCONFIRM_USER | TB_URENAM | USNAM | CHAR | 12 | 0 | Counterconfirmation Executed by (User Responsible) | ||
39 | CURRENCY | FTI_WGSCHFT | WAERS | CUKY | 5 | 0 | Currency of Transaction | TCURC | |
40 | NOM_AMOUNT | FTI_NOMAMT | WERTV7 | CURR | 13 | 2 | Nominal Amount | ||
41 | UNITS | FTI_POSITIONS_UNITS | TPM_UNITS | DEC | 22 | 6 | Units | ||
42 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
43 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
44 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | * | |
45 | POSITION_CCY | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
46 | LOCAL_CCY | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
47 | NOMORGAMT_TRADED | FTI_NOMORGAMT_TRADED | WERTV7 | CURR | 13 | 2 | Traded Original Nominal Amount | ||
48 | NOM_AMT_TRADED | FTI_NOMAMT_TRADED | WERTV7 | CURR | 13 | 2 | Traded Nominal Amount | ||
49 | NUMBER_TRADED | FTI_NUMBER_TRADED | ASTUECK | DEC | 15 | 5 | Traded Number of Units for Unit-Quoted Securities | ||
50 | PRICE_CCYUNT_PRC | FTI_QUOT_UNIT_PRCT | FTI_QUOT_UNIT_PRCT | CHAR | 5 | 0 | Quotation Currency Unit / Percent (Mixed Representation) | ||
51 | PRICE_CCYUNT | TB_RUNIT | VVSRUNIT | CHAR | 5 | 0 | Currency unit of rate | * | |
52 | PRICE_TRADED | FTI_PRICE_TRADED | FTI_PRICE_TRADED | DEC | 15 | 6 | Traded Price of Security (Mixed Representation) | ||
53 | QUOTATION | TB_NOTTYPE | T_NOTTYPE | CHAR | 1 | 0 | Quotation type for option, future, security etc. | ||
54 | MARKET_VAL_QC | TB_BEBETR | WERTV7 | CURR | 13 | 2 | Market Value in Quotation Currency | ||
55 | QUOTATION_CCY | FTI_QUOT_CCY | WAERS | CUKY | 5 | 0 | Quotation Currency | * | |
56 | MARKET_VAL_CC | FTI_MARKET_CC | TPM_AMOUNT | CURR | 21 | 2 | Market Value in Payment Currency | ||
57 | FX_RATE_TO_CC | TB_KZWKURS | UKURS | DEC | 9 | 5 | Payment currency rate | ||
58 | MARKET_VAL_PC | FTI_MARKET_PC | TPM_AMOUNT | CURR | 21 | 2 | Market Value in Position Currency | ||
59 | FX_RATE_TO_PC | TB_KBWKURS | UKURS | DEC | 9 | 5 | Position currency rate | ||
60 | MARKET_VAL_LC | FTI_MARKET_LC | TPM_AMOUNT | CURR | 21 | 2 | Market Value in Local Currency | ||
61 | FX_RATE_TO_LC | TB_KHWKURS | UKURS | DEC | 9 | 5 | Local currency rate | ||
62 | HOUSEBNK_IN | FTI_HBANK_IN | HBKID | CHAR | 5 | 0 | Short Key for Own House Bank: Incoming Side | * | |
63 | HOUSEBNKACCT_IN | FTI_HBACCT_IN | HKTID | CHAR | 5 | 0 | Short Key for House Bank Account: Incoming Side | * | |
64 | PAYER_PAYEE_IN | FTI_PAYERPAYEE_IN | BU_PARTNER | CHAR | 10 | 0 | Payer/Payee of Incoming Side | * | |
65 | PARTNERBNK_IN | FTI_PBANK_IN | BVTYP | CHAR | 4 | 0 | Partner Bank Details of Incoming Side | ||
66 | HOUSEBNK_OUT | FTI_HBANK_OUT | HBKID | CHAR | 5 | 0 | Short Key for Own House Bank: Outgoing Side | * | |
67 | HOUSEBNKACCT_OUT | FTI_HBACCT_OUT | HKTID | CHAR | 5 | 0 | Short Key for House Bank Account: Outgoing Side | * | |
68 | PAYER_PAYEE_OUT | FTI_PAYERPAYEE_OUT | BU_PARTNER | CHAR | 10 | 0 | Payer/Payee of Outgoing Side | * | |
69 | PARTNERBNK_OUT | FTI_PBANK_OUT | BVTYP | CHAR | 4 | 0 | Partner Bank Details of Outgoing Side | ||
70 | EFF_INT | TB_PYIELD | DECV3_7 | DEC | 10 | 7 | Effective Interest Rate | ||
71 | EFF_INT_METHOD | SEFFMETH | SEFFMETH | NUMC | 1 | 0 | Effective Interest Method (Financial Mathematics) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FTI_LDB_TR_SEC_DEAL_1 | ACTIVITY_CAT | AT02 | SFGZUSTT | |||
2 | FTI_LDB_TR_SEC_DEAL_1 | COMPANYCODE | T001 | BUKRS | |||
3 | FTI_LDB_TR_SEC_DEAL_1 | COUNTERPARTY | BUT000 | PARTNER | |||
4 | FTI_LDB_TR_SEC_DEAL_1 | CURRENCY | TCURC | WAERS | |||
5 | FTI_LDB_TR_SEC_DEAL_1 | GUARANTOR | BUT000 | PARTNER | |||
6 | FTI_LDB_TR_SEC_DEAL_1 | MANDT | T000 | MANDT | |||
7 | FTI_LDB_TR_SEC_DEAL_1 | PRODUCT_CAT | TZAF | SANLF | |||
8 | FTI_LDB_TR_SEC_DEAL_1 | PRODUCT_TYPE | TZPA | GSART | |||
9 | FTI_LDB_TR_SEC_DEAL_1 | SECURITY_ACCOUNT | TWD01 | RLDEPO | |||
10 | FTI_LDB_TR_SEC_DEAL_1 | TRADER | TZDEA | RDEALER | |||
11 | FTI_LDB_TR_SEC_DEAL_1 | TRANSACTION_CAT | AT01 | SFGTYP | |||
12 | FTI_LDB_TR_SEC_DEAL_1 | TRANSACTION_TYPE | AT10 | SFHAART | |||
13 | FTI_LDB_TR_SEC_DEAL_1 | VALUATION_CLASS | TRGC_COM_VALCL | COM_VAL_CLASS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |