SAP Financials (FIN) Tables

TableDescriptionModule
FINDUEDATEData Storage for Invoice Information for Due DatesFIN
FINORDUE0CFIN Objects for Receivables/PayablesFIN
FINCOMPEL0TComposition ElementFIN
FINGLACCT0CG/L AccountFIN
FINORDPUR0CData Storage for Purchase Order Information - HeaderFIN
FINORDPUR01Data Storage for Purchase Order Information - ItemsFIN
FINNRSOBJ0CTable for Number Range ObjectsFIN
ACCSYSTEM01Settings for Company on Accounting SystemFIN
FINSTLAPP0CApplications for SettlementFIN
FINGLACCT0TTexts for G/L AccountFIN
FINCOMPEL0CComposition ElementFIN
FINSTLAPP0TApplications for Settlement (Text Table)FIN
ACCSYSTEM02Number Range Object for Accounting System and CompanyFIN
ACCSYSTEM03Derivations for Accounting SystemFIN
ACCSYSTEM0CAccounting SystemsFIN
FINXBATCH0CLocal Values for FIN_BATCH (Not Used in Live System)FIN
ACCSYSTEM0TTexts of Accounting SystemsFIN
FINBSNDID0CIdentification for Sender System and Object TypeFIN
FINVALFUNC0CMaster Data for Strategy FunctionsFIN
FINJOURNAL0CJournalsFIN
FINJOURNAL0TTexts for JournalsFIN
FIN_BBE_AMAPField Mapping for BusEnt: Attributes on Value ContainerFIN
FINORDTYPE0COrder CategoryFIN
FINORDTYPE0TTexts for Order CategoriesFIN
FINPAYTYPE0CPayment typeFIN
FINPAYTYPE0TPayment typeFIN
FIN_BBE_FMAPField Mapping for BusEnt: BE on Metadata CarrierFIN
FINPOSTYPE0TTexts of Item CategoriesFIN
FINVALFUNC0TTexts for Strategy FunctionsFIN
FINPOSTYPE0CFS item categoriesFIN
FINDUETYPE0CType of receivable/payableFIN
FINBTATYPE0TBusiness Transaction CategoriesFIN
FINDOCTYPE0CDocument typesFIN
FINDOCTYPE0TTexts of Document TypesFIN
FINDUETYPE0TType of receivable/payableFIN
FINBTATYPE0CBusiness Transaction CategoriesFIN
FINXPRODUCT0CLocal Values for FIN_PRODUCT (Not Used in Live System)FIN
FINVALSTRAT0TTexts for Valuation StrategiesFIN
FINVALSTRAT0CMaster Data for Valuation StrategyFIN
FINVALLEVEL0TTexts for Valuation LevelsFIN
FINVALLEVEL0CValuation LevelsFIN
FINCHOFACCT0TTexts of Document TypesFIN
FINSTLRULES0TDefinition Settlement Rule Sender (Text Table)FIN
FINSTLRULES0CDefinition Settlement Rule SenderFIN
FINSTLRULER0TDefinition Settlement Rule Receiver (Text Table)FIN
FINXCASHLOC0CLocal Values for FIN_CASHLOC (Not Used in Live System)FIN
FINXCASHLOC0TLocal Texts for FIN_CASHLOC (Not Used in Live System)FIN
FINXPRODUCT01Local Values for FIN_PRODUCT (Not Used in Live System)FIN
FINX_FINFO_01Overview of Semantic Model: Mapping to ERP EntitiesFIN
FINXPARTYID0TLocal Texts for FIN_CASHLOC (Not Used in Live System)FIN
FINXPARTYID0CLocal Values for FIN_PARTYID (Not Used in Live System)FIN
FINXCOSTCTR0CLocal Values for FIN_COSTCTR (Not Used in Live System)FIN
FINXCOMPANY0TLocal Texts for FIN_COMPANY (Not Used in Live System)FIN
FINXCOMPANY0CLocal Values for FIN_COMPANY (Not Used in Live System)FIN
FINX_FINFO_02Overview of Semantic Model: Registration in ERP EnvironmentFIN
FINX_FINFO_0COverview of Semantic Model: Field ListFIN
FINSTLRULER0CDefinition Settlement Rule ReceiverFIN
FINCURRTYPE0CCurrency TypeFIN
FINORMNFRECIDPlanned Receivers for Manufacturing OrdersFIN
FINCURRTYPE0TText for Currency TypeFIN
FINFUNCAREA0CFunctional AreaFIN
FINCHOFACCT0CCharts of AccountsFIN
FINFUNCAREA0TTexts of Functional AreasFIN
FINVALMETHOD0TTexts for Valuation Functions for Strategy FormulasFIN
FINXCONDTYPE0CLocal Values for FIN_CONDTYPE (Not Used in Live System)FIN
FINXCONDTYPE0TLocal Texts for FIN_CONDTYPE (Not Used in Live System)FIN
FINXLOCATION0CLocal Values for FIN_LOCATION (Not Used in Live System)FIN
FINXLREPUNIT0CLocal Values for FIN_PROFITCTR (Not Used in Live System)FIN
FINGLTRATYPE0CTransaction Types of General LedgerFIN
FINGLACCTMAP0CAssignment of G/L Accounts: Operational for Local or GroupFIN
FINGLACCTGRP0TTexts of Account GroupsFIN
FINGLACCTGRP0CAccount GroupFIN
FINCOMPELDUE0TComposition Element AP/ARFIN
FINCOMPELDUE0CComposition Element AP/ARFIN
FINCLOSESTEP0CClosing PhasesFIN
FINVALMETHOD0CValuation Functions for Strategy FormulasFIN
FINCLOSESTEP0TClosing PhasesFIN
FINGLTRATYPE0TTexts for Transaction Types of General LedgerFIN
FINPRCTABDERIVAssignment Table for Table Type of PricesFIN
FINPRICELABEL0CMaster Data for Price TypesFIN
FINXPROFITCTR0CLocal Values for FIN_PROFITCTR (Not Used in Live System)FIN
FINXPROFITCTR0TLocal Texts for FIN_PROFITCTR (Not Used in Live System)FIN
FINPVALADJKEY0TAging GroupFIN
FINPVALADJKEY0CValuation Adjustment KeyFIN
FINGLACCTCOMP0CG/L Account on Accounting System/Company LevelFIN
FINPRCVARIANT0TPrice VariantsFIN
FINPRICELABEL0TText Table for Price TypesFIN
FINPRCVARIANT0CPrice VariantsFIN
FINORDITMTYPE0COrder Item CategoryFIN
FINCOMPELCASH0CComposition Element CashFIN
FINORDITMTYPE0TTexts of Order Item CategoriesFIN
FINCOMPELCASH0TComposition Element CashFIN
FINPRICELABEL01Price Type ControlsFIN
FINVALSTRATDERIVDerivation Table: Valuation Strategy for Business TransactioFIN
FINDUEAGINGGRP0CAging GroupFIN
FINDUEAGINGGRP0TAging GroupFIN
Show More SAP FIN Tables

