ABAP REPORTS

ERP SAP Installation Concepts for ABAP

2011-12-14T04:28:00.000-08:00

ERP SAP Installation Concepts for ABAP are basics that we are going to deal with basic options of installations.As a result of open know-how of R/3 and thus the variety of supported hardware platforms, working techniques,and databases, it is past the scope of this chapter to cowl all installation variants. For a single SAP system or group of related methods, customers don't often set up

SAP Full Form,Meaning and Introduction to ABAP Syntax for START OF SELECTION

2011-05-17T23:14:00.000-07:00

SAP has full form of syntax and programming language named as ABAP and here in this post we are going to see the introduction to sap syntax for the keyword START OF SELECTION in its programming language.Basic formSTART-OF-SELECTION.EffectThis is an event key word. Before the first logical database table access, it introduces any initial processing to be executed prior to the block specified under

SAP Full Form and Meaning of SPLIT Keyword in ABAP

2011-05-12T00:03:00.000-07:00

SAP has its own importance and here in this post we are going to talk about the full form of sap and its meaning and how the keyword SPLIT is used in ABAP programming.Variants1. SPLIT f AT g INTO h1 ... hn.2. SPLIT f AT g INTO TABLE itab.Variant 1SPLIT f AT g INTO h1 ... hn.EffectSplits the contents of the f according to the delimiter g and places them in the fields h1 to hn ( n >= 2).g is used

SAP Reporting Syntax for SET and Full Form

2011-05-08T23:58:00.000-07:00

SAP reporting has a programming language called ABAP and here in this post we are going to explore the keyword SET complete usage in the syntax.SET BLANK LINES ON.SET BLANKS LINES OFF.EffectThese statements allow you to specify whether you want to output blank lines or not. Use SET BLANK LINES ON to output blank lines or SET BLANK LINES OFF to suppress them. The default setting is SET BLANK

ABAP Reports Syntax for Select Options

2011-03-02T08:15:00.000-08:00

Here in this post we are going to have a look at the abap programming language syntax for a key word select optoins.Basic form for this key word is SELECT-OPTIONS sel FOR f.EffectDeclares a variable selection option. This statement only makes sense in reports, i.e. in programs defined as type 1 in the attributes. You can execute reports with the SUBMIT statement. The statements SELECTOPTIONS and

sap programming syntax for select options in abap

2010-09-18T06:51:00.000-07:00

abap programming use the word select options in its keyword usage to get the required output as shown below.EffectDeclares a variable selection option.This statement only makes sense in reports, i.e. in programs defined as type 1 in the attributes. You can execute reports with the SUBMIT statement. The statements SELECTOPTIONS and PARAMETERS determine the technical interface and the user

abap programming syntax for Select

2010-09-01T00:12:00.000-07:00

Abap programming has some keywords and select is one of the important one among them.Here is the syntax check for that.Basic formELECT result [target] FROM source [where] [GROUP BY fields] [ORDER BY order].EffectRetrieves an extract and/or a set of data from a database table or view (see Relational database ). SELECT belongs to the OPEN SQL command set.Each SELECT command consists of a series of

sap programming syntax for keyword search

2010-06-11T04:33:00.000-07:00

