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