AFWCH_STR_SP_N

Sample Customizing | #masterdata | Component: Analyzer
Column Name Description
MANDT FK Client
OBJNR FK Object Number for Financial Transactions
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WYQ05S Contract Type Show values
Column Name Description Domain name
RPORTB Portfolio RPORTB
WYQ30S Financial Transaction Type T_SFHAART
Master Data Relations | to Other Relations ↓ Join Conditions
Client AFWCH_STR_SP_N.MANDT == T000.MANDT
ID Number
  • AFWCH_STR_SP_N.MANDT == VWPANLA.MANDT
  • AFWCH_STR_SP_N.WYQ03S == VWPANLA.RANL
Securities Account
  • Securities Account
  • ?
  • AFWCH_STR_SP_N.MANDT == TWD01.MANDT
  • AFWCH_STR_SP_N.WYQ04S == TWD01.RLDEPO
  • AFWCH_STR_SP_N.[column in domain "BUKRS"] == TWD01.BUKRS
Product Category AFWCH_STR_SP_N.WYQ06S == TZAF.SANLF
Product Type
  • Product Type
  • Client
  • AFWCH_STR_SP_N.WYQ07S == TZPA.GSART
  • AFWCH_STR_SP_N.MANDT == TZPA.MANDT
Position Currency
  • AFWCH_STR_SP_N.MANDT == TCURC.MANDT
  • AFWCH_STR_SP_N.WYQ08S == TCURC.WAERS
Currency of Borrowing/Sale
  • AFWCH_STR_SP_N.MANDT == TCURC.MANDT
  • AFWCH_STR_SP_N.WYQ09S == TCURC.WAERS
Currency of Investment/Purchase
  • AFWCH_STR_SP_N.MANDT == TCURC.MANDT
  • AFWCH_STR_SP_N.WYQ10S == TCURC.WAERS
Country
  • Country/Region Key
  • Client
  • AFWCH_STR_SP_N.WYQ14S == T005.LAND1
  • AFWCH_STR_SP_N.MANDT == T005.MANDT
Rating
  • AFWCH_STR_SP_N.MANDT == TP06.MANDT
  • AFWCH_STR_SP_N.WYQ15S == TP06.RATING
Futures Account
  • Futures Account for Listed Options and Futures
  • Client
  • ?
Industry System
  • Industry System
  • Client
  • AFWCH_STR_SP_N.WYQ18S == TB038.ISTYPE
  • AFWCH_STR_SP_N.MANDT == TB038.CLIENT
Industry Sector
  • Industry System
  • Industry
  • Client
  • AFWCH_STR_SP_N.WYQ18S == TB038A.ISTYPE
  • AFWCH_STR_SP_N.WYQ19S == TB038A.IND_SECTOR
  • AFWCH_STR_SP_N.MANDT == TB038A.CLIENT
Valuation Class
  • Treasury Valuation Area
  • Valuation Class
General Valuation Class
  • General Valuation Class
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Trader
  • ?
  • Trader
  • Client
  • AFWCH_STR_SP_N.[column in domain "BUKRS"] == TZDEA.BUKRS
  • AFWCH_STR_SP_N.WYQ11S == TZDEA.RDEALER
  • AFWCH_STR_SP_N.MANDT == TZDEA.MANDT
Treasury Valuation Area
Securities Account Group
  • ?
  • Securities Account Group
  • Client