sap programming is done with a language called ABAP and it has some important keywords and search is one among them.Its usage is given as shown below.SEARCH f FOR g.Additions1. ... ABBREVIATED2. ... STARTING AT n13. ... ENDING AT n24. ... AND MARKEffectSearches the field f for the string in the field g . This string can have any of the following formats:'str' a character string (trailing blanks

SAP ABAP Programming Syntax for Scroll Keyword

2010-05-27T22:54:00.000-07:00

SAP ABAP programming language has some keywords and they have some rules to follow while using them during programming the ERP language.It is as given below.The return code value is set as follows:SY-SUBRC = 0 O.K.SY_SUBRC = 4 List limits have been reached - scrolling not possibleSY-SUBRC = 8 List does not exist - scrolling not possibleVariant 1SCROLL LIST TO FIRST PAGE.Additions1. ... INDEX idx2

ABAP Programming Syntax for Scan keyword

2010-04-21T05:49:00.000-07:00

ABAP programming language has some keywords and scan is one among them.The syntax for this programming word is as shown below.Basic formSCAN ABAP-SOURCE itab1 TOKENS INTO itab2STATEMENTS INTO itab3.EffectBreaks down the ABAP/4 source code in the source code table itab1 into tokens according to the rules of the ABAP/4 scanner. The tokens are written - one per line - to the token table itab2 . The

SAP ABAP Syntax for Report in Programming

2010-03-13T20:08:00.000-08:00

Report is the key word used in sap abap programming and here we are going to learn about the way it is used in writing the code for programming this abap language.EffectIntroduces the report. You can choose any name you like up to 8 characters long.ExampleREPORT ZREPNAME.Only standard SAP reports should begin with 'R'.Addition 1... NO STANDARD PAGE HEADINGEffectSuppresses output of the standard

SAP ABAP Syntax for Refresh mysap programming

2010-01-26T06:57:00.000-08:00

Refresh is the key word used in sap abap programming to get the fresh and modified data from mysap server. The previous programming sap abap key word is regarding recieve.Basic formREFRESH CONTROL ctrl FROM SCREEN scr.EffectInitializes the control ctrl defined by a CONTROLS statement according to its description in the screen scr . The screen scr does not have to match the initial screen for the

SAP ABAP Syntax for Receive Keyword

2009-12-24T21:23:00.000-08:00

Receive is the keyword used in abap programming of sap erp and its syntax is explained Below.The previous post deals with read keyword of sap abap.Basic formREPLACE f WITH g INTO h.Addition... LENGTH len (length specification for field f )EffectReplaces the first occurrence of the contents of field f in field h with the contents of field g . All fields are handled in their defined length; this

ABAP Syntax for Read in SAP Programming

2009-11-26T06:14:00.000-08:00

ABAP programming is used for SAP is used to extract data from R/3 data base and here we are going to learn about syntax of key word READ. Our previous discussion is regarding sap syntax for provide.READ Determine calendar informationThe READ CALENDAR statement exists only in the R/2 System.In the R/3 System, the following function modules are substituted:· DATE_COMPUTE_DAY : Returns the day for

SAP Programming Syntax for Provide in ABAP

2009-10-15T09:58:00.000-07:00

The sap programming language ABAP syntax for provide is discussed here in detail and we have done about print control in the previous post.Basic formPROVIDE f1 f2 ... FROM itab1g1 g2 ... FROM itab2...* FROM itabi...BETWEEN f AND g.EffectRetrieves the contents of the specified fields from the internal tables ( itab1 , itab2 , ...) and places them in the table header lines within the required range

SAP programming Syntax Print Control ABAP

2009-09-27T20:41:00.000-07:00

Syntax check for perform in sap programming is the previous topic of ABAP and now we are going to discuss deal with print control syntax of sap.EffectDetermines the desired print format for the subsequent characters, starting from the current output position.You define the output position either implicitly:· Line 1/column 1 before the first WRITE output on the current page.· Line and column of

SAP Programming syntax Perform code

2009-09-23T21:56:00.000-07:00

We are discussing regarding SAP programming language ABAP and its syntax for perform and it is the continuation of it.Variant 5PERFORM n ON COMMITAddition1. ... LEVEL levelEffectExecutes the specified subroutine when a COMMIT WORK occurs. This allows you to execute a subroutine only if the logical transaction has ended successfully. The subroutine is not executed until the key word COMMIT WORK is

ABAP Syntax Code for Perform in SAP Programming

2009-09-03T04:29:00.000-07:00

ABAP Code for programming SAP data retrieval has a key word perform and the previous post deals with syntax of perform and this is in continuation of that. Variant 3PERFORM form IN PROGRAM prog.Additions1. ... USING p1 p2 p3 ...2. ... CHANGING p1 p2 p3 ...3. ... TABLES itab1 itab2 ...4. ... IF FOUNDEffectSimilar to variation 2 (external PERFORM ), except that here you can specify both the

SAP ABAP Syntax for Perform part two

2009-07-30T09:31:00.000-07:00

SAP ABAP Syntax for Perform is discussed in the previous post and it is in continuation with it.Addition 3... TABLES itab1 itab2 ...EffectYou use TABLES to pass internal tables to subroutines.ExampleDATA: BEGIN OF ITAB OCCURS 100,TEXT(50),NUMBER TYPE I,END OF ITAB.STRUC LIKE T005T....PERFORM DISPLAY TABLES ITABUSING STRUC.FORM DISPLAY TABLES PAR_ITAB STRUCTURE ITABUSING PAR STRUCTURE T005T.DATA

SAP ABAP Syntax for Perform

2009-07-23T08:57:00.000-07:00

The sap abap syntax for perform has different variants an shown below.Variant 1PERFORM form.Additions1. ... USING p1 p2 p3 ...2. ... CHANGING p1 p2 p3 ...3. ... TABLES itab1 itab2 ...EffectCalls the subroutine form specified in the FORM statement. On completion, processing in the main program resumes.ExamplePERFORM HELP_ME....FORM HELP_ME....ENDFORM.The PERFORM statement calls the subroutine

SAP ABAP Syntax for Parameters part five

2009-06-20T22:12:00.000-07:00

This post is in continuation with previous post about SAP ABAP syntax for parameters part four.Addition 15... VALUE-REQUESTEffectThis addition is only allowed for database-specific parameters in the INCLUDE DBldbSEL . It permits self-programmed value help (for report-specific parameters, this is achieved by specifying the event key word AT SELECTION-SCREEN ON VALUE-REQUEST FOR ... ). The

SAP ABAP Syntax for Parameters part Four

2009-05-14T05:52:00.000-07:00

SAP ABAP Syntax for parameters were previously discussed in part one, two and three and the present post is in continuation with it.Addition 13... FOR TABLE dbtabEffectAssigns the database-specific parameter p to the table dbtab . This addition only makes sense in a logical database access program.With database-specific parameters, you need this addition to ensure that the selection screen for a

SAP ABAP Syntax for Parameters part three

2009-05-08T08:29:00.002-07:00

This SAP ABAP syntax for parameters part is in continuation with part two .Addition 8... NO-DISPLAYEffectDoes not display the parameter on the selection screen. With "normal" parameters, the associated data object is created and the parameter can be passed when SUBMIT is executed.These parameters are the part of the report interface not presented to the user on the selection screen. You can set

SAP ABAP Syntax for Parameters part two

2009-04-30T03:47:00.000-07:00

SAP ABAP Syntax for parameters is the previous post and this is in continuation with that.Addition 4... LIKE gEffectCreates the field p with the same attributes as the field g which is already defined. g can be either a database field or an existing internal field.You cannot use the addition ... LIKE g with the addition ... TYPE typ . No explicit length may be specified for the parameter (for

SAP ABAP Syntax for Paramters

2009-04-11T20:56:00.000-07:00

Basic formPARAMETERS pEffectThis statement only makes sense in report programs, i.e. in programs defined as type '1' in the attributes. You execute report programs with the SUBMIT statement. When this takes place, the parameters and selection options (SELECT-OPTIONS ) specified in the report program shape the interface which determines what the user sees on the selection screen.These parameters

SAP ABAP Syntax for Overlay

2009-04-07T03:29:00.000-07:00

SAP abap programming learning process shall start with syntax check of each key word and here is the effort for that.Basic formOVERLAY c1 WITH c2.Addition... ONLY c3EffectThe contents of the field c2 overlay the field c1 in all positions where c1 has the value SPACE ; c2 itself remains unchanged. The return code value is set as follows:SY-SUBRC = 0 At least one character in c1 is overlaid by a

SAP ABAP Syntax for Open part two

2009-03-29T05:35:00.000-07:00

The present post about SAP ABAP Syntax check is in continuation with previous post of Syntax check for OPEN.Addition 4... IN BINARY MODEEffectThe contents of the file are not interpreted by the read and write operations READ DATASET and TRANSFER . The data areas specified with these key words are directly input or output. The addition IN BINARY MODE does not have to be specified

Syntax for Open

2009-03-26T21:45:00.000-07:00

Basic form 1OPEN DATASET dsn.EffectOpens the specified file. If no addition is specified, the file is opened for reading and in binary mode .The return code value is set as follows:SY-SUBRC = 0 The file was opened.SY-SUBRC = 8 The file could not be opened.ExampleDATA: DSN(20) VALUE '/usr/test',RECORD(80).OPEN DATASET DSN.DO.READ DATASET DSN INTO RECORD.IF SY-SUBRC NE 0.EXIT.ELSE.WRITE: /

Syntax for ON

2009-03-24T21:47:00.000-07:00

Basic formON CHANGE OF f.Addition... OR f1EffectExecutes the processing block enclosed by the " ON CHANGE OF f " and " ENDON " statements whenever the contents of the field f change (control break processing). We use the statement to manipulate database fields during GET events or SELECT / ENDSELECT processing.ExampleTABLES T100.SELECT * FROM T100 WHERE SPRSL = SY-LANGUANDMSGNR < '010'ORDER BY

Syntax for New Page

2009-03-23T00:51:00.000-07:00

Basic formNEW-PAGE.EffectStarts a new page during list processing. Terminates the current page and continues output on a new page.NEW-PAGE does not generate blank pages, i.e. it ignores pages containing no output.NEW-PAGE increments the page counter (the system field SY-PAGNO ).The event END-OF-PAGE is not processed.To start a new page depending on the number of unused lines remaining on the

Syntax for New Line

2009-03-18T19:19:00.000-07:00

Basic formNEW-LINE.EffectGenerates a new line during list processing.Terminates the current list line and moves the cursor to the next list line. If there has been no output (with WRITE or SKIP ) since the last NEW-LINE , the NEW-LINE is ignored, i.e. no new line is started.Addition... NO-SCROLLINGEffectFlags the new line as "not movable" (i.e. horizontal scrolling has no effect). This allows

Syntax for Move Corresponding

2009-03-16T19:58:00.000-07:00

Basic formMOVE-CORRESPONDING rec1 TO rec2.EffectInterprets rec1 and rec2 as field strings. If, for example, rec1 and rec2 are tables, executes the statement for their header lines. Searches for the sub-fields which occur both in rec1 and rec2 and then generates, for all relevant field pairs which correspond to the sub-fields ni , statements of the form MOVE rec1-ni TO rec2-ni. The other fields

Syntax for Move part two

2009-03-16T01:55:00.000-07:00

This topic is in continuation with Syntax for SAP ABAP MOVE part one. Variant 2MOVE f+off1(len1) TO g+off2(len2).EffectWith offset off2 and length len2 , field g receives the contents of field f with offset off1 and length len1 . Therefore, the offset and length specifications can also be variable.ExampleDATA: FIELD1(10) VALUE '1234567890',OFF1 TYPE I VALUE 1,LEN1 TYPE I VALUE 2,FIELD2(8) VALUE

ABAP Syntax for Move

2009-03-14T01:43:00.000-07:00

Variant 1MOVE f TO g.EffectMoves the contents of field f to field g . Field f remains unchanged.This statement is equivalent to:g = f.ExampleDATA: NUMBER TYPE I,FIVE TYPE I.MOVE 5 TO FIVE.MOVE FIVE TO NUMBER.The fields NUMBER and FIVE now both 5.Multiple assignments like NUMBER = FIVE = 5. are also possible. ABAP/4 executes them from right to left .If the field types or lengths differ, type

Syntax for Module

2009-03-11T20:41:00.000-07:00

Basic formMODULE modl.Additions1. ... OUTPUT2. ... INPUTEffectThe processing block between the " MODULE modl. " and " ENDMODULE. " statements is snown as a module . We call the module modl in the screen flow logic with the statement " MODULE modl. ". This screen must belong to the same program (module pool) as the module.ExampleDATA: INPUT, GOOD_INPUT.MODULE CONTROL....IF INPUT NE

Modify Syntax for change list line part three

2009-03-10T00:30:00.000-07:00

Check out the part two of modify syntax for more convenience of understanding.Variant 2MODIFY LINE n OF CURRENT PAGE.Additions1. ... FIELD VALUE f1 FROM g1 ... fn FROM gn2. ... LINE FORMAT fmt1 .. fmtn3. ... FIELD FORMAT f1 fmt11 ... fmt1m ... fn fmtn1 ... fmtnmEffectChanges the n th line on the current page (stored in the system field SY-CPAGE ).Addition 1... FIELD VALUE f1 FROM g1 ... fn FROM

Modify Syntax for change list line part two

2009-03-08T09:33:00.000-07:00

This post is in continuation with Modify Syntax for change list line part ONE and going through that will give more comfort in understanding the present post.Addition 3... FIELD VALUE f1 FROM g1 ... fn FROM gnEffectOverwrites the contents of the fields f1 , f2 , ... in the list line with the current contents of the fields g1 , g2 , ... (type conversion as for MOVE g1 , g2 , ... to type C). The

Syntax Modify Change list line

2009-03-06T02:16:00.000-08:00

Variant 1MODIFY LINE n.Additions1. ... INDEX idx2. ... LINE FORMAT fmt1 ... fmtn3. ... FIELD VALUE f1 FROM g1 ... fn FROM gn4. ... FIELD FORMAT f1 fmt11 ... fmt1m ... fn fmtn1 ... fmtnmEffectChanges the n th line of the list. This could be, for example, after line selection ( AT LINE-SELECTION , AT PFxx , AT USERCOMMAND ).The current contents of the system field SY-LISEL are restored to the list

Challenges in SAP Testing

2009-03-04T08:40:00.000-08:00

Established commercial implementation methodologies for SAP typically fail to address how requirements will be met, the criteria for testing, the framework for utilizing test tools, necessary resources for testing, estimating testing budgets, specific testing roles and responsibilities, and how test defects will be managed and resolved.Many factors hamper successful testing at most SAP projects

SAP BW Business Intillengence

2009-03-01T05:33:00.000-08:00

Before loading transaction data in SAP BW, we need to load the reference data. Reference data is master data, texts, hierarchies, and other configuration-specific data that is used across all analytical applications in SAP BW. Having master data in SAP BW first speeds up the InfoCube population process. This is because SID tables for master data are created during master data loading, and

SAP BW Complete Course

2009-02-25T08:45:00.000-08:00

Here is the list of all posts labeled under SAP BW and you can browse all the topics here below.Components of data ware houseHow to construct data ware house?How to get better performance with data ware house?Data ware house building strategiesData flow in SAP BWSample SAP BW reportSAP BW third party solutionsHow to log on to SAP BW admin. environmentHow to start SAP BW project ?Data flow between

Preparing SAP for SAP BW

2009-02-21T18:23:00.000-08:00

After installing the BW add-on in the SAP R/3 OLTP instance, we need to define the remote logon connection in SAP R/3 OLTP for the SAP BW instance. This is a five-step process for the SAP BW 1.2B add-on, as outlined here: Create an ALE user, transaction SU01, to be used for remote logon to SAP BW from SAP R/3 OLTP. Make sure that this user, usually ALEREMOTE, has sufficient authorizations

SAP BW activacting business content part three

2009-02-10T05:20:00.000-08:00

This part is in continuation with activation of SAP BW business content part one and two.Loading Queries for the InfoCubes from the Business Content To actually use an InfoCube for business analysis, you need queries. Four types of Query objects are provided in SAP BW business content: REP: QuerySTR: TemplatesCKF: Calculated Key FiguresVAR: Variables A REP is a complete query that is

SAP BW Activating Business Content part Two

2009-02-03T07:54:00.000-08:00

This post is in continuation with SAP BW activating business content part one . Going through that article first will give you comfort in understanding the present topic.Enabling Business Content in SAP BW The enabling of business content is a long process. First you have SAP R/3 instances defined as a data source in SAP BW. Then select object categories one by one, transfer SAP versioned

SAP BW Activating Business Content part one

2009-01-29T04:34:00.000-08:00

Objects in SAP BW can have three versions: D, M, and A (delivered, maintained [revised], and active, respectively).You cannot work directly with D-versioned objects; therefore, you need to make a copy of D-versioned objects in your active client and then modify as needed. The business content activation process consists of the following steps: Transfer SAP-delivered content to the active

Data flow between SAP and BW

2009-01-24T22:30:00.000-08:00

SAP BW uses the pull model to pull needed data from its data sources. Data extraction from within SAP BW shall be scheduled. SAP BW sends data extract requests to the appropriate data sources. The OLTP system collects/extracts and transports requested data to SAP BW. SAP BW loads its data in its data stores.SAP BW staging engine needs to know full metadata and data content definitions (

How to start SAP BW Project ?

2009-01-22T02:32:00.000-08:00

Data Warehouse development methodologies : 1.Top-Down ApproachThe top-down approach is usually business driven, meaning that the data warehouse is a corporate directive. It has full support, business and financial, from senior management of a company, who has a clear understanding of what to expect from a data warehouse. The hardest part of top-down methodology is that all business

How to log on SAP BW Admin. Env.

2009-01-19T08:13:00.000-08:00

SAP R/3 and SAP BW share the same BASIS technology. SAP BW is installed as a separate instance. SAP R/3 and SAP BW cannot coexist on one database instance. Usually, the system administrator might configure one or more application servers to log on to SAP BW. The SAP BW administrator creates a logon account for you based on your role in the organization and SAP BW usage.SAP user interface,

SAP BW Third Party Solutions

2009-01-15T09:42:00.000-08:00

SAP BW is based on common industry-accepted standards that enable third-party vendors to integrate their products with SAP BW. Since 1998, several third-party vendors have certified their products to load data to and access it from SAP BW. Data loading tools use Staging BAPI, and data access tools use ODBO.Most data warehouse and business intelligence vendors provide a collection of tools

Sample SAP BW Report

2009-01-12T10:18:00.000-08:00

The first step to access SAP BW reports is to start the BEX Browser. You will be prompted for your user name and password assigned by your SAP BW administrator. Once SAP BW accepts your user name and password, the BEX Browser displays all reports and analytical applications for which you are authorized. On the left are the channels. Each channel contains one or more reports.Figure below shows

Data Flow in SAP BW

2009-01-09T05:10:00.000-08:00

When the user launches a report from BEX Explorer, it starts a BEX Analyzer session and opens an Excel workbook that contains an embedded BW query. BEX Analyzer sends a request to the BW application server for relevant data. If this is a new query for a user, no data is found at the application server level. The query is then pushed further down to the database server to fetch a result set

SAP Data Warehouse Building Strategies

2009-01-08T05:01:00.000-08:00

SAP customers have taken several approaches to building a data warehouse using R/3 technologies.Database-Centric Data Warehouse: In the database centric approach we have to make a copy of an R/3 database for users to report against. Conceptually, the idea is simple, but it is an operations keeping R/3 OLTP and R/3 reporting in synch is very difficult.The benefit of this model is that you will

SAP Reporting Limitations

2009-01-06T08:06:00.000-08:00

The following are the shortfalls of SAP reporting: 1.Information on existing reports is either missing or unclear. Searching a report among thousands of available reports in R/3 is a big problem. 2.Available reports are designed to meet operational and transactional information needs. Most reports are predefined, list oriented, and provide very limited OLAP functionality. 3.Several

SAP Reporting Environment

2009-01-04T05:56:00.000-08:00

Several information systems exist in R/3 that provide a reporting and data analysis environment limited to specific application modules. Information systems in R/3 are similar to data marts where subject-specific data is collected and stored in database tables dedicated for reporting. R/3 information systems provide you with information that enhances the capabilities of more than 2,000

Get better Performance of Data Warehouse

2008-12-29T03:27:00.000-08:00

A data warehouse has several characteristics-dimensions-responsible for its performance. Often only one dimension contributes to poor data warehouse performance. It may be , narrow network bandwidth causes delays in moving data from transaction systems as well as delivering information to end users while data transformation and end-user query execution are not performance issues. To end

How to Construct Data Warehouse

2008-12-24T22:19:00.000-08:00

The previous post of the blog deals with the basic components of Data ware housing. Here we are going to see the technical issues that have to be taken cared while designing the data warehouse. Global Information Delivery The Internet and intranets are the primary vehicles for information delivery. There must be robustness (scalability, security, reliability, and cost) of Web services needed

Data Ware house components

2008-12-20T23:57:00.000-08:00

Data Provider LayerThe Data Provider layer is the primary gateway to the data sources (OLTP applications or other). Major tasks performed at this layer provide an environment in which to construct subject-oriented data analysis models.Metadata (data about the data) is pulled in to a data warehouse environment from its data sources. Extraction, Transformation, and Transport services fetch

Procurement to payables Process

2008-12-18T04:50:00.000-08:00

Procurement/purchasing activitiesThe procurement process commences with determining the requirement for materials/services. A purchase requisition should be raised for all goods/services that the organisation procures. Requisitions may be raised with reference to a contract or outline agreement which specifies a certain volume of a material that should be purchased from a particular vendor.The

SAP XI What is it ?

2008-12-11T08:10:00.000-08:00

SAP XI is an integration technology and platform……for SAP and non-SAP applications.…for A2A and B2B scenarios.…for asynchronous and synchronous communication.…for cross-component Business Process Management.A goal of the Exchange Infrastructure (XI) is to provide a single point of integration for all systems, SAP and non-SAP, inside and outside the corporate boundary.1.The XI supports B2B as

SAP XI File Adapter

2008-12-08T04:38:00.000-08:00

The file adapter is used to read and write files at the OS level. The OS-level directory must be accessible by the service user of the Adapter engine, with the appropriate read/write permissions.The file adapter can also act as an FTP client, meaning that it can perform GET and PUT in the sender and receiver case, respectively.File adapter Sender :When a queue name is specified, it gets created

SAP XI adapter Flow Deployment of Variants

2008-12-03T07:02:00.000-08:00

Three possibilities for deploying the adapter framework (deployment variants):Central adapter engine (included by default in the Integration Server installation)Local adapter engine (0 or more based on customer requirements)PCK (for B2B communication)The advantage is that the three operate in a consistent way, which provides for easier configuration, maintenance and monitoring.Related PostSAP

SAP XI Adaptar Message flow

2008-11-29T03:57:00.000-08:00

This is the simplified flow for a typical message entering the AE from the IS. Communication between the IS and AE is done using the XI-protocol (SOAP w/ attachments) over HTTP(s).Upon arrival in the J2EE engine the message is queued and persisted as appropriate. These services are provided by the messaging layer.The message goes through a series of modules (generic and specific, possibly custom

SAP XI Aarchitecture of the Adapter Frame work

2008-11-24T22:05:00.000-08:00

The Adapter framework is the underlying technology supporting most of the XI adapters. The slide shows the internal architecture of the AF.As a quick walkthrough of the slide, here is an explanation of the numbers present in the diagram:1: Each specific adapter (developed either by SAP or a third-party) must comply with the JCA 1.0 specification (Java Connector Architecture). For instance, the

SAP XI Connectivity

2008-11-23T08:39:00.000-08:00

PCK is based on the adapter framework.PCK does not inherit central configuration data from the Integration Directory PCK has its own user interface (which is a subset of the Integration Directory) for configuration of individual adapters.SAP Partner Connectivity Kit (PCK) is based on Adapter Framework .SAP PCK‘s objective is to enable XML document exchange between SAP XI and business partner

Software Testing complete advanced topics

2008-11-14T04:29:00.000-08:00

Here i present a series of lessons on software testing and it is divided as topic wise.Let me know your feed back about it.UNIT TESTINGUNIT TESTING PART ONEUNIT TESTING PART TWOUNIT TESTING PART THREEGUI TESTINGWINDOWS COMPLIANCE GUI TESTING PART ONEWINDOWS COMPLIANCE GUI TESTING PART TWOWINDOWS COMPLIANCE GUI TESTING PART THREEWINDOWS COMPLIANCE GUI TESTING PART FOUR VALIDATION TESTINGWINDOWS

Software Testing Complete Course Online

2008-10-22T05:23:00.000-07:00

Any software project shall go through step by step detailed testing process . The test process could be manual or automated.Here you can go through list of topics that deals with the complete basics of software testing process and technical issues involved in it.SOFTWARE QUALITY ASSURANCE AND CONTROLSOFTWARE QUALITY AND COST ASPECTSTABLE PROCESS OF SOFTWARE TESTINGSTABLE PROCESS OF SOFTWARE

C programming Complete Course

2008-10-22T05:13:00.000-07:00

Here is the list of c programming complete course in progress. You can go through topic wise by clicking the name of the topic.INTRODUCTION TO C PROGRAMMINGC PROGRAMMING CHARACTER SETCONSTANTS IN C PROGRAMMINGPROGRAMMING C VARIABLESC PROGRAM INSTRUCTIONSCOMPILATION AND EXECUTION OF C PROGRAMC PROGRAMMING RULES PART ONEC PROGRAMMING RULES PART TWO

Sample code to send mail from SAP

2008-10-17T04:43:00.000-07:00

A sample program to send mail from SAP to Outlook with a text on body not at attachment.report zh_email1.data: email type somlreci1-receiver value ''.data: sender type soextreci1-receiver value 'SAPDEV02'.data: imessage type standard table of solisti1 with header line,iattach type standard table of solisti1 with header line,ipacking_list like sopcklsti1 occurs 0 with header line,ireceivers like

UPLOAD XML FILE FROM APPLICATION SERVER

2008-09-28T07:05:00.000-07:00

Here is the code for uploading XML file from application server into data base server of SAP.TYPE-POOLS: ixml. "iXML Library Types*TABLES : rbkp.&--------------------------------------------------------------------- * TYPE DECLERATIION&---------------------------------------------------------------------TYPES: BEGIN OF type_tabpo,ebeln TYPE ekko-ebeln, "PO document numberebelp TYPE ekpo-ebelp,

ADD COLOR TO CELL WITH ALV REPORT

2008-09-25T05:28:00.000-07:00

This alv report is useful to add color to a particular cell using abap alv report.Here is the code.DATA: g_color_green TYPE slis_t_specialcol_alv.create a table of fieldnames to be coloured intensified green -PERFORM colour_cells TABLES g_color_greenUSING 21 31 5. set cells of this line to intensified green IF CONDITION.....out-color] = g_color_green[.ENDIF.-----------------------------------

Find user exits for a sap trasaction code

2008-09-14T02:06:00.000-07:00

Unable to identify user exits for a given transaction code. install the following ABAP in you dev environnement (local, do not need package). This program looks for any user-exit (type SMOD) avalaible for any transaction code.Report Z_CHECK_USEREXIT.tables : tstc, tadir, modsapt, modact, trdir, tfdir, enlfdir.tables : tstct.data : jtab like tadir occurs 0 with header line.data : field1(30).data :

Privacy policy

2008-09-14T02:04:00.000-07:00

This website/blog uses third-party advertising companies to serve ads when visiting this site. These third parties may collect and use information (but not your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to

ABAP Sample code for Data file from applicaion server as a mail

2008-09-08T04:07:00.000-07:00

* This program will allow you to send email with attachment.First, specify the attachment file from your local hardisk and execute.Next, specify the sender email address and click the send button. report z_mail.data method1 like sy-ucomm.data g_user like soudnamei1.data g_user_data like soudatai1.data g_owner like soud-usrnam.data g_receipients like soos1 occurs 0 with header line.data g_document

SAP ABAP SYNTAX LEARNING POINT

2008-08-19T04:39:00.000-07:00

Find syntax for different key words of sap abap here.ADD CORRESPONDINGASSIGN PART ONEASSIGN PART TWOCONTROL BREAKEVENTS IN LISTSEVENTS IN LISTS PART TWOEVENTS ON SELECTION SCREEN PART ONEEVENTS ON SELECTION SCREEN PART TWOAUTHORITY CHECKBACKBREAK POINTCALL FUNCTION PART ONECALL FUNCTION PART TWOCALL FUNCTION PART THREECALL FUNCTION PART FOURCALL FUNCTION PART FIVECALL METHODCALL SCREENCALL

ABAP COMPLETE SERIES

2008-08-19T00:28:00.000-07:00

Welcome to the ABAP WORLD ,the wonderful programming language of SAP.This FIFTY SEVEN DAY COURSE will teach every thing regarding SAP ABAP ,right from basics to most advanced topics.Let us start browsing day wiseSAP NAVIGATION DAY 1SAP ARCHETECHERE DAY 2ABAP WORK BENCH TOOLS DAY 3ABAP DATA OBJECTS DAY 4SAP DATA BASE DIALOG DAY 5INTERNAL PROGRAM MODULSRIZATION DAY 6USER DIALOGS AND LISTS DAY 7USER

SAP XI ADAPTER OVERVIEW

2008-08-18T04:57:00.000-07:00

All adapters (including IDoc and HTTP) are configured centrally in the Integration Directory. There you can specify whether an adapter is to be located at the inbound channel (sender adapter) or at the outbound channel (receiver adapter) of an Integration Engine Reuse of Integration Directory’s existing versioning and transport capabilities Central administration and monitoring over adapters,

BADI DEFINATION SCREEN SHOTS

2008-08-13T08:40:00.000-07:00

Sap business enhancements definition and its process can be learned here.Define an interface for the enhancement in the SAP menu under Tools ® ABAP Workbench ® Utilities ® Business Add-Ins (transaction SE18) and call this interface at the appropriate point in their application program. Customers can then select the add-in and implement it according to their needs.Read complete article here.

SAP ABAP MODIFICATIONS OVER VIEW

2008-08-09T04:13:00.000-07:00

'User-Exit’ is one of the very first mechanisms provided by SAP to execute custom code in between the standard SAP control flow.This is implemented as subroutine call (PERFORM xxx). A classical example for User-Exit is MV45AFZZ include in order processing module of SAP R/3.‘Customer-Exit’ is better than the user-exit, in the sense that it is implemented using Function Modules and so has a well

CODE FOR FINDING EXITS,BADIS

2008-08-09T04:10:00.000-07:00

*& Selection Texts:*& P_ALV ALV format*& P_AUTH Include authority-check search*& P_BADI Display BADIs*& P_BTE Display business trans events*& P_DEVC Show development class exits*& P_EXIT Display user exits*& P_FUNC Show function modules*& P_LIMIT Limit no. of submits to search*& P_LST Standard list format*& P_PNAME Program name*& P_PROG Display program exits*& P_SUBM Show

CALLING SMART FORM FORM PRINT PROGRAM

2008-08-07T01:37:00.000-07:00

DATA : it_ekpo TYPE z50871_ekpo_t.DATA : wa_ekko TYPE z50871_ekko_s, wa_lfa1 TYPE z50871_lfa1_s.*Variable DeclarationsDATA : v_funcname TYPE rs38l_fnam, "Function Module Name v_ebeln TYPE ebeln. "Purchase Document Number---------------------------------------------------------------------SELECTION-SCREEN -------------------------------------------------

VENDOR MASTER BDC SAMPLE CODE

2008-08-04T05:57:00.000-07:00

report ZBDC_XK01 no standard page heading line-size 255.*include bdcrecx1.*parameters: dataset(132) lower case. DO NOT CHANGE - the generated data section - DO NOT CHANGE ****If it is nessesary to change the data section use the rules:1.) Each definition of a field exists of two lines2.) The first line shows exactly the comment'* data element: ' followed with the data elementwhich

Finding User Exis

2008-07-25T05:52:00.000-07:00

tables : tstc, tadir, modsapt, modact, trdir, tfdir, enlfdir.tables : tstct.data : jtab like tadir occurs 0 with header line.data : field1(30).data : v_devclass like tadir-devclass.parameters : p_tcode like tstc-tcode obligatory.select single * from tstc where tcode eq p_tcode.if sy-subrc eq 0.select single * from tadir where pgmid = 'R3TR'and object = 'PROG'and obj_name = tstc-pgmna.move :

SAP NET WEAVER AN INTRODUCTION

2008-07-10T07:20:00.000-07:00

NetWeaver is an application builder from SAP for integrating business processes and databases from a number of sources while exploiting the leading Web services technologies.Part of the company's mySAP product group, NetWeaver is getting a lot of industry attention as the first fully interoperable Web-based cross-application platform that can be used to develop not only SAP applications but

LOCK OBJECTS IN SAP ABAP DICTIONARY

2008-06-25T06:28:00.000-07:00

OVERVIEW Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.SAP Provide three type of Lock objects.Read Lock(Shared Locked) protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the tableWrite Lock(exclusive lock) protects write access to an object.

Purchage order creation using BAPI

2008-06-25T06:21:00.001-07:00

The following code explains the way of creating purchase order with BAPI.&---------------------------------------------------------------------*& Report ZBAPI_CREATE_PO **& *&---------------------------------------------------------------------REPORT ZBAPI_CREATE_PO .&---------------------------------------------------------------------*DATA DECLARATIONCONSTANTS : C_X VALUE 'X'.*Structures to

BADI Finding in ABAP

2008-06-22T08:55:00.000-07:00

u can find BADI's in different ways...1>First go to any transaction->iN THE menu bar SYSTEM->STATUS->Get the program name ->double click->u will go to the program attached to the tcode.Now search term will be CALL CL_EXITHANDLER.Now u will get list of BADI'S available..2>Goto SE24->Give class name as CL_EXITHANDLER->Display->double click on get_instance mathod->Now u will go inside the method->

ALE IDOC'S AN INTRODUCTION

2008-06-22T08:48:00.000-07:00

ALE stands for Application Link Enabling and is a remote connection technology allowing the decentralization of business processes by connecting decentralized systems together.Using ALE, it is fairly easy to synchronize several SAP systems so that they contain the same data objects at anytime. These objects may be master data (customers, vendors, GL accounts, cost centers, ...) or transaction

PERFORMACE TRACE FOR ABAP

2008-06-22T01:35:00.000-07:00

ABAP DISPLAYTo access the ABAP code that triggered the issue of the SQL statement, from the trace list screen, use the ABAP Display button or choose Trace ® ABAP Display from the menu. The ABAP coding is displayed for the SQL statement on which your cursor is currently positioned in the trace list. Explain SQL is only possible for the database operations

SAP ABAP OOPS REPORT SAMPLE CODE

2008-06-20T23:01:00.000-07:00

This abap programming sample report is relocated to the main blog sap abap athttp://www.abapprogramming.net/2010/09/abap-programming-report-sample-code.htmlThank you.RELATED POSTBADI AND ITS ADVANTAGEDELETE FROM DATA SAP ABAPDELETE PROGRAMSAP ABAPDESCRIBE PART ONESAP ABAPDESCRIBE PART TWOSAP ABAPDESCRIBE PART THREESAP ABAPDESCRIBE PART FOURSAP ABAPDESCRIBE PART FIVEDESCRIBE PART SIXDESCRIBE PART

BADI and its advantage in ABAP

2008-06-18T05:22:00.000-07:00

SAP Business Add-Ins (BAdIs) are one of the most important technologies used to adapt SAP software to specific requirements. BAdIs were introduced with Release 4.6 and replace function module exits. This technology is not limited to SAP applications. BAdI calls can be integrated in customer applications.These can then be enhanced by other customer applications. In the various SAP applications,

Aggregate Functions usage in ABAP Program

2008-06-18T05:08:00.000-07:00

n You can use aggregate functions (COUNT, SUM, MAX, MIN, AVG) to perform calculations using the DBMS. Only use aggregate functions if they significantly reduce the quantity of data records to be transferred. n Aggregate functions are usually used used with a GROUP BY clause. SQL

SQL Performance trace part two

2008-06-12T05:57:00.000-07:00

The trace list is the same regardless of the database system. Data operations that require more than 100 milliseconds are marked red. Each section of the list has a header identifying the user, transaction, R/3 work process number, and R/3 client ID. The expanded trace list has the following columns: hh:mm:ss:ms Time stamp indicating the

Accessing individual tables in abap dictionary

2008-06-12T05:47:00.000-07:00

SELECT FOR ALL ENTRIES:With SELECT FOR ALL ENTRIES, you can divide SELECT statements into loops. This variant enables you to create a JOIN between an internal table and a database table. In the example above, only the records from table KKNA1 are read that have customer numbers in the internal table g_itab_vvbak. The following

Using data base hints in abap reports

2008-06-12T05:34:00.000-07:00

If you want to force the database optimizer to choose a particular execution path, use database hints. In R/3 Releases before 4.5A, database hints can only be used in the respective database-specific SQL dialects (native SQL in the parentheses EXEC SQL. … ENDEXEC.). As of R/3 Release 4.5A, you can use database hints

Index design in data base for SAP

2008-06-11T04:38:00.000-07:00

Changing the index design of a table in the R/3 System can affect SQL statements other than the one you want to optimize. You must therefore ensure that other SQL statements are not negatively influenced by a new, changed or deleted index. To do this, you must first establish which database views are referenced on the

SQL Performance trace

2008-06-11T04:29:00.001-07:00

To obtain an overview of the behavior of the R/3 System, you can record various processes during the execution of an individual object. To analyze performance problems with database accesses, activate the SQL trace and the buffer trace from transaction ST05. The SQL trace records SQL statements. There may be

SAP SCRIPT SAMPLE CODE

2008-06-10T09:20:00.000-07:00

REPORT Z94406_SAPSCR_NOTIF . TABLES: qmel,qmih,z94392_notif,iflot. SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-t01.PARAMETERS: N_NUMBER LIKE z94392_notif-QMNUM , N_TYPE LIKE z94392_notif-QMART , F_LOCA LIKE z94392_notif-btpln , NAME LIKE z94392_notif-QMNAM .SELECTION-SCREEN END OF BLOCK b1. SELECT SINGLE * FROM

Sample code for CS_BOM_EXPL_MAT_V2

2008-06-10T09:13:00.000-07:00

TABLES: mard,stpo,stko,tc04,t024d,marc,ekbe,mara,ekko,makt.DATA : capid LIKE tc04-capid, datuv LIKE stko-datuv, emeng LIKE stko-bmeng, mehrs LIKE csdata-xfeld, mtnrv LIKE mara-matnr, stlal LIKE stko-stlal, stpst LIKE stpox-stufe, werks LIKE marc-werks.DATA : istb LIKE stpox OCCURS 0 WITH HEADER LINE.DATA : BEGIN OF ibod OCCURS 0,stufe LIKE stpox-stufe,idnrk LIKE

DUPLICATE ENTRIES IN INTERNAL TABLE SAMPLE CODE

2008-06-10T09:06:00.000-07:00

DATA: BEGIN OF itab OCCURS 0, f1(1) TYPE c, f2(1) TYPE c, f3(1) TYPE c, f4(1) TYPE c, f5(1) type c, END OF itab.REFRESH: itab. itab-f1 = 'A'.itab-f2 = '1'.itab-f3 = '0'.append itab.clear: itab.itab-f1 = 'B'.itab-f2 = '1'.itab-f3 = '1'.append itab.clear: itab.itab-f1 = 'C'.itab-f2 = '2'.itab-f3 = '1'.append itab.clear: itab.data: c1 type i.data: c2 type i.clear:

Posting Interface document sample code

2008-06-10T08:58:00.000-07:00

form buchen_beleg.data: help_counter_before type i, help_counter_after type i.data: help_subrc like sy-subrc.describe table blntab lines help_counter_before.help_subrc = 1.clear belegnummer.sort ftpost by stype count.clear blntab. "note174346call function 'POSTING_INTERFACE_DOCUMENT' exporting i_tcode = 'FBB1'*