P_IntApportnmntAggrgtns

PSM Interest Apprtmt Query Aggregation | view: PINTAPPRTMTAGGR | Extraction: Not supported | Component: Fund Accounting
Column Name Description
CompanyCode FK Company Code
Fund FK Fund
GrantID Grant
ProfitCenter FK Profit Center
Segment FK Segment for Segmental Reporting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TotalBalance null
BalanceDay0 Amount in Company Code Currency
BalanceDay1 Amount in Company Code Currency
BalanceDay2 Amount in Company Code Currency
BalanceDay3 Amount in Company Code Currency
BalanceDay4 Amount in Company Code Currency
BalanceDay5 Amount in Company Code Currency
BalanceDay6 Amount in Company Code Currency
BalanceDay7 Amount in Company Code Currency
BalanceDay8 Amount in Company Code Currency
BalanceDay9 Amount in Company Code Currency
BalanceDay10 Amount in Company Code Currency
BalanceDay11 Amount in Company Code Currency
BalanceDay12 Amount in Company Code Currency
BalanceDay13 Amount in Company Code Currency
BalanceDay14 Amount in Company Code Currency
BalanceDay15 Amount in Company Code Currency
BalanceDay16 Amount in Company Code Currency
BalanceDay17 Amount in Company Code Currency
BalanceDay18 Amount in Company Code Currency
BalanceDay19 Amount in Company Code Currency
BalanceDay20 Amount in Company Code Currency
BalanceDay21 Amount in Company Code Currency
BalanceDay22 Amount in Company Code Currency
BalanceDay23 Amount in Company Code Currency
BalanceDay24 Amount in Company Code Currency
BalanceDay25 Amount in Company Code Currency
BalanceDay26 Amount in Company Code Currency
BalanceDay27 Amount in Company Code Currency
BalanceDay28 Amount in Company Code Currency
BalanceDay29 Amount in Company Code Currency
BalanceDay30 Amount in Company Code Currency
BalanceDay31 Amount in Company Code Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
NumberOfDays null
LastDay Number of Days in Year or Month INT4
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_INTAPPORTNMNTAGGRGTNS.COMPANYCODE == T001.BUKRS
  • P_INTAPPORTNMNTAGGRGTNS.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_INTAPPORTNMNTAGGRGTNS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_INTAPPORTNMNTAGGRGTNS.MANDT == TCURC.MANDT
Fund
  • ?
  • Fund
  • Client
  • P_INTAPPORTNMNTAGGRGTNS.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_INTAPPORTNMNTAGGRGTNS.FUND == FMFINCODE.FINCODE
  • P_INTAPPORTNMNTAGGRGTNS.MANDT == FMFINCODE.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_INTAPPORTNMNTAGGRGTNS.[column in domain "DATBI"] == CEPC.DATBI
  • P_INTAPPORTNMNTAGGRGTNS.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_INTAPPORTNMNTAGGRGTNS.PROFITCENTER == CEPC.PRCTR
  • P_INTAPPORTNMNTAGGRGTNS.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_INTAPPORTNMNTAGGRGTNS.SEGMENT == FAGL_SEGM.SEGMENT
  • P_INTAPPORTNMNTAGGRGTNS.MANDT == FAGL_SEGM.MANDT