TRET_SEC_POOL - Additional Pool Data for Security

Additional Pool Data for Security information is stored in SAP table TRET_SEC_POOL.
It is part of development package FTR_ENDOWMENT in software component FIN-FSCM-TRM-TM-BO. This development package consists of objects that can be grouped under "PS /TRM-TM Integration: Endowments (Grants, Donations)".

Fields for table TRET_SEC_POOL

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6*
SECURITY_IDInvestment Pool ID NumberXTPM_POOL_IDCHAR26VWPANLA
COMPANY_CODECompany CodeXBUKRSCHAR8T001
FUNDFundFM_FUNDCHAR20*
GRANT_NBRGrantGM_GRANT_NBRCHAR40
PARTNERBusiness Partner for Investment PoolTPM_POOL_PARTNERCHAR20BUT000
SEC_ACC_ISSUELiability Securities AccountTPM_SEC_ACC_PASSIVECHAR20TWD01
COMVALCL_ISSUEGeneral Valuation ClassTPM_COM_VAL_CLASSNUMC8TRGC_COM_VALCL
SEC_ACC_INVESTAsset Securities AccountTPM_SEC_ACC_ACTIVECHAR20TWD01
DECIMALSNumber of Decimals for Number of UnitsTPM_DECIMALSNUMC2
FLG_POOL_ISSUECreate Issue Transactions for Investment PoolTPM_FLG_POOL_ISSUECHAR2
CREATE_NAMEEntered ByRERFCHAR24
CREATE_DATEFirst Entered OnDERFDATS16
CREATE_TIMETime of CreationTERFTIMS12
CHANGE_NAMEEmployee IDRBEARCHAR24
CHANGE_DATELast Edited OnDBEARDATS16
CHANGE_TIMELast Edited AtTBEARTIMS12
Privacy Policy