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