TRGT_MIGPS_SEC

Assignment of PS Account Assignments to Securities Positions | #masterdata | Component: Transaction Manager
Column Name Description
MANDT Client
COMPANY_CODE FK Company Code
SECURITY_ID FK Security Class ID Number
SECURITY_ACCOUNT FK Securities Account
ACCOUNT_GROUP FK Securities Account Group
PORTFOLIO FK Portfolio as Differentiation Characteristic
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
FUND Fund BP_GEBER
Master Data Relations Join Conditions
Company Code
  • TRGT_MIGPS_SEC.MANDT == T001.MANDT
  • TRGT_MIGPS_SEC.COMPANY_CODE == T001.BUKRS
Cost Center
  • ?
  • Cost Center
  • ?
  • TRGT_MIGPS_SEC.MANDT == CSKS.MANDT
  • TRGT_MIGPS_SEC.[column in domain "DATBI"] == CSKS.DATBI
  • TRGT_MIGPS_SEC.COST_CENTER == CSKS.KOSTL
  • TRGT_MIGPS_SEC.[column in domain "KOKRS"] == CSKS.KOKRS
Functional Area
  • TRGT_MIGPS_SEC.MANDT == TFKB.MANDT
  • TRGT_MIGPS_SEC.FUNCTIONAL_AREA == TFKB.FKBER
Portfolio as Differentiation Characteristic
  • Company Code
  • Portfolio as Differentiation Characteristic
  • Client
  • TRGT_MIGPS_SEC.COMPANY_CODE == TWPOB.BUKRS
  • TRGT_MIGPS_SEC.PORTFOLIO == TWPOB.RPORTB
  • TRGT_MIGPS_SEC.MANDT == TWPOB.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • TRGT_MIGPS_SEC.MANDT == CEPC.MANDT
  • TRGT_MIGPS_SEC.[column in domain "DATBI"] == CEPC.DATBI
  • TRGT_MIGPS_SEC.[column in domain "KOKRS"] == CEPC.KOKRS
  • TRGT_MIGPS_SEC.PROFIT_CENTER == CEPC.PRCTR
Securities Account
  • Securities Account
  • Company Code
  • TRGT_MIGPS_SEC.MANDT == TWD01.MANDT
  • TRGT_MIGPS_SEC.SECURITY_ACCOUNT == TWD01.RLDEPO
  • TRGT_MIGPS_SEC.COMPANY_CODE == TWD01.BUKRS
Security Class ID Number
  • TRGT_MIGPS_SEC.MANDT == VWPANLA.MANDT
  • TRGT_MIGPS_SEC.SECURITY_ID == VWPANLA.RANL
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client