IDCFM_DATA_SEC SAP (Valuation-Area-Independent Data for Securities) Table details

Dictionary Type: Table
Description: Valuation-Area-Independent Data for Securities




ABAP Code to SELECT data from IDCFM_DATA_SEC
Related tables to IDCFM_DATA_SEC
Access table IDCFM_DATA_SEC




Table field list including key, data, relationships and ABAP select examples

IDCFM_DATA_SEC is a standard SAP Table which is used to store Valuation-Area-Independent Data for Securities data and is available within R/3 SAP systems depending on the version and release level.

The IDCFM_DATA_SEC table consists of various fields, each holding specific information or linking keys about Valuation-Area-Independent Data for Securities data available in SAP. These include KEY_DATE (Position Value Date), COMPANY_CODE (Company Code), VALUATION_AREA (Valuation Area), COM_VAL_CLASS (General Valuation Class).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP IDCFM_DATA_SEC table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
KEY_DATEPosition Value Date TPM_POSITION_DATEDATS8TPM_POSITION_DATE
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
COM_VAL_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
POSNRItem Number Legacy Data Transfer TPM_TRDT_POSNRNUMC8NUMC08
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5TCURCWAERS
LOCAL_CURRLocal Currency TPM_LOCAL_CURRCUKY5TCURCWAERS
ACTIVE_PASSIVEIndicator: Assets/Liabilities Position TPM_ACTIVE_PASSIVECHAR1TPM_ACTIVE_PASSIVE
UNITSUnits TPM_UNITSDEC22(6) TPM_UNITS
NOMINAL_AMTNominal Amount TPM_NOMINAL_AMTCURR21(2) TPM_AMOUNT
NOMINAL_ORG_AMTOriginal Nominal Amount in Position Currency TPM_NOMINAL_ORG_AMTCURR21(2) TPM_AMOUNT
NOMINAL_CURRNominal Currency TPM_NOMINAL_CURRCUKY5TCURCWAERS
PURCH_PCPurchase Value in Position Currency TPM_PURCH_PCCURR21(2) TPM_AMOUNT
PURCH_LCPurchase Value in Local Currency TPM_PURCH_LCCURR21(2) TPM_AMOUNT
PURCH_IDX_CLEANPurchase Value, Index-Clean, in Position Currency TPM_PURCH_IDX_CLEANCURR21(2) TPM_AMOUNT
CHARGE_PCCosts in Position Currency TPM_CHARGE_PCCURR21(2) TPM_AMOUNT
CHARGE_LCCosts in Local Currency TPM_CHARGE_LCCURR21(2) TPM_AMOUNT
CHARGE_IDX_CLEANCosts, Index-Clean, in Position Currency TPM_CHARGE_IDX_CLEANCURR21(2) TPM_AMOUNT
REPAYMENT_PCCumulative Repayment in Position Currency TPM_REPAYMENT_PCCURR21(2) TPM_AMOUNT
REPAYMENT_LCCumulative Repayment in Local Currency TPM_REPAYMENT_LCCURR21(2) TPM_AMOUNT
REPAYMENT_IDX_CLCumulative Repayment in Position Currency Index-Clean TPM_REPAYMENT_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP1_PCComponent 1 in Position Currency TPM_COMP1_PCCURR21(2) TPM_AMOUNT
COMP1_LCComponent 1 in Local Currency TPM_COMP1_LCCURR21(2) TPM_AMOUNT
COMP1_IDX_CLEANComponent 1 in Position Currency Index Clean TPM_COMP1_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP2_PCComponent 2 in Position Currency TPM_COMP2_PCCURR21(2) TPM_AMOUNT
COMP2_LCComponent 2 in Local Currency TPM_COMP2_LCCURR21(2) TPM_AMOUNT
COMP2_IDX_CLEANComponent 2 in Position Currency Index Clean TPM_COMP2_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP3_PCComponent 3 in Position Currency TPM_COMP3_PCCURR21(2) TPM_AMOUNT
COMP3_LCComponent 3 in Local Currency TPM_COMP3_LCCURR21(2) TPM_AMOUNT
COMP3_IDX_CLEANComponent 3 in Position Currency Index Clean TPM_COMP3_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP4_PCComponent 4 in Position Currency TPM_COMP4_PCCURR21(2) TPM_AMOUNT
COMP4_LCComponent 4 in Local Currency TPM_COMP4_LCCURR21(2) TPM_AMOUNT
COMP4_IDX_CLEANComponent 4 in Position Currency Index Clean TPM_COMP4_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP5_PCComponent 5 in Position Currency TPM_COMP5_PCCURR21(2) TPM_AMOUNT
COMP5_LCComponent 5 in Local Currency TPM_COMP5_LCCURR21(2) TPM_AMOUNT
COMP5_IDX_CLEANComponent 5 in Position Currency Index Clean TPM_COMP5_IDX_CLEANCURR21(2) TPM_AMOUNT
CALCULATION_DATECalculation Date DVALUTDATS8DATUM
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
TRANS_FLGFlag: Legacy Data Transferred TPM_TRDT_TRANS_FLGCHAR1CHAR1
COUPON_SIGNCoupon ID for Interest and Accrued Interest Calculation TPM_COUPON_SIGNCHAR1VVSCOUPON
ORIGIN_DATEOriginal Position Acquisition Date TPM_ORIGIN_DATEDATS8TPM_ORIGIN_DATE

Key field Non-key field



How do I retrieve data from SAP table IDCFM_DATA_SEC using ABAP code

The following ABAP code Example will allow you to do a basic selection on IDCFM_DATA_SEC to SELECT all data from the table
DATA: WA_IDCFM_DATA_SEC TYPE IDCFM_DATA_SEC.

SELECT SINGLE *
FROM IDCFM_DATA_SEC
INTO CORRESPONDING FIELDS OF WA_IDCFM_DATA_SEC
WHERE...

How to access SAP table IDCFM_DATA_SEC

Within an ECC or HANA version of SAP you can also view further information about IDCFM_DATA_SEC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!