SAP Revenue Accounting Tables
Are you looking for the right table related to SAP Revenue Accounting 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 Revenue Accounting (FI-RA) module.
Top 10 tables in Revenue Accounting
| Table | Description |
|---|---|
| FARR_C_FX2_EXPL | Switch on Posting Optimization Customizing table |
| FARR_D_KEYPP_ENQ | Table is used only by ENQUEUE-Object EFKK_KEYPP |
| FARR_D_TCO_PAR | Test Cockpit: eCATT Import Parameters (for ECATT_EXECUTE) |
| FARR_D_RAIC54 | RAI Class Configuration Version (Table FARR_C_RAI54) |
| FARR_D_RAIW51C | Working Version Configuration RAI Class (FARR_C_RAI51C) |
| FARR_D_RAIC01T | RAI Class Configuration Version (Table FARR_C_RAI01T) |
| FARR_D_RAI_HIST | History Table for Revenue Accounting Item Exemptions |
| FARR_D_MANL_CHNG | Manual Changes |
| FARR_D_FULFILLMT | Fulfillments |
| FARR_D_RAIC51C | Configuration Version RAI Class (FARR_C_RAI51C) |
List of tables in Revenue Accounting
| Table | Description |
|---|---|
| FARR_C_FX2_EXPL | Switch on Posting Optimization Customizing table |
| FARR_D_KEYPP_ENQ | Table is used only by ENQUEUE-Object EFKK_KEYPP |
| FARR_D_TCO_PAR | Test Cockpit: eCATT Import Parameters (for ECATT_EXECUTE) |
| FARR_D_RAIC54 | RAI Class Configuration Version (Table FARR_C_RAI54) |
| FARR_D_RAIW51C | Working Version Configuration RAI Class (FARR_C_RAI51C) |
| FARR_D_RAIC01T | RAI Class Configuration Version (Table FARR_C_RAI01T) |
| FARR_D_RAI_HIST | History Table for Revenue Accounting Item Exemptions |
| FARR_D_MANL_CHNG | Manual Changes |
| FARR_D_FULFILLMT | Fulfillments |
| FARR_D_RAIC51C | Configuration Version RAI Class (FARR_C_RAI51C) |
| FARR_D_RAIW01T | Revenue Accounting Item Classes (Texts) |
| FARR_C_DET_CTR_H | Revenue Accounting: Derive Contract header |
| FARR_C_ACCNT_DET | Account Determination Rules |
| BPL_BREAKPOINT_A | List of all activ Breakpoints for BPL for Debuging |
| FARR_C_CT_RSN | Change Type Reason Code |
| FARR_C_RAI01T | Revenue Accounting Item Classes (Texts) |
| FARR_D_COLOGHDR | Header entries of DB changes |
| FARR_D_CONS | RA - consistency check / contract data |
| FARR_D_COST_MI | Processed Cost RAIs - Main Items |
| FARR_C_MIG_RA11 | Status of migration from RA1.0 to RA1.1 |
| FARR_D_COLOGITM | Logs of Item DB changes |
| FARR_D_POSTING | Postings |
| FARR_D_LEGACY | Legacy data for initial load of revenue accounting items |
| FARR_D_MAPPING_F | Mapping table for Fulfillment |
| FARR_C_DET_R_ACC | Revenue Accounting: Derive RAI GL Account |
| FARRLOREPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| FARR_C_BRF_STRCT | Maintain BRFplus Function Structure |
| FARR_ATTAHLOREPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| FARR_C_RAI01E | Upload Rule for Revenue Accounting Item Classes |
| FARR_D_RAIC52 | Configuration Version RAI Class (FARR_C_RAI52) |
| FARR_D_PP_LOCK | Revenue Accounting: Locked RAIs per Mass Run |
| FARR_D_RAI_GENOB | Generated Objects for a Revenue Accounting Item Class |
| FARR_D_COMP | Compound groups of Contract items |
| FARR_D_DPP_SORTC | DPP EoP: Information on Customer Retention |
| FARR_D_INV_FX_ED | Distributed invoice & exchange rate difference |
| FARR_D_RAIW54T | RAI Class Working Version (Table FARR_C_RAI54T) |
| FARR_D_DEFERRAL | Deferrals |
| FARR_ATTAHLOIO | SDOK: Logical information object instances |
| FARR_D_FX2_EXPL | Data for revenue exchange rate explanation |
| FARRLORIPR | SDOK: Logical information object attribute values |
| BPL_BREAKPOINT_L | List of all Breakpoints for BPL for Debuging |
| FARR_D_RAI_DELH | History Table for Deletion of Exempted Items |
| FARR_D_POB_FRZ | Freeze Periods of Performance Obligations |
| FARR_C_BUKRS | Exclude currency key from company code |
| FARR_C_CONTCAT_T | Text Table of Contract Category |
| FARR_D_MAPPING_M | Mapping of manual POBs between Accounting Principles |
| FARRPHHRPR | SDOK: Attributes of Target Anchor Relationships |
| FARR_D_CHECK_IC | Transparent Table for the Data Consistency Check Selection |
| FARR_D_RAIG01 | RAI Class Generation Version (Table FARR_C_RAI01) |
| FARR_D_CHG_MIG | Change Type Migration Table |
| FARR_D_RAIC54T | RAI Class Configuration Version (Table FARR_C_RAI54T) |
| FARRPHHR | SDOK: Use of target anchors in physical objects |
| FARR_D_INV_CO | Processed Invoice RAIs - Condition Items |
| FARR_D_COLOGTEC | Technical Table |
| FARR_D_FLFMT_MI | Processed Fulfillment RAIs - Main Items |
| FARR_ATTAHPHHR | SDOK: Use of target anchors in physical objects |
| FARR_D_COOBJNR | CO object number table for Migration |
| FARR_D_CONTRACT | Contracts |
| FARR_ATTAHLORIPR | SDOK: Logical information object attribute values |
| FARR_C_DET_POB | Revenue Accounting: Derive POB attributes |
| FARR_D_RAI_GENH | Generation Info for a Revenue Accounting Item Class (Hist) |
| FARRLOIO | SDOK: Logical information object instances |
| FARR_C_CODE_SWIT | Code switch between old code lines and new code lines |
| FARR_C_RAI05RES | Residence Time of exempted Revenue Accounting Items |
| FARR_C_BRF_APPL | Assign BRFplus to Revenue Accounting Item Classes |
| FARRCHKF | SDOK: Outgoing hyperlinks from physical objects |
| FARR_D_JOB | Accrual Run In Background Job |
| FARR_C_RAI51A | Interface Components: Structures |
| FARR_C_RAI05ET | Exception Reasons for Revenue Accounting Items (Texts) |
| FARR_D_COLOGFLD | Changed Fields of RAR, Database Changes |
| FARR_D_RAIG51C | Generation Version RAI Class (FARR_C_RAI51C) |
| FARR_D_DELDEFITM | Deletion update for Deferral Item(memorized for BI) |
| FARR_D_RAIW52 | Working Version Configuration RAI Class (FARR_C_RAI52) |
| FARR_L_RECKEY_BK | Recon key backup table for migration from RA 1.0 to RA1.1 |
| FARR_D_TRANCODET | Text table of FARR_D_TRANCODE |
| FARR_D_RAIG54T | RAI Class Generation Version (Table FARR_C_RAI54T) |
| FARR_D_COMP_HEAD | Header of Result table about comparative report |
| FARR_C_RAI05E | Exemption Reasons for Revenue Accounting Items |
| FARR_C_COND_MODE | Define Condition Type for SSP and RoR |
| FARR_C_HC_MSG_C | Revenue Accounting: relevant msg for Health Check - RAI proc |
| FARR_C_HC_MSG | Revenue Accounting: relevant msg for Health Check - RAI proc |
| FARR_L_RK_MIG_RE | Reconciliation key migration result from RA1.0 to RA1.1 |
| FARR_C_BAL_EXP | Revenue Accounting: Configuration of BAL expiration date |
| FARR_C_RAI05RT | Restoration Reasons for Revenue Accounting Items |
| FARR_D_RAI2_ERR | RAI2 Processing Inconsistencies |
| FARR_C_BAL_EXP_C | Revenue Accounting: Configuration of BAL expiration date |
| FARR_C_DET_SSP | Revenue Accounting: Derive Standalone Selling Price |
| FARR_C_COND_SIGN | Price Condition Types which Allow Change of Sign |
| FARR_C_CONTCAT | Customizing of Contract Category |
| FARRPHF | SDOK: Physical information object incoming relationships |
| FARR_C_DET_R_AA | Revenue Accounting: Derive RAI Account Assignment |
| FARR_C_BRF_CONF | BRF+ Rule Configuration |
| FARR_ATTAHPHNM | SDOK: Outgoing Links of Physical Information Objects |
| FARR_D_CHG_TYPE | Table of Change Type |
| FARR_D_RAI_GEN | Generation Info for Revenue Accounting Item Class |
| FARR_C_MIGPACK | Revenue Accounting: Migration Packages |
| FARR_D_TRANS_REC | Transition record data |
| FARR_D_RAIG01T | RAI Class Generation Version (Table FARR_C_RAI01T) |
| FARR_D_RECKEY_S | Reconciliation Keys (Shadow Table) |
| FARR_D_POB_HIS | History of POB/Contract Structure Changes |
| FARR_C_POB_TYPE | Configuration of Performance Obligation Types |
| FARR_ATTAHPHRE | SDOK: Status Table for Indexing Documents |
| FARR_ATTAHPHHRPR | SDOK: Attributes of Target Anchor Relationships |
| FARR_D_RAIG54 | RAI Class Generation Version (Table FARR_C_RAI54) |
| FARR_D_RECON_ERR | History table for reconcilition between logistics and RA |
| FARR_L_STATIS | Table for PPF: Migration to V1.1 - Set POB status |
| FARR_ATTAHPHREPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FARR_C_CLOSE | Revenue Accounting Period Close |
| FARR_C_EVNT_TY_T | Text Table of Event Type |
| FARR_C_ACCTPRINC | Revenue Accounting: Configuration of Accounting Principle |
| FARR_D_TRANCODE | Transaction code of RAR |
| FARR_D_RAIW54 | RAI Class Working Version (Table FARR_C_RAI54) |
| FARR_C_MIGPACK_T | Revenue Accounting: Description of Migration Packages |
| FARR_D_SHIFT_HIS | Error contract shift history |
| FARRPHIO | SDOK: Physical information object instances |
| FARR_C_POB_TYP_T | POB type text table |
| FARR_D_CHECK_SEL | Data Consistency Check Selection Date Management |
| FARRLOIOT | SDOK: Incoming Relationships of Logical Information Objects |
| FARRLORE | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FARR_C_RAI05R | Restoration Reasons for Revenue Accounting Items |
| FARR_D_MAPPING | Mapping Table to map source document to POBs of RA-Contracts |
| FARR_C_CT_RSN_T | Change Type Reason Code Text |
| FARRPHNM | SDOK: Outgoing Links of Physical Information Objects |
| FARR_C_RAI01 | Revenue Accounting Item Classes |
| FARR_D_TCO_RES | Test Cockpit: eCATT export parameter (=eCATT results) |
| FARR_D_CONT_ERR | Log Messages of Contract Errors |
| FARR_D_RECON_KEY | Reconciliation Keys |
| FARRPHRE | SDOK: Status Table for Indexing Documents |
| FARRPHRIPR | SDOK: Attributes of Hyperlink Relationships |
| FARR_C_POST_OPTI | Switch on Posting Optimization Customizing table |
| FARR_D_TCO | Test Cockpit: eCATT Status |
| IRACONTRWP_D | I_RACONTRWITHPOSTEDBALANCETP I_RACONTRWITHPOSTEDBALANCETP |
| FARR_D_PRODDEL | Productive Cleanup: Deletion Log for Order Item Header IDs |
| FARR_D_LEGACYC | Legacy data for initial load of conditions for rev.acc.it. |
| FARR_ATTAHLORI | SDOK: Outgoing Relationships of Logical Information Objects |
| FARR_C_BRFUI_RDT | List of Related Decision Tables in BRFplus UI |
| FARR_ATTAHPHPR | SDOK: Checkout data for physical information object |
| FARR_C_COND_TYPE | Condition Types Excluded From Price Allocation |
| FARR_C_INB_BRF | Assign BRFplus application to revenue accounting item source |
| FARR_C_ARCH_REST | Residence Time for Archiving Objects |
| FARR_D_CHECK_STA | Data Consistency Check Selection Run Status |
| FARR_C_EVNT_TY | Customizing of Event Type |
| FARR_D_BIZ_RECON | Business Reconciliation Table |
| FARR_C_ACCT_PARA | Revenue accounting parameters |
| FARR_ATTAHPHRI | SDOK: File name of last checkout |
| FARR_D_INVOICE | Invoice Entries |
| FARR_D_COMP_TRAN | Result table of comparative report |
| FARR_ATTAHPHIO | SDOK: Physical information object instances |
| FARR_C_RAI51 | Interface Components for Revenue Accounting Item Classes |
| FARR_D_UPDLOG_CS | Log Table containing Call Stack (new DB update logic) |
| FARR_C_ADAPT_ACT | DEPRECATED Revenue Accounting Adaptor Function Activation |
| FARR_D_RAIG54F | RAI Class Generation Version (Table FARR_C_RAI54F) |
| FARR_C_EEW_REP | Transfer Selected Fields to FI-CO |
| FARR_D_POB | Performance Obligations |
| FARR_C_ACPR_BUKR | Revenue Accounting: Supported Company Codes per Acct. Princ. |
| RACONFLICTCONT_D | I_RACONFLICTEDCONTRWORKLISTTP I_RACONFLICTEDCONTRWORKLISTTP |
| FARR_D_RAI_LOG | Log of Data Storage of RAIC Items |
| FARR_D_RAIW54F | RAI Class Working Version (Table FARR_C_RAI54F) |
| FARR_PPRUNSEL | Revenue Accounting: Selection Parameters of a Mass Run |
| FARR_PPRUNSPOOL | Revenue Accounting: Mass Run Spool IDs |
| FARR_C_RAI51B | Interface Components: Prerequisite Components |
| FARR_C_SRCTY | Source Document Types for Revenue Accounting Items |
| FARR_D_COST_CO | Processed Cost RAIs - Condition Items |
| FARR_C_RAI51R | RAI: Interface Basic Components |
| FARR_D_PP_UNITS | Unit Related Parameters for Parallel Processing |
| FARR_ATTAHPHRIPR | SDOK: Attributes of Hyperlink Relationships |
| FARR_C_REFTY | Reference Types for Revenue Accounting Items |
| FARR_C_RW_RSN_T | Text table of review reason |
| FARR_C_COND_ROLE | Condition Type Role |
| FARR_C_UICHRSN_T | Change Reason for Revenue Accounting Engine(Text) |
| FARR_ATTAHPHF | SDOK: Physical information object incoming relationships |
| FARR_C_COND_RL_T | Define text for Condition Type Role |
| FARRPHREPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FARR_C_TCO_PRCT | Test Cockpit Process labels |
| IRAPOBWAMT_D | I_RACONTRWITHPOSTEDBALANCETP I_RAPERFOBLGNWTHTOCURPERDAMTTP |
| FARR_D_RAIW01 | Revenue Accounting Item Classes (Working Versions) |
| FARR_D_INB_MI | Postponed RAIs - Main Items |
| FARR_D_RAI2_PROC | Acct. principles RAI2 was successfully processed for |
| FARR_C_CONFLI_EX | Set default value for ΓÇÿUpdate ModeΓÇÖ of POB attributes |
| FARR_D_FREEZ_IDX | Freeze Period Index Table for AIF Bulk Handling |
| FARR_D_ATTACH | SDOK: Table for document contents (import/export) |
| FARRPHPR | SDOK: Checkout data for physical information object |
| FARR_D_PP_PACK | Package-Related Parameters for Parallel Processing |
| FARR_ATTAHLORE | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FARR_ATTAHIDXSTA | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FARR_D_PAOBJMAP | Profitability segment hashing |
| FARR_D_DPP_SORTP | DPP EoP: Information on Bus. Partner Retention |
| FARR_C_BRFUI_DT | List of Relevant Decision Tables in BRFplus UI |
| FARR_ATTAHPHNMPR | SDOK: Attributes of Physical Information Objects |
| RAMNLFLFMTTP_D | I_RAMANUALFULFILLMENTTP I_RAMANUALFULFILLMENTTP |
| FARR_D_MAPPING_I | Mapping table for Invoices |
| FARR_C_SHFT_RS_T | text table for shift reason |
| FARRPHNMPR | SDOK: Attributes of Physical Information Objects |
| FARR_D_OBJKEYS | Data Consistency Check Object Keys (New) |
| FARRIDXSTA | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FARR_D_RECON_HIS | History table for reconcilition between logistics and RA |
| FARR_D_RAIC54F | RAI Class Configuration Version (Table FARR_C_RAI54F) |
| RAAGGRGDFLFMT_D | I_RAMANUALFULFILLMENTTP I_RAPERFOBLGNAGGRGDFLFMTTP |
| FARR_D_ORD_MI | Processed Order RAIs - Main Items |
| FARR_C_UI_CHRSN | Change Reason for Revenue Accounting Engine |
| FARR_D_INV_MI | Processed Invoice RAIs - Main Items |
| RACONFLICTATTR_D | I_RACONFLICTEDCONTRWORKLISTTP I_RACONFLICTEDATTRIBWORKLISTTP |
| FARR_C_RSV_COND | Reserved Condition Types |
| FARR_D_INB_COPA | Postponed RAIs - COPA data |
| FARR_D_RAIC01 | RAI Class Configuration Version (Table FARR_C_RAI01) |
| FARR_C_SRCCO_LS | Sender Components - Logical Systems Assigned |
| FARRCHKO | SDOK: Files of Physical Information Objects |
| FARR_D_FRZ_C_IDX | Freeze Period by Contract Index Table for AIF Bulk Handling |
| FARR_D_INB_CO | Postponed RAIs - Condition Items |
| FARR_C_SETTL_ACT | Define Posting Specification for General Ledger Transfer |
| FARRPHRI | SDOK: File name of last checkout |
| FARR_C_RAI54 | Indexes of Tables of Revenue Accounting Items |
| FARR_ATTAHCHKO | SDOK: Files of Physical Information Objects |
| FARR_D_RAIG52 | Generation Version RAI Class (FARR_C_RAI52) |
| FARR_ATTAHCHKF | SDOK: Outgoing hyperlinks from physical objects |
| FARR_D_LEGACYSF | legacy data for scheduled fulfillments (time based) |
| FARRLOPR | SDOK: Logical information object descriptions |
| FARR_S_BRF_STRCT | Maintains the BRF+ structure used in funtcions (OBSOLETE) |
| FARR_D_ACCRRUN | Accrual run table |
| FARRLORI | SDOK: Outgoing Relationships of Logical Information Objects |
| FARR_C_RAI52 | Fields of a Revenue Accounting Item Class |
| FARR_PPRUNLOG | Revenue Accounting: Mass Run Application Logs |
| FARR_C_RAI54F | Fields of Indexes of Tables of Revenue Accounting Item |
| FARR_D_DEFITEM | Deferral Items |
| FARR_ATTAHLOPR | SDOK: Logical information object descriptions |
| FARR_C_RAIC_SAP | Revenue accounting item class names used by SAP |
| FARR_C_RAI51C | Active Interface Components for Revenue Accounting Item Clas |
| FARR_C_RAI51K | RAI: Structures for Key Definition |
| FARR_D_ORD_CO | Processed Order RAIs - Condition Items |
| FARR_C_SRCCO_T | Source Document Components for Revenue Accounting Items Text |
| FARR_D_NOTES | Table for Farr Notes |
| FARR_C_TCO_SCN | Test Cockpit Scenario |
| FARR_C_RAI51T | Names of Interface Components |
| FARR_PPRUN | Revenue Accounting: Mass Run Logs |
| FARR_C_RAI54T | Texts of Indexes for RAI Tables |
| FARR_C_REFTY_T | Reference Types for Revenue Accounting Items- Text |
| FARR_D_OBJKEYS_E | Data Consistency Check Object Keys with Errors |
| FARR_D_POB_CTYPE | Performance Obligation Change Type |
| FARR_D_MNL_CHG | Manual Changes of Performance Obligations |
| FARR_D_PP_LOCKED | OBSOLETE |
| FARR_D_ITEM_PROC | Inbound Processing: Item proc. status for AccountPrinciple |
| FARR_C_RW_REASON | Review reason configuration table |
| FARR_C_TCO_PRC | Test Cockpit Processes |
| FARR_C_SHFT_RSON | Reasons for Shifting Contracts to Next Period |
| FARR_C_SRCTY_T | Source Document Types for Revenue Accounting Items- Text |
| FARR_D_RVS_RUNID | Run ID reverse history |
| FARR_C_RAI51E | Interface Components: SAP Program Enhancements |
| FARR_C_TCO_TCO | Test Cockpits |
| FARR_C_TCO_SCNT | Test Cockpit Scenarios |
| FARR_C_RAI52E | Changeable Fields of a Revenue Accounting Item Class |
| FARR_C_SRCCO | Sender Components for Revenue Accounting Items |
| FARR_D_RAI_CH | Change Sequence of Changed Items |
| FARR_C_SRCCO_TY | Sender Components - Source Document Types Assigned |
| FARR_D_POB_CORRT | Correct Performance Obligations before Contract turns to Err |
| FARR_D_POSTING_S | Postings (Shadow Table) |
| FARR_D_UPDLOG | Log Table containing log reason for new DB update logic |
| FARR_D_EV_CONTR | Events that Occured for Contracts |
| FARR_C_TCO_TCOT | Test Cockpit labels |
| FARR_ATTAHLOIOT | SDOK: Incoming Relationships of Logical Information Objects |
| FARR_PPRUNSPEC | 'Internal control' parameters of PPF |