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

简介: SAP S/4 HANA新变化-FI数据模型   http://mp.weixin.qq.com/s?__biz=MzAwMjgyMTA4MQ==&mid=2652153162&idx=1&sn=aee6fc43e057...

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

 

De.ion: http://mmbiz.qpic.cn/mmbiz_jpg/0zwvOrYcuQCAmsRC1jRrfRyrswEgQl1Hc7YDMlfktEfQ2CPv3GOXUacuUCY2P3NNM4P0ne6Cth6UiayTRgvyK1g/640?wx_fmt=jpeg&wxfrom=5&wx_lazy=1

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>

 

目录
相关文章
|
SQL 存储 JavaScript
SAP HANA 详细介绍
SAP HANA 详细介绍
1029 0
|
大数据
为什么要学习SAP HANA
大数据最近几年是一个比较火的名词,2015年读过一本叫做《大数据时代》的书,航空机票的例子让我记忆犹新。如今工作中接触到SAP HANA,勾起了我心中对大数据的欲望。
116 1
SAP MM/FI_运费处理方式
常见的采购运费处理方式
|
存储 缓存 算法
「内存数据库」SAP HANA的不可告人的秘密
「内存数据库」SAP HANA的不可告人的秘密
|
存储 缓存 算法
「首席看HANA」SAP HANA的秘密- 不要告诉任何人
「首席看HANA」SAP HANA的秘密- 不要告诉任何人
|
大数据
《CIO指南:如何使用SAP HANA平台处理大数据》电子版地址
CIO指南:如何使用SAP HANA平台处理大数据
106 2
《CIO指南:如何使用SAP HANA平台处理大数据》电子版地址
【SAP Hana】JAVA代码访问SAP HANA
【SAP Hana】JAVA代码访问SAP HANA
152 0
|
存储 云安全 弹性计算
SAP S/4HANA上云最佳实践
本文主要基于《阿里云解决方案技术白皮书》的指导,以一个典型S/4HANA上云案例,来分析上云过程中遇到的一些典型问题,以及架构的设计和落地的最佳实践。
SAP S/4HANA上云最佳实践
SAP S/4HANA里KPI tile的一个具体例子
SAP S/4HANA里KPI tile的一个具体例子
213 0
SAP S/4HANA里KPI tile的一个具体例子