ITPub博客

Collect语句镶嵌在select---endselect之中使用,在报表开发中经常用到,作用是根据table的unique key,把表中其他的字段进行自动的累加,一般用在对某些数据进行总数统计的时候.举例如下:data:begin of mytable, keyfield like XXX,fliedl1 like XXX, field2 like XXX,end of mytable.Data: mytable_col like hashed table of mytable With unique key keyfield with headline.select keyfield fliedl1 field2 from table_system into (mytable- keyfield, mytable-fliedl1, mytable- field2).Collect mytable into mytable_col.En

COME FORM: http://i.cn.yahoo.com/02900427056/blog/p_5/关键字: ABAP面试 问题一：锁对象（Lock Object）和 FM（Function Module），激活Lock Object时， 案 产生的 FM 的名字是什么？答案：首先要在 ABAP 字典中创建锁对象，然后才能在 ABAP 程序中设锁。 创建锁对象时，系统会自动生成两个 FM 来进行锁管理。 用于设锁的 FM 为： ENQUEUE_<锁对象名>。它用于在锁表（Lock Table）中生成一个锁项（Lock Entry）。若设锁不成功的话，就会在 Return 中反映出来。用于释放锁的 FM 为：DEQUEUE_<锁对象名>。

SAP ABAP小结 =========================================================== 作者: qiujun(http://qiujun.itpub.net)出处：http://qiujun.itpub.net/post/24006/298614--------------------------------------------------------------- 1 使用binary search之前，需要sort，并且sort by ascending（系统默认的顺序也是ascending）。而且read table with key的顺序同sort的顺序相同，否则出错，常会找不到纪录。Delete adjacent duplicates之前一定要sort。2 关于内部表示和外部表示：调用BAPI和Update DB的时候，一定要使用内部形式（物

SmartForms总结步骤一：Create Form１Tcode: smartforms；２在Form后面输入名称，然后单击“创建”；３输入描述；４设计界面；５保存并激活；６执行，可以自到系统会自动产生一个Function module,如：/1BCDWB/SF00000016；７执行，输入必要的参数；８执行，输入OutputDevice；９打印预览，可以看到设计的界面。步骤二：建立程序代码如下：DATA W_SFLIGHT like sflight occurs 0 with header line.*Name of Function ModuleDATA: fm_name TYPE rs38l_fnam.select * from sflight into table w_sflight.*取SmartForms生成的功能模块名称*CAL

DATA: BEGIN OF wa_tab1, fld1(4) VALUE ’FLD1’, fld2(4) VALUE ’FLD2’, fld3(4) VALUE ’FLD3’, fld4(4) VALUE ’FLD4’, fld5(4) VALUE ’FLD5’, END OF wa_tab1, BEGIN OF wa_tab2, fld1(4), fld2(4), fld3(4), fld4(4), END OF wa_tab2.************* Move Corresponding *************MOVE-CORRESPONDING wa_tab1 to wa_tab2.************ End Move Corres

ABAP 中的表类型及作用(转) Transparent tablesA transparent table in the dictionary has a one-to-one relationship with a table in the database. Its structure in R/3 Data Dictionary corresponds to a single database table. For each transparent table definition in the dictionary, there is one associated table in the database. The database table has the same name, the same number of fields, and the fields have the same names as the R/3 table definition. When looking at the definition of an R/3 trans

R/3 ABAP开发学习笔记T-Code:ST05,SE38,SE37,SE93,SE73,ABAPhelp1、ST05是用于在开发ABAP程序时，对应事务码取得的字段是“数据结构”而不是“透明表”的时候，通过ST05的“SQL跟踪”来获得相关“Select”的语句；一般查看“REC”列耗时比较多的“Select”语句；2、跟踪时如果有涉及到“数量”这类有对数据表进行更新或插入操作的，则直接去查Update和Insert的SQL语句；3、在跟踪后，直接双击“对象名”列的名称，点选“表格字段”转到“SE11”的表字段表；4、ABAP程序开头的Tables:“数据表名”，只有在屏幕中有用到的表，才需要声明；在

ABAP数据库操作(学习SAP程序设计的整理-数据库)1、abap语言使用的数据库语言：open sql ,Native sql(特定数据库自身sql)2、使用OPen SQL注意的原则： a、尽可能减少满足条件的数据条目数量。 b、减少数据的传输量，以减少网络流量。 c、减少访问的数据库表量。 d、减少查询难度，可以通过整理选择标准来实现。 e、减少数据库负载。3、使用Native sql有两个前提： a、知道使用数据库的类型。 b、了解该数据库的SQL语法。4、ABAP的数据定义由数据字典创建。5、提取数据方式：内表，工作区，变量。6、select语句：selec

在学习这门语言之前，让我们先看看SAP的二次开发具有哪些工具和技术 ，这里给大家一个overview: 1、REPORT(报表) ：报表程序的主要作用是从数据库中抓取数据通过整理陈列出来，给企业高层或具有相关需求的人员查看。如无特殊需求，此类程序一般不需客制screen、menu、title。 A、ABAP LIST（最简单的一种报表程序，显示在屏幕上的数据及格式都通过ABAP中的WRITE语句实现，开发工具：SE38） B、ALV REPORT （属于报表的一种高级形式，显示出来的报表整洁美观，具有很大的交互功能，屏幕上的数据及格式主要通过系统

80% of development costs are in the construction of the data model and data extracts. ************************************Shared Data Model * Pre-configured Extracts * Metadata Repository linked to R/3 * Reduced custom ABAP requirements.Integrate multiple R/3 versions, modules and external data ************************************[@more@]

BUSINESS WAREHOUSE QUESTIONSNote: A large portion of this information came from SAP’s online Help. For additional information, follow the links included in these questions and answers.What is the Business Warehouse? [answer]How is data structured in the Business Warehouse for queries, reporting and analysis? [answer] What is Business Explorer (BEx) Analyzer? [answer]What is BEx Web Reporting? [answer] What are the basic navigation functions in BEx? [answer] What kind of reports should be writte

sap bw LO ExtractionGo to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name. Go to transaction SBIW –> Settings for Application Specific Datasource –> Logistics –> Managing extract structures –> Initialization –> Filling the Setup table –> Application specific setup of statistical data –> perform setup (rel

Roles in BW ProjectsSAP BW Data Extraction ConsultantDescriptionThe BW Data Extraction Consultant is responsible to identify and obtain the data required to satisfy the requirements of the BW project. This data may include:» SAP R/3 data» New Dimension product data» Data external to SAP within the organization (legacy data)» Data external to SAP from outside the organization (provider data – D&B, Nielson)The BW Data Extraction Consult

Walkthrough Checklist for Query Performance1. If exclusions exist, make sure they exist in the global filter area. Try to remove exclusions by subtracting out inclusions.2. Use Constant Selection to ignore filters in order to move more filters to the global filter area. (Use ABAPer to test and validate that this ensures better code)3. Within structures, make sure the filter order exists with the highest level filter first.4. Check code for all exit variables used in a report.5. Move Time restric

Hello Everone, Here are some general questions that I have gathered. These are NOT Copyrighted Material. If there is a problem with these please let me know, and also note that these have been compiled from various sources so the grammer is not all that great. IF YOU FIND any of the answers to be wrong please do let me know. I have many more if needed.1. What are the extractor types?• Application Specifico BW Content FI, HR, CO, SAP CRM, LO Cockpito Customer-Generated ExtractorsLIS, FI-SL,

SAP BW Certification Exam - My Experience My SAP BW Certification Experience - The exam contains 80 questions and the time allotted for this 3 hours. Time duration is more than enough for 80 questions. The only thing you should have is Patience because you really get tired after reading all this questions and the respective 5 options for each question and that too confusing ones. I really got impatient when I was nearing 64, 65th question. And I think this is the reason I did very badl

1、 InfoProviders are objects for which you can create and execute queries in SAP BW. These includeobjects that physically store data – the data targets, such as InfoCubes, operational data store objects(ODS objects), and InfoObjects (characteristics with attributes or texts). They also include objectsthat do not contain any actual data, such as, InfoSets, RemoteCubes and MultiProviders.InfoProviders are the objects or views relevant to reporting.2、 Data targets are SAP BW objects that have t

In your normal course of work in BW you would find yourself "stuck" in certain situations unable to decide how you would move forward. Some of these situations could be because certain functions are not available in the system. Most of these situations can be easily overcome if you know some "handy" tricks. I shall discuss some of the tips and tricks which should be useful to know for a BW consultant.ROOSOURCE issue:Enhancements are a never ending part in a project. There wou

Getting started with SAP BW (BI)by Gili As this is the first post in this blog, I would like (with your permission) to start with a personal note. I have been with Business Intelligence since year 2000. I worked on a plethora of tools, but never met a fascinating and complex tool like SAP Business Intelligence (aka SAP BW). After almost two years of working with BW on a daily basis, I can surely admit that moving into SAP BW was the wisest professional decision I made to date.Why you should cons

Data Warehousing: Step by StepPurposeTo build a data warehouse, you have to execute certain process steps. Process Flow 1. Data modeling ○ Creating InfoObjects: Characteristics○ Creating InfoObjects: Key Figures○ Creating DataStore objects○ And/or creating InfoCubes○ And/or creating InfoSets○ And/or creating MultiProviders○ Or creating VirtualProviders 2. Metadata and Document Management○ Installing BI Content○ Creating document