SAP Financials (FIN) Tables

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

SAP Corporate Governance Tables

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

Full List of SAP Corporate Governance Tables


SAP Strategic Enterprise Management Tables

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

Full List of SAP Strategic Enterprise Management Tables


SAP Financial Supply Chain Management Tables

TcodeDescriptionModule
AT06Allocation of Processing Categories to Activity CategoriesFIN-FSCM
AT09Posting categoryFIN-FSCM
AT13Allocation of Flow Types to Transaction TypesFIN-FSCM
AT07Category of Flows and ConditionsFIN-FSCM
AT03Diary FunctionsFIN-FSCM
AT01Transaction CategoryFIN-FSCM
AT02Transaction Activity CategoryFIN-FSCM
AT08Allocation: Application to Category of Flows and ConditionsFIN-FSCM
AT11Allocation of Condition Types to Transaction TypesFIN-FSCM
AT05Processing CategoriesFIN-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
URBWTSRealigner: Processed Time IntervalsFIN-BAC
URBWLFRealigner: Fields in the DataSourcesFIN-BAC
URCHARField Catalog: CharacteristicsFIN-BAC
URBWLTRealigner: DataSource TextsFIN-BAC
URKEYFField Catalog: Key FigureFIN-BAC
URBWLYRealigner: Special Settings Read from DataSourceFIN-BAC
URBWLXUR_BW: Debugging Transaction Data ExtractorFIN-BAC

Full List of SAP Business Accounting Tables


SAP Financials Basis Tables

TcodeDescriptionModule
UGMDSIDDummy Table for Generic Foreign Key for F/V SIDFIN-FB
ACCMP0CAccounting ComponentsFIN-FB
ACCMP0TAccounting Component TextsFIN-FB
UATSSEKTable Search: Secondary Table AccessFIN-FB
UATSADDTable Search: Tables for Additional InformationFIN-FB
UGX001SData Basis - SIDsFIN-FB
UATSKEYTable Search: Entity Table of Individual SearchFIN-FB
UATSOUTTable Search: Tables for Additional InformationFIN-FB
ACCMP01Roles per Accounting ComponentFIN-FB
UGXV120Variant: Entity ContextFIN-FB

Full List of SAP Financials Basis Tables