关于SAP BW LO Extraction - Global Setting
来源:互联网 发布:苹果mac玩天涯明月刀 编辑:程序博客网 时间:2024/05/27 01:03
这个是从SAP Help里面直接抓过来的。 数据抽取一直是自己比较弱得地方,可能也是受限于工作吧。 要加强。
Global Settings
For the transferal of line items from Financial Accounting, important global settings can be made in the SAP R/3 system in table BWOM_SETTINGS. For this purpose, change the table using transaction SE16 (table maintenance).
OLTPSOURCE
PARAM_NAME
PARAM_VALUE
Default Value
<space>
BWFILOWLIM
YYYYMMDD
19910101
<space>
BWFISAFETY
<Days>
1
<space>
ORGSYSONLY
<space> or X
<space>
<space>
DELTIMEST
<Days>
60
<space>
BWFIOVERLA
<space> or X
<space>
<space>
BWFITIMBOR
<Time>
020000
- BWFILOWLIM
Here, you can set the lower time limit of the time stamp selection for data requests in update modeinitialization of the delta method. Together with the selection criteria, this parameter is a decisive factor for the data volume with data requests in update modeinitialization of the delta method.
设置数据抓取的起始单据创建时间,系统默认1991年1月1日,够了。
- BWFISAFETY
Here, you can the upper time limit of the time stamp selection for data requests in all update modes. Value 1 in this parameter means that the upper time limit of the time stamp selection is the previous day. With larger parameter values, the upper limit of the time stamp selection is correspondingly further (in days) in the past.
Note that you cannot choose a parameter value cannot be smaller than 1, as this would prevent the delta dataset being found completely.
简单讲,就是今天抓数据,选择单据创建日期时,需要往前推几天,这个好理解,因为你选择今天,除非是当晚最后一秒,否则极有可能掉单,保险起见,选今天之前的吧。 1即往前一天,N即N天。
系统不允许设置小于1的值。
- ORGSYSONLY
If you SAP R/3 system is part of an ALE scenario, set this parameter to X. This ensures that only those line items that were originally posted to the BW system will be transferred there from the SAP R/3 system. This prevents line items being transferred several times from various SAP R/3 system.
没看明白,求救。
- DELTIMEST
With this parameter, you can set the retention period of entries that are no longer required in time stamp table BWOM2_TIMEST. The default setting for deletion of entries that are no longer required in the time stamp table is 60 days. The minimum retention period for entries in the time stamp table is 15 days. When entries are deleted from table BWOM2_TIMEST, the corresponding entries for the changed FI line items are deleted simultaneously from log table BWFI_AEDAT.
因为数据抽取都会留有时间戳日志,保留几天的设定。
- BWFIOVERLA
The logic of this parameter prevents records with the previous day as their CPU date from still being in the update at the time of extraction.
- IfXis set for this parameter, selection is made up to the previous day if the time limit is not reached.
- If<space>is selected for this parameter, selection is made up to the day before the previous day if the time limit is not reached.
就是数据在抽的过程中, 过了12点,如果选择X,并且没有到受限时间,则时间范围把执行天也加进来。如果留空,并且没有导受限时间,则时间范围还是界定在前天。
- BWFITIMBOR
This parameter designates 02.00 (2 A.M.) as the time limit for extraction. If this limit is not reached, the system applies a safety time interval of one day for determination of the to-value. If extraction is started before 02:00 therefore, the selection takes place only up to the day before the extraction run.
设定受限时间。
Changing the default value isnot recommended.
- 关于SAP BW LO Extraction - Global Setting
- BW---HOW to basis Lo Extraction for SAP-BW
- BW---HOW to basis Lo Extraction for SAP-BW
- SAP BW LO抽取
- sap bw之Lis和Lo
- SAP BW LO后勤抽取,有三种更新模式
- LO Cockpit data extraction
- 更多关于SAP/BW BI的笔记
- sap bw
- 密码/SETUP GLOBAL SETTING
- SublimeText2:detect_slow_plugins global setting
- SAP Notes---BW
- SAP Notes---BW
- SAP BW数据仓库简介
- SAP BW-SD
- SAP BW介绍
- SAP BW 基础知识
- BW:SAP STMS配置
- 闭包,lambda表达式之学习笔记
- hdu ACM Steps 2.3
- C++连接mysql数据库的两种方法
- 手把手教你把Vim改装成一个IDE编程环境(图文)
- leeboy的linux学习二
- 关于SAP BW LO Extraction - Global Setting
- Android关闭JIT的方法
- FreeMarker + xml 导出word
- 经典SQL语句大全- 提升篇
- Source Insight阅读linux内核源代码——根据其他文章修改
- UVaOJ 10048 - Audiophobia
- android2.2 jit是什么,有啥用
- oracle--如何干预执行计划(使用hints提示)
- T-Sql 递归查询(给定节点查所有父节点、所有子节点的方法)