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

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>

原文发布于微信公众号 - SAP最佳业务实践(sztunxi)

原文发表时间:2016-12-09

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏iMySQL的专栏

优化案例:CASE WHEN进行 SQL 改写优化

今天给大家分享一个通过 SQL 改写而独辟蹊径的 SQL 优化案例。想要优化一个SQL,一般来说就是先看执行计划,观察是否尽可能用到索引,同时要关注预计扫描的行...

1610
来自专栏kwcode

SQL语句帮助大全

--删除约束 Status:字段名 alter table Table_1 drop constraint Status; --添加约束 --Status :字...

34911
来自专栏杨建荣的学习笔记

关于索引扫描的极速调优实战(第二篇)(r3笔记第82天)

在上一篇http://blog.itpub.net/23718752/viewspace-1364914/ 中我们大体介绍了下问题的情况,已经初步根据awr能...

3507
来自专栏Albert陈凯

2017年11月1日课后作业Hive 第二次课程DDL内部表、外部表、临时表的创建和特性DML

2017年11月1日课后作业 Hive 第二次课程 回顾上节课的内容 Hive是什么 SQL -> MapReduce 为什么会有Hive 给非Java编程者对...

3256
来自专栏数据和云

Oracle Hints - 先知的提示

在上周恩墨微信大讲堂的讨论中,几个有趣的视图跃入我们的视野,可以分享给大家。 在Oracle 11g中,新增的视图V$SQL_HINT记录了Oracle数据库中...

2896
来自专栏杨建荣的学习笔记

探索ASH 第一篇

老是在用ASH,对它的依赖感觉已经大于AWR,昨天心血来潮,想看看ash视图里面是怎么样的,过程也算曲折,不过也算抛砖引玉。 先看看v$active_sessi...

4308
来自专栏数据和云

案例分析:倾斜值传入导致 SQL 资源消耗升高

作者 | 邓秋爽:云和恩墨技术工程师,有超过七年超大型数据库专业服务经验,擅长 Oracle 数据库优化、SQL 优化和 Troubleshooting。

1284
来自专栏跟着阿笨一起玩NET

(1)显示每个类别最新更新的数据

在项目中经常遇到求每个类别最新显示的数据,比如显示某某某类别最新更新的5条数据。特写下这个sql记录于此:

771
来自专栏乐沙弥的世界

oracle imp导入时出现skipping table

    最近有同事在使用传统的imp工具导入数据时,总是提示收到skipping table的提示,也就是表被跳过,而不是被重建。即使是将目标数据库上的表对象删...

1141
来自专栏码生

webstorm 模板变量

${PROJECT_NAME} - the name of the current project.

1852

扫码关注云+社区

领取腾讯云代金券