IDCFM_DATA_SEC - Valuation-Area-Independent Data for Securities

Valuation-Area-Independent Data for Securities information is stored in SAP table IDCFM_DATA_SEC.
 It is part of development package ID-CFM-FR-RF in software component FI-LOC-TRM. This development package consists of objects that can be grouped under "Treasury Localization France: FIFO Reevaluation".

Fields for table IDCFM_DATA_SEC

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6*
KEY_DATEPosition Value DateXTPM_POSITION_DATEDATS16
COMPANY_CODECompany CodeXBUKRSCHAR8*
VALUATION_AREATreasury Valuation AreaXTPM_VAL_AREACHAR6*
COM_VAL_CLASSGeneral Valuation ClassXTPM_COM_VAL_CLASSNUMC8TRGC_COM_VALCL
SECURITY_IDSecurity Class ID NumberXVVRANLWCHAR26*
SECURITY_ACCOUNTSecurities AccountXRLDEPOCHAR20*
PORTFOLIOPortfolioXRPORTBCHAR20*
FUNDFundXFM_FUNDCHAR20*
GRANT_NBRGrantXGM_GRANT_NBRCHAR40
POSNRItem Number Legacy Data TransferXTPM_TRDT_POSNRNUMC16
POSITION_CURRPosition CurrencyTPM_POSITION_CURRCUKY10TCURC
LOCAL_CURRLocal CurrencyTPM_LOCAL_CURRCUKY10TCURC
ACTIVE_PASSIVEIndicator: Assets/Liabilities PositionTPM_ACTIVE_PASSIVECHAR2
UNITSUnitsTPM_UNITSDEC12
NOMINAL_AMTNominal AmountTPM_NOMINAL_AMTCURR11
NOMINAL_ORG_AMTOriginal Nominal Amount in Position CurrencyTPM_NOMINAL_ORG_AMTCURR11
NOMINAL_CURRNominal CurrencyTPM_NOMINAL_CURRCUKY10TCURC
PURCH_PCPurchase Value in Position CurrencyTPM_PURCH_PCCURR11
PURCH_LCPurchase Value in Local CurrencyTPM_PURCH_LCCURR11
PURCH_IDX_CLEANPurchase Value, Index-Clean, in Position CurrencyTPM_PURCH_IDX_CLEANCURR11
CHARGE_PCCosts in Position CurrencyTPM_CHARGE_PCCURR11
CHARGE_LCCosts in Local CurrencyTPM_CHARGE_LCCURR11
CHARGE_IDX_CLEANCosts, Index-Clean, in Position CurrencyTPM_CHARGE_IDX_CLEANCURR11
REPAYMENT_PCCumulative Repayment in Position CurrencyTPM_REPAYMENT_PCCURR11
REPAYMENT_LCCumulative Repayment in Local CurrencyTPM_REPAYMENT_LCCURR11
REPAYMENT_IDX_CLCumulative Repayment in Position Currency Index-CleanTPM_REPAYMENT_IDX_CLEANCURR11
COMP1_PCComponent 1 in Position CurrencyTPM_COMP1_PCCURR11
COMP1_LCComponent 1 in Local CurrencyTPM_COMP1_LCCURR11
COMP1_IDX_CLEANComponent 1 in Position Currency Index CleanTPM_COMP1_IDX_CLEANCURR11
COMP2_PCComponent 2 in Position CurrencyTPM_COMP2_PCCURR11
COMP2_LCComponent 2 in Local CurrencyTPM_COMP2_LCCURR11
COMP2_IDX_CLEANComponent 2 in Position Currency Index CleanTPM_COMP2_IDX_CLEANCURR11
COMP3_PCComponent 3 in Position CurrencyTPM_COMP3_PCCURR11
COMP3_LCComponent 3 in Local CurrencyTPM_COMP3_LCCURR11
COMP3_IDX_CLEANComponent 3 in Position Currency Index CleanTPM_COMP3_IDX_CLEANCURR11
COMP4_PCComponent 4 in Position CurrencyTPM_COMP4_PCCURR11
COMP4_LCComponent 4 in Local CurrencyTPM_COMP4_LCCURR11
COMP4_IDX_CLEANComponent 4 in Position Currency Index CleanTPM_COMP4_IDX_CLEANCURR11
COMP5_PCComponent 5 in Position CurrencyTPM_COMP5_PCCURR11
COMP5_LCComponent 5 in Local CurrencyTPM_COMP5_LCCURR11
COMP5_IDX_CLEANComponent 5 in Position Currency Index CleanTPM_COMP5_IDX_CLEANCURR11
CALCULATION_DATECalculation DateDVALUTDATS16
BUSTRANSIDIdentifier of the Distributor Business TransactionTPM_BUSTRANSIDRAW16
TRANS_FLGFlag: Legacy Data TransferredTPM_TRDT_TRANS_FLGCHAR2
COUPON_SIGNCoupon ID for Interest and Accrued Interest CalculationTPM_COUPON_SIGNCHAR2
ORIGIN_DATEOriginal Position Acquisition DateTPM_ORIGIN_DATEDATS16
Privacy Policy