TRLT_INIT_VAL_SE SAP (Initialization Values for TRL Positions: Securities) Table details

Dictionary Type: Table
Description: Initialization Values for TRL Positions: Securities




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




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

TRLT_INIT_VAL_SE is a standard SAP Table which is used to store Initialization Values for TRL Positions: Securities data and is available within R/3 SAP systems depending on the version and release level.

The TRLT_INIT_VAL_SE table consists of various fields, each holding specific information or linking keys about Initialization Values for TRL Positions: Securities data available in SAP. These include KEY_DATE (System Date), SRC_VAL_AREA (Source Valuation Area for Initializing Another Val. Area), COMPANY_CODE (Company Code), VALUATION_AREA (Valuation Area).. 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 TRLT_INIT_VAL_SE 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 MANDTCLNT3T000MANDT
KEY_DATESystem Date SYDATUMDATS8SYDATS
SRC_VAL_AREASource Valuation Area for Initializing Another Val. Area TPM_SRC_VAL_AREACHAR3Assigned to domainTPM_VAL_AREA
COMPANY_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3TRGC_VAL_AREATPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
VALUATION_CLASSValuation Class TPM_VAL_CLASSNUMC4TRGC_VAL_CLASSTPM_VAL_CLASS
SECURITY_IDSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10TWD01RLDEPODEPACC_CCD_CORE
ACCOUNT_GROUPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10TRGT_SECACCGRPTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
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_CURRCUKY5Assigned to domainWAERS
PURCH_PCPurchase Value in Position Currency TPM_PURCH_PCCURR21(2) TPM_AMOUNT
PURCH_VCPurchase Value in Valuation Currency TPM_PURCH_VCCURR21(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_VCCosts in Valuation Currency TPM_CHARGE_VCCURR21(2) TPM_AMOUNT
CHARGE_IDX_CLEANCosts, Index-Clean, in Position Currency TPM_CHARGE_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_TI_PCSecurity Valuation in Position Currency TPM_VAL_TI_PCCURR21(2) TPM_AMOUNT
VAL_TI_VCSecurity Valuation in Valuation Currency TPM_VAL_TI_VCCURR21(2) TPM_AMOUNT
VAL_TI_IDX_CLEANSecurity Valuation, Index-Clean, in Position Currency TPM_VAL_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_FX_VCForeign Currency Valuation in Valuation Currency TPM_VAL_FX_VCCURR21(2) TPM_AMOUNT
VAL_IDX_PCIndex Valuation in Position Currency TPM_VAL_IDX_PCCURR21(2) TPM_AMOUNT
VAL_IDX_VCIndex Valuation in Valuation Currency TPM_VAL_IDX_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_PCValuation of Cap. Costs, Security, in Position Currency TPM_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_VCValuation of Cap. Costs, Security, in Valuation Currency TPM_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_IDXCLValuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy TPM_VAL_CH_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Valuation Currency TPM_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
VAL_AAV_FX_VCFX Valuation of Amort.Acquisition Value in Valuation Crcy TPM_VAL_AAV_FX_VCCURR21(2) TPM_AMOUNT
IMPAIRMENT_PCImpairment in Position Currency TPM_IMPAIRMENT_PCCURR21(2) TPM_AMOUNT
IMPAIRMENT_VCImpairment in Valuation Currency TPM_IMPAIRMENT_VCCURR21(2) TPM_AMOUNT
IMPAIRMENT_FX_VCFX Impairment in Valuation Currency TPM_IMPAIRMENT_FX_VCCURR21(2) TPM_AMOUNT
IMPMT_IDX_CLEANImpairment in Position Currency Index-Clean TPM_IMPAIRMENT_IDX_CLEANCURR21(2) TPM_AMOUNT
AMORT_PCAmortization in Position Currency TPM_AMORT_PCCURR21(2) TPM_AMOUNT
AMORT_VCAmortization in Valuation Currency TPM_AMORT_VCCURR21(2) TPM_AMOUNT
AMORT_IDX_CLEANAmortization, Index-Clean, in Position Currency TPM_AMORT_IDX_CLEANCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_PCAmortization of Negotiation Spread in Position Currency TPM_AMORT_NEG_SPREAD_PCCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_VCAmortization of Negotiation Spread in Valuation Currency TPM_AMORT_NEG_SPREAD_VCCURR21(2) TPM_AMOUNT
AM_NEG_SPR_IDXCLAmortiz. of Negotiation Spread in Position Crcy Index-Clean TPM_AMORT_NEG_SPREAD_IDX_CLEANCURR21(2) TPM_AMOUNT
DISAGIO_PCDiscount/Premium in Position Currency TPM_DISAGIO_PCCURR21(2) TPM_AMOUNT
DISAGIO_VCDiscount/Premium in Valuation Currency TPM_DISAGIO_VCCURR21(2) TPM_AMOUNT
DISAGIO_IDXCLIndex-Clean Discount/Premium in Position Currency TPM_DISAGIO_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_TI_PC_NPLSecurity Valuation in Position Currency TPM_VAL_TI_PCCURR21(2) TPM_AMOUNT
VAL_TI_VC_NPLSecurity Valuation in Valuation Currency TPM_VAL_TI_VCCURR21(2) TPM_AMOUNT
VAL_IT_IDXCL_NPLSecurity Valuation, Index-Clean, in Position Currency TPM_VAL_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_FX_VC_NPLForeign Currency Valuation in Valuation Currency TPM_VAL_FX_VCCURR21(2) TPM_AMOUNT
VAL_IDX_PC_NPLIndex Valuation in Position Currency TPM_VAL_IDX_PCCURR21(2) TPM_AMOUNT
VAL_IDX_VC_NPLIndex Valuation in Valuation Currency TPM_VAL_IDX_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_PC_NPLValuation of Cap. Costs, Security, in Position Currency TPM_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_VC_NPLValuation of Cap. Costs, Security, in Valuation Currency TPM_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
VAL_CHTIIDXCLNPLValuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy TPM_VAL_CH_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_CH_FX_VC_NPLValuation of Capitalized Costs, FX, in Valuation Currency TPM_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
ACC_INT_PCAccrued Interest in Position Currency TPM_ACC_INTEREST_PCCURR21(2) TPM_AMOUNT
ACC_INT_VCAccrued Interest in Valuation Currency TPM_ACC_INTEREST_VCCURR21(2) TPM_AMOUNT
ACC_INT_IDXCLAccrued Interest in Position Currency Index-Clean TPM_ACC_INTEREST_IDX_CLEANCURR21(2) TPM_AMOUNT
NGSPR_PCNegotiation Spread in Position Currency TPM_NGSPR_PCCURR21(2) TPM_AMOUNT
NGSPR_VCNegotiation Spread in Valuation Currency TPM_NGSPR_VCCURR21(2) TPM_AMOUNT
NGSPR_IDXCLNegotiation Spread Index Clean TPM_NGSPR_IDXCLCURR21(2) TPM_AMOUNT
REPAYMENT_PCCumulative Repayment in Position Currency TPM_REPAYMENT_PCCURR21(2) TPM_AMOUNT
REPAYMENT_VCCumulative Repayment in Valuation Currency TPM_REPAYMENT_VCCURR21(2) TPM_AMOUNT
REPAYMENT_IDXCLCumulative Repayment in Position Currency Index-Clean TPM_REPAYMENT_IDX_CLEANCURR21(2) TPM_AMOUNT
VAD_GAIN_PCValue Adjustment of Gains in Position Currency TPM_VAD_GAIN_PCCURR21(2) TPM_AMOUNT
VAD_GAIN_VCValue Adjustment of Gains in Valuation Currency TPM_VAD_GAIN_VCCURR21(2) TPM_AMOUNT
VAD_LOSS_PCValue Adjustment of Losses in Position Currency TPM_VAD_LOSS_PCCURR21(2) TPM_AMOUNT
VAD_LOSS_VCValue Adjustment of Losses in Valuation Currency TPM_VAD_LOSS_VCCURR21(2) TPM_AMOUNT
ORIG_VAD_PCOriginal Value Adjustment in Position Currency TPM_ORIG_VAD_PCCURR21(2) TPM_AMOUNT
ORIG_VAD_VCOriginal Value Adjustment in Valuation Currency TPM_ORIG_VAD_VCCURR21(2) TPM_AMOUNT
FLG_TRANSStatus of Flow Related to Migration to CFM 1.0 TPM_MIGR_CFM10CHAR1TPM_MIGR_CFM10
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
HAMORT_PCHedge Amortization in Position Currency FTI_HAMORT_PCCURR21(2) TPM_AMOUNT
HAMORT_IDXCL_PCHedge Amortization in Position Crcy, Index-Clean FTI_HAMORT_INDX_PCCURR21(2) TPM_AMOUNT
HAMORT_VCHedge Amortization in Valuation Currency FTI_HAMORT_VCCURR21(2) TPM_AMOUNT
HADJ_PCHedge Adjustment in Position Currency FTI_HADJ_PCCURR21(2) TPM_AMOUNT
HADJ_IDXCL_PCHedge Adjustment in Position Currency, Index-Clean FTI_HADJ_INDX_PCCURR21(2) TPM_AMOUNT
HADJ_VCHedge Adjustment in Valuation Currency FTI_HADJ_VCCURR21(2) TPM_AMOUNT
EFF_PCEffective Amount in Position Currency FTI_EFFECTIVE_PCCURR21(2) TPM_AMOUNT
EFF_VCEffective Amount in Valuation Currency FTI_EFFECTIVE_VCCURR21(2) TPM_AMOUNT
EFF_IDXCL_PCEffective Amount in Position Currency, Index Clean FTI_EFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFF_PCIneffective Amount in Position Currency FTI_INEFFECTIVE_PCCURR21(2) TPM_AMOUNT
INEFF_VCIneffective Amount in Valuation Currency FTI_INEFFECTIVE_VCCURR21(2) TPM_AMOUNT
INEFF_IDXCL_PCIneffective Amount in Position Currency, Index Clean FTI_INEFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
EFFD_PCEffective Amount (Dormant) in Position Currency FTI_EFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
EFFD_VCEffective Amount (Dormant) in Valuation Currency FTI_EFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
EFFD_IDXCL_PCEffective Amount (Dormant) in Position Currency, Index-Clean FTI_EFFECTIVE_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFFD_PCIneffective Amount (Dormant) in Position Currency FTI_INEFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
INEFFD_VCIneffective Amount (Dormant) in Valuation Currency FTI_INEFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
INEFFD_IDXCL_PCIneffective Amount (Dormant) in Position Currency, Index-Cln FTI_INEFF_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT

Key field Non-key field



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

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

SELECT SINGLE *
FROM TRLT_INIT_VAL_SE
INTO CORRESPONDING FIELDS OF WA_TRLT_INIT_VAL_SE
WHERE...

How to access SAP table TRLT_INIT_VAL_SE

Within an ECC or HANA version of SAP you can also view further information about TRLT_INIT_VAL_SE 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!