SAP ABAP Table FTI_BIW_CFM_DELTA_POSITION (CFM: Delta Position for ODS 0CFM_O01)
Hierarchy
☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ CFM_TR_BIW (Package) CFM: Connection to BW
Basic Data
Table Category INTTAB    Structure 
Structure FTI_BIW_CFM_DELTA_POSITION   Table Relationship Diagram
Short Description CFM: Delta Position for ODS 0CFM_O01    
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 VALUATION_AREA TPM_VAL_AREA TPM_VAL_AREA CHAR 3   0   Valuation Area TRGC_VAL_AREA
3 BUSTRANSID TPM_BUSTRANSID SYSUUID RAW 16   0   Identifier of the Distributor Business Transaction  
4 TRLFLOWNUMBER TPM_TRLFLOWNR TPM_TRLFLOW_NR INT4 10   0   Number of TRL Flow  
5 .INCLUDE       0   0   Semantic Attributes for ODS 0CFM_O01  
6 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
7 TR_ACC_CODE TPM_ACC_CODE TPM_ACC_CODE CHAR 4   0   Accounting Code *
8 VALUATION_CLASS TPM_VAL_CLASS TPM_VAL_CLASS NUMC 4   0   Valuation Class *
9 GSART VVSART VVSART CHAR 3   0   Product Type *
10 PORTFOLIO RPORTB RPORTB CHAR 10   0   Portfolio *
11 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number *
12 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number *
13 DEAL_NUMBER FTI_POSRFHA T_RFHA CHAR 13   0   Financial Transaction That Creates a Position *
14 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group *
15 SECURITY_ACCOUNT VRLDEPO RLDEPO CHAR 10   0   Securities Account *
16 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures *
17 FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 1   0   Indicator: Long or Short Position  
18 LOT_ID TPM_LOT_ID SYSUUID RAW 16   0   Identifier of the Lot  
19 DLOTGENERATION DLOTGENERATION DATUM DATS 8   0   Date On Which Lot Was Generated  
20 TLOTGENERATION TLOTGENERATION UZEIT TIMS 6   0   Lot Generation Time  
21 LOTGENERATION_US FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
22 LOTGENERATION_CT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot *
23 LOTPOS_INIT_DATE FTI_LOTPOSITION_INIT_DATE TPM_POSITION_DATE DATS 8   0   Position Acquisition Date of a Lot  
24 LOTPOS_ORG_DATE FTI_LOTPOSITION_ORG_DATE TPM_POSITION_DATE DATS 8   0   Original Position Acquisition Date of a Lot  
25 LOTGEN_DEALNR FTI_LOTGENERATION_DEALNR T_RFHA CHAR 13   0   Lot-Generating Transaction Number *
26 ACC_ASS_REF TPM_AA_REF TPM_AA_REF CHAR 12   0   Account Assignment Reference of Position Management *
27 HKONT FTI_HKONT_BI SAKNR CHAR 10   0   General Ledger Account *
28 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
29 SE_DEAL_NUMBER FTI_SE_RFHA T_RFHA CHAR 13   0   Securities/Futures Transaction *
30 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty *
31 FLOW_TYPE TPM_DIS_FLOWTYPE TPM_DIS_FLOWTYPE CHAR 8   0   Update Type *
32 BUSTRANSCAT TPM_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category *
33 GEN_BUSTRANSCAT FTI_GENERATING_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Generating Business Transaction Category *
34 SOURCETARGET_FLG TPM_SOURCE_TARGET_FLG TPM_SOURCE_TARGET_FLG CHAR 1   0   Indicator: Source or Target of a Flow  
35 QUANT_CAT FTI_QTY_PM_CAT TPM_QTY_PM_CAT CHAR 4   0   Position Change Category: Quantity  
36 AMOUNT_CAT FTI_AMT_PM_CAT TPM_PM_CAT CHAR 4   0   Position Change Category *
37 TRL_BOOKINGSTATE TPM_TRL_BOOKINGSTATE TPM_TRL_BOOKINGSTATE CHAR 1   0   Posting Status Treasury Ledger Business Transaction  
38 PL_CATEGORY TPM_PL_CATEGORY TPM_PL_CATEGORY CHAR 3   0   P/L Type *
39 LEDGER_POST_STAT FTR_LEDGER_POSTING_STATE FTR_LEDGER_POSTING_STATE CHAR 1   0   Ledger Posting Status  
40 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
41 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
42 GL_ACCOUNT_D FTI_GLACC_D SAKNR CHAR 10   0   Number of G/L Account: Debit *
43 GL_ACCOUNT_C FTI_GLACC_C SAKNR CHAR 10   0   Number of G/L Account: Credit *
44 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
45 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
46 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
47 PERIO JAHRPER JAHRPER NUMC 7   0   Period/year  
48 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
49 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
50 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
51 SINCLVON VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
52 SINCLBIS VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
53 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
54 SHWHR TB_SHWHR WAERS CUKY 5   0   Local Currency TCURC
55 SVWHR TPM_VALUATION_CURR WAERS CUKY 5   0   Valuation Currency TCURC
56 SBWHR TB_BWHR WAERS CUKY 5   0   Position Currency/Transaction Currency TCURC
57 PLWHR SPLWHR WAERS CUKY 5   0   Profit/loss currency TCURC
58 .INCLUDE       0   0   CFM: Delta Position (Key Figures)  
59 D_UNITS FTI_D_UNITS TPM_UNITS DEC 22   6   Delta Number of Units  
60 D_NOMINAL_AMT_PC FTI_D_NOMINAL_AMT_PC TPM_AMOUNT CURR 21   2   Delta Nominal Amount in Position Currency  
61 D_NOMINAL_ORG_PC FTI_D_NOMINAL_ORG_AMT_PC TPM_AMOUNT CURR 21   2   Delta: Original Nominal Amount in Position Currency  
62 D_PURCH_PC FTI_D_PURCH_PC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Position Currency  
63 D_PURCH_LC FTI_D_PURCH_LC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Local Currency  
64 D_PURCH_VC FTI_D_PURCH_VC TPM_AMOUNT CURR 21   2   Delta Purchase Value in Valuation Currency  
65 D_AQU_VAL_PC FTI_D_AQU_VAL_PC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Position Currency  
66 D_AQU_VAL_LC FTI_D_AQU_VAL_LC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Local Currency  
67 D_AQU_VAL_VC FTI_D_AQU_VAL_VC TPM_AMOUNT CURR 21   2   Delta Acquisition Value in Valuation Currency  
68 D_BOOK_VAL_PC FTI_D_BOOK_VAL_PC TPM_AMOUNT CURR 21   2   Delta Book Value in Position Currency  
69 D_BOOK_VAL_LC FTI_D_BOOK_VAL_LC TPM_AMOUNT CURR 21   2   Delta Book Value in Local Currency  
70 D_BOOK_VAL_VC FTI_D_BOOK_VAL_VC TPM_AMOUNT CURR 21   2   Delta Book Value in Valuation Currency  
71 D_CHARGE_PC FTI_D_CHARGE_PC TPM_AMOUNT CURR 21   2   Delta Costs in Position Currency  
72 D_CHARGE_LC FTI_D_CHARGE_LC TPM_AMOUNT CURR 21   2   Delta Costs in Local Currency  
73 D_CHARGE_VC FTI_D_CHARGE_VC TPM_AMOUNT CURR 21   2   Delta Costs in Valuation Currency  
74 D_BOOK_VAL_EX_PC FTI_D_BOOK_VAL_EX_PC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Position Currency  
75 D_BOOK_VAL_EX_LC FTI_D_BOOK_VAL_EX_LC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Local Currency  
76 D_BOOK_VAL_EX_VC FTI_D_BOOK_VAL_EX_VC TPM_AMOUNT CURR 21   2   Delta Book Value Excl. Costs in Valuation Currency  
77 D_VAL_TI_PC FTI_D_VAL_TI_PC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Position Currency  
78 D_VAL_TI_LC FTI_D_VAL_TI_LC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Local Currency  
79 D_VAL_TI_VC FTI_D_VAL_TI_VC TPM_AMOUNT CURR 21   2   Delta Security Valuation in Valuation Currency  
80 D_VAL_FX_LC FTI_D_VAL_FX_LC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation in Local Currency  
81 D_VAL_FX_VC FTI_D_VAL_FX_VC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation in Valuation Currency  
82 D_VAL_CH_TI_PC FTI_D_VAL_CH_TI_PC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in PC  
83 D_VAL_CH_TI_LC FTI_D_VAL_CH_TI_LC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in LC  
84 D_VAL_CH_TI_VC FTI_D_VAL_CH_TI_VC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, Security, in VC  
85 D_VAL_CH_FX_LC FTI_D_VAL_CH_FX_LC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, FX, in Local Currency  
86 D_VAL_CH_FX_VC FTI_D_VAL_CH_FX_VC TPM_AMOUNT CURR 21   2   Delta Valuation of Capitalized Costs, FX, in Valuation Crcy  
87 D_AMORT_PC FTI_D_AMORT_PC TPM_AMOUNT CURR 21   2   Delta Amortization in Position Currency  
88 D_AMORT_LC FTI_D_AMORT_LC TPM_AMOUNT CURR 21   2   Delta Amortization in Local Currency  
89 D_AMORT_VC FTI_D_AMORT_VC TPM_AMOUNT CURR 21   2   Delta Amortization in Valuation Currency  
90 D_IMPMNT_PC FTI_D_IMPMNT_PC TPM_AMOUNT CURR 21   2   Delta Impairment in Position Currency  
91 D_IMPMNT_LC FTI_D_IMPMNT_LC TPM_AMOUNT CURR 21   2   Delta Impairment in Local Currency  
92 D_IMPMNT_VC FTI_D_IMPMNT_VC TPM_AMOUNT CURR 21   2   Delta Impairment in Valuation Currency  
93 D_REPAYMENT_PC FTI_D_REPAYMENT_PC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Position Currency  
94 D_REPAYMENT_LC FTI_D_REPAYMENT_LC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Local Currency  
95 D_REPAYMENT_VC FTI_D_REPAYMENT_VC TPM_AMOUNT CURR 21   2   Delta: Cumulative Repayment in Valuation Currency  
96 D_AMAQU_VAL_PC FTI_D_AMAQU_VAL_PC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Position Currency  
97 D_AMAQU_VAL_LC FTI_D_AMAQU_VAL_LC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Local Currency  
98 D_AMAQU_VAL_VC FTI_D_AMAQU_VAL_VC TPM_AMOUNT CURR 21   2   Delta Amortized Acquisition Value in Valuation Currency  
99 D_DISAGIO_PC FTI_D_DISAGIO_PC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Position Currency  
100 D_DISAGIO_LC FTI_D_DISAGIO_LC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Local Currency  
101 D_DISAGIO_VC FTI_D_DISAGIO_VC TPM_AMOUNT CURR 21   2   Delta Cleared PD Def./Tax Compensation in Valuation Currency  
102 D_VAL_TI_NPL_PC FTI_D_VAL_TI_NPL_PC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Pos. Crcy  
103 D_VAL_TI_NPL_LC FTI_D_VAL_TI_NPL_LC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Local Crcy  
104 D_VAL_TI_NPL_VC FTI_D_VAL_TI_NPL_VC TPM_AMOUNT CURR 21   2   Delta Security Valuation, Not Affecting P/L, in Val. Crcy  
105 D_VAL_FX_NPL_LC FTI_D_VAL_FX_NPL_LC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation, Not Affecting P/L, in LC  
106 D_VAL_FX_NPL_VC FTI_D_VAL_FX_NPL_VC TPM_AMOUNT CURR 21   2   Delta Foreign Currency Valuation, Not Affecting P/L, in VC  
107 D_VAL_CH_TI_N_PC FTI_D_VAL_CH_TI_NPL_PC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy  
108 D_VAL_CH_TI_N_LC FTI_D_VAL_CH_TI_NPL_LC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy  
109 D_VAL_CH_TI_N_VC FTI_D_VAL_CH_TI_NPL_VC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, Sec., Not Aff. P/L, Valuation Crcy  
110 D_VAL_CH_FX_N_LC FTI_D_VAL_CH_FX_NPL_LC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy  
111 D_VAL_CH_FX_N_VC FTI_D_VAL_CH_FX_NPL_VC TPM_AMOUNT CURR 21   2   Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy  
112 D_VARMAR_PC FTI_D_VARMAR_PC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Position Currency  
113 D_VARMAR_LC FTI_D_VARMAR_LC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Local Currency  
114 D_VARMAR_VC FTI_D_VARMAR_VC TPM_AMOUNT CURR 21   2   Delta Variation Margin in Valuation Currency  
115 D_SPOTVALP_LC FTI_D_SPOTVALP_LC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Purchase Crcy in Local Currency  
116 D_SPOTVALP_VC FTI_D_SPOTVALP_VC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Purchase Crcy in Valuation Currency  
117 D_SPOTVALS_LC FTI_D_SPOTVALS_LC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Sale Currency in Local Currency  
118 D_SPOTVALS_VC FTI_D_SPOTVALS_VC TPM_AMOUNT CURR 21   2   Delta Spot Valuation of Sale Currency in Valuation Currency  
119 D_SWAPACC_PC FTI_D_SWAPACC_PC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Position Currency  
120 D_SWAPACC_LC FTI_D_SWAPACC_LC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Local Currency  
121 D_SWAPACC_VC FTI_D_SWAPACC_VC TPM_AMOUNT CURR 21   2   Delta Swap/Margin Accrual/Deferral in Valuation Currency  
122 D_SWAPVAL_LC FTI_D_SWAPVAL_LC TPM_AMOUNT CURR 21   2   Delta Swap Valuation in Local Currency  
123 D_SWAPVAL_VC FTI_D_SWAPVAL_VC TPM_AMOUNT CURR 21   2   Delta Swap Valuation in Valuation Currency  
124 AMOUNT_PC FTI_D_AMOUNT_PC TPM_AMOUNT CURR 21   2   Flow Amount in Position Currency  
125 AMOUNT_LC FTI_D_AMOUNT_LC TPM_AMOUNT CURR 21   2   Flow Amount in Local Currency  
126 AMOUNT_VC FTI_D_AMOUNT_VC TPM_AMOUNT CURR 21   2   Flow Amount in Valuation Currency  
127 PLAMOUNT_PLC FTI_PLAMOUNT_PLC TPM_AMOUNT CURR 21   2   Profit/loss amount in profit/loss currency  
128 PLAMOUNT_LC FTI_PLAMOUNT_LC TPM_AMOUNT CURR 21   2   Profit/loss amount in local currency  
129 D_CON_GAIN_FX_LC FTI_D_CONS_GAINS_FX_LC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Gains in Local Currency  
130 D_CON_GAIN_FX_VC FTI_D_CONS_GAINS_FX_VC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Gains in Valuation Currency  
131 D_CON_GAIN_TI_LC FTI_D_CONS_GAINS_TI_LC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Local Currency  
132 D_CON_GAIN_TI_PC FTI_D_CONS_GAINS_TI_PC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Position Currency  
133 D_CON_GAIN_TI_VC FTI_D_CONS_GAINS_TI_VC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Gains in Valuation Currency  
134 D_CON_LOSS_FX_LC FTI_D_CONS_LOSSES_FX_LC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Losses in Local Currency  
135 D_CON_LOSS_FX_VC FTI_D_CONS_LOSSES_FX_VC TPM_AMOUNT CURR 21   2   Delta Consolidated FX Losses in Valuation Currency  
136 D_CON_LOSS_TI_LC FTI_D_CONS_LOSSES_TI_LC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Local Currency  
137 D_CON_LOSS_TI_PC FTI_D_CONS_LOSSES_TI_PC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Position Currency  
138 D_CON_LOSS_TI_VC FTI_D_CONS_LOSSES_TI_VC TPM_AMOUNT CURR 21   2   Delta Consolidated Security Losses in Valuation Currency  
139 UPDMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTI_BIW_CFM_DELTA_POSITION MANDT T000 MANDT    
2 FTI_BIW_CFM_DELTA_POSITION PLWHR TCURC WAERS    
3 FTI_BIW_CFM_DELTA_POSITION SBWHR TCURC WAERS    
4 FTI_BIW_CFM_DELTA_POSITION SHWHR TCURC WAERS    
5 FTI_BIW_CFM_DELTA_POSITION SVWHR TCURC WAERS    
6 FTI_BIW_CFM_DELTA_POSITION VALUATION_AREA TRGC_VAL_AREA VALUATION_AREA    
History
Last changed by/on SAP  20130529 
SAP Release Created in 110