TRLS_PL_SECURITIES SAP (Profit and Loss for Securities) Structure details

Dictionary Type: Structure
Description: Profit and Loss for Securities




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




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

TRLS_PL_SECURITIES is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Profit and Loss for Securities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TRLS_PL_SECURITIES TYPE TRLS_PL_SECURITIES.

The TRLS_PL_SECURITIES table consists of various fields, each holding specific information or linking keys about Profit and Loss for Securities data available in SAP. These include BUSTRANSID_PL (Identifier of the Distributor Business Transaction), POSITION_DATE (Treasury Ledger Date), NOMINAL_AMT (Nominal Amount), NOMINAL_ORG_AMT (Original Nominal Amount in Position Currency).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TRLS_PL_SECURITIES structure 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
BUSTRANSID_SALEIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
BUSTRANSID_PLIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
POSITION_DATETreasury Ledger Date TPM_TRLDATEDATS8DATUM
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
UNITSUnits TPM_UNITSDEC22(6) TPM_UNITS
AQU_VAL_PCAcquisition Value in Position Currency TPM_AQU_VAL_PCCURR21(2) TPM_AMOUNT
AQU_VAL_VCAcquisition Value in Valuation Currency TPM_AQU_VAL_VCCURR21(2) TPM_AMOUNT
SETTL_AMT_PCSettlement Amount in Position Currency TPM_SETTL_AMT_PCCURR21(2) TPM_AMOUNT
SETTL_AMT_VCSettlement Amount in Valuation Currency TPM_SETTL_AMT_VCCURR21(2) TPM_AMOUNT
PL_AMT_PCPrice Gain/Loss in Position Currency TPM_PL_AMT_PCCURR21(2) TPM_AMOUNT
PL_AMT_VCPrice Gain/Loss in Valuation Currency TPM_PL_AMT_VCCURR21(2) TPM_AMOUNT
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
DIFF_VALUES 0
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3TPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
COM_VAL_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TPM_COM_VAL_CLASSCVC
VALUATION_CLASSValuation Class TPM_VAL_CLASSNUMC4TPM_VAL_CLASS
ACCOUNTING_CODEAccounting Code TPM_ACC_CODECHAR4TPM_ACC_CODETPM_TACTRG_ACC_CODE
COMPANY_CODECompany Code BUKRSCHAR4BUKRSBUKC_T001
PRODUCT_TYPEProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10RLDEPODEPACC_CCD_CORE
SECURITY_IDSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
PORTFOLIOPortfolio as Differentiation Characteristic TPM_PORTFOLIO_DIFFCHAR10RPORTB
TRADERTrader RDEALERCHAR12RDEALER
ACCOUNT_GROUPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10TPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
LOANS_CONTRACTContract Number RANLCHAR13ALPHARANLRAN
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10TPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
FLAG_LONG_SHORTIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
DEAL_NUMBERFinancial Transaction TB_RFHACHAR13ALPHAT_RFHAFANVTBA
FUNDFund FM_FUNDCHAR10BP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
EXTERNAL_ACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
DIFF_CURRENCYCurrency as Differentiation Term TPM_DIFF_CURRENCYCUKY5WAERSTPM_DIFF_CURR

Key field Non-key field



How do I retrieve data from SAP structure TRLS_PL_SECURITIES using ABAP code?

As TRLS_PL_SECURITIES is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRLS_PL_SECURITIES as there is no data to select.

How to access SAP table TRLS_PL_SECURITIES

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