SAP S/4 HANA新变化-FI数据模型
http://mp.weixin.qq.com/s?__biz=MzAwMjgyMTA4MQ==&mid=2652153162&idx=1&sn=aee6fc43e0577479854e4842df919c90&chksm=81249bfcb65312ea90f6cc10be3036f32a0d4c7d60882ee39f9fc384b952dbae38edf6f034c6&mpshare=1&scene=5&srcid=1209zSzuADEkam4FdjFWUaAt#rd
With the installation of SAP Simple Finance, on-premise edition totals and application index tables were removed and replaced by identically-named DDL SQL views, called compatibility views.
财务的业务凭证统一到ACDOCA（行项目表）和BKPF（抬头表）。BSEG,COBK表还在，数据也有，估计是为了兼容。汇总表、索引表被DDL SQL视图即”兼容性视图”所替代。替代发生在安装过程中。
These views are generated from DDL sources. This replacement takes place during the add-on installation of SAP Simple Finance using SUM related data is secured into backup tables. The compatibility views ensure database SELECTs work as before. However, write access (INSERT, UPDATE, DELETE, MODIFY) was removed from SAP standard, or has to be removed from custom code refer to SAP note 1976487.
Original
Table
Compatibility View
(identically-named view in DDIC)
DDL Source (for the
identically-named DDIC View)
Backup Table (for
original table content)
BSAD
BSAD
BSAD_DDL
BSAD_BCK
BSAK
BSAK
BSAK_DDL
BSAK_BCK
BSAS
BSAS
BSAS_DDL
BSAS_BCK
BSID
BSID
BSID_DDL
BSID_BCK
BSIK
BSIK
BSIK_DDL
BSIK_BCK
BSIS
BSIS
BSIS_DDL
BSIS_BCK
FAGLBSAS
FAGLBSAS
FAGLBSAS_DDL
FAGLBSAS_BCK
FAGLBSIS
FAGLBSIS
FAGLBSIS_DDL
FAGLBSIS_BCK
GLT0
GLT0
GLT0_DDL
GLT0_BCK
KNC1
KNC1
KNC1_DDL
KNC1_BCK
KNC3
KNC3
KNC3_DDL
KNC3_BCK
LFC1
LFC1
LFC1_DDL
LFC1_BCK
LFC3
LFC3
LFC3_DDL
LFC3_BCK
COSP
COSP
V_COSP_DDL
COSP_BAK
COSS
COSS
V_COSS_DDL
COSS_BAK
FAGLFLEXT
FAGLFLEXT
V_FAGLFLEXT_DDL
FAGLFLEXT_BCK
In SAP Simple Finance, on-premise edition add-on 2.0 and SAP S/4HANA on-premise edition 1511,additional tables were (partially) replaced by Universal Journal (ACDOCA). The approach for compatibility views in release 2.0 differs from 1.0 in the following ways:
Compatibility views do not have the same name as the original tables. Instead, the database interface (DBI) redirects all related database table SELECTs to a compatibility view, which retrieves the same data based on the new data model (ACDOCA, and so on). The connection between table and compatibility view is NOT created during the installation w/ SUM
Again, write access (INSERT, UPDATE, DELETE, MODIFY) was adapted in SAP standard, or has to be adapted in custom code refer to SAP note 1976487.
Original
Table
Compatibility View
(identically-named view in
DDIC)
DDL Source (for the identically-named DDIC View)
Backup Table (for original table content)
ANEA
FAAV_ANEA
FAA_ANEA
FAAV_ANEA_ORI
ANEK
FAAV_ANEK
FAA_ANEK
FAAV_ANEK_ORI
ANEP
FAAV_ANEP
FAA_ANEP
FAAV_ANEP_ORI
ANLC
FAAV_ANLC
FAA_ANLC
FAAV_ANLC_ORI
ANLP
FAAV_ANLP
FAA_ANLP
FAAV_ANLP_ORI
BSIM
V_BSIM
BSIM_DDL
V_BSIM_ORI
CKMI1
V_CKMI1
V_CKMI1_DDL
V_CKMI1_ORI
COEP
V_COEP
V_COEP
V_COEP_ORI
FAGLFLEXA
FGLV_FAGLFLEXA
FGL_FAGLFLEXA
V_FAGLFLEXA_ORI
MLCD
V_MLCD
V_MLCD_DDL
V_MLCD_ORI
MLCR
V_MLCR
V_MLCR_DDL
V_MLCR_ORI
MLHD
V_MLHD
V_MLHD_DDL
V_MLHD_ORI
MLIT
V_MLIT
V_MLIT_DDL
V_MLIT_ORI
MLPP
V_MLPP
V_MLPP_DDL
V_MLPP_ORI
T012K
V_T012K_BAM
V_T012K_BAM_DDL
V_T012K_MIG
T012T
V_T012T_BAM
V_T012T_DDL
V_T012T_MIG
FMGLFLEXA
FGLV_FMGLFLEXA
FGL_FMGLFLEXA
V_ FMGLFLEXA _ORI
FMGLFLEXT
FGLV_FMGLFLEXT
FGL_FMGLFLEXT
V_ FMGLFLEXT _ORI
PSGLFLEXA
FGLV_PSGLFLEXA
FGL_PSGLFLEXA
PSGLFLEXT
FGLV_PSGLFLEXT
FGL_PSGLFLEXT
JVGLFLEXA
FGLV_JVGLFLEXA
FGL_JVGLFLEXA
V_ JVGLFLEXA _ORI
JVGLFLEXT
FGLV_JVGLFLEXT
FGL_JVGLFLEXT
V_ JVGLFLEXT_ORI
ZZ<CUST>A
*
ZFGLV_GLSI_C<number>
ZFGL_GLSI_C<number>
ZZ<CUST>T
*
ZFGLV_GLTT_C<number>
ZFGL_GLTT_C<number>
