SAP Back Office Tables
Are you looking for the right table related to SAP Back Office 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 Back Office (FIN-FSCM-TRM-TM-BO) module.
Top 10 tables in Back Office
| Table | Description |
|---|---|
| TRST_RECON_POS | Reconciliation Positions |
| TRSC_RECON_RD | Treasury: Name of External Data Records |
| TRSC_ROUND_RUL_T | Treasury: Rounding Rule Text |
| TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change |
| TRFT_SUBTRANS | Treasury: TRF Business Subtransaction |
| TRST_RECON_RCE | Treasury: External Securities Account Statement |
| TRSC_RECON_PRT | Treasury: Type of External Data Record of the Position |
| TRST_SECACC_PAY | Downport Payment Information for Securities Management |
| TRST_CLASPOS | Treasury: Class position in Securities Account |
| TRFT_SUBTOTAL | Treasury: Table with TRF Transaction Figure |
List of tables in Back Office
| Table | Description |
|---|---|
| TRST_RECON_POS | Reconciliation Positions |
| TRSC_RECON_RD | Treasury: Name of External Data Records |
| TRSC_ROUND_RUL_T | Treasury: Rounding Rule Text |
| TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change |
| TRFT_SUBTRANS | Treasury: TRF Business Subtransaction |
| TRST_RECON_RCE | Treasury: External Securities Account Statement |
| TRSC_RECON_PRT | Treasury: Type of External Data Record of the Position |
| TRST_SECACC_PAY | Downport Payment Information for Securities Management |
| TRST_CLASPOS | Treasury: Class position in Securities Account |
| TRFT_SUBTOTAL | Treasury: Table with TRF Transaction Figure |
| TRSC_DFTYPE_MP | CFM: Update Types for Manual Posting |
| TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account |
| TRST_RECON_TXT | Text for the Editor |
| TRST_POS_CHG | CFM: Securities Account Position Change |
| TRSC_ACCINT | Treasury: Assignment of Update Types for Accrued Interest |
| TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account |
| TRET_SEC_POOL | Additional Pool Data for Security |
| TRLC_PMC_TRADING | Assignment of Pos. Mgmt Procedures for Trading Positions |
| TRFB_CLASS_POS | CFM: Backup Table for TRF Class Position |
| TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. |
| TRFC_RATE_TYPE | Rate Type to Convert Margins |
| TRET_ENDOWMENT | Additional Fund/Grant Data for Endowments |
| TRSC_RECON_STA | Treasury: Status of External Securities Account Statement |
| TRSTC_BUFFER | Activation for Security Cash flow buffering |
| TRSB_NOM_CORR | CFM: Backup Table for Nominal Adjustment |
| TRSC_LEND_TRANS | Update Types for Securities Account Transfer for Sec.Lending |
| TRFC_FUT_ACC_TYP | Activation Of Futures Account Type |
| TRFC_ATTR_S | Attribute Values For Short Attributes |
| TPMT_DEDOC_POS | Derivatives Document: Document Item |
| PINC_PI_TRF | Cust.Table for Generating Position Account-Position Indic. |
| TRRC_CA3 | TR Reporting: Define Revenue Account for Currency Revenues |
| TRFT_CLASS_POS | Treasury: TRF Class Position |
| TRFT_ATTR_DESC | Description Of Free Position Account Attributes |
| TRFC_ATTR_S_T | Texts For Attribute Values For Short Attributes |
| TRST_SEC_ACC_FLD | Field Status for Securities Account Master Data |
| TRFB_SUBTRANS | CFM: Backup Table for TRF Business Subtransaction |
| TRST_SUBTOTAL | Treasury: Table with Trans.Figs - Class Pos. in Sec. Acct |
| TRET_POOL | Additional Pool Data for Fund |
| TRSC_CONDITION | Treasury: Update Types for Condition Type |
| TRFT_ATTR_L | Values for Long attributes |
| TRSC_REF_DISFLO | Treasury: Referenced Update Types (Incoming payment) |
| TRSB_RECON_POS | CFM: Backup Table for Position Reconciliation |
| TRFT_PACC_BANK | Payment Information |
| PINT_STOCKEX | Stock Exchange per Company Code and Class |
| TRFC_MRG_FT | Assign Update Types for Margin Management |
| TRFB_FLOW | CFM: Backup Table with TRF Flows |
| TRFC_ATTR_L_T | Texts For Attribute Values For Long Attributes |
| TRFT_MAN_POST | Manual Posting |
| TRIL_BWGART | OLD!!! Flow types for Hedge Accounting |
| TRRC_CA1 | TR Reporting: Definition of Currency Accounts |
| TRSC_CONDITION_P | Update Types for Condition Type (Passive Positions) |
| TRSTS_FLOWCAT | Treasury: Flow Categories for Securities Account Management |
| TRSC_DFTYPE_NC | CFM: Update Types for Nominal Adjustment |
| TRST_SECACC_BANK | Payment Details for Securities Account |
| TRET_END2POOL | Pools Permitted for Each Endowment |
| PINC_PI_TRL | Customizing Table for Generating Sub-Ledger Position Indic. |
| TPMT_LOT_HEADER | Single Position Master Data for TR Position Management |
| TRFB_SUBTOTAL | CFM: Backup Table with TRF Transaction Figures |
| TRET_TRANSACTION | Transactions to Be Created for Endowments |
| TRFT_ATTR_M | Values for Medium attributes |
| TPMT_DEDOC_HDR | Derivatives Document: Document Header |
| TRSC_SA_TYPE_T | Text for Fund Type |
| TRSC_DFTYPE_IP | CFM: Update Types for Incoming Payments |
| TRFC_DFTYPE_MP | TRF: Update Types for Manual Posting |
| TRFC_ATTR_SUFFIX | Attribute Suffix |
| TRST_CLASFLO | CFM: Class Flows in Securities Account |
| TRSC_DFTYPE_SD | CFM: Update Type for 'Capitalize Dividends' |
| TRSTS_FLOWCAT_T | Treasury: Flow Category Text for Securities Acct Management |
| TRFT_ATTR_S_T | Texts for Short Attribute Values |
| TRFTS_ATTRSUF_T | Texts For Suffixes Of Free Position Account Attributes |
| TRFT_POS_ACCOUNT | Treasury: Futures Account Master Data |
| TRFT_ATTR_SUFFIX | Attribute Suffix |
| TRFC_ATTR_L | Attribute Values For Long Attributes |
| TRET_PROTOCOL | Transactions Generated for Endowments |
| TRSC_SECACCTRANS | Treasury: Update Type for Securities Account Transfer |
| TRFT_ATTR_S | Values for Short attributes |
| TRFC_ATTR_M_T | Texts For Attribute Values For Medium Attributes |
| TRFC_ATTR_DESC | Description Of Free Position Account Attributes |
| TPMT_DEPAL_FLOWS | Listed Futures: Price Gain Records |
| TRSB_SECACCTRANS | CFM: Backup Table for Securities Account Transfer |
| TPMT_DEDOC_LOTPO | Derivatives Document: Document Item Per Lot |
| TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account |
| TRFT_MATCH_TRANS | Treasury: Matching Process Business Transaction |
| TRFC_ATTR_M | Attribute Values For Medium Attributes |
| TRFTS_ATTRSUF | Suffix to Position Account Attribute |
| TRFT_ATTR_M_T | Texts for Medium Attribute Values |
| TPMT_POS_IND_DE | Allocation of Acct Assignment Reference to Position |
| TRFC_PM_FT | Treasury: Assignment of Update Type to Flow Category |
| TRSC_ROUND_RULE | Treasury: Rounding Rule |
| TREC_TRANS_TYPE | Transaction Types for Endowment Investments |
| TRST_NOM_CORR | Treasury: Nominal Adjustment |
| TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows |
| TRRC_CA2 | TR Reporting: Assign Levels for Currency Accts for Balance |
| TRSC_SECACC_TYPE | Securities Account Type |
| TRFT_CALC_POS | Treasury: TRF Calculation Position |
| TRFT_FLOW | Treasury: Table with TRF Flows |
| TRSB_SUBTOTAL | CFM: Backup Table with Transaction Figures |
| TRFT_ATTR_L_T | Texts for Long Attribute Values |
| PINC_PI_TRS | Customizing Table for Generating Security Acct Posit.Indic. |
| TRFT_MAN_PT_FLOW | TRF: Flows for Manual Posting |
| TRSC_DFLOWTYPE | Treasury: Attributes of Update Type for TRS |
| TRST_SECACCTRANS | Treasury: Securities Account Transfer |
| TRFT_BUSTRANS | Treasury: TRF Business Transaction |