TRET_SEC_POOL

Additional Pool Data for Security | #masterdata | Component: Back Office
Column Name Description
MANDT Client
SECURITY_ID FK Investment Pool ID Number
COMPANY_CODE FK Company Code
Column Name Description
Column Name Description
Column Name Description
CREATE_DATE First Entered On
CREATE_TIME Time of Creation
CHANGE_DATE Last Edited On
CHANGE_TIME Last Edited At
Column Name Description
FLG_POOL_ISSUE Create Issue Transactions for Investment Pool Show values
Column Name Description Domain name
FUND Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
DECIMALS Number of Decimals for Number of Units NUMC01
CREATE_NAME Entered By SYCHAR12
CHANGE_NAME Employee ID SYCHAR12
Master Data Relations Join Conditions
Company Code
  • TRET_SEC_POOL.MANDT == T001.MANDT
  • TRET_SEC_POOL.COMPANY_CODE == T001.BUKRS
General Valuation Class
  • General Valuation Class
  • Client
Business Partner for Investment Pool
  • Business Partner for Investment Pool
  • Client
  • TRET_SEC_POOL.PARTNER == BUT000.PARTNER
  • TRET_SEC_POOL.MANDT == BUT000.CLIENT
Investment Pool ID Number
  • TRET_SEC_POOL.MANDT == VWPANLA.MANDT
  • TRET_SEC_POOL.SECURITY_ID == VWPANLA.RANL
Asset Securities Account
  • Asset Securities Account
  • Company Code
  • TRET_SEC_POOL.MANDT == TWD01.MANDT
  • TRET_SEC_POOL.SEC_ACC_INVEST == TWD01.RLDEPO
  • TRET_SEC_POOL.COMPANY_CODE == TWD01.BUKRS
Liability Securities Account
  • Liability Securities Account
  • Company Code
  • TRET_SEC_POOL.MANDT == TWD01.MANDT
  • TRET_SEC_POOL.SEC_ACC_ISSUE == TWD01.RLDEPO
  • TRET_SEC_POOL.COMPANY_CODE == TWD01.BUKRS