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> |