SAP TCodesSAP TablesCDS ViewsSAP AIFSAP ALM
Home
HomeCDS Views
SAP Simple Finance data migration

CDS Views for SAP Simple Finance data migration (FIN-MIG)

CDS View NameDescriptionSQL View Name
BSAD_REC_DDLReconcilation of BSAD DataBSAD_REC
BSAK_REC_DDLReconcilation of BSAK DataBSAK_REC
BSAS_REC_DDLReconcilation of BSAS DataBSAS_REC
BSID_REC_DDLReconcilation of BSID DataBSID_REC
BSIK_REC_DDLReconcilation of BSIK DataBSIK_REC
BSIS_REC_DDLReconcilation of BSIS DataBSIS_REC
FAA_1ST_OPEN_FYAsset Accounting: First open Fiscal YearFAAV_1ST_OPEN_FY
FAA_MIG_ANEPMigrate asset items to ACDOCA and FAAT_DOC_ITFAAV_MIG_ANEP
FAA_MIG_ANEP_MOVCATselect ANEP with MOVCATFAAV_ANEP_MOVCAT
FAA_MIG_ANLCMigrate ANLC to ACDOCA and FAAT_DOC_ITFAAV_MIG_ANLC
FAA_MIG_ANLC_MAXGJMaximum GJAHR in sum to validate BCF sync to GLFAAV_MIG_ANLC_GJ
FAA_MIG_ANLPCDS view to select ANLPV_ANLP_ORI
FAA_MIG_ANLP_AWORGBUILD AWORG on ANLPFAAV_MIG_ANLP_O
FAA_MIG_ANLP_COUNTConter for main areaFAAV_MIG_ANLP_C
FAA_MIG_ANLP_MAINANLP selection posting areas w/o parralel currenciesFAAV_MIG_ANLP_M
FAA_MIG_ANLP_UNIONUNION on main area and parralel currency areasFAAV_MIG_ANLP
FAA_MIG_PREPGet combination of BUKRS/GJAHR for ANLC migrationFAAV_MIG_PREP
FAA_RC1_ANEPParallel areas without leading areaFAAV_RC1_ANEP
FAA_RC1_ANEP1Provides Keys of existing ANEP recordsFAAV_RC1_ANEP1
FAA_RC1_ANEP_06ReadFAAV_RC1_ANEP_06
FAA_RC1_ANLC_BASEccFAAV_RC1_ANLC_B
FAA_RC1_ANLC_SUMccFAAV_RC1_ANLC_S
FAA_RC1_IT_BASEbbFAAV_RC1_IT_BASE
FAA_RC1_IT_SUMvvFAAV_RC1_IT_SUM
FAA_RC1_TT_BASEvvFAAV_RC1_TT_BASE
FAA_RC1_TT_SUMvvFAAV_RC1_TT_SUM
FAA_RC5_ANLC_NBReconciliation ANLC Non Posting Areas (Base View) RC5FAAV_RC5_ANLC_NB
FAA_RC5_ANLC_NSReconciliation ANLC Non Posting Areas (Result Set) RC5FAAV_RC5_ANLC_NS
FAA_REC_ANEA_BASEReconciliation ANEA (base Version)FAAV_REC_ANEA
FAA_REC_ANEA_SUMReconciliation ANEA (Result Set)FAAV_REC_ANEA_S
FAA_REC_ANLC_BASEReconciliation of Asset Accounting TotalsFAAV_REC_ANLC
FAA_REC_ANLC_BRC5Reconciliation ANLCFAAV_REC5_ANLC
FAA_REC_ANLC_RC41Reconciliation ANLC RC4 with RC1 (Result Set)FAAV_REC_ANLC_41
FAA_REC_ANLC_SRC5ddddFAAV_REC5_ANLC_S
FAA_REC_ANLC_SUMReconciliation of ANLC (Result Set)FAAV_REC_ANLC_S
FAA_REC_ANLP1_BASEBasis View ANLC vs ANLPFAAV_REC_ANLP1_B
FAA_REC_ANLP1_SUMRec View for FAAV_REC_ANLP1_BFAAV_REC_ANLP1_S
FAA_REC_ANLP_BASEReconciliation ANLP (Base View)FAAV_REC_ANLP
FAA_REC_ANLP_SUMReconciliation ANLP (Result Set)FAAV_REC_ANLP_S
FAGLBSAS_REC_DDLReconcilation of FAGLBSAS DataFAGLBSAS_REC
FAGLBSIS_REC_DDLReconcilation of FAGLBSIS DataFAGLBSIS_REC
FGL_GLSI_ACDDDL source of the view FGLV_GLSI_ACDFGLV_GLSI_ACD
FGL_GLSI_SRCView across G/L line item tablesFGLV_GLSI_SRC
FGL_GLTT_SRCView across G/L totalsFGLV_GLTT_SRC
FGL_MIG_0GL Delta Entries (Source GLT0)FGLV_MIG_0
FGL_MIG_0_BACKGL Delta Entries - Total without Period Block (Source GLT0)FGLV_MIG_0_BACK
FGL_MIG_0_CORRGL Delta Entries - Correction (Source GLT0)FGLV_MIG_0_CORR
FGL_MIG_0_CURGL Delta Entries - Currency Handling (Source GLT0)FGLV_MIG_0_CUR
FGL_MIG_0_INTGL Delta Entries - Intermediate (Source GLT0)FGLV_MIG_0_INT
FGL_MIG_3GL Delta Entries (Source GLT3)FGLV_MIG_3
FGL_MIG_3_BACKGL Delta Entries - Total without Period Block (Source GLT3)FGLV_MIG_3_BACK
FGL_MIG_3_CORRGL Delta Entries - Correction (Source GLT3)FGLV_MIG_3_CORR
FGL_MIG_3_CURGL Delta Entries - Currency Handling (Source GLT3)FGLV_MIG_3_CUR
FGL_MIG_3_INTGL Delta Entries - Intermediate (Source GLT3)FGLV_MIG_3_INT
FGL_MIG_ACDGL Delta Entries - Lines Items (Customer Fields Mapping)FGLV_MIG_ACD
FGL_MIG_BASEGL Delta Entries - Aggregates of Lines ItemsFGLV_MIG_BASE
FGL_MIG_CURRMapping of Currencies in BSEG to ACDOCA (incl. sign)FGLV_MIG_CURR
FGL_MIG_CURR_BMapping of Currencies in BSEG to ACDOCA (Base View)FGLV_MIG_CURR_B
FGL_MIG_NGL Delta Entries (Source NewGL)FGLV_MIG_N
FGL_MIG_N_BACKGL Delta Entries - Total without Period Block (Source NewGL)FGLV_MIG_N_BACK
FGL_MIG_N_CORRGL Delta Entries - Correction (Source NewGL)FGLV_MIG_N_CORR
FGL_MIG_N_CURGL Delta Entries - Currency Handling (Source NewGL)FGLV_MIG_N_CUR
FGL_MIG_N_INTGL Delta Entries - Intermediate (Source NewGL)FGLV_MIG_N_INT
FGL_MIG_SGL Delta Entries (Source sFIN 1.0)FGLV_MIG_S
FGL_MIG_SKG/L account master dataFGLV_MIG_SK
FGL_MIG_SOURCE_DDetermination of FI-GL Source Table for AggregatesFGLV_MIG_SOURCED
FGL_MIG_SOURCE_SDetermination of Source for FI-GL AggregatesFGLV_MIG_SOURCES
FGL_MIG_S_CORRGL Delta Entries - Correction (sFIN)FGLV_MIG_S_CORR
FGL_MIG_S_CURMigration Delta Entries (sFIN; Currency Handling)FGLV_MIG_S_CUR
FGL_MIG_S_INTMigration Delta Entries (sFIN - Internal)FGLV_MIG_S_INT
FGL_MIG_TTNewGL Aggregates sFIN 1.0FGLV_MIG_TT
FGL_MIG_TT_BASENewGL Aggregates sFIN 1.0 (Base View)FGLV_MIG_TT_BASE
FGL_MIG_TT_DIFNewGL Aggregates sFIN 1.0 (Dif View)FGLV_MIG_TT_DIF
FGL_MIG_TT_INTNewGL Aggregates sFIN 1.0 (Internal View)FGLV_MIG_TT_INT
FGL_MIG_TT_INT2NewGL Aggregates sFIN 1.0 (Internal View 2)FGLV_MIG_TT_INT2
FGL_MIG_TT_PERNewGL Aggregates sFIN 1.0 (per Period)FGLV_MIG_TT_PER
FGL_REC_0_BASEReconciliation GLT0 (Base View)FGLV_REC_0_BASE
FGL_REC_0_BASE_PBrecFGLV_REC_0_BASPB
FGL_REC_0_RBUSAReconciliation GLT0 (with RBUSA)FGLV_REC_0_RBUSA
FGL_REC_0_RBUSA_PBrecFGLV_REC_0_RBUPB
FGL_REC_0_SUMReconciliation GLT0 (without RBUSA)FGLV_REC_0_SUM
FGL_REC_0_SUM_PBrecFGLV_REC_0_SUMPB
FGL_REC_3_BASEReconciliation GLT3 (Base View)FGLV_REC_3_BASE
FGL_REC_3_SUMReconciliation GLT3FGLV_REC_3_SUM
FGL_REC_N_BASEReconciliation Aggregates of NewGL (Base View)FGLV_REC_N_BASE
FGL_REC_N_BASE_PBReconciliation Aggr. of NewGL, period-based (Base View)FGLV_REC_N_BASPB
FGL_REC_N_SUMReconciliation Aggregates of NewGLFGLV_REC_N_SUM
FGL_REC_N_SUM_PBReconciliationFGLV_REC_N_SUMPB
FGL_REC_S_BASEReconciliation Aggregates of sFIN (Base View)FGLV_REC_S_BASE
FGL_REC_S_BASE_PBRecFGLV_REC_S_BASPB
FGL_REC_S_CGLReconciliation Aggregates of sFIN (Classic GL)FGLV_REC_S_CGL
FGL_REC_S_CGL_PBreFGLV_REC_S_CGLPB
FGL_REC_S_SUMReconciliation Aggregates of sFINFGLV_REC_S_SUM
FGL_REC_S_SUM_PBReconciliation Aggregates of New G/L (sFIN 1.0 based)FGLV_REC_S_SUMPB
FGL_T881_MAPPEDT881 with combined curtpsFGLV_T881_MAPPED
FINSVD_F4_MPROJECT_ID_W_STATUSValue Help For Mass Data Project (ProjType 30) With StatusFINSV_F4_MPROJST
FINSVD_F4_MPROJ_ID_W_STAT_TEXTValue Help For Mass Data Project (ProjType 30) With StatusFINSV_F4_MPROSTT
FINS_MIG_DRCRKHelper View: Debit Credit Indicator for MigrationFGLV_MIG_DRCRK
FINS_MP_PACKAGEStatus information for CockpitFINSV_MP_PACKAGE
FINS_MP_PROJECTMass Data Project: Projects (incl. generated)FINSV_MP_PROJECT
FINS_MP_PROJ_STATMass Data Project: Projects (incl. generated)FINSV_MP_PROJ_ST
FINS_MP_RACTMass Data Project: Activities relative to current activityFINSV_MP_RACT
FINS_MP_RUNSMass Data Project: Run-InformationFINSV_MP_RUNS
FINS_MP_RUNS_LASTMass Data Project: Run-InformationFINSV_MP_RUNS_L
FINS_MP_SETSMass Data Activities incl. manualFINSV_MP_SETS
FINS_MP_STATUSStatus information for CockpitFINSV_MP_STATUS
FINS_MP_ST_AGStatus Aggregation for Cockpit - Top ViewFINSV_MP_ST_AG
FINS_MP_ST_AG1Status Aggregation for CockpitFINSV_MP_ST_AG1
FINS_MP_ST_AG2Aggregation view 2 for CockpitFINSV_MP_ST_AG2
FMLV_BCF_L1Material Ledger: Balance Carry Forward - part 1FMLV_BCF_L1
FMLV_BCF_L2Material Ledger: Balance Carry Forward - part 2FMLV_BCF_L2
FMLV_BCF_L3Material Ledger: Balance Carry Forward - part 3FMLV_BCF_L3
FMLV_GJAHRML: Fiscal YearsFMLV_GJAHR
FMLV_MIG_PERIV_MAX_PERIODMaximum period in a year for a fiscal year variantFMLV_PERIV_MAX_P
FMLV_YEARFiscal YearsFMLV_YEAR
FML_ACCNT_DETERMAccount determination for material inventoryFMLV_ACCNT_DET
FML_ACC_DELTAMaterial Ledger: Delta between CKMLHD and FINS_ML_ACCOUNTFMLV_ACC_DELTA
FML_BWKEYMaterial-Ledger: BWKEYsFMLV_BWKEY
FML_CCV_CHECKCheck ML-data regarding currency conversionFMLV_CCV_CHECK
FML_CCV_CHECK_1Check ML-data regarding currency conversionFMLV_CCV_CHECK_1
FML_CURTP_CONDCondense FMLV_CURTP_CELLFMLV_CURTP_COND
FML_INV_BASEMaterial Valuation - Totals of ACDOCA ItemsFMLV_INV_BASE
FML_INV_BCFMaterial Valuation - Inventory Stock: Balance Carry ForwardFMLV_INV_BCF
FML_INV_BCF_OLMaterial Valuation - Inventory Stock: BCF for other LedgersFMLV_INV_BCF_OL
FML_INV_BCF_OL_L1Material Valuation - Inventory Stock: BCF for other LedgersFMLV_INV_BCF_OL1
FML_INV_DELTAMaterial Valuation - Delta EntriesFMLV_INV_DELTA
FML_INV_DELTA_L1Material Valuation - Inventory Stock - Delta EntriesFMLV_INV_DELTA_1
FML_MBEW_PACKMigration: MBEW - PackagesFMLV_MBEWPACK
FML_MIG_ACCDET_CHECKML/MM migration - check config. for account determinationFMLV_MIG_RC1A
FML_MIG_ACCDET_CHECK_L1ML/MM migration - check config. for account determinationFMLV_MIG_RC1A_L1
FML_MIG_ACCDET_CHECK_L2ML/MM migration - check config. for account determinationFMLV_MIG_RC1A_L2
FML_MIG_ACCOUNTML accountsFMLV_ACCOUNT
FML_MIG_ACCOUNT_DML accounts: new records for table FINS_ML_ACCOUNTFMLV_ACCOUNT_D
FML_MIG_ACCOUNT_DUML accounts: FINS_ML_ACCOUNT records to be updatedFMLV_ACCOUNT_DU
FML_MIG_ACCOUNT_L1ML accounts - preparation step 1FMLV_ACCOUNT_L1
FML_MIG_ACCOUNT_L2ML accounts - preparation step 2FMLV_ACCOUNT_L2
FML_MIG_BASEML Delta Entries - Aggregates of Lines ItemsFMLV_MIG_BASE
FML_MIG_BCFMaterial Ledger: Balance Carry ForwardFMLV_BCF
FML_MIG_BCF_OLML-Migration: Balance Carry Forward for other LedgersFMLV_BCF_OL
FML_MIG_BCF_OL_L1ML-Migration: Balance Carryforward for other LedgersFMLV_BCF_OL_L1
FML_MIG_CEPCMaterial Ledger: Profit CentreFMLV_CEPC
FML_MIG_CHECK1Material Ledger: Compare migrated data vs. CKMLCRFMLV_CHECK1
FML_MIG_CHECK1AMaterial Ledger: Compare migrated data vs. CKMLCR - part AFMLV_CHECK1A
FML_MIG_CHECK1BMaterial Ledger: Compare migrated data vs. CKMLCR - part BFMLV_CHECK1B
FML_MIG_CHECK1_L1Material Ledger: Compare migrated data vs. CKMLCR - part 1FMLV_CHECK1_L1
FML_MIG_CHECK1_L2Material Ledger: Compare migrated data vs. CKMLCR - part 2FMLV_CHECK1_L2
FML_MIG_CHECK1_L3Material Ledger: Compare migrated data vs. CKMLCR - part 3FMLV_CHECK1_L3
FML_MIG_CHECK1_L4Material Ledger: Compare migrated data vs. CKMLCR - part 4FMLV_CHECK1_L4
FML_MIG_CHECK1_L5Material Ledger: Compare migrated data vs. CKMLCR - part 5FMLV_CHECK1_L5
FML_MIG_CHECK2Material Ledger: Compare migrated data vs. CKMLPPFMLV_CHECK2
FML_MIG_CHECK2AMaterial Ledger: Compare migrated data vs. CKMLPP - part AFMLV_CHECK2A
FML_MIG_CHECK2BMaterial Ledger: Compare migrated data vs. CKMLPP - part BFMLV_CHECK2B
FML_MIG_CHECK2_L1Material Ledger: Compare migrated data vs. CKMLPP - part 1FMLV_CHECK2_L1
FML_MIG_CHECK2_L2Material Ledger: Compare migrated data vs. CKMLPP - part 2FMLV_CHECK2_L2
FML_MIG_CHECK2_L3Material Ledger: Compare migrated data vs. CKMLPP - part 3FMLV_CHECK2_L3
FML_MIG_CHECK2_L4Material Ledger: Compare migrated data vs. CKMLPP - part 4FMLV_CHECK2_L4
FML_MIG_CHECK2_L5Material Ledger: Compare migrated data vs. CKMLPP - part 5FMLV_CHECK2_L5
FML_MIG_CHECK3BInventory Stock: Compare migrated data vs. MBEW...FMLV_CHECK3B
FML_MIG_CHECK3_L1Inventory Stock: Compare migrated data vs. MBEW... - part 1FMLV_CHECK3_L1
FML_MIG_CHECK3_L2Inventory Stock: Compare migrated data vs. MBEW... - part 2FMLV_CHECK3_L2
FML_MIG_CKMLVMaterial-Migration: Live Date for each Valuation AreaFMLV_MIG_CKMLV
FML_MIG_DELTAMaterial Ledger: Delta EntriesFMLV_MIG_DELTA
FML_MIG_DELTA_DMaterial Ledger: nZDT - Delta entriesFMLV_MIG_DELTA_D
FML_MIG_DELTA_DL1Material Ledger: nZDT - Delta entriesFMLV_MIGDELTA_D1
FML_MIG_DELTA_L1Material Ledger: Delta EntriesFMLV_MIG_DELTA_1
FML_MIG_INVACCInventory stock accountsFMLV_INVACC
FML_MIG_INVACC_L1Inventory stock accounts - preparation step 1FMLV_INVACC_L1
FML_MIG_INVACC_L2Inventory stock accounts - preparation step 2FMLV_INVACC_L2
FML_MIG_INVTOTInventory stock totals transfer to ACDOCAFMLV_INVTOT
FML_MIG_INVTOT_L1Inventory stock totals transfer to ACDOCA - step 1FMLV_INVTOT_L1
FML_MIG_INVTOT_L2Inventory stock totals transfer to ACDOCA - step 2FMLV_INVTOT_L2
FML_MIG_INVTOT_L3Inventory stock totals transfer to ACDOCA - step 3FMLV_INVTOT_L3
FML_MIG_INVTOT_L4Inventory stock totals transfer to ACDOCA - part 4FMLV_INVTOT_L4
FML_MIG_INV_MAX_PERIOInventory Stock: Maximum period per year for each KALNRFMLV_I_MAX_PERIO
FML_MIG_MAX_GJAHRML-Migration: Maximal GJHAR per KALNRFMLV_MAX_GJAHR
FML_MIG_MAX_GJAHR_PERIOML-Migration: Maximum Year and Period per KALNRFMLV_MAX_FISCPER
FML_MIG_MAX_LBKUMMaterial Ledger - maximum stock quantityFMLV_MAX_LBKUM
FML_MIG_MAX_PERIODMaterial Ledger: Maximum period per year for each KALNRFMLV_MAX_PERIO
FML_MIG_PERIODML-PeriodsFMLV_PERIO
FML_MIG_PERIOD_L1ML-Periods - preparation step 1FMLV_PERIO_L1
FML_MIG_PERIOD_L2ML-Periods - preparation step 2FMLV_PERIO_L2
FML_MIG_PERIOD_L3ML-Periods - preparation step 3FMLV_PERIO_L3
FML_MIG_TOTALML-totals transfer to ACDOCAFMLV_TOTAL
FML_MIG_TOTAL_AGGML-totals aggregationFMLV_TOTAL_AGG
FML_MIG_TOTAL_DML-totals transfer to ACDOCA per periodFMLV_TOTAL_D
FML_MIG_TOTAL_DL3ML-totals transfer to ACDOCA per period - step 3FMLV_TOTAL_DL3
FML_MIG_TOTAL_L1ML-totals transfer to ACDOCA - preparation step 1aFMLV_TOTAL_L1
FML_MIG_TOTAL_L2ML-totals transfer to ACDOCA - preparation step 2FMLV_TOTAL_L2
FML_MIG_TOTAL_L3ML-totals transfer to ACDOCA - preparation step 3FMLV_TOTAL_L3
FML_MLMBEW_PACKMigration: ML&MBEW - PackagesFML_MIG_PACK
FML_ML_PACKMigration: Material Ledger PackagesFMLV_MLPACK
FML_P_GAPMaterial Ledger Gap in PeriodsFMLV_P_GAP
FML_P_GAP_BMaterial-Ledger: Gaps in periodsFMLV_P_GAP_B
FML_P_GAP_L1Material Ledger Gap in PeriodsFMLV_P_GAP_L1
FML_P_GAP_L1BMaterial-Ledger: Gaps in periodFMLV_P_GAP_L1B
FML_P_GAP_L2Material Ledger Gap in PeriodsFMLV_P_GAP_L2
FML_P_GAP_L2BMaterial-Ledger: Gaps in periodsFMLV_P_GAP_L2B
FML_P_GAP_L3Material Ledger Gap in PeriodsFMLV_P_GAP_L3
FML_P_GAP_L3BMaterial-Ledger: Gaps in periodsFMLV_P_GAP_L3B
FML_P_GAP_L4Material Ledger Gap in PeriodsFMLV_P_GAP_L4
FML_P_GAP_L4BMaterial-Ledger: Gaps in periodsFMLV_P_GAP_L4B
FML_P_GAP_L5BMaterial-Ledger: Gaps in periodsFMLV_P_GAP_L5B

Other CDS Views

S4HANA Financial Consolidation[Cloud]
S/4HANA Financial Consolidation, Core Processing
Embedded Analytics
Intercompany Reconciliation
Master Data
Validation Engine
Fiori-UI for SAP Collections Management, SAP Credit Managem.
Fiori UI for Cash and Liquidity Management
Advanced Financial Closing - Remote
Financial Supply Chain Management
Direct Bank Communication
SAP Cash Management
Basic Functions
Commodity Derivative Order and Trade Execution
Commodity Derivative Risk Management
Collections Management
Credit Management
Dispute Management
One Exposure
Payment Factory
Treasury and Risk Management
Credit Risk Analyzer
Market Risk Analyzer
Transaction Manager
SAP Simple Finance data migration
Data migration for Asset Accounting
Data migration for Controlling
Data migration for Material Ledger
Real-Time Consolidation
User and Authorization Management
Fiori UI for Predictive Accounting
Results Recording
Order Printing
Situation handling across applications, generic
Product Compliance
Legal Content Management - Generic Functions
Common Functionality for Defense and Security
Localization Logistics
Analytics and Reporting.
Site MapContact UsPrivacy Policy