前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >SAP S/4 HANA新变化-FI数据模型

SAP S/4 HANA新变化-FI数据模型

作者头像
SAP最佳业务实践
发布2018-03-28 11:09:12
2.2K0
发布2018-03-28 11:09:12
举报
文章被收录于专栏:SAP最佳业务实践

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.

OriginalTable

Compatibility View(identically-named view inDDIC)

DDL Source (for theidentically-named DDIC View)

Backup Table (fororiginal 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.

OriginalTable

Compatibility View(identically-named view inDDIC)

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>

本文参与 腾讯云自媒体同步曝光计划,分享自微信公众号。
原始发表:2016-12-09,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 SAP最佳业务实践 微信公众号,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档