SAP SAP Simple Finance data migration Tables

Are you looking for the right table related to SAP SAP Simple Finance data migration 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 SAP Simple Finance data migration (FIN-MIG) module.

Top 10 tables in SAP Simple Finance data migration

TableDescription
FINS_MASSF_STEPConfiguration for a Step of a Mass Data Activity
FGL_MIG_BCFsFIN-Migration: Balance Carry Forward
FGLT_GLTAB_SRCsFIN Migration: G/L source tables
FINSTS_MIG_DRCRKHelper Table: Debit Crdit Indicator
FGL_MIG_SOURCEsFIN-Migration: Source Ledger Definition
FINS_MIG_PERIODSMigration: Periods
FINSC_MIG_CURRCurrency Settings for Migration
FINSTF_MIG_CCODESD-FT Company Code Mapping to TRM Company Code
FINSTF_MIG_DOCSD-FT Presented Document Mapping with TRM TF Document Types
FINSTF_MIG_BKBPSD-FT Bank Mapping with TRM

List of tables in SAP Simple Finance data migration

TableDescription
FINS_MASSF_STEPConfiguration for a Step of a Mass Data Activity
FGL_MIG_BCFsFIN-Migration: Balance Carry Forward
FGLT_GLTAB_SRCsFIN Migration: G/L source tables
FINSTS_MIG_DRCRKHelper Table: Debit Crdit Indicator
FGL_MIG_SOURCEsFIN-Migration: Source Ledger Definition
FINS_MIG_PERIODSMigration: Periods
FINSC_MIG_CURRCurrency Settings for Migration
FINSTF_MIG_CCODESD-FT Company Code Mapping to TRM Company Code
FINSTF_MIG_DOCSD-FT Presented Document Mapping with TRM TF Document Types
FINSTF_MIG_BKBPSD-FT Bank Mapping with TRM
FINST_RECERR_CTReconciliation error GL (customer tables)
FGL_SFIN_NGLM_PPsFIN - New G/L Migration: Parameters for parallel processes
FINST_RECERR_ACDReconciliation error ACDOCA
FINSTF_MIG_STSTrade Finance: Migration completed
FINST_RECERR_FIReconciliation error AP/AR/GL
FINS_MIG_ANLPNear Zero Downtime Migration: Keys of Changed ANLP w/o AWREF
FINST_RECERR_CTGReconciliation generic error GL (customer tables)
FINS_ACCEPT_TOKMass Data Monitor: Imported Transport requests for Messages
FINS_MASSH_SETMass Data Framework: History for Activity Configuration
FINSTF_MIG_BANKBank Function Setting for Advising Bank
FINS_DUMMY4Dummy table for record duplication
FGL_MIG_CGLT_PPCust. table conversion: Parameters for parallel processes
FINS_MASSF_SET_TMass Data Framework: Texts for Activity
FINS_MPROJ_STATMass Data Project: Status Table
FINS_MIG_RUNsFIN migration run
FINS_MPROJ_MAP_MMass Data Project: Mapping table for messages
FINS_MPROJ_MAN_TMass Data Project: Texts for Manual Activity
FINS_MPROJ_ACTMass Data Project: Actions
FINS_MIG_ANLCNear Zero Downtime Migration: Keys of changed assets
BSIM_BCKSecondary Index, Documents for Material
FINS_MIG_CUSTDefine Offsetting Account Determination
FINS_MIG_ANEKNear Zero Downtime Migration: Keys of changed ANEK entries
FINS_MASSF_SETMass Data Framework: Configuration for Activity
FINS_MIG_COEPNear Zero Downtime Migration: Keys of changed COEP entries
FINS_MASSF_STP_TMass Data Framework: Texts for Step
FINSTF_MIG_FDSD-FT Financial Document Type Mapping with TRM Product Type
FINS_MPROJECTTMass Data Project: Projects
FINS_ACCEPT_TRAMass Data Monitor: Shadow Table for FINS_ACCEPT_MSG
FINS_MIG_ACTVTYMigration activities
FINS_MPROJ_MSTATMass Data Project: Status of Manual Activity
FINS_MPROJ_TYPMass Data Project: Possible Types
FINS_MPROJ_ENQMass Data Project: Enqueue Project
FINS_MIG_BSEGNear Zero Downtime Migration: Keys of changed BSEG entries
FINS_MASS_LOGMass Data Framework: Low Level Log
FINS_MPROJ_TYPETMass Data Project: Project Types (Text)
FIN_CORR_PACKAGEConversion to S/4HANA: Packages (ECC)
FINS_MIG_PERIONear Zero Downtime Migration: Fiscal Periods with new data
FINS_MPROJ_JOBMass Data Project: Jobs
FINS_ACCEPT_MSGMass Data Monitor: Decisions about reconciliation findings
FINSTF_MIG_NEEDset migration Needs
FINS_MASS_CTRL_CNumber of jobs for activities in the mass data framework
FINS_ML_INVACCInventory Stocks Account
FINS_MPROJ_GENMass Data Project: Generated Projects
FINS_ML_ACCOUNTMaterial Ledger: Header Record
FINS_MIG_RUN_PACHistory: Runid with OBT Package ID
FINS_MASSPACKAGEWork Package Administration for sFIN Mass Data
FINS_MPROJECTMass Data Project: Projects
FINST_RECERR_GENReconciliation error (generic)
FGL_SFIN_MIGsFIN: Migration of General Settings (Obsolete)
FINS_MPROJ_SETMass Data Project: Assignment of set IDs to Project Types
FINS_MASS_CTRLControl info for mass data framework
FINS_CURTP_MAPMapping of Currency Type + Valuation to mixed Currency Type
FINS_MIG_COCODEParticipating Company Code(s) for company code specific scen
FIN_CORR_ISSUEConversion to S/4HANA: Reconciliation Issues (ECC)
FINS_MPROJ_NOTIFMass Data Project: Settings for Notifications
FINS_MIG_STATUSOverall sFIN migration status
FINS_MIG_RUN_ACTsFIN migration run: activity specific settings
FINS_MPROJ_RUNIDMass Data Project: Association of Runs to Iterations
FINS_MIG_SKA1Near Zero Downtime Migration: Changed SKA1/CSKA entries
FINS_MPROJ_MANMass Data Project: Assignment of Man. Act. to Project Types
FINS_MPROJ_MSORGMass Data Project: Status of Manual Activity on Org Unit
FINS_MPROJ_TRACCMass Data Project: Trigger-Table on ACDOCA
FINS_MIG_COCODEHHistory: Participating company codes
FINS_UT_TRIGGERDummy table for Unit Test
FINS_MPROJ_ITERMass Data Project: Control Table for Iterations
FINS_MPROJ_MSGMass Data Project: Messages
FINS_MPROJ_SELMass Data Project: Selection Criteria