SAP Financials Basis Tables

Are you looking for the right table related to SAP Financials Basis 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 Financials Basis (FIN-FB) module.

Top 10 tables in Financials Basis

TableDescription
ACCSYS09Cust. of fiscal year variant per legal entity and acc system
FINB_TR_TCATFINB TR: Directory of Transport Objects
FINB_TR_TCATTFINB TR: Text for the Transport Object
UBC_TB_NOTESTable for Notes
UBC_TB_WFMLLast Mail Transmission for each Org
ACCACCTLG01Length of G/L Account Number
UBC_TB_ACTVValues for Account Assignment Fields
FINB_DMT_NRANGEData Retention: Number Range Intervals
ACCACCOUNTEXITCallback exits for G/L account by acc. system configuration
UBC_TB_GUIDGUID for USER, ORG. WI_ID

List of tables in Financials Basis

TableDescription
ACCSYS09Cust. of fiscal year variant per legal entity and acc system
FINB_TR_TCATFINB TR: Directory of Transport Objects
FINB_TR_TCATTFINB TR: Text for the Transport Object
UBC_TB_NOTESTable for Notes
UBC_TB_WFMLLast Mail Transmission for each Org
ACCACCTLG01Length of G/L Account Number
UBC_TB_ACTVValues for Account Assignment Fields
FINB_DMT_NRANGEData Retention: Number Range Intervals
ACCACCOUNTEXITCallback exits for G/L account by acc. system configuration
UBC_TB_GUIDGUID for USER, ORG. WI_ID
ACCENTCONF01Entities: Local Storage of Configuration
ACCCLSSTEP_GRPProcess Definition for Closing Phases
FINB_TR_CCOClient Copy: Object Status
ACCDOCTYPE0TDocument Type
FINB_DMT_TINDEXData Retention: Indexes
ACCCFG0TTexts for Accounting Configuration
ACCLOGOBJCAT01Assignment of Attributes as Chars and Log. Obj. Category
UBC_TT_RPABill Item Types (Texts)
FINB_TR_CCMAdministration Client Copy
FINB_DMT_CONFIGData Retention, Configuration Object of Totals Persistence
UAC_AUDIT_TRAILTable for Audit Trail Function
UBC_TB_RAPermitted Bill Types for each Biller
ACCSYS0CAccounting System
FINB_TR_TCATOFINB TR: Attributes of Obsolete Transport Objects
ACCBUSTRANS0CBusiness Transaction Category
FINB_TR_E071Object List for Client Copy
ACCSYS06Settings for Reference Valuation
FINB_TR_TCATALFINB TR: Transport Properties of the Customizing Objects
ACCDOM02Business Domain <-> InfoObject Catalogs Assignment
ACCCLSSTPPERLEPeriod Lock Setting Depending on Legal Unit
ACCLEGENT0SSID Legal Entity
UBC_TB_STRATStrategies for WF (Sequence of Processors)
ACCLOGOBJCAT0TLogistical Object Categories
ACCACCOUNT11G/L account
ACC_JOURNAL0CJournals in the Acc Document
FINB_TR_TRANSFINB Transport: Cluster Table for Transport
ACCROLE0CApplication Role
FINB_TACSYST_MFNObsolete !!! Valuation Systm: Meta Description - Field Names
ACCAREAIDCOMPArea ID of a Technical Component
UBC_TB_ORGOrganizational Units
ACCDOM0TTexts for Business Domain
UBC_TB_REJRejection Control
ACCASSTYPE0TAccount Assignment Category
FINB_ATTRIBUTESAttributes of Field on Data Basis
FINB_TACCOMMObsolete !!! Accounting Community
ACCCLOSESTEPClosing Phase
ACCACCOUNT0CG/L account
ACCSYS0TName of Accounting System
ACCACCTGROUP0TAccount Group
UBC_CL_BIBatch Input Sessions (INDX-Structure)
ACCSYS05Setting for Currency Translation
ACCTRANTYPE0CTransaction Type
ACCQNTTYPE0CData Elements of Quantity Type
ACCDATACAT0TData Category
FINB_TR_CC02Management of Table Names for Client Copy - Runtime
FOBJ_OBJ_W_POSTFIN Objects with Postings That Have Not Yet Been Processed
FINB_GN_TEXBPDirectory of Executed Blueprints
ACCCLSSTPPERSetting for Period Lock
ACCASSTYPE00Account Assignment Category
ACCCLOSESTEPTIdentifier for Closing Processes
ACCROLE21Application Role Registration: FieldNames and FinObjectTypes
FINB_LG_TCATLanguage Activation: Objects
UBC_TB_ORGDVALAccount Assignment Default Values on Level of Biller
ACCROLE11Application Role Registration: Classes
ACCDBS02Assignment Data Basis - Generated ALV Reference Structure
ACCCLSSTEP_GRPTName of Process Definition for Closing Phases
ACCSYS08Currency IDs per Accounting System
UBC_TB_CETYPCost Event Types
ACC_JOURNAL0TText Table for the Journals in the ACC Document
UBC_TB_BIBatch Input Sessions
ACC_TERMINATIONClasses to be called up when Acc. entities are deleted
FINB_TR_E071KObject List for Client Copy (Key)
ACCLOGOBJCAT0CLogistical Object Categories
UBC_TT_CETYPText for Cost Event Types
ACCCFG01Component in Accounting Configuration
ACCLEGENT0TTexts for Legal Entities
ACCACCOUNT0SSID G/L Account
FINB_TACCOMM_MBObsolete !!! Members of an Accounting Community
UBC_TB_INVHACTAccount Assignments on Bill Header
ACCJOURNAL0CObsolete: Former: Journals in the Accounting Document
ACCSYS02Accounting System: Assignment to Selection Condition
UBC_TB_RADVALAccount Assignment Default Values on Level of Bill Type
ACCCLSSTEP_RULPeriod Rules for the Closing Phases
ACCDBS0CData Basis
UBC_TB_SAPFI0Structure Assignment for Creation of BI Sessions
ACCCHRTACCTS0CChart of Accounts
ACCDOM01FI Global Entities: Business Domain <-> RFC Dest. Assignment
FINB_TACSYST_GRObsolete !!! Valuation System: Description Groups
FINB_DMT_CHARData Retention: Characteristics
FINB_GN_TGOBJCatalog of Generated Objects
ACCSTRU0TStructure ID Texts
ACCLSYS0CLogical System ID
FINB_TR_TAPPLTFINB TR: Application Texts
FINB_TACSYST_DCRObsolete !!! Valuation System: Description in Form of Chars
FINB_TACSYSTTObsolete !!! Valuation System Texts
ACCLEGENT0CLegal Entity
FINB_TR_TXTFINB Transport: General Text Table
FINB_GN_TBPDirectory of Blue Prints
ACCACCTGROUP0CAccount Group
ACCCFG0CAccounting Configuration
FINB_DMT_KEYFData Retention: Key Figures
FINB_TR_DELIVFINB TR: Bill of Material for Delivery
ACCLSYS01Assignment of RFC Destination to Logical System ID
FINB_TR_TAPPLFINB TR: Applications
FINB_TPRFL_QTable for Result Elements (Quantities Only)
ACCROLE0TApplication Role
UBC_TT_RABill Types (Texts)
FINB_TACSYSTObsolete !!! Valuation System
FINB_TIOBC_NMValue Defaults for Info-Object Catalog Names
UBC_TB_USRUser per Organizational Unit
ACCDATACAT0CData Category
FINB_CONF_DISP0CConfiguration: Logical Names for FM Dispatcher
ACCCHRTACCTS0TChart of Accounts
ACCLOGOBJCAT02Activation Status of a Logistical Object Type
FINB_TR_TXT_HFINB TR: Header Table for Generic Texts
ACCSYS04Customizing for Accounting System
ACCSYS07Reference Accounting Systems
UBC_TB_BILBiller for each Organizational Unit
UBC_TB_STRATTStrategy Texts
FINB_LG_TCATTLanguage Activation: Objects
FINB_TPRFL_ATable for Result Elements (Amounts Only)
ACCPERSELTName of Selection Conditions for the Period Lock
ACCACCOUNT0TG/L account
ACCCLSSTEP_ASGNAssignment of Period Rules for the Closing Phases
ACCCOMPUSAGEUse of Technical Components
ACCACCTGROUP00Account Group
FINB_TACINSTTObsolete - to be deleted
ACCTRANTYPE0TTransaction Type
UBC_TB_BILDVALAccount Assignment Default Values on Level of Biller
UBC_TB_INVPBill Item
UBC_TB_CESTYPCost Event Subtypes
ACCPERSEL2Specify Selction Conditions for the Period Lock
ACCMP0TAccounting Component Texts
FINB_TPROFELTable for Result Elements
FINB_TR_CC01Management of Table Names for Client Copy
ACCJOURNAL0TObsolete: Former Text Table for the Journals in the ACC Doc.
FINB_TACINSTObsolete - to be deleted
UBC_TB_ACTAccount Assignment Fields for each Organizational Unit
ACCSEL01Selection Condition: Characteristics
ACCBUSTRANS0TTexts for Business Transaction Types
FINB_TIOBJ_APPLInfo Objects for Potential Characteristics in Val. System
FINB_DEMO_TRANSFINB Transport: Cluster Table for Transport
ACCDOCTYPE0CDocument Type
FINB_GN_TCONFIGConfiguration of the Generator
UBC_TT_ACTTexts for Account Assignment Fields
FINB_TCURTYPTText Table Currrency Type
FINB_TR_DERIVEFINB-Transport: Table for Transporting the ABA Derivation
UBC_TB_STRUSRUser Sequence
FINB_TCURTYPValues for Currency Type
UBC_TB_SAPFIField Assignments for Creating BI Sessions
UBC_TT_ACTVTexts for Values of Account Assignment Fields
ACCDOM0CFI Global Entities: Business Domain
ACCMP0CAccounting Components
UBC_TT_CESTYPTexts for Cost Event Subtypes
UBC_CL_INVBill Data (INDX-Structure)
ACCSEL0CSelection Condition
UBC_TB_CEDATACost Events
FINB_GN_TGOBJTSTime Stamp of the Generated Objects
FINB_TR_TCATAFINB TR: Transport Properties of the Customizing Objects
ACCASSTYPE0CAccount Assignment Category
ACCCURTYPE0TCurrency ID
UBC_TB_CURMax./Min. Amounts per User and Currency
ACCCFG02Role Fixing in Accounting Configuration
ACCTECCMP0TTechnical Component Text
ACCDBS0TData Basis Name
ACCCURTYPE0CCurrency ID
FINB_GN_TMODUSConfiguration of the Generator Mode
FINB_TIOBC_NMTTexts for Value Proposals for Info Object Catalog Names
ACCTECCMP0CTechnical Components
ACCLSYS0TTexts for Logical System IDs
UBC_TB_INVHBill (Header)
FINB_TR_TXT_KFINB TR: Key Table for Generic Texts
ACCPERSELDefine Selection Conditions for the Period Lock
FINB_FIELDSFields on the Data Basis
FINB_TACCOMMTObsolete !!! Accounting Community: Texts
FINB_GN_TEXBP_XEnhancement of the Configuration Key of a Blueprint
ACCMP01Roles per Accounting Component
UBC_TB_RPAPermitted Bill Item Types for each Biller
UBC_TB_CECommunication Data for Transfer to Service Billing
FINB_TAPIOBC_NMValue Defaults for Info-Object Catalog Names per Application
ACCDBS01Data Basis <-> Business Domain Assignment
UBC_TB_RPADVALAccount Assignment Default Values on Level of Bill Item Type
FINB_TR_DESTFINB TR: RFC Destinations for Transport Methods
UBC_TB_INVHMESBill: Messages from Inbound Processing
UBC_TB_INVPACTAccount Assignments on Level of Item
FINB_TR_CCHHeader Table: Tables Generated for Client Copy
ACCSTRU0CStructure IDs