SAP Corporate Governance Tables

TcodeDescriptionModule
FOPCPHFFOPC:: Files for Physical Information ObjectsFIN-CGV
HRP1802DB Table for InfoType 1802FIN-CGV
HRP1800DB Table for InfoType 1800FIN-CGV
HRP1804DB Table for InfoType 1804FIN-CGV
HRP1803DB Table for InfoType 1803FIN-CGV
HRT1823Table Part Infotype 1823FIN-CGV
HRP1810Database Table for Infotype 1810FIN-CGV
HRP1806DB Table for InfoType 1806FIN-CGV
HRP1805DB Table for InfoType 1805FIN-CGV
FOPCSHMSetting for Shared MemoryFIN-CGV

Full List of SAP Corporate Governance Tables


SAP Strategic Enterprise Management Tables

TcodeDescriptionModule
UIOPLinking operator for key word query (SEM-BIC)FIN-SEM
UPBXPlanning Applications: Generic Data ContainerFIN-SEM
UIKWKeyword (SEM-BIC)FIN-SEM
PCLHRStore of Temporary Data from HRFIN-SEM
UIORDResearch Request (SEM Business Information Collection)FIN-SEM
UIDOCResults Document of a Research Run (SEM-BIC)FIN-SEM
UIFREQFrequency of Research Run (SEM-BIC)FIN-SEM
UIAUTHAuthentification Type of a Content ProviderFIN-SEM
UIOP_TText on linking operator (SEM-BIC)FIN-SEM
UIIUSRInfoUser (SEM-BIC)FIN-SEM

Full List of SAP Strategic Enterprise Management Tables


SAP Financial Supply Chain Management Tables

TcodeDescriptionModule
AT11Allocation of Condition Types to Transaction TypesFIN-FSCM
AT03Diary FunctionsFIN-FSCM
AT05Processing CategoriesFIN-FSCM
AT06Allocation of Processing Categories to Activity CategoriesFIN-FSCM
AT07Category of Flows and ConditionsFIN-FSCM
AT02Transaction Activity CategoryFIN-FSCM
AT09Posting categoryFIN-FSCM
AT08Allocation: Application to Category of Flows and ConditionsFIN-FSCM
AT13Allocation of Flow Types to Transaction TypesFIN-FSCM
AT01Transaction CategoryFIN-FSCM

Full List of SAP Financial Supply Chain Management Tables


SAP Business Accounting Tables

TcodeDescriptionModule
URKEYField Catalog: Document KeyFIN-BAC
URBWLRealigner: DataSourcesFIN-BAC
URBWFRealigner Connection to BW Field PropertiesFIN-BAC
URBWLGRealigner: Status Information for DataSourceFIN-BAC
URBWLXUR_BW: Debugging Transaction Data ExtractorFIN-BAC
URKEYFField Catalog: Key FigureFIN-BAC
URBWLYRealigner: Special Settings Read from DataSourceFIN-BAC
URCHARField Catalog: CharacteristicsFIN-BAC
URBWLFRealigner: Fields in the DataSourcesFIN-BAC
URBWTSRealigner: Processed Time IntervalsFIN-BAC

Full List of SAP Business Accounting Tables


SAP Financials Basis Tables

TcodeDescriptionModule
UATSSEKTable Search: Secondary Table AccessFIN-FB
UGX001CDatabase - Check TableFIN-FB
UGXV120Variant: Entity ContextFIN-FB
ACCMP01Roles per Accounting ComponentFIN-FB
UATSKEYTable Search: Entity Table of Individual SearchFIN-FB
UATSADDTable Search: Tables for Additional InformationFIN-FB
UGX001SData Basis - SIDsFIN-FB
UATSOUTTable Search: Tables for Additional InformationFIN-FB
UGMDSIDDummy Table for Generic Foreign Key for F/V SIDFIN-FB
UGX0010Queries of a Data BasisFIN-FB

Full List of SAP Financials Basis Tables