- 博客(265)
- 资源 (7)
- 收藏
- 关注
原创 Exit Variant
一同事收到BT需求,要求在主数据中将不必要的数据过滤掉,原来这种实践应该在主数据加属性就可以完成的,查了查NOTES有这种解决方案:将所有的值LOOP 至内表LOW字段值,且将变量定义成Select option variable 类型, 出口变量中控制数据出口;SymptomEither you want to create a new variable of the cus
2014-01-16 09:00:52
156
原创 About PSA
针对网上一系统的PSA 理解,我们来深入理解下啥是PSA,以及他是怎么样操作的一种机制:http://scn.sap.com/thread/1799927 首先PSA table的内容都是和request关联的(上次有提到怎么看关联)。而且在BW系统脱离request存在的数据抽取是不现实的。(这句话怎么理解有些微妙,
2014-01-15 13:27:15
172
转载 Performance Tuning
Performance TuningØ When the query is running slow, how should we improve the query performance? Query PerformanceØ When we are extracting data from source system to BI, Loading might
2014-01-12 23:37:22
120
转载 How to find the transport request that changed a BW Object in the system
Any sudden change to an existing BW object(s) in the system may be caused by a transport request. This document helps in finding the transport request which made changes to a BW object. There are ma
2014-01-12 23:10:51
113
转载 How to retain deltas when you change LO in Production system!
Requirement may come up to add new fields to LO cockpit extractor which is up & running in production environment. This means the extractor is delivering daily deltas from SAP R/3 to BW system .
2014-01-12 23:09:41
132
转载 How to Create generic extractor to get the Value Table of Domain
Requirement - Many times we have requirement to get the data of “value table of domain” inside BW infoobject. To solve this one we can create a generic extractor on this domain.S
2014-01-12 22:33:33
109
转载 How to insert record in report at run time
Scenario Description:- In general ledger data remains in transaction currency, local currency etc. If we want to display trial balance in local currency (company code currency) i.e. r
2014-01-12 22:23:23
141
转载 如何修改已释放的请求
1. 找到你已经释放但是又需要修改的请求号2. 进入E070表中,找到你的请求,此时该请求的TRSTATUS是R-已释放状态.我们要只把该字段的值改为D-修改状态,即可.(个人习惯是先修改子请求 ,再修改 母请求 .)3. 输入调试命令,按两次回车,进入DEBUG界面. 4. 修改CODE值为EDIT(注意大写).
2013-04-10 22:29:10
367
转载 Incorrect Master Data Deletion
In this document I’ll discuss about an efficient method suggested by SAP to delete incorrect or obsolete master data from the system. NeedThere are many scenarios, in which we will get incorrect
2013-03-26 22:40:12
362
转载 Easy implementation of BEx-Userexit-Variables
If you want to control the processing of BEx-Queries you can define different types of variables: Manual Entry/Default Value, Replacement Path, SAP Exit, Authorization or Customer Exit. This blogs dea
2013-03-26 20:44:16
347
转载 SAP NetWeaver BW: BW Layered Scalable Architecture (LSA) Building Blocks
Welcome to my second blog about the BW Layered Scalable Architecture (LSA) the reference architecture for large scale BW DWHs/ EDWs. In this blog we will have a look at the LSA Building Blocks, the co
2013-02-25 22:24:54
491
转载 SAP NetWeaver BW: What is the BW Layered Scalable Architecture (LSA) all about?
This blog provides an overview about the BW Layered Scalable Architecture (LSA) the reference architecture for large scale BW DWHs/ EDWs and the process of customer adoption. Details about the LSA wil
2013-02-25 22:13:00
535
转载 Badi Implementation for Bex user exit variables
This document gives the step by step method for implementing BADI for user exit variables in Bex. This is an alternative approach to adding the code in EXIT_SAPLRRS0_001 through CMOD.Writing codes f
2013-01-04 14:39:36
998
转载 Generating Custom Hierarchies in SAP BI BW using Custom DataSource
SummaryStandard Business Content extractors support main hierarchies but it does not support all the hierarchies. SAP does not provide a standard DataSource to extract Employee-Supervisor Hierarchie
2013-01-04 11:51:14
1186
转载 DATA ARCHIVING PROCESS IN SAP BW
This document explains the steps on how to create a DAP in sap bw, more information on what is archiving is covered in my archiving blogHow to create data archiving process based on ADK method
2013-01-04 11:43:54
724
转载 How-to document on ALE pointers causing delta issues for master data Datasources - post Support-pack
Issue DetailsBasis team is doing a support pack upgrade from BI 701-007 to 701-012. After this upgrade done in Sandbox, Development, Quality and Pre-production we are facingDelta Load issues for
2013-01-04 11:41:45
419
转载 Unlocking Objects while creating Transport Requests
Introduction We face many issues while creating Transport Requests like "some objects are locked in other transport requests". Generally we keep on deleting each object individually in SE09 which
2013-01-04 11:40:17
336
转载 Performance Optimization techniques in SAP BW
Introduction:The performance of the data warehouse processes depends on various factors. Good system performance begins with the design of the data model. The other important aspects that affect B
2013-01-04 11:19:45
807
转载 Program to delete table entries
Scenario :We may come across different inconsistencies in the data base tables due to incorrect deletions happened in the Infoproviders, Infopackages etc.. At times, we are forced to delete the un
2013-01-04 11:17:21
281
转载 Enhanced functionalities of Process chains in SAP BW 7.3
Enhanced functionalities of Process chains in SAP BW 7.3Applies to:SAP NetWeaver Business Warehouse 7.30 (BW7.30)SummaryThis paper provides details on enhanced functionalities of proce
2013-01-04 10:26:18
454
转载 Update Behavior of Fields in the End Routine
Update Behavior of Fields in the EndRoutine UseUsing thisfunction, you can change the update behavior of fields in the end routine of astandard DataStore object or master data attribute.Depend
2012-08-25 12:39:51
305
转载 Real-Time Data Acquisition
DescriptionReal-time dataacquisition (RDA) supports operative reporting. The data is transferred intoBI at regular intervals and is then updated to the DataStore objects, whichare directly available
2012-08-25 12:39:14
304
转载 How to write routine to fetch current day's filename
Applies to:SAP BI 7.0 developers for carrying out tasks related to data loading and monitoring.SummaryThis document provides step by step approach to create infopackage/ datasource routine to fe
2012-08-12 16:18:56
595
原创 Financial Accounting: Line Item Extraction Procedure
General information about the line item extraction procedure For the General Ledger, selection is made from tables BKPF and BSEG, while selection for the subsidiary accounts is made from t
2012-07-30 23:07:11
484
转载 ABAP program to find BI lookups and code Patterns
Description*****************Actual Source Code for the Program******************************************** ************************************************************************ PROGRAM
2012-07-25 23:07:51
319
转载 Business Transaction Events (BTE)
What is a BTEBTE are comparable to the old enhancementsBTEs are used mostly within FIBTEs can be used both by SAP, third party vendors and customers. Each use their own function modules where the
2012-07-15 21:28:16
336
转载 Easy implementation of BEx-Userexit-Variables
If you want to control the processing of BEx-Queries you can define different types of variables: Manual Entry/Default Value, Replacement Path, SAP Exit, Authorization or Customer Exit. This blogs dea
2012-06-18 11:15:14
305
原创 BW中的增强类型
根据所了解的资料,BW中的有关增强可分为五部分,如下:1、 数据抽取增强 即在标准数据源中加入数据源中所不存在的字段,或者标准数据源不存在所需数据而需要自定义数据源,相关的事务代码有RSO2(用于定义一般数据源)、RSA6(维护数据源,用于增加其他字段)、SMOD(出口:RSAP0001,其中EXIT_SAPLRSAP_001用于业务数据,EXIT_SAPLRSAP_002用于主数
2012-06-11 09:38:44
409
转载 SAP用户出口(exit)问题--数据源增强
SAP用户出口(exit)问题数据源增强sap的用户出口总共有三代: 第一代 sap提供一个空代码的子过程,在这个子过程中用户可以添加自己的代码,控制自己的需求。这类增强都需要修改sap的标准代码。 示例:USEREXIT.. in SAPMV45A 对于第一代增强,可以用以下方法查找增强:打开欲增强的程序,点击工具栏上的“Display Object List”按钮,
2012-06-11 09:26:59
455
原创 bw report language problems
Sometimes,bw report display "#" charater,now following those steps many help you again.1,check language installed package using tcode RSCPINST2,check RFC charater extractor setting through tcode S
2012-05-31 10:32:07
204
转载 Useful functions for Data Transformation
Functions for Data TransformationRSAU_READ_MASTER_DATAVery often you need to read a characteristic's [attribute] during a data transformation process, e.g. in an update rule. Rather than accessing
2012-05-28 23:24:48
221
转载 How to find size of Infocube
************************************************************************* Description... InfoCube Size Determination* Author - Kenneth Murray* Disclaimer.... The author of this program ass
2012-05-28 23:22:41
275
转载 Program to get List of Scheduled Process Chains
Applies to:SAP Business Warehouse, Netweaver 7.0SummaryThere is no simple straight forward way to get a list of scheduled Process chains in SAP BW system. This program will give you a list of pr
2012-05-28 23:00:53
201
转载 How to check the status of the job in the application server level
Sometimes there comes situation where the job doesn’t progress with further steps in theJob log and it remains on hold for long time (even for several hours). So if the job doesn’t proceed with the
2012-05-25 11:23:29
170
转载 SAP BW 7.30: Semantically Partitioned Objects (SPOs) built from BAdI
AbstractLogical Partitioning is a very popular modeling pattern in BW. It means instead of storing data in a single InfoCube or DSO distributing the data into several identical InfoCubes or DSOs.
2012-05-21 15:42:16
569
转载 Currency symbol display in BEx 7.0
Query Output with stadard design option: The Query output with default setting for currency ; Sample query: Currency key is appearing after values of amount key figure. Report require
2012-05-21 14:45:42
233
原创 BW学习笔记1
1,Abr 与 aie 的区别Abr 支持新项,前项,后项和反转像Aie只支持后项,所以模型选择上,只支持aie的数据源,psa上层只能选择dso,支持abr的数据源既可以选择dso也可以选择cube。 2,2lis_03_bx,2lis_03_bf,2lis_03_um 三个数据源的区别以及加载时的先后顺序。2lis_03_bx 存放盘点数据2lis_03_bf 存放
2012-05-10 15:55:26
96
原创 Reset the status of a process chain step_updating
************************************************************************ Author: leno email:leno.lotus@gmail.com* Function: Resets the status of a process chain step.*****************
2012-05-04 16:06:24
223
原创 Procedure for Custom Hierarchy Extraction In SAP BW
Many times,you wanna create custom hierarchy whereas no stardard hierarchy.this topic purpose of these articles is toCreate a custom hierarchy in R/3Create a Generic Hierarchy data source for the
2012-05-03 13:29:04
202
Apress-Pro SQL Server 2008 Relational Database Design and Implementation(2008)
2010-02-09
Apress-Pro SQL Server 2008 Disaster Recovery (2008)
2010-02-09
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人