SAP Portfolio Analyzer Tables
Are you looking for the right table related to SAP Portfolio Analyzer Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Portfolio Analyzer (FIN-FSCM-TRM-PA) module.
Top 10 tables in Portfolio Analyzer
| Table | Description |
|---|---|
| BMA_BM | OLD CFM Benchmarking: BM Central Master Data |
| BMA_BMT | OLD CFM Benchmarking: BM Central Master Data |
| PFAIM_MDATMANU | Master Data: Pos. Managed Externally and Entered Manually |
| RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA |
| BMA_CHT | OLD CFM Benchmarking: Characteristics (TEXTS) |
| RDBPA_REC_FLW | Key Figure Values FLW: Single Record Items with Currency |
| RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency |
| AFWKFPA_FLW | Key Figures: Flow in Transaction Currency |
| AFW_RORT_T | Rate of Return Types Text Table |
| AFWKF_YLDSNCCC_H | Key Figures: Yield from Evaluation Currency Since CALCSINCE |
List of tables in Portfolio Analyzer
| Table | Description |
|---|---|
| BMA_BM | OLD CFM Benchmarking: BM Central Master Data |
| BMA_BMT | OLD CFM Benchmarking: BM Central Master Data |
| PFAIM_MDATMANU | Master Data: Pos. Managed Externally and Entered Manually |
| RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA |
| BMA_CHT | OLD CFM Benchmarking: Characteristics (TEXTS) |
| RDBPA_REC_FLW | Key Figure Values FLW: Single Record Items with Currency |
| RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency |
| AFWKFPA_FLW | Key Figures: Flow in Transaction Currency |
| AFW_RORT_T | Rate of Return Types Text Table |
| AFWKF_YLDSNCCC_H | Key Figures: Yield from Evaluation Currency Since CALCSINCE |
| BMA_CHVAL | OLD CFM Benchmarking: Characteristic Values |
| RDBPA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-PA |
| AFWKF_YLDSNC_H | Key Figures: Yield from Transaction Currency Since CALCSINCE |
| RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency |
| BMA_BMLAYERDET | OLD CFM Benchmarking: Benchmark Layer |
| AFWKFPA_SORTINO | Key Figures: Sortino Ratio |
| AFWKFPA_FLWCC | Key Figures: Flow in Evaluation Currency |
| AFWKF_SHARPE_H | Key Figures: Sharpe Ratio |
| AFWKFPA_YLDMTH | Key Figures: Yield Calculation Methods |
| AFWKF_TREYNOR_H | Key Figures: Treynor's Ratio |
| AFWKFPA_YLDCC | Key Figures: Yield Calculated from Evaluation Currency |
| AFWKF_SORTINO_H | Key Figures: Sortino Ratio |
| BMA_BMBM | OLD CFM Benchmarking: Benchmark Relationships |
| AFWKFPA_YLDSNCCC | Key Figures: Yield from Evaluation Currency Since CALCSINCE |
| AFWKFPA_YLDSNC | Key Figures: Yield from Transaction Currency Since CALCSINCE |
| BMA_GUIDIDX | OLD <<Boundary>> CFM-BM: Assignment of BMGUID Index |
| AFWKF_FLW_H | Key Figures: Flow in Transaction Currency |
| RDBPA_REC_CCYPOS | Generic Single Record Items with Currency |
| AFWKFPA_POSCC | Key Figures: Position in Evaluation Currency |
| PFAIM_CF_FTMATCH | Assignment Cash flow type to PA flowtype |
| BMA_BMLAYER | OLD CFM Benchmarking: Benchmark Layer |
| AFWKF_PRDFLWCC_H | Key Figures: Flow for Period in Evaluation Currency |
| AFWKFPA_PRDFLWCC | Key Figures: Flow for Period in Evaluation Currency |
| PFA_FLOWTYPEST | TRM-PA Flow Types: Text Table |
| RDBPA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-PA |
| RDBPA_NSUM_GEN_R | Final Results for Ratio BM Key Figures: TRM-PA |
| RDBPA_NSUM_GEN | Final Results for Non-Additive Generic Key Figures: TRM-PA |
| BMA_BMM | OLD CFM Benchmarking: Master Data for Market Benchmark |
| AFWKFPA_VAL | Valuation Rules that Deviate from the Evaluation Type |
| AFWKF_POS_H | Key Figures: Position in Position Currency |
| AFWKF_YLD_H | Key Figures: Yield Calculated from Transaction Currency |
| AFWKFPA_INFO | Key Figures: Information Ratio |
| AFWKFPA_POS | Key Figures: Position in Position Currency |
| AFWKF_JENSEN_H | Key Figures: Jensen's Alpha |
| AFWKFPA_SHARPE | Key Figures: Sharpe Ratio |
| AFWKFPA_JENSEN | Key Figures: Jensen's Alpha |
| PFA_FLOWTYPES | TRM-PA Flow Types |
| AFWKFPA_TREYNOR | Key Figures: Treynor's Ratio |
| AFWKF_INFO_H | Key Figures: Information Ratio |
| AFWKFPA_PRDFLW | Key Figures: Flow for Period in Transaction Currency |
| PFAIM_UMATCH_TRL | Assignment of Flow Types to PA Flow Types |
| BMA_GUIDRANL | OLD <<Boundary>> CFM-BM: Assignment of BMGUID-WPKN |
| PFA_DINTERVALS | TRM-PA: Time Intervals for Period-Based Key Figures |
| AFW_RORT_POSCOMP | Key Figure Types |
| AFWKFPA_YLDMTHT | Key Figures: Yield Calculation Methods - Text Table |
| BMA_CHVALT | OLD CFM Benchmarking: Characateristic Values (TEXTS) |
| AFWKF_PRDFLW_H | Key Figures: Flow for Period in Transaction Currency |
| RDBPA_REC_HEADER | Single Record Header |
| AFWKF_POSCC_H | Key Figures: Position in Evaluation Currency |
| BMA_CH | OLD CFM Benchmarking: Characteristics |
| AFWKFPA_YLD | Key Figures: Yield Calculated from Transaction Currency |
| AFWKF_FLWCC_H | Key Figures: Flow in Evaluation Currency |
| AFWKF_YLDCC_H | Key Figures: Yield Calculated from Evaluation Currency |
| PFAIM_FTYPEMATCH | Assignment of Flow Types to PA Flow Types |
| PFAIM_TR_UTMATCH | Assignment of Update Type to Flow Types in PA |
| BMA_BMLAYERT | OLD CFM Benchmarking: Benchmark Layer (TEXTS) |